[Buildbot-commits] [Buildbot] #2590: Use Alembic instead of SQLAlchemy-Migrate

[Buildbot trac]

#2590: Use Alembic instead of SQLAlchemy-Migrate
-------------------------+--------------------
Reporter:  dustin        |       Owner:
    Type:  project-idea  |      Status:  new
Priority:  major         |   Milestone:  0.9.+
 Version:                |  Resolution:
Keywords:  database      |
-------------------------+--------------------
Description changed by dustin:

Old description:

> Migrate has some compatibility problems - in particular, it doesn't work
> with SQLAlchemy >= 8.0.  Its API is a little unpredictable, too, and it
> doesn't do a very good job of masking differences between dialects.  Its
> linear numbering scheme is also problematic when developing on topic
> branches, as a merge of branches with overlapping DB version numbers will
> need some substantial changes to put them in linear order.
>
> Alembic seems to be the fix to all that, although that's as far as we've
> gotten.
>
> This would make a decent, if small, Google Summer of Code project.

New description:

 Migrate has some compatibility problems - in particular, it doesn't work
 with SQLAlchemy >= 8.0.  Its API is a little unpredictable, too, and it
 doesn't do a very good job of masking differences between dialects.  Its
 linear numbering scheme is also problematic when developing on topic
 branches, as a merge of branches with overlapping DB version numbers will
 need some substantial changes to put them in linear order.

 Alembic seems to be the fix to all that, although that's as far as we've
 gotten.

 This would make a decent, if small, Google Summer of Code project.

 == Scope ==

 The goal of this project is clear: replace the functionality of
 SQLAlchemy-Migrate with equivalent functionality implemented with Alembic.
 A GSoC application should also address:

  * Compatibility - users with current versions of Buildbot must be able to
 upgrade to Alembic
  * Testing - when database migrations fail, users lose data.  The current
 migrations are thoroughly tested to ensure they do the right thing on all
 supported databases, and the new implementation must do the same.

--

-- 
Ticket URL: <http://trac.buildbot.net/ticket/2590#comment:3>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation