9 ms·

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? (

by wruza 5y ago

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 5y ago
for me mixed value types killed index, which drastically affected performance