lobste.rs is now running on SQLite

The community website Lobsters has officially migrated its infrastructure from MariaDB to SQLite. While the site originally planned to switch to PostgreSQL starting in 2018, developers shifted their focus to SQLite last year. The transition is now complete, and the site is considered stable enough to remain on this architecture permanently.

The Rails application now operates on a single virtual private server. The primary content is stored in a 3.8GB SQLite database, supported by smaller databases for caching, task queuing, and request throttling. The migration involved extensive code changes, including modifications across 188 files to ensure the system functioned correctly with the new database engine.

This change has resulted in measurable performance improvements, including lower CPU and memory usage. Additionally, the site is faster for users and has reduced hosting expenses by half now that the separate MariaDB server is no longer required. This migration serves as a practical case study demonstrating that a single server running SQLite can effectively handle the demands of a community platform in 2026.