SQLite
A complete SQL database in a single file and a small C library, the most deployed database in the world. See how developers rate it month by month on DTDb.
- Category
- database engine
- Developer
- SQLite team
- Created by
- D. Richard Hipp
- First release
- 2000
- License
- Public domain
- Open source
- Yes
- Pricing
- Free
- Website
- https://sqlite.org
- Written in
- C
- Data model
- Relational
- Storage layout
- Row-oriented
- Workload
- Transactions (OLTP)
- Analytics architecture
- Not an analytics platform
- Query language
- SQL
- ACID transactions
- Yes
- Schema
- Flexible
- Deployment
- Embedded
- Scaling
- Single node
- Create, read, update, delete
- Create: moderate (Fast in a transaction, one writer at a time); Read: fast (Reads straight from a local file, no network); Update: moderate (One writer at a time); Delete: moderate (Freed pages are reused, VACUUM shrinks the file)