I think the main points that melvincarvalho (nprofile…ml2f) somewhat missed is that there is no SQL for Nostr relays and there is, currently, no easy replication scheme to support load balancing, especially for geo-distributed semi-mirrored servers.
Relays ARE databases in the sense they store stuff, but if you need advanced querying capability OR if your events are too big (binary or text) or has too many tags (too many indexes), the relay operator might not be able to support it and might either reject it or become super slow.
The lack of a query language is a limit we are forcing on ourselves. The rest is pretty much solvable with the usual enterprise stack without changing the protocol.
Vitor Pamplona
npub1gc…fnj5z
2024-10-11 14:40:22
in reply to nevent1q…tw20
Author Public Key
npub1gcxzte5zlkncx26j68ez60fzkvtkm9e0vrwdcvsjakxf9mu9qewqlfnj5zPublished at
2024-10-11 14:40:22Event JSON
{
"id": "b1dc39255293bbe078d018b27cf4396861cf552b8475821df2fae7963541f6ba",
"pubkey": "460c25e682fda7832b52d1f22d3d22b3176d972f60dcdc3212ed8c92ef85065c",
"created_at": 1728657622,
"kind": 1,
"tags": [
[
"e",
"9cd9af51437d921450f0edb0e7b9485f90823f4c7665f48ff6a93ef950462dd5",
"",
"root"
],
[
"e",
"efe85c484eb4b587940ed59aa359d0c997d95a44cd1eaa326dccacb265efd963"
],
[
"e",
"a675ef51678c8696382770e26cefe1b5c08e7f8ad3aa4376df190945079da558",
"",
"reply"
],
[
"p",
"726a1e261cc6474674e8285e3951b3bb139be9a773d1acf49dc868db861a1c11"
],
[
"p",
"de7ecd1e2976a6adb2ffa5f4db81a7d812c8bb6698aa00dcf1e76adb55efd645",
"",
"mention"
],
[
"p",
"460c25e682fda7832b52d1f22d3d22b3176d972f60dcdc3212ed8c92ef85065c"
],
[
"p",
"a9434ee165ed01b286becfc2771ef1705d3537d051b387288898cc00d5c885be"
]
],
"content": "I think the main points that nostr:nprofile1qqsdulkdrc5hdf4dktl6taxmsxnasykghdnf32sqmnc7w6km2hhav3gppemhxue69uhkummn9ekx7mp0qywhwumn8ghj7mn0wd68ytfsxyhxymmvwshx7cnnv4e8vetj9uq3uamnwvaz7tmwdaehgu3dwp6kytnhv4kxcmmjv3jhytnwv46z7qmml2f somewhat missed is that there is no SQL for Nostr relays and there is, currently, no easy replication scheme to support load balancing, especially for geo-distributed semi-mirrored servers. \n\nRelays ARE databases in the sense they store stuff, but if you need advanced querying capability OR if your events are too big (binary or text) or has too many tags (too many indexes), the relay operator might not be able to support it and might either reject it or become super slow.\n\nThe lack of a query language is a limit we are forcing on ourselves. The rest is pretty much solvable with the usual enterprise stack without changing the protocol.",
"sig": "a7dbe6d93d962b4b090cd0a69c6b3129a81e8c16cb9cec8a45e682eee354d4448886f4d774e9318b56c8248bdde031254469118c119d935790629cf12e85f65f"
}