SQLite

SQLite is an embedded relational database — the entire database lives in a single file, accessed via the sqlite3 CLI or application libraries. It excels at local storage, edge deployments, and read-heavy workloads. Be cautious when many processes write concurrently; WAL mode improves concurrency but SQLite still allows only one writer at a time.