This feature is relatively easy to implement for personal relays. I have 300k events locally and the count query is still very fast. I've simply implemented it, you can give it a try. Btw, the results of queries with multiple filtering conditions are inaccurate. I simply add up the results of each filtering condition.
https://github.com/CodyTseng/nostr-relay-tray/pull/11
cody / Cody Tseng
npub1sy…wf6wl
2024-05-02 04:27:36
in reply to nevent1q…qn9r
Author Public Key
npub1syjmjy0dp62dhccq3g97fr87tngvpvzey08llyt6ul58m2zqpzps9wf6wlPublished at
2024-05-02 04:27:36Event JSON
{
"id": "a5134051c394bdfee52527eae47df5ff508222f3e71ab6ed0db06e9858b9ccfc",
"pubkey": "8125b911ed0e94dbe3008a0be48cfe5cd0c0b05923cfff917ae7e87da8400883",
"created_at": 1714624056,
"kind": 1,
"tags": [
[
"e",
"7bc43d6d57939309bf9296e58eba7dfad859f1af7245edba85e607b2e1671ec1",
"",
"root"
],
[
"e",
"7bc43d6d57939309bf9296e58eba7dfad859f1af7245edba85e607b2e1671ec1",
"",
"reply"
],
[
"p",
"266815e0c9210dfa324c6cba3573b14bee49da4209a9456f9484e5106cd408a5",
"",
"mention"
]
],
"content": "This feature is relatively easy to implement for personal relays. I have 300k events locally and the count query is still very fast. I've simply implemented it, you can give it a try. Btw, the results of queries with multiple filtering conditions are inaccurate. I simply add up the results of each filtering condition.\n\nhttps://github.com/CodyTseng/nostr-relay-tray/pull/11",
"sig": "36d688b85aa76d8c329a175857bded9482928211e153e4f533c08615ec698d96ab576cfd18f9ecbc522f617d8ce7b71fd97355af2a24a0a3b8f8844671ebf5da"
}