this post was submitted on 21 Jun 2023
104 points (99.1% liked)

General Discussion

12038 readers
261 users here now

Welcome to Lemmy.World General!

This is a community for general discussion where you can get your bearings in the fediverse. Discuss topics & ask questions that don't seem to fit in any other community, or don't have an active community yet.


🪆 About Lemmy World


🧭 Finding CommunitiesFeel free to ask here or over in: [email protected]!

Also keep an eye on:

For more involved tools to find communities to join: check out Lemmyverse!


💬 Additional Discussion Focused Communities:


Rules

Remember, Lemmy World rules also apply here.0. See: Rules for Users.

  1. No bigotry: including racism, sexism, homophobia, transphobia, or xenophobia.
  2. Be respectful. Everyone should feel welcome here.
  3. Be thoughtful and helpful: even with ‘silly’ questions. The world won’t be made better by dismissive comments to others on Lemmy.
  4. Link posts should include some context/opinion in the body text when the title is unaltered, or be titled to encourage discussion.
  5. Posts concerning other instances' activity/decisions are better suited to [email protected] or [email protected] communities.
  6. No Ads/Spamming.
  7. No NSFW content.

founded 1 year ago
MODERATORS
104
Lemmy growth curve (self.general)
submitted 1 year ago* (last edited 1 year ago) by phil299 to c/general
 

Seems the growth shows no sign of slowing

data here

you are viewing a single comment's thread
view the rest of the comments
[–] pleasemakesense 13 points 1 year ago (2 children)

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

[–] danc4498 12 points 1 year ago (1 children)

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

[–] ptah 2 points 1 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'));

[–] phil299 1 points 1 year ago* (last edited 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.