Database version control without pain

Harrie Verveer (11.Jun.2010 at 14:30)
Talk at Dutch PHP Conference 2010 (English - UK)

Rating: 4 of 5

We've all read the textbooks and are using version control systems for our code, but our databases are left out in the cold. Every team has their own workaround, ranging from patch files to SQL snippets in the bugtracker, but none is really robust. Unfortunately there is no silver bullet, but there are several tools and best practices that can help you to make your life easier. This talk shows several approaches that can help you to overcome this problem and to control database structure changes in a more sophisticated way.

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.

Comments

Rating: 4 of 5

11.Jun.2010 at 15:40 by Tom Smith (12 comments)

Very good talk on solutions available for database version control. Have got some good ideas on how to improve our phing deployments scripts

Rating: 4 of 5

11.Jun.2010 at 15:51 by Jacob Christiansen (59 comments)

Great talk. Nice to be introduced to new tools. No more old bikes!!

Rating: 4 of 5

11.Jun.2010 at 15:54 by Maarten van Leeuwen (4 comments)

Nice talk about version control of database(structure) touching on the most important problems that you will run in. The topic of solving merge conflicts in database changes was however underexposed and imo deserves more attention and in-depth exploration.

Rating: 4 of 5

11.Jun.2010 at 15:57 by Thijs Feryn (134 comments)

Good stuff ! Nice to see that there are tools out there that can handle SQL delta data.

Decent slides, nice overview & summary. Very accessible talk.

Rating: 4 of 5

11.Jun.2010 at 18:06 by (11 comments)

Good talk! Only a bit of deception to hear that there still no all-in-one solution for this versioning issue!

Rating: 4 of 5

11.Jun.2010 at 18:36 by Rowan Merewood (126 comments)

Had read the slides from a previous conference, but it was good to see the presentation as Harrie filled in some of the gaps. Nice and confident in his delivery and he kept a decent pace. Would have liked to have seen a bit more about the Doctrine stuff, but he covered a lot for a 45 minute slot. Technical examples were easy to follow as well.

Rating: 4 of 5

11.Jun.2010 at 18:40 by Tom Van Herreweghe (71 comments)

This was a nice talk, and the presenter came well prepared. Too bad I didn't hear about some silver bullet, but hey, that's not his fault :)

Rating: 4 of 5

11.Jun.2010 at 18:53 by Simon R Jones (25 comments)

Liked the summary of the different strategies for database version control. An important topic oft ignored. Nice to see the simple patching system is what we use at Studio 24. From what Harrie says seems to be keep it simple = good. Rob Allen's Akrabat_Db_Schema_Manager is something I really need to check out though.

Rating: 4 of 5

11.Jun.2010 at 19:16 by Richard Hinkamp (14 comments)

Good talk, good speaker. Harrie touched the real problem once (the new "type" table in a branche and a new "type" table in trunk which will collide when merging), but he never came with a solution/direction to that problem, that would've given it more depth. The delta's/migration/db patches itself aren't rocket science of course.

I wouldn't mind more normal slides and less photo's with some kind of "metaphor", bit too much for me.

Rating: 4 of 5

11.Jun.2010 at 19:53 by Rene Bakx (9 comments)

good speaker good content. Especially since I followed Harrie twittering about his timing worries ;) My tips : shorten the intro about the need for versioning. To much slides about numbering etc. And if possible try adding a part about logic that lives in db's. I do know it is bad practize to have logic that has logic in db only but systems like drupal and wordpress 3 do use it. Same goes for stored procedures etc.

Rating: 5 of 5

11.Jun.2010 at 22:14 by Jeroen Keppens (18 comments)

Same as Miljar

Rating: 4 of 5

12.Jun.2010 at 11:28 by Willem Spruijt (4 comments)

Clear talk about the different techniques and strategies when performing db deployments and migrations.

Tools discussed: Liquibase, DB Deploy

Rating: 3 of 5

12.Jun.2010 at 13:26 by Peter Kruithof (7 comments)

Good talk, nothing much to add to it really

Rating: 4 of 5

12.Jun.2010 at 20:17 by Onno Marsman (53 comments)

Nice presentation and I had a great talk with Harrie afterwards. Although I don't know about anything that wasn't covered, I do have some doubts on whether Harrie covered everything (relevant) there is to know about the subject. I still have the feeling something is missing.

Rating: 5 of 5

13.Jun.2010 at 18:32 by Stephan Hochdörfer (79 comments)

Very well done. Many small improvements compared to the talk he held at PFCongres 2010. Good to see that Liquibase was covered.

Rating: 4 of 5

13.Jun.2010 at 22:25 by Bart McLeod (61 comments)

I liked the presentation. I think there is still pain involved somehow. The "without pain" in the title sounds promising, but I think with any of the solutions proposed in this talk, we are exchanging one type of pain for another.

Still I could make quite a few notes of techniques I didn't yet bother to investigate and that I might look at as a result of attending. Phing, Liquibase. Thanks Harrie!

Rating: 3 of 5

14.Jun.2010 at 10:26 by Arno Lambert (18 comments)

Good speaker but I was a little disappointed by the solutions.

Rating: 4 of 5

14.Jun.2010 at 16:25 by Andy Martin (3 comments)

Good presentation, just a shame the best solution is still roll your own :)

Rating: 5 of 5

14.Jun.2010 at 20:07 by Martin de Keijzer (56 comments)

Harrie definitely showed us that database schema's can be controlled, the talk had a nice build-up. It started with fairly simple solutions and as the talk continued you got the picture how these can become more advanced life savers. All the questions that came in mind got answered while the talk progressed, and at the end I got the whole picture without asking a single question.

Rating: 3 of 5

14.Jun.2010 at 22:59 by Oana Botezat (7 comments)

Interesting. We already have the in house script which seems the best. We don't have any branching problems because [we don't use so many branches :))] we have the names of the patches generated from timestamp. pretty small chance that two developers will create a patch in the exact same second.

Rating: 4 of 5

16.Jun.2010 at 17:43 by Tim Swann (36 comments)

Nice talk illustrating the problem and possible methodologies for getting around them.

© Joind.in 2014