Dev Tools · 3h ago
Lobsters migrates from MariaDB to SQLite, cuts costs and CPU usage
The social news site Lobsters successfully migrated its production database from MariaDB to SQLite over the weekend. CPU and memory usage dropped, site responsiveness improved, and the team will halve VPS costs by decommissioning the MariaDB server. The migration, which took years of community effort, was finalized after a failed deploy in February.
Meridian48 take
The move underscores SQLite's surprising viability for low-traffic web apps, but don't expect this to scale for high-concurrency sites.
sqlitedatabase-migration