How do you manage multiple database environments with SQLAlchemy & Alembic? /u/sersherz Python Education

I am currently migrating over from MongoDb to PostgreSQL and now need to manage the state of development, test and prod as over time there may be changes done in test that then need to eventually go down into test and prod.

I know that sqlalchemy is good for being able to set up tables and relations. I also know that alembic can manage migrations, but I seem to struggle with using alembic to manage multiple environments.

The issue with just doing sqlalchemy is I am finding that I can create the tables, indexes and relationships, but then I cannot update them, but using Alembic I can’t seem to do migrations from dev to test to prod

I am currently migrating over from MongoDb to PostgreSQL and now need to manage the state of development, test and prod as over time there may be changes done in test that then need to eventually go down into test and prod.

I know that sqlalchemy is good for being able to set up tables and relations. I also know that alembic can manage migrations, but I seem to struggle with using alembic to manage multiple environments.

The issue with just doing sqlalchemy is I am finding that I can create the tables, indexes and relationships, but then I cannot update them, but using Alembic I can’t seem to do migrations from dev to test to prod