Re: PATCH: Add hstore_to_json()

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>
To: Hitoshi Harada <umi.tanuki@gmail.com>
Cc: Peter Eisentraut <peter_e@gmx.net>, "David E. Wheeler" <david@kineticode.com>, Robert Haas <robertmhaas@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2010-01-03T16:00:51Z
Lists: pgsql-hackers

Hitoshi Harada wrote:
> 2010/1/3 Andrew Dunstan <andrew@dunslane.net>:
>   
>> Hitoshi Harada wrote:
>>     
>>> A question: Isn't there no possibility that we have our own
>>> implementation to handle JSON (i.e. no use of external libraries)?
>>>
>>>
>>>
>>>       
>> Why should we reinvent a wheel someone else has already invented? This is
>> what shared libraries are all about.
>>     
> Because what we need may be another wheel nobody has already invented.
> I don't deny to use one of external libraries but don't like to decide
> specification by their specifications.
>
>
>   

OK, we really need to stop being abstract and say what operations we want.

I think the minimal functionality I'd want is:

    convert record to JSON
    convert JSON to record
    extract a value, or set of values, from JSON
    composition of JSON

Now all the libraries I have looked at (briefly) would require some code 
to provide for those, possibly quite a bit of code, but that doesn't 
mean we should just start from scratch and write our own JSON parser too.

cheers

andrew