Notices by halcy​:icosahedron: (halcy@icosahedron.website), page 60

@nightpool @codl ty this helps a lot

@codl idk you're.... same size as i.w. I guess, slightly larger

so that's probably smallish?

in any case thank you

p.s. these are probably Very slow and the third one is the most interesting for me

oh yeah LB watch this it's very good

@bea @Gargron (I _can_ compare weekly posts, so that's useful, I guess)

@bea @Gargron activity endpoint counts logged-in users, but I want this as a baseline for comparison with sth where I only know about users that actually posted a thing

@Gargron like what? also I mostly want to compare this to stats from a place where I most definitely can only look at rate of public posts / number of publicly active users

@Gargron willllll they slow an instance down if ran? if so, oops (they ran just fine on i.w., but there probably just aren't that many posts here so)

hey if you run a mid size to large mastodon instance, want to run the following things in the masto console and tell me the output? I need some values for comparison

Status.local.where('created_at > ?', 1.day.ago).count('distinct account_id')

Status.local.where('created_at > ?', 7.day.ago).count('distinct account_id')

Status.local.where('created_at > ?', 31.day.ago).count('distinct account_id')

(counts daily/weekly/monthly distinct users that posted at least once. boosts appreciated!)

hey if you run a largeish mastodon instance, want to run the following things and tell me the output:

Status.local.where('created_at > ?', 1.day.ago).count('distinct account_id')

Status.local.where('created_at > ?', 7.day.ago).count('distinct account_id')

@revenant they're best friends and they go on adventures imo

how isn't there any unix that has a Command Lion as mascot

@bea in Germany, what we say is "Muss ja."

@codl pyqt 100%

@Ronflaix MULTIPLE kilobytes

why _doesn't_ the node team take like, the 5000 or so most popular mini modules and combines them into a _single_, vettable standard library, anyways

@LottieVixen I mean, really, the Main Problem is that every single node thing depends on 3000 different modules because js has no good standard library so you gotta trust several thousand entirely different people. at this point, you've already lost. nothing any single maintainer does matters there.