Re: JSON Patch for PostgreSQL - BSON Support?

Robert Haas wrote: <blockquote cite="mid:AANLkTimZ5FJ8Q8GY7dq1BioN1R92GRs-p6Tj5yFpzXt1@mail.gmail.com"
type="cite"><prewrap="">On Sun, Aug 15, 2010 at 11:03 PM, Tom Lane <a class="moz-txt-link-rfc2396E"
href="mailto:tgl@sss.pgh.pa.us"><tgl@sss.pgh.pa.us></a>wrote: </pre><blockquote type="cite"><pre wrap="">I knew
therewould be a lot of critters crawling out as soon as we
 
turned over this rock.  Which other data-formats-of-the-week shall
we immortalize as core PG types?   </pre></blockquote><pre wrap="">
PER-encoded ASN.1, for when you really need something human-readable?  :-) </pre></blockquote><br /> I like to
prioritizewith "hits on Google" as a proxy for popularity:<br /><br /> XML:  341M<br /> CSV:  132M<br /> JSON:  96M<br
/>YAML:  6M<br /> ASN.1:  1.1M<br /> BSON:  130K<br /> "Protocol Buffers":  86K<br /> OGDL:  45K<br /><br /> I think
there'sa strong case to add JSON, as it may very well be the most popular data->text serialization format out there
notyet supported.  It's certainly beyond a format of the week at this point.<br /><br /> "XML is like violence: if it
doesn'tsolve your problem, you aren't using enough of it." - Chris Maden <br /><br /><pre class="moz-signature"
cols="72">--
 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
<a class="moz-txt-link-abbreviated" href="mailto:greg@2ndQuadrant.com">greg@2ndQuadrant.com</a>   <a
class="moz-txt-link-abbreviated"href="http://www.2ndQuadrant.us">www.2ndQuadrant.us</a>
 
</pre>