Re: [openstack-dev] [keystone] sqlite doesn't support migrations

2013-07-19 Thread Joe Gordon
Along these lines, OpenStack is now maintaining sqlachemy-migrate, and we have our first patch up for better SQLite support, taken from nova, https://review.openstack.org/#/c/37656/ Do we want to go the direction of explicitly not supporting sqllite and not running migrations with it, like

Re: [openstack-dev] [keystone] sqlite doesn't support migrations

2013-07-16 Thread Thomas Goirand
On 07/16/2013 12:07 PM, Michael Still wrote: On Tue, Jul 16, 2013 at 1:44 PM, Thomas Goirand z...@debian.org wrote: In Debian, by policy, any package should be able to be installed using DEBIAN_FRONTEND=noninteractive apt-get install. What I do in my postinst is calling db_sync, because that

Re: [openstack-dev] [keystone] sqlite doesn't support migrations

2013-07-16 Thread Thomas Goirand
On 07/16/2013 01:50 PM, Dolph Mathews wrote: Make it work is an entirely different goal than make a production-ready deployment. If your goal in using sqlite is just to make it work then I'm not sure that I would expect such an install to survive to the next release, anyway... rendering

Re: [openstack-dev] [keystone] sqlite doesn't support migrations

2013-07-16 Thread Michael Still
On Tue, Jul 16, 2013 at 4:05 PM, Thomas Goirand z...@debian.org wrote: On 07/16/2013 12:07 PM, Michael Still wrote: On Tue, Jul 16, 2013 at 1:44 PM, Thomas Goirand z...@debian.org wrote: In Debian, by policy, any package should be able to be installed using DEBIAN_FRONTEND=noninteractive

Re: [openstack-dev] [keystone] sqlite doesn't support migrations

2013-07-16 Thread Michael Still
On Tue, Jul 16, 2013 at 4:17 PM, Thomas Goirand z...@debian.org wrote: Could you explain a bit more what could be done to fix it in an easy way, even if it's not efficient? I understand that ALTER doesn't work well. Though would we have the possibility to just create a new temporary table

Re: [openstack-dev] [keystone] sqlite doesn't support migrations

2013-07-16 Thread Morgan Fainberg
On Tue, Jul 16, 2013 at 12:55 AM, Michael Still mi...@stillhq.com wrote: On Tue, Jul 16, 2013 at 4:17 PM, Thomas Goirand z...@debian.org wrote: Could you explain a bit more what could be done to fix it in an easy way, even if it's not efficient? I understand that ALTER doesn't work well.

Re: [openstack-dev] [keystone] sqlite doesn't support migrations

2013-07-16 Thread Thomas Goirand
On 07/16/2013 03:55 PM, Michael Still wrote: On Tue, Jul 16, 2013 at 4:17 PM, Thomas Goirand z...@debian.org wrote: Could you explain a bit more what could be done to fix it in an easy way, even if it's not efficient? I understand that ALTER doesn't work well. Though would we have the

Re: [openstack-dev] [keystone] sqlite doesn't support migrations

2013-07-15 Thread Stephen Gran
On 15/07/13 09:26, Thomas Goirand wrote: Dolph, If you do that, then you will be breaking Debian packages, as they expect Sqlite as the default, for example when using DEBIAN_FRONTEND=noninteractive apt-get install keystone (if you choose MySQL, then you need to enter admin credentials to setup

Re: [openstack-dev] [keystone] sqlite doesn't support migrations

2013-07-15 Thread Thomas Goirand
On 07/15/2013 04:32 PM, Stephen Gran wrote: On 15/07/13 09:26, Thomas Goirand wrote: Dolph, If you do that, then you will be breaking Debian packages, as they expect Sqlite as the default, for example when using DEBIAN_FRONTEND=noninteractive apt-get install keystone (if you choose MySQL,

Re: [openstack-dev] [keystone] sqlite doesn't support migrations

2013-07-15 Thread Morgan Fainberg
On 2013/07/13, Stephen Gran a wrote : On 15/07/13 10:46, Thomas Goirand wrote: On 07/15/2013 04:32 PM, Stephen Gran wrote: On 15/07/13 09:26, Thomas Goirand wrote: Dolph, If you do that, then you will be breaking Debian packages, as they expect Sqlite as the default, for example when

Re: [openstack-dev] [keystone] sqlite doesn't support migrations

2013-07-15 Thread Adam Young
On 07/15/2013 05:46 AM, Thomas Goirand wrote: On 07/15/2013 04:32 PM, Stephen Gran wrote: On 15/07/13 09:26, Thomas Goirand wrote: Dolph, If you do that, then you will be breaking Debian packages, as they expect Sqlite as the default, for example when using DEBIAN_FRONTEND=noninteractive

Re: [openstack-dev] [keystone] sqlite doesn't support migrations

2013-07-15 Thread Dolph Mathews
On Sun, Jul 14, 2013 at 12:29 PM, Boris Pavlovic bo...@pavlovic.me wrote: Hi Dolph, Yes, I agree that there are some problems with sqlite and migrations. But I am not agree with approach of fully removing sqlite. It is pretty useful for testing. To be clear, I don't have any interest in

Re: [openstack-dev] [keystone] sqlite doesn't support migrations

2013-07-15 Thread Dolph Mathews
On Fri, Jul 12, 2013 at 3:19 PM, Monty Taylor mord...@inaugust.com wrote: On 07/11/2013 01:12 PM, Dolph Mathews wrote: Just as a general statement, outside the scope of openstack, I don't think sqlite is intended to support schema evolution. From the sqlite docs [1]: SQLite supports a

Re: [openstack-dev] [keystone] sqlite doesn't support migrations

2013-07-15 Thread Thomas Goirand
On 07/15/2013 11:07 PM, Adam Young wrote: On 07/15/2013 05:46 AM, Thomas Goirand wrote: On 07/15/2013 04:32 PM, Stephen Gran wrote: On 15/07/13 09:26, Thomas Goirand wrote: Dolph, If you do that, then you will be breaking Debian packages, as they expect Sqlite as the default, for example

Re: [openstack-dev] [keystone] sqlite doesn't support migrations

2013-07-15 Thread Dolph Mathews
On Mon, Jul 15, 2013 at 10:44 PM, Thomas Goirand z...@debian.org wrote: On 07/15/2013 11:07 PM, Adam Young wrote: On 07/15/2013 05:46 AM, Thomas Goirand wrote: On 07/15/2013 04:32 PM, Stephen Gran wrote: On 15/07/13 09:26, Thomas Goirand wrote: Dolph, If you do that, then you will be

Re: [openstack-dev] [keystone] sqlite doesn't support migrations

2013-07-12 Thread Monty Taylor
On 07/11/2013 01:12 PM, Dolph Mathews wrote: Just as a general statement, outside the scope of openstack, I don't think sqlite is intended to support schema evolution. From the sqlite docs [1]: SQLite supports a limited subset of ALTER TABLE. [...] It is not possible to rename a column,