News for hackers. Stuff that matters.
Re:NoSQL Is Technologically Inferior To SQL by kaib on Wednesday April 06, 2011 @10:53AM (#2415295)
What a disappointing piece of writing. Having worked with BigTable for several years at my previous gig I find the whole premise of NoSQL hilarious. BigTable really is a very specific solution to a very specific problem, creating a datastore that can feed massive mapreduces efficiently. Basically you have a design problem that nobody else is solving and you have the monetary resources and knowledge to solve it yourself.

I'll be extremely delighted when the discussion starts revolving around how well a solution fits a specific problem as opposed to declaring one or the other solution inferior or superior. A single grading scale is not what a real engineer uses.

For the record we use a "NoSQL" technology called flat files. Because our challenge is making sure the right workers have the right data in memory, not on disk.

Re:NoSQL Is Technologically Inferior To SQL by rch on Wednesday April 06, 2011 @10:43AM (#2415244)
I would like to have the term NoSQL come to mean 'manipulate data as you naturally would in your language of choice, irrespective of the persistent storage system.'

The tone of the current debate reflects poorly on everyone involved.

Re:NoSQL Is Technologically Inferior To SQL by dkersten on Wednesday April 06, 2011 @08:15PM (#2417618)
Agreed.

I like the Durable Clojure hack that someone wrote, because it basically adds disk-backed durability to clojures ref types (which already have atomicity, consistency and isolation). Having ACID guarantees on built-in data structures reduces the need for databases for a lot of use cases and would be a lot nicer to work with than having to deal with an external database.

Re:NoSQL Is Technologically Inferior To SQL by andrewcurioso on Wednesday April 06, 2011 @10:25AM (#2415172)
The site must be using NoSQL, since it is down for me right now. I wish it would load, the article sounds interesting.
Re:NoSQL Is Technologically Inferior To SQL by vyrotek on Wednesday April 06, 2011 @10:33AM (#2415204)
Yeah, rather disappointing. It seems there's a text-only google cache of it.

http://webcache.googleusercontent.com/search?q=cache:http://...

Re:NoSQL Is Technologically Inferior To SQL by jensnockert on Wednesday April 06, 2011 @10:38AM (#2415225)
Just says that you can emulate any NoSQL database with a SQL one, using multi-master systems etc. And that NoSQL 'wants' to use SQL.

NoSQL for me is not about scaling, it is about having a different data and query model that means creating new sorts of applications easier than with plain old SQL.

That I can build a graph database or something with xSQL is not really relevant. I can write webapps in C, but I made a conscious decision not to, I also try to select the best datastore for the job.

Re:NoSQL Is Technologically Inferior To SQL by vyrotek on Wednesday April 06, 2011 @10:43AM (#2415242)
Our company uses a mix of both. The author mentions that one of the perceived benefits is the "Flexibility of schema definition". We actually ended up needing a NoSQL database for exactly that. We have one part of our system that needed to store schema-less data in a way that still let us query it using the custom data fields.

I wish we could have found a way to make it work within our SQL database but none of the solutions that I could find felt right. Schema-less data and complex queries (Group Bys, Distinct, etc) just don't seem to mix well with most systems. I'd love to know if others have any experience in this area.

Re:NoSQL Is Technologically Inferior To SQL by kozlovsky on Friday April 08, 2011 @02:10AM (#2422681)
"How FriendFeed uses MySQL to store schema-less data" http://bret.appspot.com/entry/how-friendfeed-uses-mysql
Re:NoSQL Is Technologically Inferior To SQL by wulczer on Wednesday April 06, 2011 @10:44AM (#2415247)
I wouldn't say it's technologically inferiot. I'd say it's less mature.

Making desing choices is OK. The authors admits that relational databases have different design goals and thus comaring them directly is necessarily comparing apples to oranges.

What is true and wise is that non-relational databases have been around for much less time, have less theoretical background, the development teams and DBAs are less experienced with them, etc.