Re: [Maria-discuss] getting all name-value pairs from a dynamic column

2012-04-12 Thread Jakob Lorberblatt
> Isn't this request something like this > http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html - only not only > XML but also JSON should be supported? > yes! its a more useful format, as Mark points out below, I have code for it. I'll test it on a more recent version of mariadb in the next

Re: [Maria-discuss] getting all name-value pairs from a dynamic column

2012-04-12 Thread Jakob Lorberblatt
> Isn't this request something like this > http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html - only not only > XML but also JSON should be supported? > yes! its a more useful format, as Mark points out below, I have code for it. I'll test it on a more recent version of mariadb in the next

Re: [Maria-discuss] getting all name-value pairs from a dynamic column

2012-04-11 Thread Peter Laursen
Isn't this request something like this http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html - only not only XML but also JSON should be supported? I remember when this XML functionality was introduced in early MySQL 5.1 there was quite a lot of *buzz* about it. I never heard anything about i

Re: [Maria-discuss] getting all name-value pairs from a dynamic column

2012-04-11 Thread MARK CALLAGHAN
I think I want a function that converts the blob into a JSON formatted set of key-value pairs. On Wed, Dec 7, 2011 at 9:19 PM, MARK CALLAGHAN wrote: > On Fri, Dec 2, 2011 at 5:23 AM, Michael Widenius wrote: >> MARK> How do you fetch all name-value pairs from a dynamic column in a >> MARK> format

Re: [Maria-discuss] getting all name-value pairs from a dynamic column

2011-12-27 Thread Michael Widenius
Hi! > "Jakob" == Jakob Lorberblatt writes: Jakob> Monty, Jakob> I wrote this function already, and had it working as fast as any query, if Jakob> you'd like my code I wrote for a previous employer (and was NOT used, so Jakob> is available) I would gladly turn this over to the project. Jak

Re: [Maria-discuss] getting all name-value pairs from a dynamic column

2011-12-27 Thread Michael Widenius
Hi! > "Jakob" == Jakob Lorberblatt writes: Jakob> Monty, Jakob> I wrote this function already, and had it working as fast as any query, if Jakob> you'd like my code I wrote for a previous employer (and was NOT used, so Jakob> is available) I would gladly turn this over to the project. Jak

Re: [Maria-discuss] getting all name-value pairs from a dynamic column

2011-12-07 Thread MARK CALLAGHAN
On Fri, Dec 2, 2011 at 5:23 AM, Michael Widenius wrote: > MARK> How do you fetch all name-value pairs from a dynamic column in a > MARK> format that can be consumed by a client? > > Do you mean from SQL or in the client library? In the client > > MARK> The client can select the > MARK> column as

Re: [Maria-discuss] getting all name-value pairs from a dynamic column

2011-12-03 Thread Jakob Lorberblatt
Monty, I wrote this function already, and had it working as fast as any query, if you'd like my code I wrote for a previous employer (and was NOT used, so is available) I would gladly turn this over to the project. I called it JSONIFY(QUERY_TEXT). Jakob Lorberblatt > > Hi! > >> "MARK" == MA

Re: [Maria-discuss] getting all name-value pairs from a dynamic column

2011-12-02 Thread Michael Widenius
Hi! > "MARK" == MARK CALLAGHAN writes: MARK> These docs are excellent -- http://kb.askmonty.org/en/dynamic-columns Thanks. MARK> How do you fetch all name-value pairs from a dynamic column in a MARK> format that can be consumed by a client? Do you mean from SQL or in the client library?

[Maria-discuss] getting all name-value pairs from a dynamic column

2011-11-30 Thread MARK CALLAGHAN
These docs are excellent -- http://kb.askmonty.org/en/dynamic-columns How do you fetch all name-value pairs from a dynamic column in a format that can be consumed by a client? The client can select the column as is but then must know how mariadb encoded it. The function column_list returns the col