Can’t just magically have an aggregate event. That defeats the whole purpose of the way events are designed. I have a short write up of events that might help clarify here https://armstrys.github.io/nostrfastr/nostr_core.html#nostr-events
Discussion
lnbc4200n1p3m5cmzpp5wm9ncx5xcld29ja2q05l3nglp6uulvm6zr4ekkhykzfqthvqchpqdq5g9kxy7fqd9h8vmmfvdjscqzpgxqyz5vqsp5ghwp7423j8gwhmz7c0rmwdq2ved3q73vkzwy7nre4n4l0kyhtmhs9qyyssqprt5f4ysl7e2z6tk5s7jfpg20855xktkalcct95nm4th5dud9z4yhy22h3lnttfql84hwkena08h35eqc8up3e6pwalgqjtrvy6ptggpwjkult
I'm not proposing anything "magically" happen. As a 25+ year dev I'm aware of the technical issues involved in aggregate storage. I also understand Nostr being designed for in-time events and not aggregates. If any solution would be unacceptable due to that design philosophy, then there's no purpose in having a reaction event, at least not for large public relays.
Once Nostr popularity has millions (or tens of millions) of daily active users requesting thousands or hundreds of thousands of kind 7 notes for each note being displayed, the load on the relays would be untenable. There's a discussion of possibilities on the issue I posted to the Nostr git if your'e interested in chiming in there.
Yes, sorry I naively posted last night without looking deeper into your comments and profile. Thanks for the link - curious to see more about this proposal.
No worries. #[3] posted a good solution to the git thread. Have a REST API built into relays that returns all the stats for a given note (# reactions, # replies, # reports) etc. That would solve more than just the reactions issue.