I need to find latest releases for apps given a set of app ids and this query is complex. Syncing hundreds of thousands of releases to a local relay is not viable.
We are going to end up with more custom query languages and ad-hoc external services just because we're stubborn to address the query language issue. I'm not saying massive processing like WoT - but stuff that is trivial for SQLite to handle
franzap
npub1wf…3dgh9
2024-10-11 15:32:18
in reply to nevent1q…m494
Author Public Key
npub1wf4pufsucer5va8g9p0rj5dnhvfeh6d8w0g6eayaep5dhps6rsgs43dgh9Published at
2024-10-11 15:32:18Event JSON
{
"id": "b522d2df77854d86e7af93bc87d96d1bff22557dabab423887db5532324e407b",
"pubkey": "726a1e261cc6474674e8285e3951b3bb139be9a773d1acf49dc868db861a1c11",
"created_at": 1728660738,
"kind": 1,
"tags": [
[
"e",
"9cd9af51437d921450f0edb0e7b9485f90823f4c7665f48ff6a93ef950462dd5",
"",
"root"
],
[
"e",
"418ad2d3df27249a16b6428f9112c3c396acd8c26b02d4565f5b1494bb365948",
"",
"reply"
],
[
"p",
"460c25e682fda7832b52d1f22d3d22b3176d972f60dcdc3212ed8c92ef85065c",
"",
"mention"
],
[
"p",
"a9434ee165ed01b286becfc2771ef1705d3537d051b387288898cc00d5c885be",
"",
"mention"
]
],
"content": "I need to find latest releases for apps given a set of app ids and this query is complex. Syncing hundreds of thousands of releases to a local relay is not viable.\n\nWe are going to end up with more custom query languages and ad-hoc external services just because we're stubborn to address the query language issue. I'm not saying massive processing like WoT - but stuff that is trivial for SQLite to handle",
"sig": "d5bd41cf43b9e2636dc21d8d4c9cafd35c4a417f83260700bdcfb43f2bfd7e9169fa749cf543f6b4661698a39192e70fe2a3bf32ebc4c232a3d3e6160d5c4e82"
}