News for hackers. Stuff that matters.

A comment on Comparison of Joins: MongoDB vs. PostgreSQL. Parent comment

Re:Comparison of Joins: MongoDB vs. PostgreSQL by zozbot234 on Friday April 10, 2020 @02:54PM (#22836201)
> what’s faster than a fast join? No join. With nosql you have more flexibility to store the data organized in the same way it is accessed.

You can definitely do this in PostgreSQL via materialized views. They're directly supported in recent releases, and they don't require you to denormalize the underlying datamodel unlike NoSQL.

[ Parent | on HN ]
Re:Comparison of Joins: MongoDB vs. PostgreSQL by jmull on Friday April 10, 2020 @08:09PM (#22838652)
Well, a materialized view is denormalized data. You distinguish it from the “underlying data model”, but you can do that in nosql as well. Also, materialized views still tend to be oriented to rectangular data, which isn’t always how you want to access data.

I agree with the general point that Postgres and other relational databases can do nosql things (and nosql databases can do relational things).

[ Parent | on HN ]