I wrote a blog post about various annoyances I have with SQLite's defaults, and a suggestion about how it could be fixed: https://mort.coffee/home/sqlite-editions/ TL;DR: SQLite should have a Rust-style edition system which lets us set a whole suite of more sensible defaults with a single 'PRAGMA edition = 2026'. #sqlite #databases #rdbms #embedded