Re: json type

On 05/21/2012 11:18 AM, Craig Ringer wrote:
> On 05/10/2012 05:17 PM, Mikko Tiihonen wrote:
>> Hi,
>>
>> Here is a patch to enable initial support for hstore in the jdbc driver.
>>
>> With the patch using ResultSet.getObject() on a hstore column and it returns a HashMap<String, String>
>> Similarly a Statement.setObject(Map<Object,Object> will send the data to backend using hstore format.
>
> That's absolutely brilliant, thankyou!
>
> Of course, now there's a `json' type that folks will probably use much of the time instead, not least because it should be easier to work with from JDBC. I
> doubt it'll be as efficient and fast as hstore for single-level key/value info though.

Unfortunately there is no standard json type on java side so adding support for json to postgres jdbc is not straight forward.

I've been thinking that we could have a code that allows the postgres jdbc user to set the json class to use (gson, org.json, json-simple, jackson) and add some
reflection code into the jdbc driver to return path so that it works nicely. And of course the reverse reflection code for sending json to database.

-Mikko