librelist archives

« back to archive

Migrating database schemas in a Flask / SQLAlchemy app using SQLAlchemy-migrate or Alembic?

Migrating database schemas in a Flask / SQLAlchemy app using SQLAlchemy-migrate or Alembic?

From:
Jurie Horneman
Date:
2012-06-20 @ 15:52
Hi. I have a web app that uses Flask and SQLAlchemy (and PostgreSQL).
I want to set things up so that I can make changes to my models and
migrate those to my dev and production databases (rather than
recreating my databases which is what I've been doing so far).

SQLAlchemy-migrate and Alembic both seem interesting tools. Does
anyone have pointers or tips for this, especially in the context of a
Flask app?

Thanks,

Jurie