News for hackers. Stuff that matters.
Re:What MongoDB got right (2015) by ssijak on Tuesday November 28, 2017 @05:25AM (#15795946)
What you wrote is data migration. Table/database migrations are just DDL scripts which are usually really small on an ongoing project. For example you add 2 columns in a sprint so you have that in the SQL migration file for that sprint.
Re:What MongoDB got right (2015) by jbergens on Tuesday November 28, 2017 @07:17AM (#15796512)
A real project usually have a lot of things that changes over time, including how to store the data. Adding columns and tables are basically the only simple things and not even new tables are always easy if they are connected to other tables and you have contraints that means they have to be pre-filled with something from the old database. Other things that can change is splitting one table into multiple table while keeping all data, splitting or joining columns while keeping data and so on. For large datasets this may cause headaches. Any error will also cause a lot of extra work.
Re:What MongoDB got right (2015) by dorfsmay on Tuesday November 28, 2017 @09:07AM (#15797367)
Adding a column is easy!

What about removing a column? What about if you've decided that you both current and next version of the code to work (then removing a column is a 3 step process, copy to new and use new, skip a version, remove old).

Migration can and is often hard.

Re:What MongoDB got right (2015) by yoz-y on Tuesday November 28, 2017 @11:21AM (#15798576)
Migration is hard, but I fail to see how something like MongoDB makes this easier.

Either you kick the can to the code, or do a migration script. Is there some magic style of coding that allows me to use the old data structures with the new code without having to do any special checks?