pg-version-compare: a web app to view or grep release notes between two PostgreSQL versions

Talk Type: 

5 Minute Lightning

Technical Level: 

No more combing through the HTML release notes.

Juggling PostgreSQL versions can be a pain, especially if you're a consultant like me who works with many clients. Sometimes it's hard to remember when a certain feature was introduced. Does my client have HOT or not? And then there are migrations: if I'm slated to perform a much-needed upgrade from 8.1 to 8.4, are there issues I need to know about?

If I don't know this stuff off the top of my head, I have to read through the release notes for multiple versions of PostgreSQL. If I'm searching for a specific feature, I probably have to use the HTML versions and do a find-in-page on each one. What a pain.

This talk presents a better way: pg-version-compare. It's a small web app that lets you enter two PostgreSQL versions (in drop-downs or in the URL). It'll show you all the release notes between those versions, or, if you enter a search string, it'll show you only notes that match the search.

We wrote this tool to scratch our own itch. Now we're making it available as a web app and releasing it open-source (BSD, of course). The code is in Catalyst, the Perl MVC. The database content is parsed from the SGML release notes, and is included in the codebase in SQL form.