Awiteb on Nostr: `momostr.pink` just nuked my relay with 75,942 deletion request. I used this SQL to ...
`momostr.pink` just nuked my relay with 75,942 deletion request.
I used this SQL to count them
```
SELECT COUNT(*)
FROM event
WHERE content LIKE '%pink.momostr%'
AND kind = 5;
```
And this to delete them
```
DELETE FROM event
WHERE content LIKE '%pink.momostr%'
AND kind = 5;
```
Published at
2025-05-05 05:07:27Event JSON
{
"id": "000001c41e64571bc1710aea9c5467a57193a30bf1d5633384502b47dab95449",
"pubkey": "00000001505e7e48927046e9bbaa728b1f3b511227e2200c578d6e6bb0c77eb9",
"created_at": 1746421647,
"kind": 1,
"tags": [
[
"nonce",
"542303",
"23"
]
],
"content": "`momostr.pink` just nuked my relay with 75,942 deletion request.\n\nI used this SQL to count them\n```\nSELECT COUNT(*) \nFROM event \nWHERE content LIKE '%pink.momostr%'\n AND kind = 5;\n```\nAnd this to delete them\n```\nDELETE FROM event\nWHERE content LIKE '%pink.momostr%'\n AND kind = 5;\n```",
"sig": "d3295e21a8b26ff04038ef45f04348a321202b938b7940437aff0195b1700778ffd36a10718cfa0ef8a45e0f2e1654ce6cb51b69188e853536c11725c008cd7f"
}