Re: Postgresql 9.4 / JSONB / JDBC

Yes, we can pull the data from the server in binary. After that though we
have to convert it to text

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On 29 December 2014 at 05:08, Christopher BROWN <brown(at)reflexe(dot)fr> wrote:

> Hello,
>
> Regarding my previous messages on this subject (JSONB support in the
> Postgresql JDBC driver), one assumption I'm making is that the driver might
> be able to stream the JSON data more efficiently that just throwing a chunk
> of text onto the wire... as text isn't the most efficient way of encoding
> numbers, booleans, and nulls.
>
> How does the native network protocol of Postgresql actually transfer such
> data? Is there an opportunity for sending the data efficiently?
> Personally for some of my applications, I'm able to use Jackson's "Smile"
> binary JSON format, although I doubt that the Postgresql server would
> understand it or want to implement it (I don't know if it could be
> considered a standard, even if it's specified --
> http://wiki.fasterxml.com/SmileFormatSpec).
>
> --
> Christopher
>
>
> On 20 December 2014 at 10:44, Christopher BROWN <brown(at)reflexe(dot)fr> wrote:
>
>> Hello,
>>
>> I'm new to this list, and have tried searching both the mailing list
>> archives, and internet in general, for information on how to use the new
>> JSONB data type with JDBC. Found almost nothing in the mailing list
>> archives, and internet searches "helpfully" assume I've misspelled "json"
>> and give me results that are unrelated or refer to the basic "JSON" type
>> from older Postgresql versions.
>>
>> How can this type be used, with simple "flat" key-value collections
>> (maps), with tree-like maps-of-maps, and (ideally) with JSON APIs such as
>> Jackson JSON API?
>>
>> Is it possible? Is it already described somewhere that I missed?
>>
>> Thanks,
>> Christopher
>>
>
>