The community site Lobsters has switched its backend database from MariaDB to SQLite, a move completed over the weekend that consolidates the entire stack onto a single virtual private server. This decision follows a planning phase dating back to August 2018, during which the team initially considered PostgreSQL before settling on the embedded solution. The migration was executed by Thomas Dziedzic through a series of thirty commits affecting one hundred and eighty-eight files, resulting in a primary database file of approximately 3.8GB alongside smaller caches for queuing and security throttling.
The operational results indicate lower CPU and memory consumption compared to the previous setup, which previously required a dedicated database server. Site responsiveness has improved for users, and the hosting bill is now roughly half of what it was when running MariaDB on separate infrastructure. This case study demonstrates that a single server remains a viable architecture for high-traffic community platforms in 2026 without sacrificing performance.
* Primary content database size is 3.8GB
* Total database footprint including caches is under 5.5GB
* Hosting costs reduced by 50 per cent