if you are gonna use SQL, why would you only implement nip-01 filters and not add full text searching?
and it's very easy to add full text indexing with SQL databases, to make it even more fancy
the point of simple filter queries is to make the relays lighter and faster
but i get why there's some value in more than that... full text search would be realllly useful, as would being able to create arbitrary queries like "has a OR b AND c" which you can't do with filters either, or even "a OR b OR c AND NOT d" such as "don't send me events from asshats on my mute list without me having to rewrite the relay to do that"
that's partly why that is already a standard feature on #realy - it doesn't send you messages from people you mute, ever.
mleku
npub1fj…mleku
2025-01-04 18:23:18
in reply to nevent1q…8ec0
Author Public Key
npub1fjqqy4a93z5zsjwsfxqhc2764kvykfdyttvldkkkdera8dr78vhsmmlekuPublished at
2025-01-04 18:23:18Event JSON
{
"id": "8a2428a57f82e4e507a0007eb163660df7cc4564578e26d3733a65f1c92eacd9",
"pubkey": "4c800257a588a82849d049817c2bdaad984b25a45ad9f6dad66e47d3b47e3b2f",
"created_at": 1736014998,
"kind": 1,
"tags": [
[
"e",
"de725bf343d7faa6d15d537766a600c24c71140a2844384e0f6e2f64ba41210c",
"",
"root"
],
[
"e",
"6b4281af75e487bf2c5a03bfccc46facea49f06d8ff8d67237308ca4f577a1ab",
"wss://mleku.realy.lol/",
"reply",
"fd208ee8c8f283780a9552896e4823cc9dc6bfd442063889577106940fd927c1"
],
[
"p",
"4eb88310d6b4ed95c6d66a395b3d3cf559b85faec8f7691dafd405a92e055d6d"
],
[
"p",
"df57b4986a2c659965c3df95ca3fea3533a207b09bf2c55a70d406c7d049124f"
],
[
"p",
"fd208ee8c8f283780a9552896e4823cc9dc6bfd442063889577106940fd927c1"
],
[
"p",
"036533caa872376946d4e4fdea4c1a0441eda38ca2d9d9417bb36006cbaabf58"
],
[
"p",
"4c800257a588a82849d049817c2bdaad984b25a45ad9f6dad66e47d3b47e3b2f"
],
[
"t",
"realy"
],
[
"client",
"noStrudel",
"31990:266815e0c9210dfa324c6cba3573b14bee49da4209a9456f9484e5106cd408a5:1686066542546"
]
],
"content": "if you are gonna use SQL, why would you only implement nip-01 filters and not add full text searching?\n\nand it's very easy to add full text indexing with SQL databases, to make it even more fancy\n\nthe point of simple filter queries is to make the relays lighter and faster\n\nbut i get why there's some value in more than that... full text search would be realllly useful, as would being able to create arbitrary queries like \"has a OR b AND c\" which you can't do with filters either, or even \"a OR b OR c AND NOT d\" such as \"don't send me events from asshats on my mute list without me having to rewrite the relay to do that\"\n\nthat's partly why that is already a standard feature on #realy - it doesn't send you messages from people you mute, ever.",
"sig": "1eeb5188a1bc216a6f36f65b93b05fbc25057c72845ef5d339a34a42d77ead7f2b345246a991796bd7da193afef4af17749228749c38ac5553489b7d508df644"
}