I'm pretty hopeful that DuckDB will replace some of the use of SQLite. SQLite is... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

IshKebab on May 22, 2021 | parent | context | favorite | on: An early look at Postgres 14: Performance and moni...

I'm pretty hopeful that DuckDB will replace some of the use of SQLite. SQLite is great but it sucks that it's entirely dynamically typed (the types specified for columns are completely ignored).

dragonwriter on May 25, 2021 [–]

> the types specified for columns are completely ignored

They aren’t constraints (except in the case of “INTEGER PRIMARY KEY”), but they also aren’t “completely ignored”, because of type affinity.

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