The more I deal with edge cases in SQLite, the more I realize it's not actually a very good database.
-
Oh god what
SQLite is dynamically typed. Type names affect "type affinity", which only means "try to store this value as this type, if the conversion is lossless and reversible". Any column can store any type.https://twitter.com/sgrif/status/942136720392306688 …
-
-
So for example, inserting `'1'` into a column with a type called `INTEGER` will get stored on disk as a 1 byte integer, but that's literally irrelevant from the outside
-
SQLite is basically The Dude. Integer? That's, like, your opinion, man.
End of conversation
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.