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
