On Mon, Nov 28, 2016 at 05:56:41PM +0100, Pavel Stehule wrote: > Dne 28. 11. 2016 17:26 napsal uživatel "David Fetter" <da...@fetter.org>: > > There's another option we should also consider: jq > > <https://stedolan.github.io/jq/>. It's available under a > > PostgreSQL-compatible license, and has had a LOT of work put into > > correctness and performance. > > we can use it for inspiration. but the syntax of this tool is little bit > too complex and too original against Json path ... jsonpath is relative > simple implementation of xpath to json > > we have one proprietary syntax already, two is maybe too much :-)
jq is hardly proprietary :) JSON Path is not expressive enough (last I looked) and can be mapped onto jq if need be anyways. libjq has a number of desirable features, mostly its immutable/COW data structures. In libjq data structures are only mutated when there's only one reference to them, but libjq's jv API is built around immutability, so jv values are always notionally immutable. For example, one writes: jv a = jv_array(); a = jv_array_append(a, jv_true()); // `a' is notionally new, but since // it had only one reference, its // memory is reused and similarly for objects. One could instead write: jv a = jv_array_append(jv_array(), jv_true()); or jv a = JV_ARRAY(jv_true()); One of the nice things about libjv is that almost every function consumes a reference of every jv value passed in, with very few exceptions. This simplifies memory management, or at least avoidance of double-free and use-after-free (it can be harder to track down leaks though, since tools like valgrind don't understand that jv_copy() call sites can be like allocations). Nico -- -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers