News for hackers. Stuff that matters.

A comment on SQL vs. NoSQL Databases: What’s the Difference?. Parent comment

Re:SQL vs. NoSQL Databases: What’s the Difference? by jimbokun on Thursday May 12, 2016 @02:08PM (#11685482)
NoSQL DBs became popular because performant distributed joins are hard.

Joins (and aggregate, group by, etc.) were thrown out to make horizontal scale out simpler. Cassandra CQL, for example, shares keywords with SQL, but the key-value(ish) data model couldn't be more different, and is much easier to scale horizontally.

Various systems are trying to solve the distributed join problem while keeping easy horizontal scaling, and if they succeed the NoSQL label won't make sense for those systems any more.

[ Parent | on HN ]
Re:SQL vs. NoSQL Databases: What’s the Difference? by aristus on Thursday May 12, 2016 @04:40PM (#11686615)
Yep. I spent 2.5 years at MemSQL, which nailed its colors to the mast of solving distributed joins via good old SQL. It is absolutely possible to have fast scaled distributed SQL, and a pony. The caveats are falling away one by one.
[ Parent | on HN ]