Xaprb

Stay curious!

Idea: a reverse changelog for MySQL

with 5 comments

Most software changelogs list what’s changed and what bugs are fixed during each upgrade. But when you’re evaluating an upgrade, what you’re typically concerned about is slightly different — it’s a combination of what’s changed and what might have broken. The fixed bugs aren’t as important for most people, who are either using a workaround or aren’t using the software. What people ask is “what do I have to change in my application, and/or make sure I’m not going to run afoul of, in order to use this new version?”

One of the interesting things about this is that you don’t know until sometime in the future, and it’s never a finished process. So as you look back from each new version, you have more information about the older versions. You see bugs that were fixed, and weren’t known when an older version was released, but which affected that version. So a “20/20 hindsight changelog” is going to be an evolving thing.

Such a changelog might say something like “when upgrading to 5.0.45, watch out for broken tmpdir handling; upgrade to at least 5.0.48 to avoid this bug.” Yes, this is necessarily a pessimistic look at the server, but people who are responsible for mission-critical server deployments are typically pretty conservative, and the good ones focus actively on identifying and managing risks. So it’s a good kind of pessimism.

Written by Xaprb

January 26th, 2009 at 3:11 pm

Posted in SQL

Tagged with

5 Responses to 'Idea: a reverse changelog for MySQL'

Subscribe to comments with RSS

  1. YES!! This would be great. I’ve been wanting software to do this for a while now. I wanted to do this with a closed source piece of software I was employed to write, but management wouldn’t let me. But, yeah it doesn’t just apply to MySql. Its just an honest thing to do.

    William

    27 Jan 09 at 11:46 am

  2. [...] has a good idea: a reverse changelog.  If you have ever worked your way through a changelog in preparation for an upgrade, this will [...]

  3. One can hope so!

    Dan C

    9 Feb 09 at 6:30 am

  4. Thanks for the idea – you might want to investigate the new section of the MySQL Version Reference I added on friday: http://dev.mysql.com/doc/mysqld-version-reference/en/bugsfixed.html

    That should (I hope) address your concerns – but also view http://coalface.mcslp.com/2009/03/14/reverse-changelog/ to see what else is possible and let me know if you have any further ideas on you’d like to see.

    MC Brown

    14 Mar 09 at 6:00 am

  5. Wow! You are amazing! The docs at MySQL just keep getting better and better. I’ve checked out the bugs-fixed page and that is exactly what I think users need — that is so useful. Thank you!

    Xaprb

    14 Mar 09 at 9:13 am

Leave a Reply