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
    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.