Request for comment: pgjson project
Hi all -
http://github.com/tlaurenzo/pgjson
I'm a long-time postgres user but have never developed any extensions for
it. I had some time over the past week and decided to tackle a project I've
had on my list for a while: adding robust JSON capabilities to the database
server. This is the first step in a bigger thought that I've been toying
with for a while.
Its not done yet, but it builds and works with some examples (see the Github
readme).
This isn't just an alias for a text type with some validation. The internal
representation is actually a superset of BSON (http://bsonspec.org/) as
defined for MongoDB. I've architected it so that it should play naturally
with the postgres type system, but there are still some cast functions that
need to be implemented.
Anyway, feedback is appreciated - good, bad or otherwise.
Thanks.
Terry
Terry Laurenzo <tj@laurenzo.org> writes:
I'm a long-time postgres user but have never developed any extensions for
it. I had some time over the past week and decided to tackle a project I've
had on my list for a while: adding robust JSON capabilities to the database
server.
Hm, are you aware that there's already work going on in that area?
There are two relevant patches in the queue at
https://commitfest.postgresql.org/action/commitfest_view?id=7
Perhaps you should join forces with those folk instead of starting an
independent effort. I don't believe that anyone thinks those patches
are set in stone yet, so design ideas are still welcome.
regards, tom lane
Thanks Tom. I wasn't aware - I did do a quick search at the beginning but
didn't turn this up. I'll post over on the hackers list.
Terry
On Sat, Oct 16, 2010 at 7:44 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Show quoted text
Terry Laurenzo <tj@laurenzo.org> writes:
I'm a long-time postgres user but have never developed any extensions for
it. I had some time over the past week and decided to tackle a projectI've
had on my list for a while: adding robust JSON capabilities to the
database
server.
Hm, are you aware that there's already work going on in that area?
There are two relevant patches in the queue at
https://commitfest.postgresql.org/action/commitfest_view?id=7Perhaps you should join forces with those folk instead of starting an
independent effort. I don't believe that anyone thinks those patches
are set in stone yet, so design ideas are still welcome.regards, tom lane