Hacker News new | ask | show | jobs
by Bishonen88 1260 days ago
No third party tools etc. are needed for that. A trigger can update a materialized view whenever the source table changes.
1 comments

This causes the whole materialized view to update. If the underlying query is complex (which it usually is - otherwise you would not need the view), you often don't want to rerun it for every update.

With the separate tools the idea is to stream the incoming updates and keep the materialized views up to date all the time.

How does it know which rows would be affected how when we have something complex? Even better: Is there a detailed proposal or a paper to allow me to gawk at the intelligence of other people? :)
Yes, there is!

https://jon.thesquareplanet.com/papers/phd-thesis.pdf

This is the paper on which Readyset and Noria are based.

I am unable to open the link. Do you mind sharing a working one? Thanks.
This is likely because the author blocks access from non-Western countries, you're likely located outside the West (I am as well, and had to use a VPN to access it).

I've mirrored the file here, this link should work for you: https://tazj.in/blobs/noria-thesis.pdf