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:
To read this article in full, please click here
InfoWorld Cloud ComputingRead More