Re: JSON for PG 9.2

----- Original message -----
> On Dec 12, 2011, at 4:51 PM, Peter van Hardenberg wrote:
>
> > Because we haven't heard from him in a while we've been using PL/V8 to
> > validate a JSON datatype simulated by a DOMAIN with a simple
> > acceptance function. (See below.) This is not ideally performant but
> > thanks to V8's JIT the JSON parser is actually reasonably good.
>
> Note that Claes Jakobsson has been working on a JSON data type using the
> Jansson JSON library.
>
>    http://pgxn.org/dist/pg-json/

We recently needed to store/valisate JSON data and be able to do some trivial extraction of values from it and went with pg-json.

The great benefit of having JSON as an extension type is being able to use an external library (Jansson is very small, MIT licensed, looks really well written and has been actively maintaied for years) and not being tied to a yearly release cycle.

Postgres jumps through a lot of hoops to be extensible and I think a JSON type is a kind of thing that fits the bill of an extension perfectly.

Cheers,
Jan