Skip to content
SPECIFICTION
Get listed

SQLite

sqlite.org

From $12.50/mo Free plan Open source WebWindowsmacOSLinuxiOSAndroid
Visit sqlite.org
Spec score 9.4 #2 of 74 in Database Software

What it is

SQLite is a transactional SQL database engine that runs within an application, without a separate server process or configuration. Each complete database resides 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 are atomic, consistent, isolated, and durable, including after system crashes and power failures. A database file can have unlimited simultaneous readers, but only one writer at a time. The project recommends SQLite for device-local storage with low writer concurrency and less than a terabyte of content. SQLite is free for commercial or private use, with source code in the public domain. Downloads include source and precompiled binaries for Android, Linux, Mac OS X, and Windows, along with WebAssembly and JavaScript bundles for web applications. A free public forum is available, alongside paid private email and technical support options. The maker is based in Charlotte, North Carolina, and was founded in 2000.

Spec sheet

What it does
SQLite is an in-process C library that provides a self-contained, serverless, zero-configuration SQL database engine.Read 19 Oct 2026 · sqlite.org
Product
SQLite is an in-process, self-contained, serverless, zero-configuration transactional SQL database engine.Read 29 Sep 2026 · sqlite.org
Platforms
The project lists Android, BSD, iOS, Linux, Mac, Solaris, VxWorks, and Windows as supported platforms.Read 29 Sep 2026 · sqlite.org
Deployment
The project says SQLite is embedded in billions of applications and is the world's most widely deployed database engine.Read 19 Oct 2026 · sqlite.org
Free plan
YesRead 22 Sep 2026 · sqlite.org
API
SQLite supplies a C/C++ API reference, Tcl bindings and application-defined SQL-function interfaces; bindings for many other languages are separate.Read 19 Oct 2026 · sqlite.org
Security
The security guidance says SQLite is extensively fuzz-tested and recommends defensive settings and lower input limits for applications accepting untrusted SQL.Read 29 Sep 2026 · sqlite.org
Support
SQLite offers a free public forum as well as paid private email and technical support options.Read 29 Sep 2026 · sqlite.org
License
SQLite source code is in the public domain and is free for commercial or private use without a license.Read 29 Sep 2026 · sqlite.org
Headquarters
Charlotte, North Carolina, USARead 23 Sep 2026 · sqlite.org
Founded
2000Read 23 Sep 2026 · sqlite.org
Maker
Paid support and products are provided by Hipp, Wyrick & Company, Inc. (Hwaci), headquartered in Charlotte, North Carolina, and in business since 1992.Read 29 Sep 2026 · sqlite.org
ACID transactions
Transactions remain atomic, consistent, isolated and durable through crashes and power failures.Read 19 Oct 2026 · sqlite.org
Capacity
The documented maximum database size is 281 terabytes and the maximum row size is 1 gigabyte.Read 19 Oct 2026 · sqlite.org
CLI
A standalone command-line client is included for administering SQLite databases.Read 19 Oct 2026 · sqlite.org
Company founded
Dun & Bradstreet lists Hipp Wyrick & Company Inc. as founded in 2001, while its summary says the company has provided services since 1992.Read 19 Oct 2026 · dandb.com
Company headquarters
Hwaci's headquarters are listed at 6200 Maple Cove Lane, Charlotte, North Carolina.Read 19 Oct 2026 · sqlite.org
Company legal name
Hipp, Wyrick & Company, Inc. (Hwaci) is identified as SQLite's developer and an independent software development and consulting firm.Read 19 Oct 2026 · sqlite.org
Company size
Dun & Bradstreet lists an employee count of 5.Read 19 Oct 2026 · dandb.com
Concurrency limit
SQLite permits unlimited simultaneous readers but only one writer at a time per database file.Read 19 Oct 2026 · sqlite.org
Database format
A complete SQLite database is stored in a single cross-platform disk file.Read 29 Sep 2026 · sqlite.org
Documentation
Documentation includes overview guides, SQL syntax, pragmas, C/C++ APIs, compilation instructions, Android bindings, testing, FAQs and compatibility material.Read 19 Oct 2026 · sqlite.org
Downloads
The official download page provides source, Android AAR, Linux, macOS, Windows, WebAssembly/JavaScript and documentation bundles.Read 19 Oct 2026 · sqlite.org
Footprint
A fully configured build can be smaller than 900 KiB.Read 19 Oct 2026 · sqlite.org
Intended use
The project recommends SQLite for device-local storage with low writer concurrency and less than a terabyte of content.Read 29 Sep 2026 · sqlite.org
Latest release
Version 3.54.1 was released on 2026-10-16.Read 19 Oct 2026 · sqlite.org
Licence
SQLite source code is dedicated to the public domain and may be used for any purpose.Read 19 Oct 2026 · sqlite.org
Limit: Trustpilot complaints
The two Trustpilot reviews are one-star complaints alleging a problematic code-of-ethics message and a virus download.Read 19 Oct 2026 · uk.trustpilot.com
Limit: TrustRadius reviewers
Repeated complaints include weak high-throughput or multi-user scaling, missing advanced SQL or stored procedures, limited tooling, encryption costs and uneven language integration.Read 19 Oct 2026 · trustradius.com
Network filesystem limit
The project advises against multi-client database files on network filesystems because locking implementations can be unreliable and cause corruption.Read 19 Oct 2026 · sqlite.org
Notable news: 2026-10-16
Release 3.54.1 fixed a heap buffer overflow affecting some 32-bit builds and other bugs in 3.54.0.Read 19 Oct 2026 · sqlite.org
Praise: G2 reviewers
G2 reviewers repeatedly describe SQLite as serverless, easy to integrate, lightweight and effective for internal or lower-traffic applications.Read 19 Oct 2026 · g2.com
Praise: TrustRadius reviewers
TrustRadius reviewers commonly praise speed, portability, simple setup, offline operation, low maintenance and cross-platform mobile use.Read 19 Oct 2026 · trustradius.com
Project origin
The SQLite project began on 2000-05-09 under D. Richard Hipp.Read 19 Oct 2026 · sqlite.org
Rating on Apple App Store
5.0 out of 5 from 1 ratingRead 19 Oct 2026 · apps.apple.com
Rating on G2
4.3 out of 5 from 260 reviewsRead 19 Oct 2026 · g2.com
Rating on Trustpilot
2.9 out of 5 from 2 reviewsRead 19 Oct 2026 · uk.trustpilot.com
Rating on TrustRadius
8 out of 10 from 47 reviewsRead 19 Oct 2026 · trustradius.com
Scale limit
Official guidance recommends a client/server database for many concurrent writers, write-intensive multi-server sites or data approaching terabyte scale.Read 19 Oct 2026 · sqlite.org
Security extension
Native public-domain SQLite does not include encryption; the vendor sells the SEE extension for AES-encrypted databases.Read 19 Oct 2026 · sqlite.org
Self-hosting
SQLite has no separate server process and reads and writes ordinary local disk files, so applications embed and operate it themselves.Read 19 Oct 2026 · sqlite.org
Single-file storage
A complete database containing tables, indexes, triggers and views can reside in one cross-platform disk file.Read 19 Oct 2026 · sqlite.org
SQL capabilities
Its SQL implementation includes partial indexes, expression indexes, JSON, common table expressions and window functions.Read 19 Oct 2026 · sqlite.org
SQL features
SQLite implements SQL features including partial indexes, indexes on expressions, JSON, common table expressions, and window functions.Read 29 Sep 2026 · sqlite.org
Supported systems
Official support covers Android, BSD variants, iOS, Linux, macOS, Solaris, VxWorks and Windows.Read 19 Oct 2026 · sqlite.org
Testing quality
The project reports millions of test cases, hundreds of millions of SQL statements and 100% branch test coverage.Read 19 Oct 2026 · sqlite.org
Transactions
SQLite transactions are atomic, consistent, isolated, and durable even after system crashes and power failures.Read 29 Sep 2026 · sqlite.org
Zero configuration
SQLite requires no setup or database administration.Read 19 Oct 2026 · sqlite.org

