News for hackers. Stuff that matters.
Re:The dark side of NoSQL by jbl on Wednesday September 30, 2009 @08:57AM (#852311)
It seemed to me like the article was more about particular "NoSQL" databases than it was about the genre as a whole. In other words, I don't think the author's pain is endemic to this admittedly broad class of data stores, just the few that do exist.
Re:The dark side of NoSQL by antirez on Wednesday September 30, 2009 @09:01AM (#852316)
The "missing alter table" problem affects more or less any kind of schema-free DB.
Re:The dark side of NoSQL by zaphar on Wednesday September 30, 2009 @03:27PM (#853438)
How so. In most schema-free db's the missing alter table feature is not needed. maybe you meant the quotes to be in a different place? missing "alter table problem" perhaps?
Re:The dark side of NoSQL by vicaya on Wednesday September 30, 2009 @05:19PM (#853725)
With completely schema-free db, you have to encode 'column' in a key, which means you cannot delete or rename a column easily (in O(1) time).
Re:The dark side of NoSQL by evgen on Wednesday September 30, 2009 @05:52PM (#853809)
You won't get O(1) since scheme-free dbs are not organized around columns/fields in the same way a traditional db is all about rows and columns, but just about every one I am aware of let's you create an index on a particular field so at least you get O(n). Given the infrequent use of this operation I am happy to leave it in the "O(n) is good enough" category in return for the other benefits an efficiencies that a schema-free db offer.
Re:The dark side of NoSQL by vicaya on Wednesday September 30, 2009 @06:34PM (#853882)
Well, you can get both with Hypertable, where you can alter table to add/drop column families in O(1) time, while still have schema free benefits with column qualifiers.