SQLite
3 posts tagged #sqlite
3 posts on SQLite, 2 of them in the Dev Tools & AI Workflow pillar, with 1 in AI in Production — most read: “Single File Web App SQLite: Migrations + Backups That Work” and “SQLite WAL Mode in Production APIs: Concurrency Limits”.
Developer Tools Single File Web App SQLite: Migrations + Backups That Work
“One binary + one database file” is a great deployment model until you hit migrations under load and WAL backups. Here’s the safety-first playbook I actually trust.
Technology SQLite WAL Mode in Production APIs: Concurrency Limits
SQLite in production is real. WAL mode buys you read/write concurrency and great latency. The trap is write contention, checkpoints, and backups. Here’s the decision guide, tuning defaults, and a runnable load test + restore drill.
Developer Tools SQLite vs PostgreSQL 2026: Which DB Wins for App Backends?
I'd pick SQLite for single-server apps under ~10k daily active users and PostgreSQL the moment you need concurrent writes, multi-node deployments, or a team larger than one. The fault line isn't size — it's concurrency and operational complexity.
Keep exploring
Close to this topic, not on this page.
