3 ms·
SQLite has no type safety on its fields; CSV is just text. You can create an integer field and save the value "wenc" in a SQLite record without it complaining,
by rhizome 9y ago
SQLite has no type safety on its fields; CSV is just text. You can create an integer field and save the value "wenc" in a SQLite record without it complaining, something it calls "dynamic typing."
- wenc 9y agoGood point. Type affinity via dynamic typing [1] isn't strong typing. But I think it's still slightly better than CSV's no-typing. [1] https://www.sqlite.org/faq.html#q3 https://www.sqlite.org/faq.html#q3