[openstack-dev] [DB][Migrations] Switching to using of Alembic

David Ripton dripton at redhat.com
Tue Jul 16 18:09:28 UTC 2013

On 07/16/2013 12:09 PM, Dolph Mathews wrote:
> On Tue, Jul 16, 2013 at 10:51 AM, Roman Podolyaka
> <rpodolyaka at mirantis.com <mailto:rpodolyaka at mirantis.com>> wrote:

>     We are going to implement ALTER support in Alembic for SQLite in the
>     next few weeks.
> I'm a little lost on this ... sqlite doesn't support ALTER, so what
> exactly is being added to alembic? Is the alembic community receptive or
> interested?

There is some code in Nova (on its way into Oslo) to work around not 
being able to alter tables in SQLite.  It deletes the old table and adds 
the modified version as a new table.  That's the best you can do without 
modifying SQLite itself.

The Alembic README specifically mentions this SQLite issue and says "we 
will support these features provided someone takes the initiative to 
implement and test".  So, yeah, he'll take these patches.  Means we'll 
need to use the future version of Alembic with this feature, though.

David Ripton   Red Hat   dripton at redhat.com

More information about the OpenStack-dev mailing list