ChipsLobstersabout 3 hours ago
lobste.rs is now running on SQLite
5 min read
Lobste.rs deployed SQLite to production after migrating from MariaDB. CPU and memory usage dropped, site responsiveness improved, and hosting costs halved by removing the MariaDB VPS. The migration required custom SQLite user-defined functions, collation changes, and fixing full table scan performance issues during a failed first deploy.
Level
Hype check
Tap to vote and see what everyone thinks.
Summary by ByteBrief
