SQLite vs MySQL: When a File Beats a Server
A calm comparison between SQLite and MySQL from someone who runs both: when the zero-ops file wins, when you need a database server, and the honest middle.
database - 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.