lobste.rs is now running on SQLite

9 hours ago

Lobste.rs migrated from MariaDB to SQLite after planning since 2018, initially targeting PostgreSQL but switching to SQLite last year.
The migration was completed recently and is now considered stable, with improvements in CPU usage, memory usage, performance, and reduced VPS costs.
The Lobsters Rails app runs on a single VPS with multiple SQLite database files, including a 3.8GB primary database and smaller cache, queue, and security databases.
The migration involved significant code changes detailed in a PR by Thomas Dziedzic, building on previous work, and serves as a case study for using SQLite in 2026.

Hasty Briefsbeta