franzap on Nostr: That's a great question, I am not sure. Maybe there are other ways of doing it ...
That's a great question, I am not sure. Maybe there are other ways of doing it without joins. Anything in that direction would help, queries on nostr are very primitive - so clients implement workarounds that are wasteful anyway, like data duplication and lots of extra queries that add processing and bandwidth
Published at
2024-07-19 17:09:33Event JSON
{
"id": "fb0630c42558c7a36d22f17c9461ce77877edd9a417731847431a6d857cedfa7",
"pubkey": "726a1e261cc6474674e8285e3951b3bb139be9a773d1acf49dc868db861a1c11",
"created_at": 1721408973,
"kind": 1,
"tags": [
[
"e",
"7fb969fbf61e277337428912dd3dd4684a61c7ae04f91439f225ee8b00e9a880",
"wss://relay.nostr.net/",
"root"
],
[
"e",
"f77f525fa941eeaf770d319c75389363c59671c5eee53f648a5052a9413a003e",
"wss://relay.nostr.net/",
"reply"
],
[
"p",
"00000000827ffaa94bfea288c3dfce4422c794fbb96625b6b31e9049f729d700",
"",
"mention"
],
[
"p",
"f821179bd5d691c61b4356336388adadc3cc1304f49e771a87c38de7ed4fd022",
"",
"mention"
]
],
"content": "That's a great question, I am not sure. Maybe there are other ways of doing it without joins. Anything in that direction would help, queries on nostr are very primitive - so clients implement workarounds that are wasteful anyway, like data duplication and lots of extra queries that add processing and bandwidth",
"sig": "6001e569aa55cd7119177e17286834b84c401b1ffcf7b3049b3ec962b65745be59f8b2ff9f7340303f7da766d34a15209621e29a6ddcd9208f35770bad36476f"
}