FactArticle

Lobsters completed its migration to SQLite this weekend and now considers it stable enough to be the permanent architecture going forward.

The migration finished over the weekend and the site's operators now treat SQLite as the long-term backend. ✦ AI generated

Simon Willison · Simon Willison's Weblog · 2026-07-14 · original ↗

Share card ↓Export .md Export .txt

This weekend they completed the migration, and now consider it stable enough that it looks like this is the permanent architecture for the site going forward

Read full article ↗excerpt · fair-use quotation

▦ Lobsters ✳ SQLite

Around this claim

Evidence · 1

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.Lobsters site operator (quoted from migration thread) · Simon Willison's Weblog · conf 65%

Context · 1

Lobsters had been planning to migrate away from MariaDB since August 2018, originally aiming for PostgreSQL before switching its target to SQLite last year.Simon Willison · Simon Willison's Weblog · conf 80%

This moment responds to

supports → The Lobsters migration is a useful case study showing that a single server running SQLite can accomplish a lot in 2026.Simon Willison · Simon Willison's Weblog