4 ms·
NoSQL Is Technologically Inferior To SQL
- andrewcurioso 15y agoThe site must be using NoSQL, since it is down for me right now. I wish it would load, the article sounds interesting.
- vyrotek 15y agoYeah, rather disappointing. It seems there's a text-only google cache of it. http://webcache.googleusercontent.com/search?q=cache:http://chronicdb.com/blogs/nosql_is_technologically_inferior_to_sql&hl=en&strip=1 http://webcache.googleusercontent.com/search?q=cache:http://...
- jensnockert 15y agoJust 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.
- vyrotek 15y agoOur 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.
- kozlovsky 15y ago"How FriendFeed uses MySQL to store schema-less data" http://bret.appspot.com/entry/how-friendfeed-uses-mysql http://bret.appspot.com/entry/how-friendfeed-uses-mysql
- rch 15y agoI 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.
- dkersten 15y agoAgreed. 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.
- wulczer 15y agoI 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.
- kaib 15y agoWhat 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.