Stardance Stats dev log #3
Little differently today. I fetched all of Stardance today, and if you have any query requests, make a comment and I will answer!
It can be something like, “What’s the best rated project on SD?” or “How many users have over 20 followers?”
There’s a queue of everything worth crawling, and each page gets a tier. Pages that keep changing get checked often; pages that never change drop to the slow lane.
It reads the sitemap to find pages and see what changed recently. But the sitemap misses a lot, so it also just walks id ranges past the highest one it knows is real. Most of those 404s, that’s fine. Owners that never got listed get found through their projects instead. Hidden and unverified profiles still parse.
Comments 19
@SeradedStripes well there is not a ton i can check on this one but here you go
devlogs : 19
total_hours : 34
summed_hours : 34.19
shipped_hours : null
paid_hours : null
followers : 16
likes : 29
comments : 10
reposts : 2
views : 572
ships : 0
stardust_total : 0
latest_multiplier : null
avg_multiplier : null
stardust_per_paid_hour : null
unpaid_hours : 34.19
ratable_unpaid_hours : 34.19
mission_pending_hours : 0
mission_pending_stardust : 0
estimated_pending_stardust : null
estimated_total_stardust : null
fixed_payout_hours : 0
flat_rate_hours : 0
how many projects have I interacted with? like followed, liked, commented on, etc
@ethmarks uhh, I don’t track that, and I don’t think it’s even possible to track; likes are not public.
but i will be tracking comments soon! Anything else you want?
oh. well nvmd then lol. next question: who has created the largest number of projects on stardance?
@mixidmb I have another question: are there any hardware projects with super star?
@ethmarks Yes there are, 4 projects currently:
https://stardance.hackclub.com/projects/2362
https://stardance.hackclub.com/projects/4170
https://stardance.hackclub.com/projects/4431
https://stardance.hackclub.com/projects/10164
💖
@ethmarks user @imu has the most amount of projects, 23 currently.
I think a good number would be the total number of hours a user has spent on all projects. I don’t see this anywhere, so you may have to add up total hours on all the user’s projects :)
@Abracadabra3 i have that already :p
@mixidmb which devlog has the highest ratio of likes:views?
@ethmarks post_id 20291
1 view 2 likes somehow lol
Lol
How about the devlog with the highest ratio of likes:views where likes is less than and not equal to views?
@ethmarks ahh that’s really hard to query, but devlog id 9362, 114views 17likes
Thnx so much 💖
I think there should be a list somewhere of all the projects a user is following, is that something that is in/could be added to your site?
Sign in to join the conversation.