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 -- storm mailing list [email protected] Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/storm
