Product & software
SQLite
An embedded SQL database that runs inside an application and stores a complete database in an ordinary file.
At a glance
- Deployment model
- Embedded library
- Source code
- Public domain
Overview
SQLite is a database engine implemented as a library. An application can read and write SQL data without operating a separate database server. Tables, indexes, triggers, and views can share one database file, making storage part of the application itself.
A database in a file
SQLite works directly with disk files. Its portable file format allows databases to move between supported systems, and the application can use SQL to access structured records rather than design a custom storage format.
Transactions and operation
SQLite supports transactions and is tested against failures including crashes and interrupted writes. Its lack of a separate server simplifies deployment, but applications still need to handle disk errors and choose an appropriate data-access design.
Sources and review
MOOR's explanatory text is supported by the following source links.
- About SQLite — SQLite
- SQLite: supporting documentation — SQLite