lobste.rs is now running on SQLite
Named practitioner synthesis
#188
- Topic
- Practitioner Notes
- First seen
- 2026-07-16 19:08:00
- Last seen
- 2026-07-16 19:08:00
Source raw items (1)
- Blog / Newsletter2026-07-16 19:07:19lobste.rs is now running on SQLite
<p><strong><a href="https://lobste.rs/s/ko1ji1/lobste_rs_is_now_running_on_sqlite">lobste.rs is now running on SQLite</a></strong></p> Community site <a href="https://lobste.rs">Lobsters</a> has been planning a migration away from MariaDB <a href="https://github.com/lobsters/lobsters/issues/539#issuecomment-4959857588">since August 2018</a> - originally targeting PostgreSQL, but last year they decided to <a href="https://github.com/lobsters/lobsters/issues/539#issuecomment-2964114295">investigate SQLite</a> instead.</p> <p>This weekend they completed the migration, and now consider it stable enough that it looks like this is the permanent architecture for the site going forward:</p> <blockquote> <p>SQLite seems to have passed with flying colors: cpu usage is down, memory usage is down, site seems to be snappier at least for me, 1/2 the vps cost once mariadb vps is taken down</p> </blockquote> <p>The Lobsters Rails application now runs on a single VPS, with a primary content SQLite data