That's cool! I built something too, will share soon. It will be cool to compare the approaches.
Right now my problem is getting historical data. I managed to build a good enough event listener, but i...
Ok, interesting. I never thought about using SQL to query nostr events. Please share your queries :)
One thing about nostralink is that if there's some JSON in the content field of a nostr event, it unpacks the JSON, and that information is then serialized to RDF and into the events store, so you can then query it natively with SparQL. I even wrote a nostr client that uses nostralink: https://pazstr.codeberg.page/
One thing about nostralink is that if there's some JSON in the content field of a nostr event, it unpacks the JSON, and that information is then serialized to RDF and into the events store, so you can then query it natively with SparQL. I even wrote a nostr client that uses nostralink: https://pazstr.codeberg.page/