On: Strict Tables – Column type constraints in SQLite - Draft

[wruza]

I tried a quick search for “sqlite [dynamic] typ{e,ing} pitfalls”, but got mostly irrelevant results.

Can anyone please share common pitfalls of $subj issue? (Apart from obvious “you can insert a mess into a column and get hit by it later”)

[nooorofe → wruza]

for me mixed value types killed index, which drastically affected performance