this post was submitted on 01 Jul 2023
35 points (100.0% liked)

Meta

55 readers
18 users here now

Discussion about the aussie.zone instance itself

founded 1 year ago
MODERATORS
 

Graphs in the post body

Edit: Source https://the-federation.info/node/details/50624

top 8 comments
sorted by: hot top controversial new old
[–] [email protected] 4 points 1 year ago (3 children)

Out of interest, do we have stats on daily active users? (Preferably where "active" is defined by "makes at least one comment or post".)

[–] [email protected] 3 points 1 year ago

I couldn't find anything. I'm sure it is in the code here somewhere but can't find it in there either. https://codeberg.org/thefederationinfo/the-federation.info

[–] [email protected] 3 points 1 year ago

Found it. It is the function "site_aggregates_activity" which essentially says if you have published a comment or a post since the target time (day, month, 6 month etc) you are considered active. Here is the code

select c.creator_id from comment c inner join person 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 person u on p.creator_id = u.id where p.published > ('now'::timestamp - i::interval) and u.local = true

[–] [email protected] 2 points 1 year ago

Looks like the data actually is calculated by lemmy not the logging tool as it is just the stats from the Aussie Zone public api...

Eg. id":1,"site_id":1,"users":1319,"posts":1228,"comments":13307,"communities":32,"users_active_day":170,"users_active_week":300,"users_active_month":481,"users_active_half_year":481}

So the answer would actually be in the lemmy documentation..

[–] [email protected] 4 points 1 year ago

I'm glad it's steady growth rather than an explosion in users. Much easier to let things evolve organically that way.

[–] [email protected] 3 points 1 year ago

That all looks pretty healthy, the key will be maintaining momentum. Thanks for sharing.

[–] [email protected] 2 points 1 year ago

When do we get to spam "it's over 9000" memes?

[–] [email protected] 1 points 1 year ago

The only way is up