search

openclimatefix / nowcasting_datamodel

Datamodel for the nowcasting project
6 stars 6 forks source link

SQL migration process #1

Closed peterdudfield closed 2 years ago

peterdudfield commented 2 years ago

Detailed Description

Make proper SQL migration process. This could be done automatically with 'alembic' https://alembic.sqlalchemy.org/en/latest/

Context

Currently would have to destroy database and remake if the datamodel changes. This will be a problem when live, as we dont want to lose predictions

Possible Implementation

  1. Run AWS task to run alembic update 'alembic' https://alembic.sqlalchemy.org/en/latest/
  2. Build VPN and manually do migration on database
peterdudfield commented 2 years ago
  1. has been done and tried and tested