david on Nostr: Suppose each :NostrEvent node were limited to just a few properties: eventId, ...
Suppose each :NostrEvent node were limited to just a few properties: eventId, created_at, author. +/- tags. This would reduce the db size by quite a lot.
Published at
2025-01-15 19:40:38Event JSON
{
"id": "bafc6c472d6b9e41f5644b6b807d403145f03cfcd915200bfe545e245d767031",
"pubkey": "e5272de914bd301755c439b88e6959a43c9d2664831f093c51e9c799a16a102f",
"created_at": 1736970038,
"kind": 1,
"tags": [
[
"e",
"b588f4cbb4c73bef489673c7c58240ae4a996505ce8e6c289c544a7eb7101905",
"",
"root"
],
[
"e",
"f70593ba459df39ede305708f14ef7b5f1ca0f1f531c928e8a6b679bdf69b36b",
"",
"reply"
],
[
"p",
"460c25e682fda7832b52d1f22d3d22b3176d972f60dcdc3212ed8c92ef85065c"
],
[
"p",
"32e1827635450ebb3c5a7d12c1f8e7b2b514439ac10a67eef3d9fd9c5c68e245"
],
[
"p",
"3356de61b39647931ce8b2140b2bab837e0810c0ef515bbe92de0248040b8bdd"
],
[
"p",
"7ed7d5c3abf06fa1c00f71f879856769f46ac92354c129b3ed5562506927e200"
]
],
"content": "Suppose each :NostrEvent node were limited to just a few properties: eventId, created_at, author. +/- tags. This would reduce the db size by quite a lot.",
"sig": "aa0b216128152a26f710a9a0277446d310f5219c190773cea879fc3a78f50561dda5c5f361fa42f22ca8ace19f1c01a9e99a95792aac7f58d011f3aad8896c87"
}
