SQLite in production on a VPS
SQLite is the right production database for most small apps on one VPS. WAL mode, busy_timeout, Litestream replication, and the limits that break it.
#sqlite
Filtering by topic #sqlite · clear
DuckDB vs SQLite on a server
SQLite holds transactional application state. DuckDB answers analytics over Parquet and CSV. Why one VPS usually runs both, with a worked example of each.