Lemmy growth curve

The total number of active users in the last month would be a much more accurate statistic. The number of users does not give the correct result due to bot accounts.

The chart here shows 37,000 active users for Lemmy, and this chart here shows 45,000 active users for Kbin.

And if the recent trend continues then those numbers should grow.
- What actually is kbin? Is it just Lemmy with a different user interface? Does it have multiple instances like Lemmy?
- Actually lemmy has over half a million total users and Kbin stands at about 50,000 the 37,000 number is just the lemmy.world users
Here is the active users last month curve

It is not just active users , we have gone from under 100 nodes (instances) to over 300 in June alone , I really love the distributed network idea, I could see large sub from reddit running there own instance where they really have control of the destiny of there community.
- Like https://startrek.website/

Lemmy is where it's at. I'm noticing an insane jump in quality. It feels like everyone on reddit wants to be a comedian or repeat the same thing 1000 times just to show they fit in.

I've checked Reddit a few times the past few days and I've started to notice how many comments are the same inside jokes over and over again. The hive mind really looks different when you're on the outside.
- I bet many of those are just reposting bots.
It's so nice not seeing the same jokes over and over again here.

Expect a crazy peak around July 1st, that's when reddit apps will shutdown, after that things should settle I think.

Yeah and it's only nine (ten) days left.
I imagine there will still be a higher than normal amount of growth, but not as steep, through the rest of the summer as other people give up on Reddit after the changes. Some casual users may not understand what's going on, but they'll notice the changes through July and August without all the 3rd party people and the mods who leave/have left/got removed, which may drive them to alternatives.
I hope the new version of Lemmy is released before then so the home page gets fixed.

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

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

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'));

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.

I understand a large part of it is an influx of spam bots on unsecured instances so don't get too excited quite yet.

But we can get excited that lemmy.world is the largest non-bot instance with 37k users.
I have not seen a great deal of evidence of spam bots yet myself
- Me neither, very glad our various admins are on top of it all. There's an interesting update on the situation from the admin of lemm.ee here https://lemmy.world/post/378640

It's just like 14 people not understanding the software and creating accounts on every instance

I feel personally attacked.
- Me too....
That's fucking funny lmao
Not really multiple accounts on lemmy but one one lemmy.world and another on kbin. Then came across lemm.ee which had some sorting bug fixed and liked the name so… yeah 2 lemmy accounts and one kbin.
- Exactly what I've done as well. Probably not necessary, but a part of my learning curve.
lol
Raising my hand.
That's me at the beginning. I was confused and it seemed to not work. But now I got it :D
loool... but yeah