It's not clear that Alembic has real advantages over Migrate. Its simpler for sure since it only is for SQLA 0.6 and up and doesn't attempt to do the crazy things Migrate does like versioning SQLite databases. I'm going to attempt to handle branching (but already that means, ugly hex digest version numbers). The transactional DDL and the very short ALTER constructs that don't require Table metadata are other advantages, but Migrate could have those same features (particularly if they decide to drop pre-0.6 support, which they probably cannot for some time).
It also doesn't have any of the schema comparison stuff Migrate has, which seems to be the kind of thing people want (Ken's request is not the first I've heard). Migrate could improve a lot on that feature if they use the new Inspector interface in 0.6. So its hard to say at the moment. It wouldn't be too hard to move from one to the other except that you'd probably start back at version 1 and not try to re-use old version files (which again appears to be heresy in some migration circles). On May 17, 2010, at 7:50 PM, Chris Withers wrote: > Michael Bayer wrote: >> sqlalchemy-migrate is the obvious choice. I am also developing a >> micro-migrations system called Alembic (http://bitbucket.org/zzzeek/alembic) > > If we start with sqlalchemy-migrate, do you reckon switching to Alembic when > it's mature would be feasible? > > Chris > > -- > Simplistix - Content Management, Batch Processing & Python Consulting > - http://www.simplistix.co.uk > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.