Ask HN: Is there a way to efficiently subscribe to an SQL query for changes?

Re:Ask HN: Is there a way to efficiently subscribe to an SQL... by sathorn on Thursday April 22, 2021 @08:33AM (#26901993)

There is also the research DB Noria[0] that's based on this idea. It maintains materialized views for queries and efficiently updates them when the data changes.

[0] https://github.com/mit-pdos/noria

[ Parent | on HN ]

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 ]