Yeah, unless you want to query a large dataset.
Discussion
like an event database? using standard nip-01 filters?
that's like using a $10000 CNC machine to sharpen a knife
Vector embeddings.
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.
I didn't say we aren't going to do more advanced stuff with it.
there is even all these nice vector node points aka "event ID" to use as well
i'd probably spend more time on playing with that if i had more time to spend on playing with things
i already use dgraph's badger, swapping that out to use straight up dgraph would be awesome and easy to do, create a bunch of nodes based on the least common words in posts and link them all up and then throw some zippo fluid on it and flick several matches concurrently
Have you tried out the Alexandria visualization, from nostr:nprofile1qqsdcnxssmxheed3sv4d7n7azggj3xyq6tr799dukrngfsq6emnhcpspz9mhxue69uhkummnw3ezuamfdejj7qgmwaehxw309a6xsetxdaex2um59ehx7um5wgcjucm0d5hsz9nhwden5te0dp5hxapwdehhxarj9ekxzmny9u78m52f?
i muted him ages ago, unmuting now, where?
It'll go nuts and process like crazy, for a minute, but if you wait a minute, it'll show you a graphical view of the publications on thecitadel relay. He needs to fix the zoom, so that it starts zoomed in, and the user has to zoom out, but it's just a PoC.
(I know, our site certificate is expired.)
does it ever stop rearranging it? it's doing a tension optimization right?
just seems to keep on animating even though the state should be steady at some point?
Well, it's never completely static. It reacts when mouse-over and stuff, but it should zoom way in and cool down, eventually.
yeah, obviously it's not right because it didn't stop and my machine isn't a slouch, switch tabs and come back to it a minute later it's still jiggling around, i can't even tell what it's doing, but i think there's basically too many objects in the visualisation and it just would take hours to finally reach a relatively stable state, otherwise it just looks like spaghetti