[thom]

Have you looked into something like Materialize? That’d give you realtime updates over even materialised views, works to back Hasura etc.

[aidos]

Hadn’t seen that one. Thanks for the heads up. It’s the sort of thing that I could see being useful in a bunch of places. We have a number of hand rolled things to deal with similar issues.

Might not be a perfect fit here because some of the views are session context dependent (but could maybe still be workable).