Hacker News Reader

This is being worked on if I recall:

We've had success using DBT incremental models for this. Deletes aren't supported though, but for our use case that's fine and do a nighly refresh on the whole.

Otherwise the best alternative would be something like https://materialize.com

"Incremental view maintenance"

Lots and lots of theory about how to do this correctly.

I authored a project to do this with triggers. https://github.com/rivethealth/denorm

Nice! I did this "by hand" for a dozen views a few years back, fiddly but rewarding; if I have to do it again ...

Check out https://readyset.io as well — it’s an incremental view maintenance system