Oooh i like that.
We always figured we would need to build some type of “purgatory” db eventually but I’m pleasantly surprised by how enlightening it is out of the box.
I've been struggling with spam on my free relay, of course, and I've been thinking a lot more about spam filtering. I'm not operating anything as massive as nostr.wine, but I like the idea of a purgatory database because I've been trying to think of how I could categorize npub behavior by something other than timing. Having a whole separate database that you could just sit there and analyze would be useful.