search

wtsi-npg / npg_porch

GNU General Public License v3.0
2 stars 3 forks source link

Schema migrations desirable #41

Open nerdstrike opened 2 years ago

nerdstrike commented 2 years ago

A tool like Alembic can provide us with safe schema management for the dev and production databases. At the very least we need to have controlled upgrade and history of schema changes so that the two services can remain in sync.

Configure Alembic to deploy the v1 schema, and subsequently generate schema patches for future changes.

nerdstrike commented 2 years ago

Also we need to standardise a procedure for telling users about downtime, issue the schema changes, and restore service.