News for hackers. Stuff that matters.

A comment on Feature Casualties of Large Databases. Parent comment

Re:Feature Casualties of Large Databases by zozbot234 on Wednesday December 02, 2020 @07:06AM (#25275616)
PostgreSQL supports arrays as a first-class feature. There's very little issue with "unnormalized" data when the data will never be used as a lookup key within the database.
[ Parent | on HN ]
Re:Feature Casualties of Large Databases by roenxi on Wednesday December 02, 2020 @03:41PM (#25281290)
SQL was designed somewhat before PostgreSQL decided to support arrays. It is a terrible, terrible language for dealing with non-normal data.

If you are doing string parsing in SQL, mistakes were made.

[ Parent | on HN ]