laanwj on Nostr: fwiw, after deleting all kind 5 events in `SELECT event_id FROM tag WHERE name="L" ...
fwiw, after deleting all kind 5 events in `SELECT event_id FROM tag WHERE name="L" and value="pink.momostr"`, there are 72 left and it's wayy down the list
now i need a way to block these before they're even inserted 🙂
Published at
2024-09-29 08:00:55Event JSON
{
"id": "5144e7c13b78289ef52e219d4efec87cfbd2871198f6c655ba93fa2e6404adc6",
"pubkey": "0aa39e5aef99a000a7bdb0b499158c92bc4aa20fb65931a52d055b5eb6dff738",
"created_at": 1727596855,
"kind": 1,
"tags": [
[
"e",
"000071828875c7d34d468fd08ef6662ecba027f4adabc8ab6f20eb6b9c61d9d8",
"wss://relay.damus.io/",
"root"
],
[
"e",
"f5ae87e5267de48762032b65947802a92363ed6f642bb73b848ba041ae9411c4",
"",
"reply"
],
[
"p",
"e0cfb5549d3cf7db4e2736f8e1bc84f62486af7a41295d867c6a313459042528",
"",
"mention"
],
[
"p",
"e4336cd525df79fa4d3af364fd9600d4b10dce4215aa4c33ed77ea0842344b10",
"",
"mention"
],
[
"client",
"noStrudel",
"31990:266815e0c9210dfa324c6cba3573b14bee49da4209a9456f9484e5106cd408a5:1686066542546"
]
],
"content": "fwiw, after deleting all kind 5 events in `SELECT event_id FROM tag WHERE name=\"L\" and value=\"pink.momostr\"`, there are 72 left and it's wayy down the list\n\nnow i need a way to block these before they're even inserted 🙂 ",
"sig": "0ff25bd678cfb94a8b52d634616d9d12462c58fc06b0b98a34495bfb7bca1efd2bf84e68122a7f05fc369e5c412aa9a5bd3a9969cb34c2b5bc1fc72a3edffdf0"
}