This post was originally published on Info World
In Mapping the wider fediverse I showed how a new table added to the Mastodon plugin—mastodon_domain_block—enables queries that find which servers are moderating which other servers. For example, here are servers on nerdculture.de’s list of offenders.
select server, domain, severity from mastodon_domain_block where server = ‘https://nerdculture.de’ +————————+——————————–+———-+ | server | domain | severity | +————————+——————————–+———-+ | https://nerdculture.de | roysbeer.place | silence | | https://nerdculture.de | *.10minutepleroma.com | suspend | | https://nerdculture.de | *.activitypub-troll.cf | suspend | …snip… | https://nerdculture.de | shitposter.club | suspend | | https://nerdculture.de | wolfgirl.bar | suspend | | https://nerdculture.de | www2.gabbers.me | suspend | +————————+——————————–+———-+
I used the new query pattern to build a dashboard to report, for each server in the home timeline:
The list of blocking servers. The count of blocked servers for each blocking server. The list of blocking servers for each blocked server, and the count of those blocking servers.
This was a good start, but I had a hunch that relationship graphs would reveal non-obvious connections among these servers. And indeed they do! Here’s a view of the new graph-enriched dashboard.
The left pane shows the blocked servers shunned by a blocking server selected from those in the home timeline. The right
— Read the rest of this post, which was originally published on Info World.