News for hackers. Stuff that matters.
Re:Comparison of Joins: MongoDB vs. PostgreSQL by tasubotadas on Friday April 10, 2020 @12:45PM (#22834761)
If you picked mongodb and you are using joins, you've picked a wrong tool for a job.
Re:Comparison of Joins: MongoDB vs. PostgreSQL by baq on Friday April 10, 2020 @12:56PM (#22834891)
'professional managers' might not know this.
Re:Comparison of Joins: MongoDB vs. PostgreSQL by Beefin on Friday April 10, 2020 @12:47PM (#22834780)
right, this is an apples to oranges comparison.

you're comparing the feature that RDBs do best to the feature that NoSQL DBs do worst...

Re:Comparison of Joins: MongoDB vs. PostgreSQL by AmericanChopper on Friday April 10, 2020 @01:02PM (#22834948)
The most common use case for Mongo is storing relational data for web apps, and the most common outcome for those apps is complete dysfunction. How do I know that’s the most common use case? Aside from my own anecdotal experience, you just need look at the features those DBs implement. They’re constantly implementing new RDBMS-like and ACID-like features. They wouldn’t be doing that if that wasn’t their market. Why does this happen? Because people who don’t know better keep thinking that they can somehow work around the constraints, and just make a mongo (or dynamo) RDBMS work somehow. It is an apples to oranges comparison. But it’s worth making, because of the large number of people who think it’s ok to substitute oranges into apple pie recipes.
Re:Comparison of Joins: MongoDB vs. PostgreSQL by Beefin on Friday April 10, 2020 @01:07PM (#22834979)
None of that matters because your data needs to be modeled around your application usage patterns. If you maintain inter-collection relationships via Joins in Mongo just as if you were in Postgres, you're not doing it right.
Re:Comparison of Joins: MongoDB vs. PostgreSQL by AmericanChopper on Friday April 10, 2020 @08:47PM (#22838821)
Your schema needs to be modelled around your domain, because that will dictate what your application usage patterns actually are. That will determine wether using a document database is feasible or not. If not, then there isn’t any design cleverness that can save you.
Re:Comparison of Joins: MongoDB vs. PostgreSQL by ldng on Friday April 10, 2020 @12:58PM (#22834908)
Like NoSQL proponent, never do that. Worst offender often beeing Mongo (although they calmed down a bit since "Web-scale" days ...)
Re:Comparison of Joins: MongoDB vs. PostgreSQL by commandlinefan on Friday April 10, 2020 @12:52PM (#22834833)
And the corollary: if you store data, you need to use joins.
Re:Comparison of Joins: MongoDB vs. PostgreSQL by throwanem on Friday April 10, 2020 @12:55PM (#22834865)
Embrace denormalization! It makes for splendid job security.
Re:Comparison of Joins: MongoDB vs. PostgreSQL by oftenwrong on Friday April 10, 2020 @12:56PM (#22834881)
Not if you're just doing vanilla document storage.
Re:Comparison of Joins: MongoDB vs. PostgreSQL by Beefin on Friday April 10, 2020 @12:56PM (#22834873)
this isn't always true there are plenty of schema designs for storing data based on your application's usage patterns.