Profile avatar
m3ta.uk
Proud geek and author of "Hacking Through Time" (it's on Amazon) Metalhead.🀘| Neurodivergent, OCD | INTJ/INTP (it changes) Former πŸ¦‹ Bluesky Statistics v0.63 πŸ¦‹ main Dev πŸ‡¬πŸ‡§
223 posts 2,092 followers 1,890 following
Regular Contributor
Active Commenter
comment in response to post
True, but they -did- declare "war" on 0/1 button builds. And some... Erm... "Older people" πŸ˜‚πŸ€·β€β™‚οΈπŸ€¦β€β™‚οΈ enjoy those builds! (Yeah, me, lol)
comment in response to post
Unfortunately, GGG is nerfing every fun build very quickly, which is making me worried about the future of PoE2. TBH, the ascendancy trials are so bad, I went back to PoE1 for a few hours earlier today.
comment in response to post
Epic.
comment in response to post
You /can/ do it, but it's considered inefficient for... Decades.
comment in response to post
Luxury! Awesome. πŸ‘β€οΈ
comment in response to post
Want do do a \t before that query and share the time it takes to get results on a highly not recommend count(*)?
comment in response to post
Maybe one day we will "rearchitect" our HA pgsql triggers and stored procedures and replace it with an Sqlite crap flat db and ask for your opinion. Until then, stay in your lane. media3.giphy.com/media/VkICFY...
comment in response to post
πŸ™ˆ
comment in response to post
I only checked it twice right in the beginning but the % of zero posters was below 15%.
comment in response to post
Musk... Change? Hah, I can see the humour in that statement.
comment in response to post
That value has been growing daily. Many join because "oh it's private, FOMO" but as soon as they land, they feel "mission accomplished, I'm in the inner circle " and the truth is, they have nothing to say or any value to add. One might say that the return on investment from being private is failing.
comment in response to post
666 to go... interesting. 😈
comment in response to post
Either too much money or just bad taste in music.
comment in response to post
Not audiophile grade. Not worth it.
comment in response to post
I don't know. Why exactly should that account show up, and in each category? And don't ever compare our stats with anyone else's - no one does it "the same way".
comment in response to post
Ohhhhh indeed, that is something that transpired from "the beginning". Fixed now. Thanks!!
comment in response to post
You don't know how we collect stats, which makes you write inefficient skeets. That warning says the rate limiting makes gathering data slower, not that we hit the limits.
comment in response to post
Yes, it will happen!
comment in response to post
🀣Now I'm wondering if there's a cat named Netflix somewhere...
comment in response to post
Good thing I created a global function for number formatting, so any change takes -literally- a second. 😎
comment in response to post
Now that's just nitpicking... unless you tell me that "only commas" make a number easier to read.
comment in response to post
Done. πŸ‘
comment in response to post
Almost done.
comment in response to post
Valid... I have to agree.
comment in response to post
We never count deleted/banned accounts, and every single number you see in vqv.app constitutes "the truth" as far as atproto is concerned. I can't speak for other devs.
comment in response to post
I could add that feature to vqv.app. Let me think about it.
comment in response to post
No worries! Yeah that would be great. Another thing we'd like to have is the ability to extract info of more than 25 users at a time. Just imagine how many atproto calls we have to do presently, to get data from 1M people. 🀦
comment in response to post
Weekly/Monthly tracking will need some database changes. I'm on it. πŸ˜„
comment in response to post
Criteria right now (might change) is a difference in 'follows', 'followers' or 'posts'. As I said before, atproto does not provide login metrics.
comment in response to post
We actually loved it too. But it stirred the waters a bit too much. πŸ˜‰
comment in response to post
BUG! That was the active users sum from the last week. If only considering the last day: active_users_today -------------------- Β  Β  Β  Β  Β  Β  Β  73414 πŸ€·β€β™‚οΈ
comment in response to post
Spoiler - preliminary result: active_usersΒ  ---------------------- Β Β  Β  Β  Β  Β  Β  Β  561092 I'll automate the thing and add it to the vqv.app Assorted page. Thanks for the idea. πŸ‘
comment in response to post
You need to be proactive, not reactive. That's not enough.
comment in response to post
Actually, vqv.app tracks all that already - except blocks, because it's such a toxic topic (tongue twister) we gave up on blocks. But the rest.. Might take some work, but definitely doable. Let me put it on my "ToDo next" 😎
comment in response to post
Musk can fuck off to Mars and it still wouldn't be far enough.
comment in response to post
Atproto does not provide metrics regarding users who login and "just look". Is that an "active" user"? What about the ones who only repost and create nothing, are those active? And the ones who follow then unfollow immediately? (spamming a notification, I call it "bsky bullying")
comment in response to post
Mac&Cheese is perpetual... perennial. Like peanut butter. Crunchy, obviously
comment in response to post
Get the list of repos from the bsky.social PDS to a text file, then see what's the line number of the DID from the accounts.