Back to Tech landscape

SQLite

Databases

Embedded database for local and edge

Official documentation (opens in a new tab)

Overview

SQLite backs local developer tools, acceptance test fixtures, and lightweight utilities—not production multi-tenant stores.

Relational SQL Server on Azure remains the default for Factory and SaaS templates—paired with NHibernate or EF Core, migrations in CI, and backup policies that match enterprise SLAs.

Polyglot and client-mandated stores are supported with clear boundaries: integration schemas, migration tooling, and capacity planning so operational data never becomes an undocumented side channel.

Need search, cache, or warehouse tiers alongside transactional SQL? We design data paths that stay observable, recoverable, and aligned with your Azure landing zone.

Why we use it:

  • EF Core provider for dev/test
  • Single-writer constraints understood
  • Migrations for local schemas
  • Never default production store
  • Migration and rollback discipline in Azure Pipelines
  • Encryption, redundancy, and residency matched to SLA
  • Clear ownership between platform SQL and integration stores

Ready to work with us?

Let's discuss how our team can help achieve your digital goals