JSON Patch (RFC 6902) support? - Mailing list pgsql-hackers

From Ryan Pedela
Subject JSON Patch (RFC 6902) support?
Date
Msg-id CACu89FSYikxdUj+J01BoAvoyieaGsXr1wSo1oQgGBMXsBNoMhg@mail.gmail.com
Whole thread Raw
List pgsql-hackers
This is my first email to the PostgreSQL mailing lists so I hope this is the correct place. If not, please let me know.

I was wondering if it would be possible and wise to support JSON Patch?
https://tools.ietf.org/html/rfc6902

One of the problems I have as a user is how to update a portion of a JSON object efficiently. Right now I have to read the entire field from the database, update it, and then write it back. I am thinking JSON Patch might be a good way to solve this problem because it would allow partial updates and I think it could easily fit into the existing set of JSON functions such as:

// applies a JSON Patch
json_patch_apply(json, patch)

// diffs two JSON objects and produces a JSON Patch
json_patch_diff(json a, json b)

Thanks,
Ryan Pedela

pgsql-hackers by date:

Previous
From: Rajashree Mandaogane
Date:
Subject: Proposal to join the hackers list
Next
From: Heikki Linnakangas
Date:
Subject: Re: GIN improvements part2: fast scan