News for hackers. Stuff that matters.
Re:MongoDB Raises $150 Million at $1.2 Billion Valuation by omni on Friday October 04, 2013 @10:26AM (#6495527)
Can you point me to an article that explains why you would want JOINs in a NoSQL database to begin with? I thought the entire point was to denormalize your data. I keep seeing this point brought up, but it reads to me like a misguided complaint stemming from misunderstanding how to apply the tech.
Re:MongoDB Raises $150 Million at $1.2 Billion Valuation by troyk on Friday October 04, 2013 @10:58AM (#6495709)
The rethinkdb guys think it's important and have joins in their nosql product. Everytime I try nosql first thing I miss is the ability to query as the need arises without a refactor.
Re:MongoDB Raises $150 Million at $1.2 Billion Valuation by danudey on Friday October 04, 2013 @12:57PM (#6496491)
I've always just abstracted the DB away with objects and lazy-load any 'subqueries' that I might want to have/use/get (or autoload them if necessary).
Re:MongoDB Raises $150 Million at $1.2 Billion Valuation by rpedela on Friday October 04, 2013 @10:40AM (#6495611)
Using hierarchical data structures takes care of the most common use case of JOIN (i.e. "SELECT * FROM a, b, c"). This is a win for MongoDB. However there are times when you want to JOIN multiple hierarchical data structures [1]. Or use a different type of JOIN.

[1] http://tebros.com/2011/07/using-mongodb-mapreduce-to-join-2-...

Re:MongoDB Raises $150 Million at $1.2 Billion Valuation by mason55 on Friday October 04, 2013 @11:05AM (#6495751)
So JOIN in your application. Or use a different DB. MongoDB isn't correct for every use case and they would never claim it is.
Re:MongoDB Raises $150 Million at $1.2 Billion Valuation by ArbitraryLimits on Friday October 04, 2013 @12:37PM (#6496369)
Am I just too old for HN now?

I can understand calling something that holds your data and makes it so you don't have to do JOINs a database.

I can understand calling something that holds your data and does JOINs for you a database.

I'm having trouble calling something that holds my data and makes it so I have to "JOIN in my application" anything but a file system.

Re:MongoDB Raises $150 Million at $1.2 Billion Valuation by untog on Friday October 04, 2013 @01:32PM (#6496712)
I don't know, what is the definition of a database? I'd be surprised if it mandated joins.
Re:MongoDB Raises $150 Million at $1.2 Billion Valuation by gaius on Friday October 04, 2013 @01:33PM (#6496723)
Actually, if you speak to them, they do claim that. Then they backtrack when you call them on it, but I've heard guys from 10gen as they were known then claim their product was a drop-in replacement for Oracle.
Re:MongoDB Raises $150 Million at $1.2 Billion Valuation by omni on Friday October 04, 2013 @03:39PM (#6497465)
Hearsay and strawman arguments don't make for an intellectual discussion.
Re:MongoDB Raises $150 Million at $1.2 Billion Valuation by wmf on Friday October 04, 2013 @12:22PM (#6496268)
The entire point is to go fast; denormalization is a tool, not an end in itself. If, hypothetically (ahem), a database could scale and support joins, why not?
Re:MongoDB Raises $150 Million at $1.2 Billion Valuation by MichaelGG on Friday October 04, 2013 @08:08PM (#6498836)
Using partitioning like VoltDB allows you to keep joins. I think Google's Spanner/F1 partitioning/relation scheme also allows joins.