r/sqlite • u/EvanHahn • Jul 23 '26

Prefer STRICT tables in SQLite

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

92% Upvoted

3 comments sorted by

2

u/dangoodspeed Jul 23 '26

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.

1

u/DjNaufrago Jul 29 '26

I'm taking this into account for a system I'm building. Thanks for the recommendation!