🔗 Lobste.rs is now running on SQLite

Lobste.rs has officially migrated from MariaDB to SQLite. This decision, which began in August 2018 with plans initially focused on PostgreSQL, culminated successfully over the past weekend. The new architecture has shown performance improvements, including reduced CPU and memory usage, making the site feel snappier. The Lobsters Rails application now operates on a single VPS with an SQLite database file of approximately 3.8GB, supplemented by a cache and queue database, and a rack_attack database. The migration PR optimized the code significantly, reflecting a modern approach to server management with minimal resources. This case study serves as a potent reminder of how effective SQLite can be for smaller applications in 2026.