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 it since. I have not even seen a bug report! It seems that nobody knows it and nobody uses it. I agree that JSON is an important format. But there are lots such. A little polemically I could say that as since some people store .mp3/.mp4 snippets in a BLOB why not add a media streaming functionality to the server ... and playback functionalities to the standard client :-) I think such stuff belongs in a 'stored functions library' and are not a core server feature. But I realize that as long as stored functions programming only supports SQL (and not Perl like in Postgsql and not C# as in recent SQL Server) it is not really much feasible. Currently it requires coding in the application/client environment (such as a PHP class for instance). (you may find this an off-topic comment from a non-coder (and you are right) - but I wanted to put a little perspective on this. IMHO this reqeust arises bcos of poor 'stored programs' programming options in MySQL) -- Peter -- Webyog On Wed, Apr 11, 2012 at 19:40, MARK CALLAGHAN <mdcallag@gmail.com> wrote:
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 <mdcallag@gmail.com> wrote:
On Fri, Dec 2, 2011 at 5:23 AM, Michael Widenius <monty@askmonty.org> 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 is but then must know how mariadb encoded it.
Sorry, don't understand the question.
When asking for a value for a column in the client , you get back a structure that tells how the data is encoded. See the 'struct st_dynamic_column_value'
MARK> The function MARK> column_list returns the column names.
Dynamic columns are dynamic. The client doesn't know which key names are used for each row selected. With the current code there is no way for the client to get all key:value pairs set in a dynamic column for some number of rows. They can select the column but probably won't know how to decode the name:value pairs stored in it.
Apparently Jakob has code for this. So I don't have much more to add for this thread.
-- Mark Callaghan mdcallag@gmail.com
-- Mark Callaghan mdcallag@gmail.com
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp