Compare and Contrast with PostgreSQL Autodoc and diff.

Perry Clark

Ever tried to figure out what happened to a database between upgrades?

Or ever wanted to figure out schema difference between a backup and

production system? In other words, what has changed on the

database?!?

With any large software project, maintaining quality and keeping track

of changes coming in can be a daunting task. Using PostgreSQL Autodoc

and extending the typical 'diff a b' to include some magic can ease this

task. We'll explain how we use these tools for managing updates and

merging new functionality into our ever growing and evolving ERP

application with execution examples and explanations. We'll also

explain the practical applications of this approach so you may learn how

to possibly downgrade or upgrade a db application, identify movement

across versions of schema parts and establish a baseline by comparing

old to new or original versions.