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 <mmonc...@gmail.com> wrote: > On Fri, Mar 27, 2015 at 1:36 PM, Arthur Silva <arthur...@gmail.com> wrote: > > On Fri, Mar 27, 2015 at 1:56 PM, Deven Phillips < > deven.phill...@gmail.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 >