Re: JSON Patch for PostgreSQL - BSON Support? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: JSON Patch for PostgreSQL - BSON Support?
Date
Msg-id 28590.1282013305@sss.pgh.pa.us
Whole thread Raw
In response to Re: JSON Patch for PostgreSQL - BSON Support?  (Joseph Adams <joeyadams3.14159@gmail.com>)
List pgsql-hackers
Joseph Adams <joeyadams3.14159@gmail.com> writes:
> Others already mentioned that you can't convert 2 billion byte long
> JSON strings to BSON.  Another issue is that BSON cannot encode all
> JSON numbers without precision loss.

As somebody already mentioned, the former isn't likely to be an issue
for us anytime in the foreseeable future, because we can't push around
datum values more than 1GB large anyhow.  The latter seems like a pretty
nasty problem though.

I'm good with just dropping this idea for the moment.  The Google hit
statistics that were cited earlier show that there's not enough interest
in BSON to justify a separate datatype, which is what it would
apparently need to be.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: refactoring comment.c
Next
From: Tom Lane
Date:
Subject: Re: security label support, part.2