Plans and prices

Public Forum Free Free community help and advice · public forum Read 19 Oct 2026 · sqlite.org
SQLite Free Free for any purpose; no license required. Embedded SQL database engine · no separate server process Read 29 Sep 2026 · sqlite.org
SQLite Consortium Membership $150 a year Annual Premium enterprise support · on-site visits · proprietary extensions and test suites Read 29 Sep 2026 · sqlite.org
Technical Support $885 a year Annual High-priority email and phone support · guaranteed response time available as an option Read 29 Sep 2026 · sqlite.org
Annual Maintenance Subscription $1,500 a year Annual Private expert email advice from SQLite developers Read 29 Sep 2026 · sqlite.org
Annual Maintenance Subscription $1,500 a year $1500/year private expert email support · non-disclosure promise Read 19 Oct 2026 · sqlite.org
CEROD $2,000, paid once $2000 one time fee compressed and encrypted read-only database support Read 19 Oct 2026 · sqlite.org
CEROD $2,000, paid once One time Source code · reads compressed and encrypted databases Read 29 Sep 2026 · sqlite.org
SQLite Encryption Extension (SEE) $2,000, paid once $2000 one time fee AES-encrypted database read/write support · drop-in replacement source Read 19 Oct 2026 · sqlite.org
SQLite Encryption Extension (SEE) $2,000, paid once One time Source code · reads and writes AES-encrypted databases Read 29 Sep 2026 · sqlite.org
ZIPVFS $4,000, paid once $4000 one time fee compressed and encrypted read/write database extension Read 19 Oct 2026 · sqlite.org
ZIPVFS Read/Write Compressed Database Extension $4,000, paid once One time Source code · compresses and encrypts data when written and decompresses and decrypts it when read Read 29 Sep 2026 · sqlite.org

