SQLite
By SQLite · sqlite.org
- Free plan
- Open source
- Windows
- macOS
- Linux
- Web
- iPhone and iPad
- Android
- API
- Self-hosted
What SQLite is
SQLite is an in-process SQL database engine that stores data within an application rather than in a separate server process. It is self-contained and requires no configuration, and each complete database is held in a single disk file that works across platforms. Its SQL features include partial indexes, indexes on expressions, JSON, common table expressions, and window functions. Transactions remain atomic, consistent, isolated, and durable even after system 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 with low writer concurrency and less than a terabyte of content. SQLite is free for private or commercial use, with source code in the public domain. Downloads include source code and precompiled binaries for Android, Linux, Mac OS X, and Windows, plus WebAssembly and JavaScript bundles for web applications. A free public forum is available, along with paid private email and technical support options. SQLite is associated with Charlotte, North Carolina, and was founded in 2000.
Who it suits
SQLite suits developers who need a self-contained database for device-local storage, especially when writer concurrency is low. It is a less suitable fit when a database file needs simultaneous writers.
Good to know, and what to watch
- Each database is stored in one cross-platform disk file.
- Supports JSON and window functions.
- Free for commercial or private use.
- Unlimited simultaneous readers.
- Only one writer is allowed per database file at a time.
- Project recommends it for less than a terabyte of content.
- Private email and technical support options are paid.
Plans
Every plan and priceSQLite Consortium Membership
Technical Support
Public Forum
SQLite
Free plan
Getting started
- Open the SQLite website
- Choose source code, a precompiled binary, or a web bundle
- Select the package for Android, Linux, Mac OS X, Windows, or web use
- Embed the engine in the application
- Store the database in its single disk file
Limits to check
The free SQLite plan is the embedded SQL database engine at no cost and permits unlimited simultaneous readers, but each database file allows only one writer at a time. SQLite recommends this model for low writer concurrency and less than a terabyte of content.
The Club's review
Overview
SQLite puts a structured SQL database inside an application, without a separate server to install or manage. It is a strong fit for apps that need reliable device-local storage and modest write activity; it is a weaker fit when a database file must accept concurrent writes.
Key features
SQL in a self-contained file
A complete database resides in one cross-platform disk file. The engine supports partial indexes, expression indexes, JSON, common table expressions and window functions, giving application developers a useful range of SQL capabilities without a server process. Its transactions are atomic, consistent, isolated and durable, including after system crashes and power failures.
Concurrency and security
SQLite allows unlimited simultaneous readers but only one writer at a time per database file. Read-heavy local workloads can benefit from that reader capacity; applications with frequent simultaneous writes should look elsewhere or reconsider their storage design. SQLite's security guidance notes extensive fuzz testing and recommends defensive settings and lower input limits when accepting untrusted SQL.
Pricing
The SQLite engine costs free, with no license required for commercial or private use. That makes the core database available without a recurring charge, but it does not include the paid support and extensions below.
- SQLite Consortium Membership: $150 a year for premium enterprise support, on-site visits, proprietary extensions and test suites; suited to organizations that need those services.
- Technical Support: $885 a year for high-priority email and phone support, with a guaranteed response time available as an option.
- Annual Maintenance Subscription: $1,500 a year for private expert email advice from SQLite developers.
- 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.
These options are separate from the free engine: choose paid support for direct assistance, or an extension when its particular data-handling capability is needed.
Platforms
SQLite is available for Android, iOS, Linux, macOS, Windows, web and self-hosted deployments, as well as through an API. Downloads include source code and precompiled binaries for Android, Linux, Mac OS X and Windows, plus WebAssembly and JavaScript bundles for web applications. It is self-hosted rather than a managed database service.
Who it's for
SQLite suits software makers who want a compact, serverless database for device-local data, especially where read concurrency is high relative to write concurrency and content stays below a terabyte. Its broad SQL feature set and public-domain source code make it usable in commercial and private projects without a license fee. Teams that need a managed service or multiple concurrent writers per file should consider another approach.
Pros and cons
- Pro: The database is a single cross-platform file and needs no separate server, reducing the infrastructure an application must run.
- Pro: The free public-domain source code can be used commercially or privately without a license.
- Pro: Transactions are designed to remain durable through crashes and power failures, and unlimited readers can share a database file.
- Con: Only one writer at a time is allowed per file, which constrains write-heavy concurrent workloads.
- Con: SQLite is self-hosted, not a managed service, so it is not a choice for teams seeking a provider-run database.
- Con: Private support and specialized extensions carry substantial additional charges beyond the free engine.
Alternatives
For other options, browse Embedded Databases, Database Software and Relational Databases.
- ObjectBox is worth comparing if a freemium database with a free core and free trial better matches your selection criteria.
- Chroma is an alternative if you want an Apache 2.0-licensed open-source database whose maker says its codebase also powers Chroma Cloud.
- Qdrant offers a free cloud tier with a single-node cluster, 0.5 vCPU, 1GB RAM and 4 GB disk; consider it if those cloud resources suit your deployment better than SQLite's self-hosted model.
- LadybugDB is another free option, distributed under an MIT license with pre-compiled binaries.
- RxDB may suit readers looking for a free core that includes replication and realtime sync, alongside default storages.
- DuckDB UI provides a free local browser-based SQL notebook and optional MotherDuck connection.
- RocksDB is a free open-source C++ library under GPLv2 or Apache 2.0.
- bbolt is a free open-source Go library and command-line utility.
Verdict
Choose SQLite for reliable, device-local SQL storage when you want a serverless, single-file database with no license cost and your workload does not demand concurrent writers. Look elsewhere if you need a managed service or simultaneous writes to the same database file.
The verdict
SQLite offers a serverless database engine with a broad set of SQL features and public-domain source code. Its one-writer-per-file limit makes its recommended use case device-local storage with low writer concurrency.
Questions people ask
How much does SQLite cost?
The SQLite plan costs nothing, billed Free for any purpose, with no license required. Paid options include support, memberships, maintenance, and extensions.
Is SQLite open source?
SQLite source code is in the public domain and is free for commercial or private use without a license.
Which platforms can use SQLite?
Listed platforms include Android, API, iOS, Linux, macOS, self-hosted, web, and Windows. Downloads also provide WebAssembly and JavaScript bundles for web applications.
Can several users write at once?
SQLite supports unlimited simultaneous readers, but only one writer at a time is allowed per database file.
What support is available?
SQLite provides a free public forum. Private email and technical support options are paid, including a technical support plan at $885 a year.
What the maker publishes
- ACID transactions
- Transactions remain atomic, consistent, isolated and durable through crashes and power failures. source
- API
- SQLite supplies a C/C++ API reference, Tcl bindings and application-defined SQL-function interfaces; bindings for many other languages are separate. source
- Capacity
- The documented maximum database size is 281 terabytes and the maximum row size is 1 gigabyte. source
- CLI
- A standalone command-line client is included for administering SQLite databases. source
- Company founded
- Dun & Bradstreet lists Hipp Wyrick & Company Inc. as founded in 2001, while its summary says the company has provided services since 1992. source
- Company headquarters
- Hwaci's headquarters are listed at 6200 Maple Cove Lane, Charlotte, North Carolina. source
- Company legal name
- Hipp, Wyrick & Company, Inc. (Hwaci) is identified as SQLite's developer and an independent software development and consulting firm. source
- Company size
- Dun & Bradstreet lists an employee count of 5. source
- Concurrency limit
- SQLite supports unlimited simultaneous readers but allows only one writer at a time per database file. source
- Concurrency limit
- SQLite permits unlimited simultaneous readers but only one writer at a time per database file. source
- Database format
- A complete SQLite database is stored in a single cross-platform disk file. source
- Deployment
- The project says SQLite is embedded in billions of applications and is the world's most widely deployed database engine. source
- Documentation
- Documentation includes overview guides, SQL syntax, pragmas, C/C++ APIs, compilation instructions, Android bindings, testing, FAQs and compatibility material. source
- Downloads
- The download page offers source code and precompiled binaries for Android, Linux, Mac OS X, and Windows, plus WebAssembly and JavaScript bundles for web applications. source
- Downloads
- The official download page provides source, Android AAR, Linux, macOS, Windows, WebAssembly/JavaScript and documentation bundles. source
- Footprint
- A fully configured build can be smaller than 900 KiB. source
- Founded
- 2000 source
- Free plan
- Yes source
- Headquarters
- Charlotte, North Carolina, USA source
- Intended use
- The project recommends SQLite for device-local storage with low writer concurrency and less than a terabyte of content. source
- Latest release
- Version 3.54.1 was released on 2026-10-16. source
- Licence
- SQLite source code is dedicated to the public domain and may be used for any purpose. source
- License
- SQLite source code is in the public domain and is free for commercial or private use without a license. source
- Limit: Trustpilot complaints
- The two Trustpilot reviews are one-star complaints alleging a problematic code-of-ethics message and a virus download. source
Checked against the maker's pages on 19 Oct 2026.