News for hackers. Stuff that matters.
Re:Postgres is eating the database world by TOMDM on Friday March 15, 2024 @02:12AM (#39712519)
This solves the same problem, just not as well, the idea of an incrementaly maintained view is that only the update needs to be computed, so a count will increment or decrement as rows are inserted or deleted.

It means complex views that could take minutes or hours to calculate from scratch can be kept fresh in realtime.

Re:Postgres is eating the database world by physicles on Friday March 15, 2024 @10:36AM (#39716240)
I’ve built a few of these in snowflake for time series data (with dbt, which is fine but I don’t love it). My feeling so far is that the incremental bits are kinda fiddly and often domain-specific. Is it possible to define a single “shape” that would solve >90% of these incremental refresh scenarios?