

Jon Udell
Jon Udell was once "blogger in chief" for InfoWorld and is now the community lead for steampipe.io.

Migrating Mastodon lists
If you move from one Mastodon server to another and you want to migrate the people on your lists, you have few options. Here’s a way to do it with Steampipe and SQL.

The Mastodon plugin is now available on the Steampipe Hub
The fediverse offers an opportunity to reboot the social web and gain control of our information diets. Steampipe and its Mastodon plugin can help you seize it.

Mastodon timelines for teams
Using Steampipe and SQL to pool Mastodon timelines and point queries and dashboards at the combined histories of teams or groups.

Visualizing Mastodon server moderation
Which Mastodon servers are blocking other Mastodon servers, and which servers are being blocked? We can discover them using Steampipe’s relationship graphs.

Mapping people and tags on Mastodon
How Steampipe’s API queries and relationship graphs enable maps that select what is helpful and omit what isn’t.

News in the fediverse
The fediverse is our chance to reboot the social web and gain control of our information diets. Let’s make it trivial for anyone to turn on a rule like ‘news only on lists, not timelines.’

Protocols, APIs, and conventions
We’re in one of those internet moments of rapid innovation, when new conventions can unlock emergent behaviors. Enjoy it!

Mapping the wider fediverse
After overcoming a few obstacles, my set of Steampipe dashboards is starting to feel like the Bloomberg terminal for Mastodon that I envision.

Images considered harmful (sometimes)
Steampipe’s Mastodon dashboards are image-free for now, and I think it’s having a calming effect. Perhaps all social media interfaces should have an optional text mode.

Working with Mastodon lists
Steampipe makes it easy to create Mastodon dashboards, find interesting people, see which lists they’re on, and export lists in useful ways. Now we need ways to share and remix those lists.
Mastodon relationship graphs
Steampipe and SQL allow us to see relationships among the data we extract from APIs. Here’s how to graph the connections between tooters and boosters on Mastodon.