SQLite
Embedded local relational persistence, zero-configuration database engines, and lightweight state store testing.
1 / Embedded Persistence
SQLite served as a zero-configuration embedded database for lightweight state storage and testing. Its serverless architecture — a single file on disk, no daemon process — made it useful for local development, automated test suites, and applications where deploying a full database server was unnecessary overhead.
2 / Practical Use
In testing contexts, SQLite provided a fast, disposable database that could be created and destroyed per test run without requiring database server management. For small applications and prototypes, it offered persistence without infrastructure complexity. The trade-off is clear: SQLite is not designed for concurrent write-heavy workloads or multi-tenant production services, which is where PostgreSQL takes over.