Re: Interest in serializing composite types?

On 08/25/2014 02:36 PM, David E. Wheeler wrote:
> On Aug 25, 2014, at 11:32 AM, Andrew Dunstan <[email protected]> wrote:
>
>> Well, of course, json and jsonb are already serializations. Even jsonb in binary mode is sent to the client as a json string (with a version number in case we ever decide to send/receive a different binary format).
>>
>> And turning a composite into json is pretty simple - in 9.4 it's just to_json(recordval). populate_json(null::recordtype, jsonval) pretty much does the reverse. On the perl side there are well known modules for moving between hashes and json objects. Maybe with some sort of Tie mechanism you could make that almost transparent?
> No, I meant convert /JSONB?/ values to and from hashes or arrays.
>



I'm not following.

In the hands of a client jsonb is still just a string, more or less. And 
of course json is just a string anyway. We never send the jsonb on-disk 
format to a client, even in binary mode.

cheers

andrew