Painless, version-controlled database refactoring

Wil Moore III (02.Mar.2012 at 14:45)
Talk at ConFoo 2012 (English - US)

Rating: 5 of 5

Emailing *.sql files to the in-house DBA before each release used to work for your single-node, single-environment website. You have recently been tasked with building a multi-environment application architecture when you realize that you need to come up with a more professional process which is less error-prone. You also see the benefits of having your schema versioned along-side your code.

You've read a few blog posts by some fairly enterprising developers on the subject but you still can't quite get your head wrapped around how to start or even what tools to use or how to integrate the tools into your project. You now have that sinking feeling in your stomach as you think that maybe you are in over your head.

In this session, we walk through real-world refactoring scenarios using a tool called Liquibase. Liquibase is an open-source and cross-platform database refactoring tool which allows changes to be tracked and automated across environments.

Who are you?

Claim talk

By clicking this button you are declaring that you are the speaker responsible for it and a claim request will be sent to the administrator of the event.

If the claim is approved you will be able to edit the information for this talk.

Are you sure?

Comments closed.


Speaker comment:

02.Mar.2012 at 16:19 by Wil Moore III (28 comments)


I completely forgot to add "INSERT" examples so I will update the slides shortly to include these.

Rating: 5 of 5

02.Mar.2012 at 16:58 by Rowan Merewood (125 comments)

Clear delivery and nicely paced, really easy to follow at the end of the day. Slides were good and the live coding didn't interrupt the flow. Code was hard to read on the projector, but you did mitigate that by just swapping over to the terminal.

Really liked the practical nature of the whole thing, always good when you're seeing the stuff that people are actually using in their projects rather than say, just repeating the documentation. Great Q&A at the end.

Speaker comment:

02.Mar.2012 at 18:05 by Wil Moore III (28 comments)

Slides have been updated to include an example INSERT change-set which also includes the "context" attribute as mentioned during the Q&A portion.

© 2015