SQLite

In-process SQL database engine that runs embedded inside applications with no separate server, zero configuration, and a single file per database. Reads and writes directly to disk files and implements full SQL with ACID transactions, making it suited for local data storage on devices and desktops rather than shared enterprise repositories.

SQLite is the most widely deployed database engine in the world. It ships inside all major mobile operating systems and most computers, and underpins countless applications, version control tools, browsers, and IoT devices. The engine is public domain and free for any use. Unlike PostgreSQL or MySQL, SQLite targets application-local storage and is often described as a replacement for fopen rather than for Oracle. Its file format is cross-platform and recommended by the US Library of Congress for long-term storage. The project maintains 100% branch test coverage and releases with backward compatibility guaranteed through 2050.

Key capabilities:

• Single-file database with cross-platform format, copyable between architectures
• Full SQL support: window functions, JSON extension, triggers, views, common table expressions
• ACID transactions that survive crashes and power loss
• Minimal footprint, often under 900 KiB with all features enabled
• Native bindings for C, Python, JavaScript, Go, Rust, and most mainstream languages

Embedded devices and IoT deployments benefit from zero administration. Desktop applications use it as an on-disk file format with no separate database process. Low to medium traffic websites often run fine on SQLite. Data analysts use the sqlite3 shell to slice CSV imports and ad-hoc datasets. Developers rely on it for local caching, testing, demos, and as a portable data transfer format in a single compact file.