Hacker News new | ask | show | jobs
by ranit 1859 days ago
> Do any other entrenched software projects come to mind?

SQLite.
1 comments
IshKebab 1859 days ago
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).
link
dragonwriter 1856 days ago
> 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.

link