Re:Comparison of Joins: MongoDB vs. PostgreSQL
by BenoitP on Friday April 10, 2020 @02:29PM
(#22835953)
A basis for the apples to oranges argument is that you don't use MongoDB when you need JOINs.
To me, this almost never happens. You almost always need JOINs, otherwise your data is sterile and useless. What point is there to talk about entities devoid of relationships to other entities? Data is always relational; we don't live in a 1-dimensional world.
The only way I see it being useful is for scaling purposes. But there are way better, more stable, more resistant to failure kv stores out there.
To me, this almost never happens. You almost always need JOINs, otherwise your data is sterile and useless. What point is there to talk about entities devoid of relationships to other entities? Data is always relational; we don't live in a 1-dimensional world.
The only way I see it being useful is for scaling purposes. But there are way better, more stable, more resistant to failure kv stores out there.