[storm] ORM-agnostic schema migration

[Daniel Werner]

Hello everyone,

I am new to Storm (and ORMs in general). Browsing the mailing list
archives, I've recently found a lot of discussions about the pros and
cons of using ORMs for schema management. These have already convinced
me against trying to manage database schemas in Python. However, at my
company with our ~400 PostgreSQL customer database instances, applying
changes to all of them quickly becomes a pain whenever DB schema
upgrades are due. (Some of these DBs are "real" databases, some of
them Postgres schemas, distributed among several clusters. All of them
share the same structure.)

What I'm looking for is a software to compare multiple database
schemas (e.g., an original and a slightly modified version) and create
patches" (basically SQL scripts) which can be used to upgrade old
database schemas to the changed version. Does anyone of you already
use a tool like this? I'm hopeful that something like this may already
be employed at Canonical, since you seem to prefer schema management
via pure SQL.

Best regards,
--
Daniel