From: | Deven Phillips <deven(dot)phillips(at)gmail(dot)com> |
---|---|
To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
Cc: | Arthur Silva <arthurprs(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: json-patch support? |
Date: | 2016-10-24 12:34:26 |
Message-ID: | CAJw+4ND+T3s+3tPg-gy7sghzFyX-sCqdM8zRXDGUGymgMQLVuQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Finally got around to doing this... The link below points to a complete
implementation of JSONPatch in pure PostgreSQL. It is compatible with
PostgreSQL >= 9.5 (Not tested using earlier versions)
https://gist.github.com/InfoSec812/b830a9db4c9048552f8c51d7987cc4d0
Cheers!
Deven
On Fri, Mar 27, 2015 at 4:16 PM, Deven Phillips <deven(dot)phillips(at)gmail(dot)com>
wrote:
> OK, then I will look into perhaps implementing it as a pl-python or
> pl-java function. Thanks for the advice!!
>
> Deven
>
> On Fri, Mar 27, 2015 at 2:40 PM, Merlin Moncure <mmoncure(at)gmail(dot)com>
> wrote:
>
>> 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
>>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-10-24 12:37:55 | Re: Errors while installing PostGIS by an unusual method |
Previous Message | Nicolas Paris | 2016-10-24 08:59:12 | Re: postgres_fdw : disable extended queries |