News for hackers. Stuff that matters.
Re:The Future of NoSQL by xj9 on Wednesday November 12, 2014 @11:18PM (#8599902)
I've always been interested in NoSQL databases, but I never understood the advantage of a schema-less design. Migrations make it so you can change the structure of your data at any time so you really aren't locked into anything. Even ignoring that, your data has to have some kind of shape to it (a kind of ad-hoc schema) and you still have to deal with data whose shape has changed (which migrations take care of for you).
Re:The Future of NoSQL by skybrian on Wednesday November 12, 2014 @11:32PM (#8599949)
Migrations get expensive and risky when you have lots of data. Being able to do them incrementally is sometimes worth the complication of maintaining code to read older versions. A traditional database doesn't let you do that; you have to execute an "alter table" statement all at once.
Re:The Future of NoSQL by Rapzid on Thursday November 13, 2014 @04:21AM (#8600626)
The current state-of-the art with MySQL uses temporary tables and triggers to perform online migrations.
Re:The Future of NoSQL by nrser on Wednesday November 12, 2014 @11:56PM (#8599994)
yup. once upon a time we had a MySQL db on commodity hardware doing around 6K QPS with over 100M rows in the biggest table. you can't do much to it without taking it offline, and even then you have no idea if/when the migration will complete.
Re:The Future of NoSQL by zenbowman on Wednesday November 12, 2014 @11:26PM (#8599929)
There is no advantage of a schema-less design, because there is always a schema. It is just a matter of whether the schema is made explicit and enforced, or whether it is scattered all over the application code.
Re:The Future of NoSQL by nrser on Thursday November 13, 2014 @12:02AM (#8600012)
it can make it much easier to do on-demand migrations: in massive online apps, a large percentage of data is essentially 'dead' - it's unlikely anyone will ever access it again. and massive online apps (call it 'web-scale' if you will ;) can accumulate a lot of data. the systems they're discussing make it easier to migrate data as needed instead of at once (which sometimes isn't even possible if the infrastructure is really being pounded).
Re:The Future of NoSQL by threeseed on Wednesday November 12, 2014 @11:27PM (#8599932)
The advantage of schemaless is that if you are adding extra attributes (most common database change) then you don't have to do any migration. And migrations have a long history of having side effects as well as requiring Database/Operations teams involvement if you work in the enterprise.

And as I mentioned before the "shape of your data" is quite often defined in your application anyway.

Re:The Future of NoSQL by collyw on Thursday November 13, 2014 @11:23AM (#8602329)
I imagine that side effects exist and are more difficult to spot in a NoSQL migration.