Simon Willison • 7/14/2026

lobste.rs is now running on SQLite

This article details how the community site Lobste.rs successfully migrated from MariaDB to SQLite after years of planning. The migration, completed in July 2026, resulted in lower CPU and memory usage, a snappier site, and reduced hosting costs by eliminating a separate database VPS. The Rails application now runs on a single VPS with a 3.8GB primary SQLite database, plus cache, queue, and security databases. The article includes links to the migration pull request and community discussion, serving as a case study for using SQLite in production web applications.

0 comments

#migration #sqlite #database