Andrew Conner
banner
andrewconner.com
Andrew Conner
@andrewconner.com
May 21, 2023 at 2:56 AM
"Awareness month"s exist to sell you things
May 1, 2023 at 5:16 PM
Arc'teryx seriously misunderstands my mom.
April 25, 2023 at 10:36 PM
Updated my Bsky profile/follower sqlite database.

Makes it pretty easy to see overall growth and what's happening in the network. Will post about follows cluster analysis later, but for now: how many unique people follow someone, per day?

(Database is available if you want a copy, see below)
April 20, 2023 at 9:43 PM
One character does it for me. 😬
April 20, 2023 at 2:48 PM
Would anyone like a sqlite database of the Bsky accounts and follow graph for data exploration?

Includes account details (did, handle, followers, following), follows, and PageRank calculations for each account.

Since no DMs here, DM me on Twitter: https://twitter.com/connerdelights
April 19, 2023 at 3:58 PM
(This is a quite good "people you may know" implementation, once you follow several people.)

Currently just using follows, but experimenting with likes now. Since it's calibrated to you, like spam isn't a problem.
April 18, 2023 at 6:32 PM
A peek into what I'm working on: a personalized, configurable trust score on Bluesky.

Consider *just* people you follow and people they follow, build a PageRank trust graph. This is much smaller, and shows what accounts that your personal network trusts the most.

Here's my most trusted accounts.
April 18, 2023 at 6:23 PM
I use percentiles for both followers and PageRank, because they have very different distributions.

Here's a graph of the raw values.

Clearly more followers → higher PageRank, but there are outliers. Most of the high followers / low page rank accounts follow spam, so have low-quality followers back
April 18, 2023 at 6:05 PM
More PageRank analysis!

Considering only accounts with more than 40 followers, here is the distribution of followers vs PageRank.

This gives "trust" recursively: if your followers are largely empty accounts → low score, if largely active → high score.

Explanation about what this means...
April 18, 2023 at 6:04 PM
It's far more interesting if you remove the follow spammers. This is the same graph as above, but not considering the top 30 network-wide follow spammers.

Way more cozy!
April 18, 2023 at 5:46 PM
Bsky network analysis

Here's how many followers the entire Bluesky network has. Nearly every account gets 20-30 followers (follow spam), and then it drops off quickly.

If you have 100 followers, you're in the top 93%. The top 1% has 430 followers.
April 18, 2023 at 5:38 PM
I mostly throw normal pottery (vases, planters, bowls), but also do weird sculptural pieces.
April 18, 2023 at 5:20 PM
Similar: top PageRank people, but who have less than 200 followers (as of yesterday)
April 17, 2023 at 8:42 PM
(Continuing PageRank of Bsky people, click below for context)

Playing around with "who is the most underrated", I kind of like sorting by (followers rank - PageRank rank). e.g., you're the 100th most followed, and 50th highest PR.

This captures how far off your follower count is from PageRank.
April 17, 2023 at 8:37 PM
Same disclaimer. Of the top 500 PageRanked accounts, these are the lowest PankRank / follower counts ("most overrated")
April 17, 2023 at 8:19 PM
Disclaimer: the distribution of PageRank is different than the distribution of followers, so this has a bias. I'll play with this more. But, the ordering here seems decently valid.

From top 500 PageRanked accounts, these are the highest PankRank / follower counts ("most underrated")
April 17, 2023 at 8:18 PM
Ran PageRank on the bsky follower graph. Here are the top accounts.

(My crawl is a little incomplete, but this should be directionally accurate)
April 17, 2023 at 6:41 PM
Do you ever get the sense that they use a bit too much blue?
April 17, 2023 at 2:21 PM
still you, but stellar vibes
April 14, 2023 at 9:23 PM
A clay Klein bottle, work in progress.
April 14, 2023 at 7:26 PM
Things you can just do:

You can make boba tea at home. Boba is on Amazon, cooks quite easily. Delicious.
April 13, 2023 at 9:13 PM
April 12, 2023 at 7:53 PM
Pretty cool that it's fairly easy to implement custom "people you may know". Mirror the follows graph to a local database, query to your hearts content.

(`pifft` is "People I Follow that Follow Them")
April 12, 2023 at 6:46 PM
This is where I post from
April 12, 2023 at 3:38 AM