I haven’t looked at relay implementations in a while. I assume you know about awesome-nostr repo tracking all the projects? that’s my go to for what others are doing.

Yeah I think it’s perfect for that!

The cypher queries for those should be pretty straightforward. I’m currently working on scaling my deployment of a neo4j db and making it more performant. Open to trading notes if you start using neo4j!