asone on Nostr: #NIP-56 on #grafana : I currently find many limitations to monitor the NIP-56 content ...
#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/0b89b834e0aba30a54c61927425b8f25It provides, however, a tool for reporting and moderation, and a base to build other metrics around NIP-56 tags and 1984 event kind.
Published at
2023-10-07 23:37:57Event JSON
{
"id": "5e5604a41c00545d0e586118f9224aaf525705bc152629149da306fd97fcf169",
"pubkey": "7a5af9e01b137408e7cb2d85fb9d5d8395297ac19faf266069b82bc20b156859",
"created_at": 1696714677,
"kind": 1,
"tags": [
[
"t",
"NIP-56"
],
[
"t",
"grafana"
]
],
"content": "#NIP-56 on #grafana : \n\nhttps://m.primal.net/HMwW.png\nhttps://m.primal.net/HMwZ.png\n\n\nI currently find many limitations to monitor the NIP-56 content : \n\n- 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.\n\n- There are different types of report with different data structures to handle \n with CASE WHEN instructions in query.\n\n- The events tags can be declared in any order making it difficult with SQLite to filter out the Json content. \n\n- Grafana does not provide hex to bech32 transformations\n\nThose limitations lead me for now to a probably too complex query with small readibility : \n\nhttps://gist.github.com/Asone/0b89b834e0aba30a54c61927425b8f25\n\nIt provides, however, a tool for reporting and moderation, and a base to build other metrics around NIP-56 tags and 1984 event kind.",
"sig": "3c6e891eee809ff080735d41ee7b03c65d8b14366b3e59a2dec98a0f7dcadf2eed4c28f0ae28c4257b11f66ebbb48f37eea02008b6eb4ad9e754b69a2af9c884"
}
