I tried a quick search for “sqlite [dynamic] typ{e,ing} pitfalls”, but got mostl... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		wruza on Aug 22, 2021 \| parent \| context \| favorite \| on: Strict Tables – Column type constraints in SQLite ... 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 on Aug 22, 2021 [–]

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

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact