News for hackers. Stuff that matters.

A comment on We’re happy with SQLite and not urgently interested in a fancier DBMS (2016). Parent comment

Re:We’re happy with SQLite and not urgently interested in a ... by rhizome on Friday May 04, 2018 @02:18PM (#16996890)
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."
[ Parent | on HN ]
Re:We’re happy with SQLite and not urgently interested in a ... by wenc on Friday May 04, 2018 @02:27PM (#16996991)
Good 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

[ Parent | on HN ]