Comparison of Joins: MongoDB vs. PostgreSQL

Re:Comparison of Joins: MongoDB vs. PostgreSQL by jeltz on Friday April 10, 2020 @01:13PM (#22835047)

PostgreSQL has the JSONB data type which is essentially the same as the BSON type except slightly better optimized for reading partial documents. And PostgreSQL also provides good indexing support for them, and did so before MongoDB.

[ Parent | on HN ]

Re:Comparison of Joins: MongoDB vs. PostgreSQL by zozbot234 on Friday April 10, 2020 @01:21PM (#22835109)

Postgres can also be made to shard any table to multiple hosts via the PARTITION BY RANGE/PARTITION OF feature, combined with the FOREIGN DATA WRAPPER (FDW) core extension.

[ Parent | on HN ]

Re:Comparison of Joins: MongoDB vs. PostgreSQL by Beefin on Friday April 10, 2020 @01:15PM (#22835066)

have you tried using the postgres json data type? it's a joke.

[ Parent | on HN ]

Re:Comparison of Joins: MongoDB vs. PostgreSQL by eyelidlessness on Friday April 10, 2020 @01:31PM (#22835205)

Not really sure about the `JSON` type, but the `JSONB` type is excellent.

[ Parent | on HN ]

Re:Comparison of Joins: MongoDB vs. PostgreSQL by LunaSea on Friday April 10, 2020 @01:19PM (#22835092)

Can you list some reasons?

[ Parent | on HN ]

Re:Comparison of Joins: MongoDB vs. PostgreSQL by thinkx on Saturday April 11, 2020 @06:56AM (#22841021)

that’s a throwaway opinion, worth the time you spent writing it

[ Parent | on HN ]