4 ms·
Not schemaless, but typeless. SQLite will let you declare a column to be an integer and then dump a string into it, but you're still defining a table with speci
by jamie_ca 4y ago
Not schemaless, but typeless. SQLite will let you declare a column to be an integer and then dump a string into it, but you're still defining a table with specific columns.
It's like the opposite problem Mysql has when you try to write data larger than the field definition - Mysql will truncate, Sqlite will store the data you gave it.
- seanwilson 4y agoTypeless is the default though? Why wouldn't you want the types to be reliable when you're reading/writing from the backend in the general case?
- mbreese 4y agoI believe typeless is the default because of largely historical reason. Namely, typeless was the original mode and strict mode was added later. But, that’s not the only reason. There is a whole page on why typeless is a feature and not a bug. https://sqlite.org/flextypegood.html https://sqlite.org/flextypegood.html