Tuesday, September 04, 2007

Database Build Script "Greatest Hits"

I know its been a quiet time on this blog for a while now, but I've noticed that I'm still getting visitors looking up old blog posts. It's especially true of the posts that relate to "The Patch Runner". Many of them come through a link from Wilfred van der Deijl, mainly his great post of "Version control of Database Objects". The patch runner is my grand idea for a version controlled database build script that you can use to give your developers sandbox databases to play with as well as ensuring that your live database upgrades work first time, every time. It's all still working perfectly here, and people still seem to be interested, so with that in mind I've decided to collate them a little bit. basically provide an index of all the posts I've made over the years that directly relate to database build scripts, sandboxes and version control. So, Rob's database build script 'Greatest Hits': All of the posts describe processes and patch runners that are very similar to those that I use in my work every day. I started playing with these theories over 3 years ago now and there is no way I'd go back to implement database upgrades the way I did before. However, I'd LOVE to hear ideas on how things can be improved. I'd be amazed if my three year old thinking was still up to date! Technorati Tags: , , , , ,


forkboy said...

Great series of articles, This is something that I would really love to get going, and have started to play around with, fashioning my solution (which is just in my head) in a ruby-migrate kind of way. I fear its all going to get very complex very quickly though.

Rob Baillie said...

If you view the build script / patch runner the same way as you would view any other piece of code, sit down and think about it, refactor it mercilessly and only accept solid, lean, modularised, working code then you'll probably find it's a lot less complex than you might imagine.

Try not to be too generic, just implement what you need in your environment (at least to start with).

Go on, try it.

Anonymous said...

Hmmm, seems cool.

Joe joestain13@yahoo.com

MikeH said...

So many moons on and still so relevant!

I produced a patcher for the python framework Django, it gained some interest and IBM used it as the basis for their patch system in their ProjectZero framework.

Great to know how things work out, isn't it?