News for hackers. Stuff that matters.
Re:Database versioning best practices by akbar501 on Monday August 10, 2015 @12:55PM (#10035798)
> * A database so large that even a minimally empty one cannot be created from scratch in less than 10-15 minutes. This creates problems for CI, integration testing, etc.

When we ran into this issue we would take period snapshots of the schema / data dump so that it could be recreated rapidly at a certain point. For example, we would create a DB creation and data insert script at version 2.0, then update scripts would be applied starting at 2.1, 2.2 etc.

There are no comments on this comment yet.