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
jb55 / Destroyer of Notes
npub1xt…vkk5s
2025-11-18 12:57:26 UTC
in reply to nevent1q…8ku5
Author Public Key
npub1xtscya34g58tk0z605fvr788k263gsu6cy9x0mhnm87echrgufzsevkk5sSeen on
wss://nos.lolPublished at
2025-11-18 12:57:26 UTCEvent JSON
{
"id": "f5817c8cebe380456ea58d85de1a9d71a91dcf2252f3092fb27ab52a079d9b42",
"pubkey": "32e1827635450ebb3c5a7d12c1f8e7b2b514439ac10a67eef3d9fd9c5c68e245",
"created_at": 1763470646,
"kind": 1,
"tags": [
[
"e",
"a12ff3d33a94fa408d71e2435e6382700647f0cd3c0c09d56ec2cc64d5164b43",
"wss://ditto.pub/relay",
"root"
],
[
"e",
"e7dacce7259ef6326cb5994867a0bffaf5014f3dbce867d8e658b55f60b36dd4",
"wss://nos.lol",
"reply"
],
[
"p",
"d49a9023a21dba1b3c8306ca369bf3243d8b44b8f0b6d1196607f7b0990fa8df"
],
[
"p",
"21856daf84c2e4e505290eb25e3083b0545b8c03ea97b89831117cff09fadf0d"
],
[
"p",
"fa984bd7dbb282f07e16e7ae87b26a2a7b9b90b7246a44771f0cf5ae58018f52"
],
[
"p",
"3f770d65d3a764a9c5cb503ae123e62ec7598ad035d836e2a810f3877a745b24"
],
[
"p",
"76c71aae3a491f1d9eec47cba17e229cda4113a0bbb6e6ae1776d7643e29cafa"
],
[
"p",
"d0a1ffb8761b974cec4a3be8cbcb2e96a7090dcf465ffeac839aa4ca20c9a59e"
],
[
"p",
"9fce3aea32b35637838fb45b75be32595742e16bb3e4742cc82bb3d50f9087e6"
],
[
"p",
"781a1527055f74c1f70230f10384609b34548f8ab6a0a6caa74025827f9fdae5"
],
[
"p",
"d2e97f7320554e1306951a7caebe0c5a962c464d151324ec960655b3ea9a4d1b"
],
[
"p",
"0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd"
],
[
"p",
"7e9c924ae5255c95a454d28ae89552a1e081f828ad4dc0381508b509188c865e"
]
],
"content": "strfry/nostrdb model is the only thing that has worked. lmdb + indexes that cover common use cases:\n\n- created\n- pubkeyKindCreated\n- kindCreated\n- tagKindCreated\n\nBonus points for storing json string and flatbuffer version of the note for optimal performance",
"sig": "d8f81090775459e3dff0757491a712898877b91b83386fd4e3a911b50dc70ddaf9b14896be03cb086395dc30fa765992b8f215ba09dd1f720b0a9369ec108373"
}