Lobste.rs Successfully Migrates to SQLite with Major Performance Gains
Lobste.rs is now running on SQLite
After years of discussion and multiple deployment attempts, I successfully migrated Lobste.rs from MariaDB to SQLite. The switch resulted in lower CPU and memory usage, reduced hosting costs, and a snappier site experience. Despite initial performance hurdles caused by full table scans, careful debugging and community collaboration ensured a smooth transition that passed the Monday traffic spike with flying colors.
"Migrating the underlying database without having access to the production database is really hard to get right."
HN discussion
- SQLite was chosen over PostgreSQL for pragmatic reasons, specifically to eliminate the overhead of running a separate database service and reduce operational complexity.
- Critics argue that the site's migration has introduced instability, with reports of pages taking seconds to load and recent incidents causing data loss and read-only mode outages.
- Lobste.rs is described as a monoculture with strict anti-AI policies that force LLM topics into a 'vibecoding' tag and aggressively downvote dissenting views, potentially driving away contributors.
- Concerns raised in the migration post about MariaDB potentially going closed-source are dismissed as legally impossible, given its GPL licensing and the separation between the commercial entity and the non-profit foundation.
- Users contrast Lobste.rs with Hacker News, noting the former maintains a narrower scope focused on programming and avoids the 'bot central' and AI saturation prevalent on the latter.