Following https://tarte.nuage-libre.fr/c/fediverse/p/194717/we-need-more-users I decided to explore data a little bit more. I'm not the biggest fan of growth-as-as-target so I wanted to see how much the people were participating in the discussion.

The data

I took the data from the API explorer in https://api.fediverse.observer/ with this query:

query {  
  monthlystats {  
    date_checked  
    softwarename  
    total_posts  
    total_users  
    total_comments  
  }  
}  

Then parsed the json with this https://jqlang.org/ filter:

jq '.data.monthlystats | map(select(.total_users > 0 and (.softwarename == "lemmy" or .softwarename == "mbin" or .softwarename == "kbin" or .softwarename == "piefed"))) | group_by(.date_checked) | map( {date_checked: .[0].date_checked, total_users: ([.[] | .total_users] | add), total_posts: ([.[] | .total_posts] | add), total_comments: ([.[] | .total_comments] | add)}) | map({date_checked, posts: .total_posts/.total_users, comments: .total_comments/.total_users}) | sort_by(.date_checked) | map([.date_checked, (.posts | tostring), (.comments | tostring)]) | .[] | @csv'  

(As you see I filtered for the threadiverse. I also did the same with all software, I'll put the graph for that in comments)

Then did a good old' chart

What to think of it

I don't know. Users' activity is on the rise and I find it nice

A graph of posts per users and comments per user since beginning of 2024: posts per user is relatively stable, but comments per user is on the rise
you are viewing a single comment's thread
view the rest of the comments
[–] 11 points 9 months ago* (2 children)

Yes. I'm here for the long tail, the niche communities. And what do I see? Not enough photos of houseplants! Come on, you must have some too. And to add to the list, !books@lemmy.world looks nice.

  • source
  • parent
  • hideshow 2 child comments
  • [–] 3 points 9 months ago

    You’re the pineapple blossom post! That’s such a nice picture.

    I've been intentionally trying to be less of a lurker and more active in comments. !books@lemmy.world is one place that I’ve tried to be more active because I love reading, thinking, and talking about books. I was also posting updates about a green lynx spider on my lemmy.world account before I switched to piefed, this is a good reminder for me to post an update on my girl (RIP) and her beautiful little babies.

    Lots of us lurkers need to be more active, myself included.

  • source
  • parent