Post #1820171
2026-04-27 07:47 UTC
@monospace My biggest gripe with SQLite is their non-existing data type system which permits storing any value in a column regardless of the data type it was defined with (in fact, the type is optional and completely ignored)
https://dbfiddle.uk/hQNQafJm
The new "strict" tables solve this only partially, as that is only available for a limited number of data types
Replies (1)
-
@monospace@floss.social 2026-04-27 11:41
@truls46 Huh, coming from server-based DB like Oracle, MySQL, and PostgreSQL, that's certainly surprising. I'm still to use SQLite in my own projects. Good to know this shortcoming.