brugeman on Nostr: Sql works with indexes, without them it won't help. To add proper index you add ...
Sql works with indexes, without them it won't help. To add proper index you add single letter tag. If you want joins then all you are asking is for relay to bear the weight for you. Just denormalize your data, add a tag, and make life easy for both sides
Published at
2024-10-11 16:11:03Event JSON
{
"id": "2ae20aa1bd22c961b25b0839ca24fc0acf7df29acfb2b7611394b2166816e702",
"pubkey": "3356de61b39647931ce8b2140b2bab837e0810c0ef515bbe92de0248040b8bdd",
"created_at": 1728663063,
"kind": 1,
"tags": [
[
"e",
"9cd9af51437d921450f0edb0e7b9485f90823f4c7665f48ff6a93ef950462dd5",
"",
"root"
],
[
"e",
"418ad2d3df27249a16b6428f9112c3c396acd8c26b02d4565f5b1494bb365948"
],
[
"e",
"b522d2df77854d86e7af93bc87d96d1bff22557dabab423887db5532324e407b",
"",
"reply"
],
[
"p",
"460c25e682fda7832b52d1f22d3d22b3176d972f60dcdc3212ed8c92ef85065c"
],
[
"p",
"a9434ee165ed01b286becfc2771ef1705d3537d051b387288898cc00d5c885be"
],
[
"p",
"726a1e261cc6474674e8285e3951b3bb139be9a773d1acf49dc868db861a1c11"
]
],
"content": "Sql works with indexes, without them it won't help. To add proper index you add single letter tag. If you want joins then all you are asking is for relay to bear the weight for you. Just denormalize your data, add a tag, and make life easy for both sides ",
"sig": "b51eab34bcf91d8ed09a369bdf5f331ba0c6aa21e883b92fccc5af44891c4d9c519919687f4b9fa354e2c41958eb87c5cc670ed14361ed04e4d040126462908a"
}