
SQLite
D. Richard Hipp · 2000
SQLite is a C library that embeds a relational database engine directly into applications. It stores data in a single cross-platform file. It delivers ACID transactions and most SQL-92 features—but omits materialized views, full trigger support, and ALTER TABLE. It relies on file-system locking, not internal concurrency control. It enforces access via file permissions, not users or roles. Its type system is dynamic by default. It is widely deployed because it requires no installation, configuration, or administration.