News for hackers. Stuff that matters.

A comment on Databases: 2021 in Review and Predictions for 2022. Parent comment

Re:Databases: 2021 in Review and Predictions for 2022 by phyrex on Friday November 11, 2022 @07:26AM (#33559938)
SQLite has strict mode now
[ Parent | on HN ]
Re:Databases: 2021 in Review and Predictions for 2022 by exceptione on Friday November 11, 2022 @07:28AM (#33559962)
I think I mentioned that, or I don´t understand what you mean.
[ Parent | on HN ]
Re:Databases: 2021 in Review and Predictions for 2022 by krono on Friday November 11, 2022 @08:10AM (#33560393)
Which is quite limited in scope and does not allow for boolean (faux-boolean, of course) or json columns. It also affects certain operations in ways that might not be immediately obvious.

Not sure if this has received any further work since its release.

https://sqlite.org/src/wiki/StrictMode

https://sqlite.org/stricttables.html

[ Parent | on HN ]