🔔 This profile hasn't been claimed yet. If this is your Nostr profile, you can claim it.
Edit
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/
Some time ago i wrote a Rust crate to run SparQL queries on a nostr events store. https://crates.io/crates/nostralink Makes it possible to build pretty powerful queries: https://codeberg.org/nostralink/nostralink/src/branch/master/sparql/content_union.rq https://codeberg.org/nostralink/nostralink/src/branch/master/sparql/feed_followees_metadata.rq
https://npub1r3cnzta52fee26c83cnes8wvzkch3kud2kll67k402x04mttt26q0wfx0c.nsite.lol/ Having fun writing nostr projects. xonos (3d nostr client): https://xonos.codeberg.page disastr (nostr game SDK): https://codeberg.org/disastr/disastr pongstr (multiplayer pong game): https://pongstr.codeberg.page voistr (nostr p2p softphone): https://voistr.codeberg.page paz (semantic nostr client that uses an RDF events store): https://pazstr.codeberg.page nostralink (Linked Data for Nostr): https://nostralink.codeberg.page caracal (Nostr client for Gemini): https://gitlab.com/cipres/caracal ssnrelay (relay with pkdns): https://gitlab.com/cipres/ssnrelay
