[openstack-dev] [DB][Migrations] Switching to using of Alembic
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
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