manwar, 4 months ago

@ovid really? never came across.

ovid, 4 months ago

@manwar It's called "type affinity" in #SQLite. If you have a column defined as "count INTEGER NOT NULL DEFAULT 0", there's nothing to stop you from inserting the value of "foo" into that column.

It's one of the reasons why I strongly recommend not using SQLite to simulate your database in the test suite: the subtle differences in behavior means your test suite might pass, even if your code is going to fail in production.

manwar, 4 months ago

@ovid hard to believe what I just read.

barubary, 4 months ago

@manwar @ovid It's basically dynamic typing. In SQLite, each datum is typed separately and "column types" are more like suggestions.
That said, you can declare your table as strict to make SQLite behave more like other DBs. https://www.sqlite.org/stricttables.html

ovid, 4 months ago

@manwar Most databases are remarkably bad at handling data. SQLite is even worse! Fortunately, its incredible ease of use makes up for its weaknesses.

mjgardner, 4 months ago

@ovid @manwar “Sometimes when you pull the trigger it explodes at both ends. But on the upside, the safety is very easy to disengage!”