SQLite

SQLite is a transactional SQL database engine that runs inside an application, without a separate server process or setup. A complete database is stored in one disk file that works across platforms. Its SQL features include partial indexes, indexes on expressions, JSON, common table expressions, and window functions. Transactions are designed to remain atomic, consistent, isolated, and durable, including after crashes or power failures.

SQLite allows unlimited simultaneous readers, but only one writer at a time per database file. The project recommends it for device-local storage where writer concurrency is low and content is below a terabyte. It is free for commercial or private use, with source code in the public domain. Downloads include source code and precompiled binaries for Android, Linux, Mac OS X, and Windows, along with WebAssembly and JavaScript bundles for web applications. SQLite offers a free public forum and paid private email and technical support options. Paid offerings also include support, memberships, and extensions at their listed prices.

SQLite is an embedded SQL engine with broad platform downloads and no separate server process. Its one-writer-at-a-time limit is important when choosing it for workloads with concurrent writes.

SQLite suits developers needing an embedded database, particularly for device-local data with low writer concurrency and less than a terabyte of content. Its single-file format and broad platform downloads may also suit cross-platform application development.

Overview

SQLite is a compact SQL database engine for developers building applications that need local, structured storage without a separate database server. It is especially well suited to device-local data and workloads with modest write concurrency. Its strongest case is the combination of a single portable database file, transactional reliability and free commercial use; applications that need multiple simultaneous writers should look elsewhere.

Because SQLite runs inside the application, it avoids a separate server process and configuration. The entire database is kept in one cross-platform disk file, a practical fit for applications that need to package or manage local data without operating database infrastructure. The tradeoff is that SQLite is self-hosted, not a managed database service.

Key features

SQL and transactions

SQLite supports partial indexes, indexes on expressions, JSON, common table expressions and window functions. That breadth makes it capable of more than simple key-value storage: applications can use SQL to organize and query structured data, including JSON. Transactions are atomic, consistent, isolated and durable, including after system crashes and power failures, an important foundation for software that must preserve data through interruptions.

Concurrency and security

SQLite allows unlimited simultaneous readers, but only one writer at a time for each database file. That balance suits read-heavy or low-write-concurrency applications, but can be a meaningful constraint for workloads that need frequent concurrent updates. The project recommends it for device-local data with low writer concurrency and less than a terabyte of content.

SQLite is extensively fuzz-tested. For applications that accept untrusted SQL, its security guidance recommends defensive settings and lower input limits; developers should treat those safeguards as part of the integration rather than assume the engine removes the risks of untrusted input.

Pricing

The core SQLite engine costs free, billed Free for any purpose, with no license required. That makes it a straightforward choice for commercial and private projects alike. The source code is in the public domain. The paid offerings are optional support, extensions or a separate license arrangement, not a required tier for using the engine.

• SQLite Consortium Membership: $150 a year for premium enterprise support, on-site visits, proprietary extensions and test suites. It is aimed at organizations seeking a broader support and extension package.
• Technical Support: $885 a year for high-priority email and phone support; a guaranteed response time is available as an option. This fits teams that value prioritized access.
• Annual Maintenance Subscription: $1,500 a year for private expert email advice from SQLite developers, suited to users seeking direct technical guidance.
• SQLite Encryption Extension (SEE): $2,000, paid once for source code that reads and writes AES-encrypted databases.
• CEROD: $2,000, paid once for source code that reads compressed and encrypted databases.
• ZIPVFS Read/Write Compressed Database Extension: $4,000, paid once for source code that compresses and encrypts data on write, then decompresses and decrypts it on read.
• SQLite License: $6,000, paid once for a warranty of title and perpetual right-to-use for SQLite source code. Since the source code is otherwise public domain and free to use without a license, this is a distinct option for buyers seeking those stated terms.

A free public forum is also available. Paid support plans are the relevant step up for users who need private or prioritized assistance; no managed service is offered.

Platforms

SQLite is offered across Android, iOS, Linux, macOS, Windows, web, API and self-hosted environments. Downloads include source code and precompiled binaries for Android, Linux, Mac OS X and Windows, as well as WebAssembly and JavaScript bundles for web applications. That range supports both local app storage and embedding in software across desktop, mobile and web contexts.

Who it's for

SQLite is a strong fit for developers who want a transactional SQL engine embedded in an application, particularly for device-local data, a portable single-file database and low write concurrency. Its broad SQL support and lack of a required license also make it practical where a separate server would add unnecessary operational work.

It is a weaker fit when a workload depends on concurrent writes to the same database file, or when the deployment needs a managed database service. The one-writer limit is not a minor caveat for those cases; it should shape the architecture decision.

Pros and cons

• Pro: The database is a single cross-platform file and runs without a separate server process, reducing infrastructure needs for embedded and local-storage use.
• Pro: The free public-domain source can be used commercially or privately without a license, while still supporting a substantial set of SQL features and durable transactions.
• Pro: Unlimited simultaneous readers accommodate applications where many operations read data concurrently.
• Con: Each database file permits only one writer at a time, which can rule it out for write-heavy concurrent workloads.
• Con: SQLite is self-hosted and has no managed service, so teams must handle deployment and operation themselves.
• Con: Applications accepting untrusted SQL need to follow defensive-setting and input-limit guidance; fuzz testing does not replace those precautions.

Alternatives

For a broader set of database choices, browse Relational Databases, Database Software or Embedded Databases.

• RaimaDB is a paid option for readers comparing database software across web, desktop and mobile platforms.
• MySQL is worth considering if you want a freemium database with a free trial and its Community Edition, rather than SQLite's embedded, single-file approach.
• Aiven for PostgreSQL suits readers seeking a freemium PostgreSQL service with web and API platforms; its free plan has one CPU, 1 GB RAM, 1 GB disk and a single node, with no support services.
• Amazon RDS is an alternative for readers looking at a paid database service with a free tier or trial.
• InterSystems IRIS offers a paid database option with a free Community Edition and broad platform coverage.
• Neon is a freemium choice for API, Linux, macOS, web and Windows, with a free plan capped at 10 projects, 50 CU-hours per month per project, 0.5 GB storage per project, 10 branches per project and 5 GB monthly egress.
• Firebird is another free database option, with no fees for download, registration, licensing or deployment, including commercial distribution.
• H2 Database Engine is a free alternative with source code included, for readers comparing another no-cost database engine.

Verdict

Choose SQLite for embedded and device-local SQL storage when you want a portable database file, durable transactions and no separate server or license cost. Its one-writer-at-a-time limit is the decisive reason to look elsewhere: if multiple simultaneous writers or a managed service are central requirements, SQLite is not the right fit.