Field Notes

SQLite is enough, more often than you think

October 12, 2026

Most of my side projects store a few thousand rows. For years I set up a full database server for each of them, with users, backups and a monitoring check that nobody read.

Then I tried the opposite: one file next to the application. Backups became cp. Migrations became a short script. The whole thing fits in a container volume.

What to turn on

PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;
PRAGMA foreign_keys = ON;

Write-ahead logging lets readers and one writer coexist, which covers the vast majority of small web apps. When you outgrow it, you will know, and the schema moves over without drama.

← All posts