SQLite in Production: Optimizing WAL Mode, Concurrency, and VFS Layers | Hacker News

A Hacker News thread debated whether SQLite is viable for production workloads.

Supporters said SQLite works well when the use case fits, while critics raised limits around concurrency, migrations, and schema changes.

Operational concerns included GUI access, WAL tuning, and migration workflows, with Postgres often cited as the richer alternative.

The discussion underscored the tradeoff between SQLite’s simplicity and its narrower tooling and evolution path.