Re: Feature Request: JSON input for hstore

David Fetter wrote:
> On Mon, Sep 14, 2009 at 06:55:52PM -0400, Andrew Dunstan wrote:
>   
>> David Fetter wrote:
>>     
>>> On Mon, Sep 14, 2009 at 03:14:57PM -0700, Josh Berkus wrote:
>>>       
>>>> Hackers,
>>>>
>>>> I've just had a feature request from a client that we come up with
>>>> a way to enable JSON input into hstore.  This would make hstore
>>>> much more useful for software developers.
>>>>
>>>> First question: would this go in the language driver, libpq, or
>>>> the backend?  Thoughts?
>>>>         
>>> The backend, ideally in some pluggable way.  XML, under proper
>>> circumstances, should work, as should YAML, etc.
>>>       
>> The way the standard specifies SQL/XML requires grammar support.
>> That  means it can't really be pluggable. We've been over this
>> before.
>>     
>
> I haven't found anything about hstore in the standard, so I'm not sure
> how this applies.
>
>
>   

You're the one that mentioned the backend being pluggable w.r.t. XML 
among other things.

In any case, this is academic. It has become clear in off-list 
discussion that support for JSON input isn't really what the requestor 
needs. What he needs is a way to translate a Perl hashref to an hstore 
literal and vice versa, and Andrew Gierth has written some nice routines 
in Perl to do just that.

cheers

andrew