Posts about engineering
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.