News for hackers. Stuff that matters.
Re:Why Uber Engineering Switched from Postgres to MySQL (2016) by colanderman on Saturday February 27, 2021 @10:04AM (#26285255)
Yes! Have one-to-many data that you know you will usually always grab all in one go, and won't ever participate in a relation? Arrays are the way to go. JSONB can be similarly highly appropriate. They can greatly reduce the number of disk reads needed for certain workloads.

Don't forget that both can be indexed in Postgres! And the indexes are more powerful than what you can do with the equivalent relational layout, as they support efficient subset queries.

Re:Why Uber Engineering Switched from Postgres to MySQL (2016) by sk5t on Saturday February 27, 2021 @01:03PM (#26286700)
Same goes for hstore and the @> style operators.