SQLite should have editions
Summary
A personal blog post arguing that SQLite's default settings are suboptimal and proposing a novel 'edition' pragma to standardize sensible defaults (enable foreign_keys by default, set busy_timeout, WAL, and synchronous settings, and make strict tables the default). It covers issues with foreign key enforcement, type affinity, concurrent writers, and performance, and suggests a year-based edition system to evolve defaults without breaking compatibility.