SQLite
SQLite: A free, serverless SQL engine for applications that need local, embedded storage. Ranked #10 of 37 in Relational Databases by our editors (8.5/10); pricing: Free plan; best for embedded databases for applications.
At a glance
- Editor score8.5 / 10
- PricingFree plan
- Best forEmbedded databases for applications
- Free planYes
- Paid fromFree
- Deployment modelSelf_hosted
- Founded2000 · Charlotte, North Carolina, USA
- Facts checked22 Sep 2026
Where it wins
- Serverless, zero-configuration operation with single-file storage
- Full SQL plus JSON, indexes, triggers, views, and CTEs
- Runs across desktop, mobile, Linux, and self-hosted environments
Where it doesn't
- No managed service or high-availability deployment model
- Distributed production systems are outside its core fit
- Application teams manage deployment, backups, and operations
Our verdict on SQLite
SQLite is an embedded, self-contained SQL database engine implemented as an in-process C library. It stores complete databases in single cross-platform disk files and runs without a separate server process or configuration. That makes it a strong fit for applications, mobile devices, embedded systems, and small to medium-sized websites that need local relational storage with a small operational footprint. Its public-domain source code also supports commercial and private use.
The published model is straightforward: SQLite is open source and free to use, with no hosted service or paid tier to select. Its capabilities are delivered through the database engine itself, including ACID transactions, crash-resistant durability, full-featured SQL, native JSON and JSONB functions, a standalone command-line interface, and an online backup API for live database copies. Write-ahead logging can support concurrent readers and writers, while indexes, triggers, views, common table expressions, and window functions cover substantial application querying needs.
Platform fit is a central strength. SQLite runs on Windows, macOS, Linux, iOS, Android, and self-hosted environments, giving teams one single-file storage model across varied application targets. The trade-off is architectural: SQLite is a library rather than a hosted database service, and it does not provide a managed-service or high-availability deployment model. Choose it when an application benefits from embedded storage, simple deployment, and direct control of database files. Consider another relational database when distributed production operation, managed infrastructure, or high availability is a primary requirement.
Your product? Our editors can test SQLite in depth and publish a review, labelled as paid · from $149/mo →
SQLite pricing
SQLite fact sheet
| Free plan | Yes |
|---|---|
| Paid from | Free |
| Deployment model | Self_hosted |
| Managed service | No |
| High availability | Not verified |
| Read replicas | Not verified |
| Backup retention | Not verified |
| JSON data support | Yes |
| Maximum connections | Not verified |
| Deployment | Self-hosted, Desktop, Mobile |
| Platforms | Windows, macOS, Linux, iOS, Android |
| Support | Email, Phone, Community |
| Built for | Solo, Small business, Mid-market (editorial estimate) |
| Pricing | Free plan |
| Website | sqlite.org |
| Facts checked | 22 Sep 2026 |
Alternatives to SQLite
- PostgreSQLA free, extensible relational database for production workloads and technical teams.9.4
- MySQLA versatile open-source SQL database with replication, JSON, connectors, and failover.9.3
- Oracle DatabaseA mature enterprise database with unusually broad data-model and availability capabilities.9.2
Also Ranked In
SQLite is ranked in 5 of our directories.
Used SQLite? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used SQLite for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
SQLite is listed in our Relational Databases directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/sqlite/"><img src="https://www.itechguides.com/best/badge/sqlite.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update