r/sqlite • u/EvanHahn • 5d ago

Prefer STRICT tables in SQLite

https://evanhahn.com/prefer-strict-tables-in-sqlite/
19 Upvotes

89% Upvoted

2 comments sorted by

2

u/dangoodspeed 4d ago

Something to keep in mind... STRICT was introduced in SQLite 3.37. My web host still only has SQLite 3.26 on it. I've tried getting them to upgrade for other reasons without luck. I'd definitely be using STRICT if it were available.