SQLite

Meet SQLite

SQLite is an embedded SQL database engine that runs inside an application without a separate database server. It stores tables, indexes, views, and other database structures in a single portable file, making it useful for mobile apps, desktop software, embedded devices, and local data storage. Developers can use its C interface or bindings for other languages to query and update data.

The library supports transactions, joins, JSON functions, and window functions, while a command-line tool helps users inspect databases and run SQL scripts. Its public-domain source code is free for commercial and personal use. SQLite also works well for application file formats, testing, and smaller websites. Each database allows one writer at a time, which is worth considering for workloads with heavy concurrent updates.