Обсуждение: Database migrations

Поиск
Список
Период
Сортировка

Database migrations

От
Simon Connah
Дата:
Hi,

I'm building a web app using the Python web framework Flask and I'm curious how I should handle database changes. At
themoment I can just delete everything and load the SQL files but when I launch into production obviously I won't be
ableto do that. Currently all my database stuff is stored in a SQL file. One file for each table and includes stored
proceduresand function definitions. 

I know there are libraries like Alembic but that seems to be for SQLAlchemy and not raw SQL and Flyway seems to require
anexpensive license to allow migration rollback so I'm wondering if anyone can offer some advice? 

If you need more information then please let me know.

Simon.
Вложения