Re:Ask HN: How do you organize and manage database migrations?
by keshab on Thursday October 31, 2019 @01:46AM
(#21406055)
We use flyway for the biggest monolith database in our company. We also use alembic for some microservices.
Alembic is extra convenient if you're already invested in sqlalchemy.
I've tried yoyo-migrations[1] once, a while ago.
With yoyo, like flyway, migrations are written as SQL queries. However, they're expressed as SQL steps in python files. Might worth a look if you're using python.
Alembic is extra convenient if you're already invested in sqlalchemy.
I've tried yoyo-migrations[1] once, a while ago.
With yoyo, like flyway, migrations are written as SQL queries. However, they're expressed as SQL steps in python files. Might worth a look if you're using python.
1. https://pypi.org/project/yoyo-migrations/