SQLite is a self-contained, high-reliability, embedded, full-featured, public-domain, SQL database engine. SQLite is the most used database engine in the world. It is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.
The database file format is cross-platform – you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures.
These features make SQLite a popular choice as an Application File Format. SQLite database files are a recommended storage format by the US Library of Congress. Think of It not as a replacement for Oracle but as a replacement for fopen().
Very carefully tested prior to every release and has a reputation for being very reliable.
Transactions are ACID even if interrupted by system crashes or power failures.
Supported by an international team of developers who work on SQLite full-time.
SQLite is open and honest about all bugs and provides bugs lists and minute-by-minute chronologies of code changes.