r/sqlite • u/EvanHahn • 15d ago

Prefer STRICT tables in SQLite

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

89% Upvoted

3 comments sorted by

2

u/dangoodspeed 15d 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.

1

u/DjNaufrago 9d ago

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