uh does anyone know how to delete a broken toot from the postgres database

Follow

okay, for posterity: delete from statuses where account_id = <id> and <condition>;

· · Web · 1 · 0 · 1

also wow it's scary to do surgery on the live database

@noiob transactions and "select count(*) where" is your friend, but it never really stops being nervewracking

@noiob gosh yeah. even with backups!

i always hesitate before doing it, even if that was preceded by all the selects i needed to be totally sure that i'm doing the right thing

Sign in to participate in the conversation
Awoo Space

Awoo.space is a Mastodon instance where members can rely on a team of moderators to help resolve conflict, and limits federation with other instances using a specific access list to minimize abuse.

While mature content is allowed here, we strongly believe in being able to choose to engage with content on your own terms, so please make sure to put mature and potentially sensitive content behind the CW feature with enough description that people know what it's about.

Before signing up, please read our community guidelines. While it's a very broad swath of topics it covers, please do your best! We believe that as long as you're putting forth genuine effort to limit harm you might cause – even if you haven't read the document – you'll be okay!