/0

As I had said a while ago, I'm doing some light inactive community pruning on the regular.

This time I looked for communities with 0 posts and low effort (i.e. no description, banners etc). I didn't bother to send a warning because that just adds extra effort for me. If you can't put any effort when starting a community, I can't be expected to put any effort when deleting it for abandonment, eh?

In case anyone else is interested, here's the SQL query I used to detect abandoned communities.

SELECT c.id, c.name, c.local, c.published
FROM public.community AS c
LEFT JOIN (
   SELECT community_id, COUNT(*) AS post_count
   FROM public.post
   GROUP BY community_id
) AS p ON c.id = p.community_id
WHERE c.local = true

If they don't have any post, description and banner after 10 days, then I consider them low-effort and purge them immediately.

For the communities I've seen at least a bit of effort, I plan to still send warnings first.

About 20 communities were pruned this time (including 3 of mine :D )