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

Reply to this note

Please Login to reply.

Discussion

Intersting! Did not occur to me to use a kv solution for this.