Hacker News Reader

Yeah I think they meant to write "A subtle braindead footgun about SQLite..."

I love SQLite but that's easily the most broken thing about it. Also foreign keys are not enforced by default which I'm sure has caused lots of people unexpected pain.

from my experience, mixed values in a column silently kills index.

SQL is dynamically typed, so it stands to reason that the storage engine behind it be too.

Of course, SQL is horrible, so...

> SQL is dynamically typed,

No, it's not. It's strongly type.

The SQL standard clearly states that you can't store 'abc' in a column defined as integer (or date or timestamp or boolean).

It has some well defined implicit casting rules if you compare values of different types. But that has nothing to do with "dynamically typed".

The opposite of strongly typed is weakly typed, not dynamically typed. A language can be both dynamically typed and strongly typed. Python, for example.

The opposite of dynamically typed is statically typed. SQL is not statically typed.