i'm pleased to say that in my work progress is going well but it is well into refactoring stage now... just had a massive leap forward with bulk iterations of the database, the time for completing a garbage collection count pass escalated to basically infinity after a couple of gigabytes of data but now i have got a counter that runs in 10 seconds on a 15gb store

i can see how i might even be able to do reindexing, fast data backup, and in the near future full text indexes and even maybe go the next step to graph database and design a better search API

filter searches are just the most minimal required index and search API for nostr, it will have to get a lot more advanced to provide the necessaries such as which you are constantly ruminating about