What does HackerNews think of event-reduce?
An algorithm to optimize database queries that run multiple times
Language:
TypeScript
#48
in
Database
EventReduce - An algorithm to optimize database queries that run multiple times
See also the Event-Reduce algorithm which is a more lightweigt version of the similar principle. https://github.com/pubkey/event-reduce
Instead of invalidating query caches, you can sometime re-calculate the new result instead https://github.com/pubkey/event-reduce
You should check out the event-reduce algorithm[1]. It scales in a different way on how it calculates new results based on old-Results+Event. So it can have some benefits over materialized views depending on the data size and how many clients subscribe to a query.