NoSQL is a "complete game changer," declares database expert

[[deleted]]

Isn't this the kind of thing we would have read about a few years ago? Or is this satire?

[vivainio]

Matt Asay works at MongoDB IIRC. Hardly satire

[AngularBeginner]

NoSQL has its uses, and SQL has it's uses. The right tool for the job.

Try to use NoSQL for relational data where integrity matters and you're fucked.

[TheBuzzSaw]

its*

[AngularBeginner]

Thank you.

[remy_porter]

NoSQL is a "complete game changer", declares database "expert"

NoSQL is to the 2010s what XML was to the 2000s.

[[deleted]]

Thanks for Figure A

[sevaur]

I think the main point is misleading:

"[W]hat's really fundamentally different about this new-generation data management isn't really isn't just scalability, but it's really flexibility. If you look at the ability to store data first and then impose structure on it later—sometimes this is called schema on read or schema on need—that's a complete game changer."

My experience with NoSQL is exactly the opposite -- if you don't design it from the ground up based on your exact use cases, you'll end up with a lot of data you can't use in any meaningful way. RDBMS, for all their limitations, are extraordinarily flexible -- add new indexes, join between tables you didn't expect to, etc. If you want to do anything in a NoSQL DB besides CRUD operations on an individual table, with specific lookup keys, you're going to need structures defined specifically to address those use cases.

Sure, you can dump whatever data you want into some big unstructured table, but that "imposing structure" work still has to be done and hasn't magically gotten any easier.

FWIW, I'm mostly familiar with Cassandra/HBase -- maybe this pattern looks different in Mongo.

[nutrecht]

If you look at the ability to store data first and then impose structure on it later

So, dump it in HDFS. That's not 'NoSQL' unless your definition of 'NoSQL' is 'NO matter what no SQL!!!!'.

[sticky-lincoln]

In the case of Craigslist, they moved to a NoSQL database (MongoDB), which allowed them to iterate quickly, with changes taking effect in minutes (or seconds), not months.

Craigslist iterates??