News for hackers. Stuff that matters.

A comment on Ask HN: Is there a way to efficiently subscribe to an SQL query for changes?. Parent comment

Re:Ask HN: Is there a way to efficiently subscribe to an SQL... by skyde on Thursday April 22, 2021 @02:48PM (#26906533)
the cool thing with noria is that it behave like a cache.

So it only store the row from the materialized view that are frequently needed instead of storing the complete materialized view.

But if you query for a row which is missing it will rematerialize this row on demand with "up-query" without having to run the expensive query that a materialized view refresh normally need.

[ Parent | on HN ]
Re:Ask HN: Is there a way to efficiently subscribe to an SQL... by vaughan on Thursday April 22, 2021 @07:03PM (#26909184)
This approach would be cool if it ran on a database on the frontend too. You could run a complex query against an in-browser DB with a few joins and some params, and then tweak the params, and it would only need to pull down the missing rows. Then your app is offline and super snappy.
[ Parent | on HN ]
Re:Ask HN: Is there a way to efficiently subscribe to an SQL... by victor106 on Friday April 23, 2021 @12:30AM (#26911012)
Noria looks cool but it requires Zookeeper which is a PITA.
[ Parent | on HN ]