SilberWitch on Nostr: SQL is better for detailed queries, obviously, but most people filter the same things ...
SQL is better for detailed queries, obviously, but most people filter the same things over and over. I.e. "give me the next ten items from my favorite relays". There's been a move to make the filtering more advanced, but this seems like overloaded the scope of the relays with a wannabe RDB. Pull it into an RDB, in parallel, so that it can be queried, as-needed, but don't try to RDB-style everything.
Published at
2025-01-02 21:06:11Event JSON
{
"id": "2dd9c40d0585747cd964dde5245d3a69ac15f44dcf6f4fc47450072f31134fab",
"pubkey": "fd208ee8c8f283780a9552896e4823cc9dc6bfd442063889577106940fd927c1",
"created_at": 1735851971,
"kind": 1,
"tags": [
[
"e",
"b12daf71924f31d6ae7263bbdab39b6cd762f93f202d4f22e4a0e992fe8a40c5",
"wss://bostr.bitcointxoko.com/",
"root"
],
[
"e",
"eca0eea22aff2d7e647dd291577ecf93b21472e24eb98a7a920c965015a721e2",
"wss://nostrelites.org/",
"reply",
"036533caa872376946d4e4fdea4c1a0441eda38ca2d9d9417bb36006cbaabf58"
],
[
"p",
"fd208ee8c8f283780a9552896e4823cc9dc6bfd442063889577106940fd927c1",
"wss://theforest.nostr1.com/"
],
[
"p",
"036533caa872376946d4e4fdea4c1a0441eda38ca2d9d9417bb36006cbaabf58"
]
],
"content": "SQL is better for detailed queries, obviously, but most people filter the same things over and over. I.e. \"give me the next ten items from my favorite relays\". There's been a move to make the filtering more advanced, but this seems like overloaded the scope of the relays with a wannabe RDB. Pull it into an RDB, in parallel, so that it can be queried, as-needed, but don't try to RDB-style everything.",
"sig": "ce4ecdc0c33adb2f27a0ed3b5f5bffd6bf8e5c353d89335c3a1af349ea7dc6126cc9b1af886626a5b69e7383fd1a97a233ced18e3adfa1f04d7b94214a9b569d"
}
