Re:What MongoDB got right
by acjohnson55 on Friday November 13, 2015 @02:50PM
(#10562008)
What's annoying about joins? I think practically speaking, whether you're going relational or not, joins are a reality of a data model that supports multiple views and transformations. Assuming that's the case, the only question is whether you're doing joins ad hoc in your application code or you've learned the handful of variations that work natively in your RDBMS.
That seems to add to the idea that NoSQL fans just don't know how to use SQL properly.
This just adds to the idea that sql kind of sucks in terms of usability. For the record I always use sql, but let's be honest with ourselves.
Re:What MongoDB got right
by obsurveyor on Friday November 13, 2015 @11:27AM
(#10560643)
Are you implying you're not supposed to use joins in SQL?
I think he's implying that finding joins difficult is a sign of immaturity of the developer rather than a problem with the language.
Joins might be tricky if you are unused to them, but they are the secret sauce of relational databases. They are what make it possible to have dozens of views on a single normalized data structure.
Granted, I think a big part of it has to do with joins being the annoying part of SQL...