Lobste.rs is now running on SQLite
lobstersSQLiteMariaDBdatabase migrationperformance improvementdata integritycustom functionsslow query logging.
Author: abetusk
Date: 7/13/2026
Article Summary:
Lobsters, a community-driven news site, successfully migrated from MariaDB to SQLite, improving performance and reducing costs. The migration involved writing scripts to handle data integrity, performance testing, and implementing custom functions in SQLite.