Posts about sqlite
Backing up a self-hosted zerosoft: one database, one folder, one .env
A self-hosted zerosoft is a SQLite file, an uploads folder and an .env. How to copy them while the app runs, store them off the server and test a restore.
One codebase, two databases: a local SQLite file or Turso
zerosoft runs on a SQLite file on disk or on a remote Turso database, switched by one environment variable. How it works in the code and how to choose.
Versioned migrations without an ORM: a baseline, a list and one table
How zerosoft changes its SQLite/libSQL schema with numbered migrations in plain TypeScript, why each one must survive running twice at once, and the SQLite trap that can delete data.
Rate limiting without Redis: one table and one UPSERT
How zerosoft rate-limits its API and public endpoints with a fixed-window counter in the same SQLite/libSQL database, and when that stops being a good idea.
SQLite is enough for apps like ours
The most deployed database runs in your phone, your browser and Link. Millions of rows, WAL mode, and backups that are a file copy.