Is it worth using sqlalchemy-migrate ? [closed]

Use Alembic instead:

http://pypi.python.org/pypi/alembic

Thanks for comments, edited to add some reasoning —

It’s developed by the author of SQLAlchemy, and it’s brand new and well supported. I don’t know enough about sqlalchemy-migrate to give a good comparison. But I took a quick read through the clear and concise Alembic docs, then got my own autogenerated migration working in a very short time.

Autogeneration: Not its only mode of operation, but if you choose, Alembic will read your application’s sqlalchemy configuration (for instance, your declarative model classes that set up all your tables, constraints, and mappings) and compare to the actual current state of your database, and output a Python script that represents the delta between the two. You then pass that script to Alembic’s upgrade command and there you go, the differences are resolved. A small amount of editing the migration script by hand is usually needed, and that’s (a) just the nature of migrations, and (b) something you want to do anyway to make sure you were fully aware of the exact steps that the migration is going to perform before you run it.

Alembic brings a DVCS-like ability to the way your migrations are tracked, too. It makes it really easy to return to any past state of your db schema.

Leave a Comment

tech