sqlite.org/
What is SQLite?
SQLite is free. SQLite keeps the whole database in a single file on disk. It fits local tools, tests, and small apps that do not need a hosted Postgres yet.
SQLite is a tool in the Databases category of a tech stack.
Level
Key Features
Single fileSQLNo separate server
SQLite Pros & Cons
Pros of SQLite
Nothing to install beyond the library
Easy to copy, back up, or reset in development
Drizzle can use it the same way as Postgres
Cons of SQLite
One writer at a time is the comfortable limit
You outgrow it once you need hosted auth and storage