Hacker News new | ask | show | jobs
by phyrex 1319 days ago
SQLite has strict mode now
2 comments

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

I think I mentioned that, or I don“t understand what you mean.