twosigma/postgresql-contrib
View on GitHub ↗ ★ 13 PLpgSQL archived
6 mentions on Hacker News by 1 person: 0 stories, 6 comments · first 2017-05-18 · latest 2023-06-02
20082026
-
…Here's a script that generates a JSON view of a PG SQL schema enriched with JSON from COMMENTs: https://github.com/twosigma/postgresql-contrib/blob/master/s... and https://github.com/twosigma/postgresql-contrib/blob/master/s...
comment by cryptonector · 2023-06-02 · in Sketch of a Post-ORM -
You can use https://github.com/twosigma/postgresql-contrib/blob/master/m... and write triggers to update your views or mark them as needing asynchronous refreshes. It's not as automatic as what you'd like, but it's a lot better than having…
comment by cryptonector · 2023-05-25 · in PostgreSQL 16 Beta 1 -
…complete quickly", so just mark the view as needing a refresh and refresh it asynchronously. [0] https://github.com/twosigma/postgresql-contrib/blob/master/m...
comment by cryptonector · 2023-05-25 · in PostgreSQL 16 Beta 1 -
…practice that's only trivial for some kinds of queries, and I've not written such a tool yet. [0] https://github.com/twosigma/postgresql-contrib/blob/master/m...
comment by cryptonector · 2022-10-03 · in The next generation of Materialize -
Thanks. You can find some of that code here: https://github.com/twosigma/postgresql-contrib I need to finish the open sourcing of tailfhttpd though. It's... an open-coded HTTP server, written in C, specifically tailored for tailing files…
comment by cryptonector · 2019-10-18 · in Aquameta: Web development platform built in PostgreSQL -
…materialized views. I needed such a thing so much so that I implemented such a thing in PlPgSQL: https://github.com/twosigma/postgresql-contrib/blob/master/p... This lets me materialize a view and then inspect deltas between refreshes,…
comment by cryptonector · 2017-05-18 · in PostgreSQL 10 Beta 1 Released