What kind of complex queries do you want? What kind of complex queries are out there in the wild right now?
IMO this is a large ask and complexity can become out of hand very quickly and all of a sudden implementing a relay includes and implementing an entire query language. Everyone is saying "let's use SQL". Which flavour of SQL? And then relays are locked into using only SQL databases of that flavour or writing some translation layer that can be riddled with bugs and security issues.
The simple query language lowers the attack surface and makes it easier and more flexible for relay operators. That doesn't mean we can't add complexity to the existing query language but let's be very careful here.
RebelOfBabylon
npub16p…z7gjy
2024-10-11 18:04:36
in reply to nevent1q…s88e
Author Public Key
npub16phxqxxplnmasr20rzh8afnflgg0ssufl90k6x7ua2tj0jexdseszz7gjySeen on
wss://relay.damus.ioPublished at
2024-10-11 18:04:36Event JSON
{
"id": "544d608ded430783caf02ac581c9172a2c5542ff2d1460728d2ea7aa85263b3c",
"pubkey": "d06e6018c1fcf7d80d4f18ae7ea669fa10f84389f95f6d1bdcea9727cb266c33",
"created_at": 1728669876,
"kind": 1,
"tags": [
[
"e",
"b73c19c266c76e9875d10775f36c5a70581d8694d902809fd506527f45f908f0",
"",
"root"
],
[
"p",
"726a1e261cc6474674e8285e3951b3bb139be9a773d1acf49dc868db861a1c11"
]
],
"content": "What kind of complex queries do you want? What kind of complex queries are out there in the wild right now?\n\nIMO this is a large ask and complexity can become out of hand very quickly and all of a sudden implementing a relay includes and implementing an entire query language. Everyone is saying \"let's use SQL\". Which flavour of SQL? And then relays are locked into using only SQL databases of that flavour or writing some translation layer that can be riddled with bugs and security issues. \n\nThe simple query language lowers the attack surface and makes it easier and more flexible for relay operators. That doesn't mean we can't add complexity to the existing query language but let's be very careful here.",
"sig": "8a4e89557c83fffa6773f4ae0a9b66b6eea3b9500dd82fc213eb428bed0938bb8361e839265852e315fac9bad2d1be128600434768b29431c4b4a3059e26aa6c"
}