#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 :

https://gist.github.com/Asone/0b89b834e0aba30a54c61927425b8f25

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

Reply to this note

Please Login to reply.

Discussion

I am wondering though if it wouldn't be easier to provide monitoring for that kind of the reported content on #relays with postures.

Also I'd like to check how to extract raw logs for monitoring.

#nostr #relay #monitoring

nostr:nevent1qqs9u4sy5swqq4zapevxzx8eyf9275jhqk7p2f3fzjw6xphajl70z6gpzpmhxue69uhkummnw3ezumt0d5hsygr6ttu7qxcnwsyw0jedshae6hvrj55h4svl4unxq6dc90pqk9tgtypsgqqqqqqsjssqq7

Keep up with the documentation progress, but make it more documentary for future generals.