Skip to content
This repository has been archived by the owner on Oct 25, 2019. It is now read-only.

Implement smarter database migration #83

Open
de-code opened this issue Feb 2, 2018 · 0 comments
Open

Implement smarter database migration #83

de-code opened this issue Feb 2, 2018 · 0 comments

Comments

@de-code
Copy link
Collaborator

de-code commented Feb 2, 2018

The current database migration is quite crude - drop and rebuild tables if the schema version doesn't match. Data is then getting rebuild. As postgresql requires a lock when dropping tables, all existing connections need to be dropped (which is why the service is stopped before every re-deployment).

Alembic can be used to manage database migrations:
http://alembic.zzzcomputing.com/en/latest/

(also see comments in JIRA)

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant