----- 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
withpg-json.
The great benefit of having JSON as an extension type is being able to use an external library (Jansson is very small,
MITlicensed, looks really well written and has been actively maintaied for years) and not being tied to a yearly
releasecycle.
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
anextension perfectly.
Cheers,
Jan