Re: json-patch support?

On Fri, Mar 27, 2015 at 1:36 PM, Arthur Silva <arthurprs(at)gmail(dot)com> wrote:
> On Fri, Mar 27, 2015 at 1:56 PM, Deven Phillips <deven(dot)phillips(at)gmail(dot)com>
> wrote:
>>
>> Are there any plans or ideas about implement JSON Patch
>> (http://jsonpatch.com/) support for PostgreSQL? We deal with some relatively
>> large JSON documents for our in-house application and it is often better to
>> just send a json-patch update rather than the full document. It would be
>> very nice if we could just select for the changes via a trigger and use
>> NOTIFY to tell our application about a patch. If nobody has discussed it
>> previously, perhaps I will look into implementing it myself.
>>
>> Thanks in advance,
>>
>> Deven
>
>
> This could be implemented as an extension.
> There're already a few extensions that provide this functionality with plain
> functions, so it's just a matter of parsing the json and executing those
> functions.

Right. If it was me, I'd shoot for a userland (that is, in sql or
pl/pgsql) implementation that wraps the existing json APIs to get the
desired result. From there, could determine if a more optimized
version in C was warranted.

merlin