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-----