News for hackers. Stuff that matters.
Re:Databases in 2024: A Year in Review by zzzeek on Thursday January 02, 2025 @10:13AM (#42575090)
PostgreSQL is very very good about really never doing this, and also a scalar vs. list is pretty much a PostgreSQL case since most other relational DBs dont have a native ARRAY type. I think you're mostly thinking of MySQL that has some int/string coercion cases which are to be clear bad, but not as egregious as "any arbitrary type goes right in with no checking whatsoever.

as mentioned, SQLite breaks all these rules and I think SQLite is very wrong on this.

There are no comments on this comment yet.