Why SQLite Should Adopt Rust-Style Editions to Fix Dangerous Defaults

SQLite should have (Rust-style) editions

I argue that SQLite, despite being the industry standard for local storage, suffers from dangerous defaults like ignored foreign keys and loose type checking. These settings lead to silent data corruption and referential integrity failures. I propose adopting Rust-style editions to enable strict typing and constraint enforcement by default, ensuring data safety without sacrificing the flexibility developers love.

"A dangling reference easily results in a reference to the wrong column, which is even worse than a dangling reference because everything will seem fine."