> STRICT should be the default. Somewhat ironically[^1], if STRICT were suddenly made the default, countless applications which work today would fail to work r

> STRICT should be the default. Somewhat ironically[^1], if STRICT were suddenly made the default, countless applications which work today would fail to work right after that update. SQLite is on billions upon billions of devices, frequently with many installations on any given device, and even a 0.001% regression rate adds up to many, many clients. One of the reasons people trust SQLite is because, as a project policy, it does not pull the rug out from under them by changing long-held defaults. [^1]: it's ironic because proponents of Strict tables frequently say that it improves app stability and robustness, whereas activation of Strict tables in apps not designed to handle it will, in fact, make them more fragile. Spoiler alert: most SQLite apps are not designed for Strict tables.