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.
database - DevProfit
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.