wakoinc on Nostr: NostrGraph 7 day reactions (less than 4 chars). For databases, reactions are actually ...

NostrGraph 7 day reactions (less than 4 chars).

For databases, reactions are actually not amazing. For a single character (ignore UTF8), it’s basically 500 characters in event JSON.

You can certainly extract the reaction, and even use something like hyperloglog to compress that way down - and even using the reaction event creator local DB id, and then you can delete the reaction, but avoid double counting too. However, you then can’t broadcast, search or prove that reaction after deletion. Maybe that doesn’t matter.

We’ll either get better at handling data and processing for stuff like this, or it will have to change anyway, as relays won’t be able to host all the data in its current form - even for a 30 day period.