I see! Is a document based DB the way to go? In memory?
Discussion
strfry/nostrdb model is the only thing that has worked. lmdb + indexes that cover common use cases:
- created
- pubkeyKindCreated
- kindCreated
- tagKindCreated
Bonus points for storing json string and flatbuffer version of the note for optimal performance
Intersting! Did not occur to me to use a kv solution for this.