Hello everyone, new user here. I’m liking the site so far, specially the technology communities.

One thing I noticed that there are far too many communities for a significantly low user base website. There are 1075 Communities as the right sidebar shows. I feel most of them are created to park community names only not for purpose of any discussion. IMO is not good to have so many communities at very early stage, restricting community creation till the userbase of the site has achieved an arbitrary number big enough to sustain such large number of communities is better.

  • DessalinesA
    10•4 years ago

    I can also pretty easily query to get a list of abandoned communities for removal.

    • @blaha
      7•4 years ago

      Consider starting with communities that have inactive admins first. Someone looking to “create” a community at an abandoned name might do better to start contributing to it if the existing admin is simply waiting for people to talk to.

      • DessalinesA
        6•4 years ago

        I didn’t do that yet, but I just did some analysis of posts and communities, its not good. Out of 1079 communities

        count no activity within the last
        589 1 week
        451 1 month
        229 2 months
        136 3 months

        I’d say at the very least 2 months of inactivity means ded.

        My query just to save it:

        select count(*) from (
  select c.name, a.* from (
    select max(published) as recent, community_id from post p group by community_id
  ) a
  inner join community c on c.id = a.community_id
  where recent < now() - interval '4 week'
) b;
        • @blaha
          3•4 years ago

          My point is only that a new name-sitter isn’t really an improvement on the previous name-sitter if both are similarly active on Lemmy.