Have you looked at the nostrdb format?
Me and Mike Dilger ☑️ (npub1acg…p35c) also talked about this at nostrasia. You can either make it compact (varints) with an encoding/decoding step or flat/aligned with zero copy. I chose flat for query performance.
I think fiatjaf (npub180c…h6w6) also has one in his Go libraries somewhere.
jb55 /
npub1xt…vkk5s
2024-05-07 15:36:37
in reply to nevent1q…a4qs
Author Public Key
npub1xtscya34g58tk0z605fvr788k263gsu6cy9x0mhnm87echrgufzsevkk5sPublished at
2024-05-07 15:36:37Event JSON
{
"id": "902ab71657cb8e5fb354d0cda11f1411b2b19139aa9f1a8bf74b16ad35940269",
"pubkey": "32e1827635450ebb3c5a7d12c1f8e7b2b514439ac10a67eef3d9fd9c5c68e245",
"created_at": 1715096197,
"kind": 1,
"tags": [
[
"e",
"f19a120d6e55b1339742aa54b488c54ede4e8bb954dc98687fae663715709d1e"
],
[
"e",
"ee4d73763bf0d02be49cec17b91c283275fa992a5a84e0b13e6158468ff3e4d9"
],
[
"p",
"4c800257a588a82849d049817c2bdaad984b25a45ad9f6dad66e47d3b47e3b2f"
],
[
"p",
"52b4a076bcbbbdc3a1aefa3735816cf74993b1b8db202b01c883c58be7fad8bd"
],
[
"p",
"ee11a5dff40c19a555f41fe42b48f00e618c91225622ae37b6c2bb67b76c4e49"
],
[
"p",
"3bf0c63fcb93463407af97a5e5ee64fa883d107ef9e558472c4eb9aaaefa459d"
]
],
"content": "Have you looked at the nostrdb format?\n\nMe and nostr:npub1acg6thl5psv62405rljzkj8spesceyfz2c32udakc2ak0dmvfeyse9p35c also talked about this at nostrasia. You can either make it compact (varints) with an encoding/decoding step or flat/aligned with zero copy. I chose flat for query performance.\n\nI think nostr:npub180cvv07tjdrrgpa0j7j7tmnyl2yr6yr7l8j4s3evf6u64th6gkwsyjh6w6 also has one in his Go libraries somewhere.",
"sig": "a04ee59ce4c292e91cf075da49a97248deb05508790445b92fc073047405c71b34ef3f8d30ff3c3edf167c132a9ea0faed72f515e6b1f2225141f7143f300c42"
}