Seems the growth shows no sign of slowing

data here

  • @pleasemakesense
    link
    English
    131 year ago

    Unfortunately these are most bots, which you can see from the active user ratio

    • @danc4498
      link
      English
      121 year ago

      What does “active” mean? Are lurkers considered active? Or do you have to vote/comment/post to be considered active?

      • @ptah
        link
        English
        21 year ago

        Looking through the code on GitHub it looks like active is the number of new posts plus the number of new comments in a certain time period (in this case 6 months).

        Caveat: I’m just a hobbyist so my reading of the code may not be exactly correct.

        create or replace function site_aggregates_activity(i text)
        returns int
        language plpgsql
        as
        $$
        declare
           count_ integer;
        begin
          select count(*) 
          into count_
          from (
            select c.creator_id from comment c
            inner join user_ u on c.creator_id = u.id
            where c.published > ('now'::timestamp - i::interval) 
            and u.local = true
            union
            select p.creator_id from post p
            inner join user_ u on p.creator_id = u.id
            where p.published > ('now'::timestamp - i::interval)
            and u.local = true
          ) a;
          return count_;
        end;
        $$;
        
        update site_aggregates 
        set users_active_day = (select * from site_aggregates_activity('1 day'));
        
        update site_aggregates 
        set users_active_week = (select * from site_aggregates_activity('1 week'));
        
        update site_aggregates 
        set users_active_month = (select * from site_aggregates_activity('1 month'));
        
        update site_aggregates 
        set users_active_half_year = (select * from site_aggregates_activity('6 months'));
        
        
    • PhilOP
      link
      English
      1
      edit-2
      1 year ago

      Not sure you can infer that from this chart as I believe it counts active users and contributors so lurkers won’t show up, of course will will have a lot of people checking us out. Not that bots won’t be an issue in the future they will.