building stat counting into #nostrdb so that pulling stats for a post (zaps, likes) will be O(1)

It will even be smart enough to count stats on individual versions of parameterized events so that if you like something and someone edits it to say something else, this information isn’t lost. So you will be able to show that a user liked an older version of a post in malicious situations.

nostrdb naturally supports viewing different versions of events as well, so you will be able to view the edit history of a post, as well as rollback to older version of your contact list, view a users profile history, etc.