2 ms·
You may be interested in STRICT Tables [1], introduced just 6 months ago: > Some developers appreciate the freedom that SQLite's flexible typing rules provide
by infogulch 4y ago
You may be interested in STRICT Tables [1], introduced just 6 months ago:
> Some developers appreciate the freedom that SQLite's flexible typing rules provide and use that freedom to advantage. But other developers are aghast at SQLite's flagrant rule-breaking and prefer the traditional rigid type system found in all other SQL database engines and in the SQL standard. For this latter group, SQLite supports a strict typing mode, as of version 3.37.0 (2021-11-27), that is enabled separately for each table.
[1]: https://www.sqlite.org/stricttables.html https://www.sqlite.org/stricttables.html
Related past discussions:
Strict Tables – Column type constraints in SQLite - Draft | 2021-08-21 | 331 points, 108 comments | https://news.ycombinator.com/item?id=28259104 https://news.ycombinator.com/item?id=28259104
SQLite Release 3.37.0 | 2021-11-27 | 333 points, 112 comments | https://news.ycombinator.com/item?id=29363054 https://news.ycombinator.com/item?id=29363054