Re:Lessons learned from the big rewrite
by Fumzz on Sunday January 11, 2015 @06:39AM
(#8869721)
To number 2 (Migrating the database is hard) I would also add that it is important to verify the integrity of the migrated database in some way afterwards. Even a simple assertion like "the number of user accounts (or whatever) is the same in both databases" will help greatly.
[ Parent
| on HN ]
Re:Lessons learned from the big rewrite
by antonpirker on Sunday January 11, 2015 @06:52AM
(#8869740)
Yes, right! I forgot about this in the blog post. We counted the rows of some tables. Unfortunately we could not do this with all tables because we had dead data in the old database (ex: child rows without parents). But with the new database we made sure to have all the database features and checks in place to guarantee referential integrity. We also did spot tests to make sure the data is as expected.