Hacker News new | ask | show | jobs
by Foober223 2656 days ago
On the deployment side of things...

Many developers don't get the concept of deploying a patch. They envision a script for each DB object stored in source control. Mimicking the the Java class files for all their objects. That's fine for code which can be re-built from scratch. But you can't re-build your DB, it must be patched to preserve the precious data.

It works fine for DB release #1. But when DB release #2 comes around there's no way to deploy the DB changes. Special diff tools are brought in to generate the patch. The auto generated patch drops a column.. ooops.