Compare and Contrast with PostgreSQL Autodoc and diff.
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
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.