The Go + SQLite Stack I Actually Run in Production
One binary, one file, one cheap VPS: the honest full stack behind a Go + SQLite service — systemd, nginx, Cloudflare, backups, and what each piece is for.
sqlite - DevProfit
How to Recover a Corrupted SQLite Database: A Real-World Walkthrough
A verified, step-by-step recovery of a corrupted SQLite database using VACUUM INTO, integrity_check, and backups — including what SQLite's integrity check can and cannot catch.
SQLite vs PostgreSQL: When to Use Which (I've Built Both)
A decision framework from a developer who runs SQLite in production: when SQLite is more than enough, when PostgreSQL is worth the switch, and the honest middle ground.
SQLite in Production: 5 Mistakes That Corrupt Your Database
Five real mistakes that damage SQLite databases in production, learned the hard way — and the backup and integrity discipline that catches them before they become disasters.