Overview
SQLite is an in-process SQL database library: there is no separate server, and a complete database with tables, indexes, triggers and views lives in a single ordinary disk file[18]. Its source code is in the public domain, so it can be used for any purpose without a licence[18]. The file format is cross-platform between 32-bit and 64-bit and big- and little-endian systems, and the project describes it as stable and enduring; the US Library of Congress recommends SQLite files as a storage format[18].
The project describes SQLite as the most widely deployed database in the world, embedded in billions of devices and applications[18]. Limits are large for an embedded engine: a maximum database size of 281 terabytes and a maximum row size of 1 gigabyte[18]. SQLite is ideal for mobile apps, browsers, desktop software, IoT devices and test environments, and is increasingly used at the edge. It is not designed for high write concurrency from many clients over a network, so it rarely replaces a client-server database for multi-user transactional systems.
What SQLite does
- Serverless, zero-configuration
- Single-file database
- Public-domain source
- Cross-platform stable file format
- Up to 281 TB per database
SQLite pricing
Free; public domain.
SQLite strengths and limitations
Strengths
- No licence or server required
- Extremely portable
- Stable file format
- Tiny footprint
Limitations
- Limited write concurrency
- No built-in network access
- No user management
- Not suited to multi-user OLTP
Appears in
SQLite alternatives and competitors
Alternatives to SQLite: companies ranked in the same lists.
- Oracle
Microsoft Power BI- PostgreSQL
- MySQL
MongoDB
Amazon Lex
Redis
IBM Consulting
MariaDB
CockroachDB
Supabase
Neon
Is this your company?
Update the description, logo, image and link through the submission form. Editors review every change.