goldfish on Nostr: also learned the hard way: don't accidentally add 50,000 entries to your production ...
also learned the hard way: don't accidentally add 50,000 entries to your production db while attempting to benchmark your system.
luckily I was able to delete them all with one command, but didn't notice until the next day.
lesson learned the hard way: don't put non-ASCII characters in a SQL_ASCII encoded postgres db
Published at
2026-06-15 23:21:23 UTCEvent JSON
{
"id": "50943f8a7132c2eabb051ef589eefa5a970a19e976d97482e1777939a293a1a8",
"pubkey": "fa7acc02e78076f61c1baad84b519724a2aebb39b82b67c58f9b28edf98b0e0b",
"created_at": 1781565683,
"kind": 1,
"tags": [
[
"q",
"ff56a7e7d0bed001ada316d1068620dcd6832302a3c892745b29cf17c1d5803f",
"wss://relay.ditto.pub"
],
[
"proxy",
"https://mastodon.bsd.cafe/ap/users/115858790418838587/statuses/116756688664673267",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.ditto.pub"
]
],
"content": "\n\nalso learned the hard way: don't accidentally add 50,000 entries to your production db while attempting to benchmark your system.\nluckily I was able to delete them all with one command, but didn't notice until the next day.\n\nnostr:nevent1qy2hwumn8ghj7un9d3shjtnyd968gmewwp6kyqpqlat20e7shmgqrtdrzmgsdp3qmntgxgcz50yfyazm98830sw4sqls0nkf67",
"sig": "ff166275974c38529f32b921848d959cff96f20346b1b96023f4394be62fbf6ea461cb866d5a4c9583a9fba400bf716ff3ee58fec4de2a565ecdae5914686a8b"
}