Finished the manual moderation tools I mentioned yesterday, and I'm pretty happy with the result.
I tested it out on a queue of about 160 posts from the last 24 hours, and it went smoothly, once I switched from my original design (quick form submissions and a
JOIN with the main
posts table — bad idea, it's too big) to async requests and denormalized data.
I'm thinking about what this would look like in #WriteFreely, and I'm not yet sure if exposing all of our spam detection logic will make it easier for spammers to work around our roadblocks. I don't know if they put that much effort into it. But I know instance admins would be very welcoming to a feature like this. So I'm thinking of bringing it over soon.