One Command Would Bundle SQLite's Safer Defaults By Year
SQLite's proposed PRAGMA edition=2026 would enable foreign keys, strict typing and WAL mode, fixing silent data corruption from lax defaults.
- SQLite ignores foreign keys by default, letting deleted rows leave dangling references.
- Edition 2026 would turn on foreign keys, strict typing and WAL mode via one PRAGMA line.
- The model is Rust's yearly edition system, which keeps old code's behavior unchanged.
Why it matters: Backward compatibility, not ignorance, is why a database can keep dangerous defaults for decades.
mort.coffee (author "Mort"), blog post "SQLite should have (Rust-style) editions" ↗ · Jul 15, 20267/15/26 · ✓ Checked✓ Check