Data◆Article
Switching to SQLite reduced CPU and memory usage, made the site feel snappier, and will halve the VPS cost once the MariaDB server is decommissioned.
A Lobsters operator reports the SQLite switch cut resource usage and cost while improving perceived performance. ✦ AI generated
Lobsters site operator (quoted from migration thread) · Simon Willison's Weblog · 2026-07-14 · original ↗
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
Read full article ↗excerpt · fair-use quotation
- ·CPU usage down after migration
- ·Memory usage down after migration
- ·Site feels snappier to operator
- ·VPS cost to halve once MariaDB server is decommissioned
- ·Confirms SQLite as viable production database
Around this claim