Re: Interest in serializing composite types?

[email protected] ("David E. Wheeler") Mon, 25 Aug 2014 11:36:03 -0700
Newsgroups perl.dbd.pg
Message-ID <[email protected]>
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.

D
signature.asc (application/pgp-signature, 842 B)
-----BEGIN PGP SIGNATURE-----
Comment: GPGTools - https://gpgtools.org

iQIcBAEBCgAGBQJT+4ITAAoJEJLfYnT4yIHxNAwP/3Y2NhuGVzBc2ZoZ3iO4JvBF
6HOcdSm9aHtiEDwkOnNMN3Cw6Dx5Id4nJ1AZMI7AbWB2AOB+9mTCw8Pd3A1l9qOf
WbR69dUqlKXA5YJdqDRRfr8l4YKlWA+lP1Z9akXRIJqic9XG9ZGyD9zJ87beb6UO
k8zSjxIW5RpNeLH9WaeLHNaBE7JUPplLDZRBP2qloDS1VPGsy3tnOyJCLiCjZzsf
/khxdT83ct8cFQu2D5iQxRKfX/i6Yuc3u4BD+Du8MEknJwilnOy8qjJpu5HGeymq
1o+dhuqoVgPaGW/EQooyI4AplFbncHOL/iwG19EI2xF80A+KUk9Bl8BLt/9L6tFR
boO88g0hzM0THSOif4oModU2pJ0I7xQMYOeGBqIOm5tx/dKAGKiq8PmUVojT9lJj
fzreww2+74vNTKX/YDAaA3DpIQAs+prqML+NcQjY2RND/vBYqNKpBieRuv1tHe5Z
+4LBifPwSymyMCW8OSw0Cc47sKbPFfZWJKX5wTILyCVLYXtYBsOUCt4WXl5DTRPt
jr6cSoFLgvnT9/Y/hYFS8GpqwXaBLM+eK+4XvlbOkd5V1CP//UsBQQdxilHXrj4c
UiKY8kzD30kGL716PLXfABxWipJGG55QZuJMRMYA+d6YcRFDnLK9gSBH8PJqZqsF
z9cHcezC0J5I4WuCwQiO
=pF8o
-----END PGP SIGNATURE-----