Notes

Small things about Linux, databases and boring infrastructure.

SQLite in WAL mode is enough for most side projects

Three years of running a small service on a single file, what broke, and the two pragmas that mattered more than the rest.

Systemd timers instead of cron: a short migration note

Logs in one place, no missed runs after a reboot, and a template unit that took eleven lines.

Backups I actually restore

A restic repository, a cheap object storage bucket, and a monthly reminder to restore something on purpose.