Most teams reach for Postgres because "SQLite is for embedded use." That assumption is years out of date. SQLite with WAL mode and Litestream replication runs real production workloads at 50,000 writes per second. Here is when it's the right tool, the patterns that work, and the limits to know.