Every SQLite plan and price →

Strong points and limits

Strong points

  • No separate server process or configuration.
  • Stores each database in one cross-platform file.
  • Supports JSON and window functions.
  • Free for commercial or private use.
  • Allows unlimited simultaneous readers.

Limits

  • Only one writer per database file at a time.
  • Project guidance targets low writer concurrency.
  • Private email and technical support are paid.

Who it suits

SQLite suits applications needing local database storage where writer concurrency is low and content is less than a terabyte. It is also an option when an embedded database is preferable to a separate server process.

SQLite in depth

Read the full write-up

Overview

SQLite is a transactional SQL engine built into the application that uses it, rather than a separate database server. It is best suited to device-local storage where writes are modest; its single-writer limit is the key reason to consider another architecture for busier write workloads.

A database lives in one cross-platform disk file, and the engine requires no configuration. That compact deployment model makes SQLite a practical fit when an app needs structured local data without operating a server. The project recommends it for less than a terabyte of content and low writer concurrency.

Key features

SQL and transactions

SQLite supports partial indexes, indexes on expressions, JSON, common table expressions and window functions. That is a capable SQL foundation for applications that need more than simple key-value storage. Transactions are atomic, consistent, isolated and durable, including after system crashes and power failures, an important safeguard for device-local data.

Concurrency and security

Unlimited readers can access a database at once, but each database file accepts only one writer at a time. Read-heavy applications can benefit from that concurrency; applications that need simultaneous writes should look elsewhere or reconsider how they divide their data.

SQLite is extensively fuzz-tested. For applications that accept untrusted SQL, its security guidance recommends defensive settings and lower input limits. Those precautions matter particularly when SQL comes from outside the application’s control.

Deployment and support

SQLite is self-hosted and has no managed service. 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. A free public forum is available; private email and technical support are paid options.

Pricing

The core SQLite engine costs nothing, for any purpose, with no license required. Its public-domain source code is free for commercial and private use. Paid offerings are separate support, membership, licensing and extension options, rather than charges for the core engine.

SQLite Consortium Membership: $150 a year for premium enterprise support, on-site visits, proprietary extensions and test suites.

Technical Support: $885 a year for high-priority email and phone support; a guaranteed response time is 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 and decompresses and decrypts it on read.

SQLite License: $6,000, paid once for a warranty of title and perpetual right to use SQLite source code.

The free engine is the straightforward choice for ordinary commercial or private use. The paid license is for buyers who need its stated warranty and perpetual right-to-use terms; the support and membership options fit organizations that want direct assistance or enterprise support. Extension prices apply to the specific source-code products, not to a required core subscription.

Platforms

SQLite lists Android, API, iOS, Linux, macOS, self-hosted, web and Windows. Its downloads include native binaries for several desktop and mobile platforms alongside web-focused bundles, while the self-hosted model means deployment and operation remain with the user.

Who it's for

Choose SQLite for embedded applications and device-local storage when a self-contained database file, broad platform reach and low write concurrency matter more than a managed service. It is a poor fit for workloads that regularly require multiple writers to the same database file, or for teams specifically seeking a managed database service.

Pros and cons

Pro: One cross-platform file and no separate server simplify packaging and local deployment.

Pro: The core engine is free for commercial and private use without a license, reducing both cost and licensing friction.

Pro: Unlimited concurrent readers and durable transactions suit many read-heavy device-local applications.

Con: One writer at a time per database file constrains applications with concurrent write demand.

Con: Self-hosted deployment means SQLite does not provide a managed service.

Alternatives

For a cloud database with a free offer and an explicit allowance of 100,000 vCore seconds, 32 GB of data storage, 32 GB of backup storage and 10 databases per subscription, consider Azure SQL Database. Choose MySQL instead if its GPL-licensed Community Edition and SQL/NoSQL application support are a better match. C++Builder is another option in this category.

InterSystems IRIS offers a free Community Edition; its AWS infrastructure may carry costs. RaimaDB is a paid alternative with pricing on request. For a hosted PostgreSQL option with a free tier capped at 1 CPU, 1 GB RAM, 1 GB disk and a single node, consider Aiven for PostgreSQL. Neon offers a free plan with project, compute, storage, branch and egress quotas. Actian Zen is another database alternative.

Browse Embedded Databases, Relational Databases and Database Software for more options.

Verdict

SQLite is an excellent choice for developers who need a free, durable, serverless database embedded in an app or device. Its single-file design keeps deployment simple and its SQL features cover substantial ground. Look elsewhere when concurrent writes or managed operations are central requirements.

Verdict

SQLite's single-file, in-process design is aimed at embedded and device-local storage. Its one-writer-at-a-time limit is a key constraint for workloads with concurrent writes.

Where Specifiction places it

Alternatives to SQLiteAll alternatives →