TYtypingmonkey·Jan 26, 2023
EventReduce - An algorithm to optimize database queries that run multiple times
https://github.com/pubkey/event-reduce
In Ask HN: What have you created that deserves a second chance on HN?pubkey
event-reduce
TypeScript2020–2023
pubkey / event-reduce
event-reduce
An algorithm to optimize database queries that run multiple times https://pubkey.github.io/event-reduce/
6Distinct people
10Mentions
0Explicit recommenders
756GitHub stars
What to know before exploring
What it is
An algorithm to optimize database queries that run multiple times https://pubkey.github.io/event-reduce/
GitHub
Where it is used
No documented product use has been verified yet.
What people are saying
No recommendation phrase was found in the indexed comments.
No classified warning is attached to this page. Read the discussions before treating silence as approval.
Also in these discussions
No other repository is repeatedly linked in the same discussions.
This week on Hacker News
Nov 7–Nov 14 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/14/2026, 3:03:16 PM UTC.
No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.
Mentions over time
HN mentions by year10 dated mentions
Observed mentions: 2020-04-14 22:47:24 UTC to 2023-01-26 21:51:40 UTC.
Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.
View mention counts and date ranges
| Period | Start (UTC) | End (exclusive, UTC) | Mentions | Submissions | Comments |
|---|---|---|---|---|---|
| 2020 | 2020-01-01 00:00:00 UTC | 2021-01-01 00:00:00 UTC | 4 | 3 | 1 |
| 2021 | 2021-01-01 00:00:00 UTC | 2022-01-01 00:00:00 UTC | 3 | 2 | 1 |
| 2022 | 2022-01-01 00:00:00 UTC | 2023-01-01 00:00:00 UTC | 2 | 0 | 2 |
| 2023 | 2023-01-01 00:00:00 UTC | 2024-01-01 00:00:00 UTC | 1 | 0 | 1 |
What Hacker News says
10 sourcesSee also the Event-Reduce algorithm which is a more lightweigt version of the similar principle. https://github.com/pubkey/event-reduce
In How PlanetScale Boost serves SQL queries fasterInstead of invalidating query caches, you can sometime re-calculate the new result instead https://github.com/pubkey/event-reduce
In Ask HN: Should I give up and get a job?EventReduce optimizes database queries that run multiple times
3 points · Open discussionYou 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.
[1] https://github.com/pubkey/event-reduce
In Why query planning for streaming systems is hardShow HN: EventReduce – Algorithm to optimise db queries that run multiple times
5 points · Open discussionEvent-reduce: An algorithm to optimize database queries that run multiple times
29 points · Open discussionThis is a great question. So EventReduce is only the algorithm that calculates your new results. The parsing of SQL is not done by it, you have to bring it by yourself. This works over providing some information about the query like Sort-fields and query-matchers. This is described good in the JavaScript implementation [1]. Providing this functions works easy for NoSQL-Queries because they are better composable. For SQL-queries you have to do some work before you can use EventReduce.
Also see the limitations of EventReduce in the readme.
[1] https://github.com/pubkey/event-reduce/tree/master/javascrip...
In EventReduce: An algorithm to optimize database queries that run multiple timesEventReduce: An algorithm to optimize database queries that run multiple times
208 points · Open discussionEvent-Reduce – An algorithm to optimize database queries that run multiple times
8 points · Open discussion