I've written before about why we run SQLite in production for HelperX, and about multi-tenant isolation and backup strategy. There's one topic I kept deferring because it's genuinely hard and I didn't want to hand out advice I wasn't sure of: schema migrations.

SQLite is famous for a painful migration story. ALTER TABLE is deliberately limited —...