News for hackers. Stuff that matters.

A comment on An early look at Postgres 14: Performance and monitoring Improvements. Parent comment

Re:An early look at Postgres 14: Performance and monitoring ... by IshKebab on Saturday May 22, 2021 @06:04PM (#27250687)
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).
[ Parent | on HN ]
Re:An early look at Postgres 14: Performance and monitoring ... by dragonwriter on Tuesday May 25, 2021 @06:30PM (#27283574)
> 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.

[ Parent | on HN ]