#NIP-56 on #grafana : I currently find many limitations to monitor the NIP-56 content : - The tag data store structure in the event table is cumbersome to manipulate and the tag table does not provide the NIP-56 tags itself. - There are different types of report with different data structures to handle with CASE WHEN instructions in query. - The events tags can be declared in any order making it difficult with SQLite to filter out the Json content. - Grafana does not provide hex to bech32 transformations Those limitations lead me for now to a probably too complex query with small readibility :

Gist

gist:0b89b834e0aba30a54c61927425b8f25

GitHub Gist: instantly share code, notes, and snippets.

It provides, however, a tool for reporting and moderation, and a base to build other metrics around NIP-56 tags and 1984 event kind.

Btw, I'll also update the dashboard gist I shared the other day, as I fine-tuned some other metrics widgets

Ok, first draft of a grafana widget to have an overview of the NIP-56 events almost ready. I will share it in the next 24h, but there's plenty of things to say about it as i had to dig quite a bit to get the relevant information. #monitoring #relay #nostr

Don't forget, there is no china, only West Taïwan

I'll try to check if I can add a visualisation to the dashboard listing the report events in order to help identifying the spam/scam content. This would be helpful to create banlist on the relay side