Comment by BenjiWiebe

15 days ago

SQLite did add 'STRICT' tables for type enforcement.

Still doesn't have a huge variety of types though.

4 comments

BenjiWiebe

Reply
mikeocool  15 days ago

The fact that they didn’t make STRICT default is really a shame.

I understand maintaining backwards compatibility, but the non-strict behavior is just so insane I have a hard time imagine it doesn’t bite most developers who use SQLite at some point.

  • sgbeal  15 days ago

    > The fact that they didn’t make STRICT default is really a shame.

    SQLite makes strong backwards-compatibility guarantees. How many apps would be broken if an Android update suddenly defaulted its internal copy of SQLite to STRICT? Or if it decided to turn on foreign keys by default?

    Those are rhetorical questions. Any non-0 percentage of affected applications adds up to a big number for software with SQLite's footprint.

    Software pulling the proverbial rug out from under downstream developers by making incompatible changes is one of the unfortunate evils of software development, but the SQLite project makes every effort to ensure that SQLite doesn't do any rug-tugging.

  • sethops1  15 days ago

    Nearly every default setting in sqlite is "wrong" from the outset, for typical use cases. I'm surprised packages that offer a sane configuration out of the box aren't more popular.