I'd originally sent this to Joseph Adams, as he has been working on
adding a JSON datatype.
I've suggested supporting BSON, as there are many client implementations
available,
and the format is more efficient than xml and json trees for some use cases.
http://bsonspec.org/
On 8/15/10 11:27 AM, Joseph Adams wrote:
> On Sat, Aug 14, 2010 at 6:35 PM, Charles Pritchard<chuck@jumis.com> wrote:
>
>> Hello,
>>
>> I saw that you've submitted a patch to add JSON support to PostgreSQL.
>> Thought I'd mention that BSON is gradually picking up in popularity,
>> and does have a good amount of cross-client support.
>>
>> That said, I wouldn't be surprised if a patch were looked at with suspicion,
>> but it does make sense as a contrib module.
>>
>> BSON is a binary json format used by Mongo DB.
>>
>> I don't use it, at all, but it seems like a good fit, and the right time.
>>
>> Returning BSON would be more efficient than returning JSON,
>> for some use cases.
>>
>> -Charles
>>
>>
> Would you mind posting this to the pgsql-hackers@postgresql.org
> mailing list? I think a BSON module would be a good idea, as it would
> provide a more efficient alternative to the more text-oriented JSON
> data type.
>
>
> Joey Adams
>