lobste.rs is now running on SQLite
- ID
- 4707
- Status
- summarized
- Published
- 15 Jul 2026, 3:44 AM
- Fetched
- 15 Jul 2026, 7:02 AM
- Provider
- Simon Willison
- Category
- developer-ai
- Original URL
- https://simonwillison.net/2026/Jul/14/lobsters-sqlite/
- Source URL
- https://simonwillison.net/atom/everything/
Summary
- Score
- 7.5
- Created
- 15 Jul 2026, 7:02 AM
- Tags
- Audience
- developersdatabase_learnerssaas_founders
What happened
The community site Lobsters completed its long-planned migration from MariaDB to SQLite, now running its entire Rails application on a single VPS with a ~3.8GB primary SQLite database. CPU and memory usage dropped, the site feels snappier, and VPS cost was halved once the MariaDB server was decommissioned.
Why it matters
This is a concrete production case study showing SQLite can serve a real community site at modest scale, which is directly relevant to Malaysian builders running forums, SaaS prototypes, or side projects who want to cut infrastructure cost and complexity. It challenges the default assumption that you need a separate database server, and the migration PR is a practical reference for anyone considering a similar move.
Discussion angle
When does SQLite make sense as a primary database for a production app, and what are the trade-offs for Malaysian teams who often default to MySQL/MariaDB or Postgres on shared hosting?