4 ms·
> A small, cool fact about SQLite is that its columns are flexibly typed I don't think that's cool - I think it's horrible.
by hans_castorp 5y ago
> A small, cool fact about SQLite is that its columns are flexibly typed
I don't think that's cool - I think it's horrible.
- nooorofe 5y agofrom my experience, mixed values in a column silently kills index.
- IshKebab 5y agoYeah 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.
- randomdata 5y agoSQL is dynamically typed, so it stands to reason that the storage engine behind it be too. Of course, SQL is horrible, so...
- hans_castorp 5y ago> 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".
- randomdata 5y agoThe 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.