From: | Arthur Silva <arthurprs(at)gmail(dot)com> |
---|---|
To: | Deven Phillips <deven(dot)phillips(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: json-patch support? |
Date: | 2015-03-27 18:36:16 |
Message-ID: | CAO_YK0W5s6xsmTxiPE=_W8_oyW86EwhHAnZKHsOWxiNx135eTA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2015-03-27 18:36:43 | Re: Building JSON objects |
Previous Message | Jan de Visser | 2015-03-27 18:31:01 | Re: Building JSON objects |