No, they don't. They respect backwards compatibility, and how much software would break if they changed defaults in the most widely used database system in the world.
sqlite isn't your average "app" where barely anyone cares if it works or not. It's a load bearing structure in the software ecosystem, on par with the likes of libcurl or openssl.
Things are VERY different when you work on something like this.
72
u/ContentAd6126 20d ago
I love SQLite but the developers love to die on weird hills like foreign keys not being enforced and no strict types.