In-process & embedded engines · SQLite (public domain)
SQLite
Serverless, in-process SQL database engine that reads and writes a single file, embedded inside applications worldwide.
SQLite is not an analytics product, but it is included here because it is the architectural model the modern generation of embedded analytical engines is explicitly built on: DuckDB is commonly described as "SQLite for analytics," and understanding SQLite clarifies what that comparison means. SQLite implements a full SQL database as a single C library with no separate server process: an application links it directly and reads/writes one ordinary disk file, with no configuration, ports or accounts involved. It is row-oriented and optimized for transactional workloads (OLTP) rather than analytical aggregation, which is precisely the gap DuckDB and similar engines fill by applying the same embedded, serverless model to columnar, analytical queries instead. SQLite's code is released into the public domain, making it free for any use without a license, and it is estimated to be the most widely deployed database engine in the world, present in browsers, phones and countless applications.
At a glance
| Vendor | SQLite (public domain) |
|---|---|
| Pricing model | Open source + paid options |
| Free tier | Yes |
| Deployment | Self-hosted |
| Open source | Yes (Public Domain) |
| Best for | Developers embedding a zero-administration transactional database directly inside an application or device. |
Pricing
Free for any use under a public-domain release; optional paid support and warranty-of-title licenses are available separately.
Pricing has not been verified yet — see the vendor's site.
Features
- Serverless, in-process SQL engine with no configuration
- Entire database stored in a single cross-platform file
- ACID-compliant transactions
- Row-oriented storage tuned for transactional workloads
- Bindings and drivers for virtually every programming language
- Zero-administration deployment inside applications
Integrations
Profile last reviewed September 21, 2026