I wrote a blog post about various annoyances I have with SQLite's defaults, and a suggestion about how it could be fixed: SQLite should have editions:

https://mort.coffee/home/sqlite-editions/

#sqlite #databases #rdbms #embedded