Open Stack

On 12/15/2015 11:39 AM, Igor Kalnitsky wrote:
> Hey Mike,
> 
> Thanks for your input.
> 
>> actually not.  if you replace your ARRAY columns with JSON entirely,
> 
> It still needs to fix the code, i.e. change ARRAY-specific queries
> with JSON ones around the code. ;)
> 
>> there's already a mostly finished PR for SQLAlchemy support in the queue.
> 
> Does it mean SQLAlchemy will have one unified interface to make JSON
> queries? So we can use different backends if necessary?

I still need to comb over the PR for the MySQL feature which looks to
mirror all the same functions that Postgresql has, as this is a SQLA 1.1
thing I think I'd like to build out a whole DB-agnostic JSON test suite
and really try to get these two to have as much parity as possible.
Because yes, the whole fricking world is going to be bothering me about
this one 24/7 if I don't do that, JSON datatypes are huge (how often
does MySQL add a datatype).





> 
> Thanks,
> - Igor
> 
> On Tue, Dec 15, 2015 at 5:06 PM, Mike Bayer <mbayer at redhat.com> wrote:
>>
>>
>> On 12/15/2015 07:20 AM, Igor Kalnitsky wrote:
>>> Hey Julien,
>>>
>>>> https://blueprints.launchpad.net/fuel/+spec/openstack-ha-fuel-postgresql
>>>
>>> I believe this blueprint is about DB for OpenStack cloud (we use
>>> Galera now), while here we're talking about DB backend for Fuel
>>> itself. Fuel has a separate node (so called Fuel Master) and we use
>>> PostgreSQL now.
>>>
>>>> does that mean Fuel is only going to be able to run with PostgreSQL?
>>>
>>> Unfortunately we already tied up to PostgreSQL. For instance, we use
>>> PostgreSQL's ARRAY column type. Introducing JSON column is one more
>>> way to tighten knots harder.
>>
>> actually not.  if you replace your ARRAY columns with JSON entirely,
>> MySQL has JSON as well now:
>> https://dev.mysql.com/doc/refman/5.7/en/json.html
>>
>> there's already a mostly finished PR for SQLAlchemy support in the queue.
>>
>>
>>
>>>
>>> - Igor
>>>
>>> On Tue, Dec 15, 2015 at 12:28 PM, Julien Danjou <julien at danjou.info> wrote:
>>>> On Mon, Dec 14 2015, Igor Kalnitsky wrote:
>>>>
>>>>> The things I want to notice are:
>>>>>
>>>>> * Currently we aren't tied up to PostgreSQL 9.3.
>>>>> * There's a patch [2] that ties Fuel up to PostgreSQL 9.3+ by using a
>>>>> set of JSON operations.
>>>>
>>>> I'm curious and have just a small side question: does that mean Fuel is
>>>> only going to be able to run with PostgreSQL?
>>>>
>>>> I also see
>>>> https://blueprints.launchpad.net/fuel/+spec/openstack-ha-fuel-postgresql,
>>>> maybe it's related?
>>>>
>>>> Thanks!
>>>>
>>>> --
>>>> Julien Danjou
>>>> // Free Software hacker
>>>> // https://julien.danjou.info
>>>
>>> __________________________________________________________________________
>>> OpenStack Development Mailing List (not for usage questions)
>>> Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
>>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>>>
>>
>> __________________________________________________________________________
>> OpenStack Development Mailing List (not for usage questions)
>> Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
> 
> __________________________________________________________________________
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>