Simon Willison
lobste.rs is now running on SQLite
infrastructure
What happened
The community site Lobsters (lobste.rs) successfully migrated its production database from MariaDB to SQLite. The Rails application now runs on a single VPS with a 3.8GB primary SQLite database, a 1.1GB cache database, a 218MB queue database, and a 555MB throttling database. The migration resulted in decreased CPU and memory usage, a snappier site, and halved VPS hosting costs.
Why it matters
It proves that modern SQLite is highly viable for production workloads on a single server, offering a blueprint for radically simplified and cheaper infrastructure.
The take
This is a massive validation for the 'SQLite in production' movement. For AI startups and LLM app builders, it proves that you don't need complex, expensive database clusters (like Postgres or RDS) to run a highly active, medium-scale community site. A single VPS with SQLite can handle significant traffic with lower latency and cost.
Don't read this site daily. Get it in your inbox.
The daily brief and Sunday deep dive — distilled, scored, and opinionated. For builders only.