Re: [HACKERS] Tackling JsonPath support

2016-11-28 Thread Nico Williams
I wonder what it might take to integrate jq[1] (via libjq) with PostgreSQL... The internal representation of JSON data is bound to be completely different, no doubt, but jq is a fantastic language, akin to XPath and XSLT combined, but with nice syntax. [1] https://stedolan.github.io/jq (note: jq

Re: [HACKERS] Alternative MATERIALIZED VIEW design and implementation with history table and other features

2016-11-28 Thread Nico Williams
On Sat, Nov 26, 2016 at 04:13:19PM -0600, Jim Nasby wrote: > On 11/22/16 9:11 PM, Nico Williams wrote: > >But we needed a method for recording deltas from REFRESHes, and that's > >not supported. So I coded up my own version of materialized views, in > >PlPgSQL, that does prov

[HACKERS] Alternative MATERIALIZED VIEW design and implementation with history table and other features

2016-11-22 Thread Nico Williams
I love MATERIALIZED VIEWs. But we needed a method for recording deltas from REFRESHes, and that's not supported. So I coded up my own version of materialized views, in PlPgSQL, that does provide a history feature. Besides a history feature, this includes the ability to record changes made to a

<    1   2