Use Steampipe to select your AWS resources across SSO accounts with SQL
https://dev.to/aws-builders/use-steampipe-to-select-your-aws-resources-across-sso-accounts-with-sql-4dd3

#aws #steampipe

As I begin viewing the Fediverse through the lens of #Calckey, the most interesting thing so far is search. Example: Looking for "InfoWorld" finds posts by others, and also by me in two places: mastodon.social and social.coop.

How does this work? Is it the case that Mastodon instances are more comprehensively searchable by way of ActivityPub than by way of the Mastodon API?

Should a #Steampipe plugin for ActivityPub be a next project?

I'm curious about that too.

Also, @davidshq, I'll be really interested to know your thoughts on the state of the project. I'm trying to work out whether, or to what extent, the responsiveness I'm aiming to achieve will require prefetching and storing Mastodon data. #Steampipe is a realtime system by default, storing nothing unless you ask it to, and that's great for many things. But the value of the dashboards has to do with the amount of data they summarize, and that's a stretch for realtime.

Playing around with @judell's plugin and mod that provides access to the #mastodon #api using #steampipe. pretty cool!

Steampipe: https://steampipe.io/
Plugin: https://hub.steampipe.io/plugins/turbot/mastodon
Mod: https://github.com/turbot/steampipe-mod-mastodon-insights

Curious if anyone else is using steampipe for anything?

@bracken The #Steampipe-based dashboards I'm building and using aren't (yet) a mainstreamable thing, but for me they are most definitely something better.

@ntnsndr Yes, and yes. My gig, #steampipe, provides two of the essential ingredients for doing that: a mechanism for normalizing APIs using SQL, and for visualizing SQL queries on dashboards.

@judell Jon, is there a JDBC driver for #Steampipe? If not, is one planned?

#mastodon is on #steampipe

https://hub.steampipe.io/plugins/turbot/mastodon

NEAT!

@SpaceLifeForm @jrosen707 I was super-curious about that too. It appears that I can't.

"Your account is inactive because it is currently redirecting to judell@social.coop. **Cancel redirect"**

I'll appreciate any tips on how to proceed. I'd like to be able to query both accounts with #Steampipe. If I cancel the redirect what will happen?

#mastodon #migration

#introduction

Past affiliations: Lotus, BYTE, Safari Books Online, InfoWorld, ITConversations, Microsoft, Hypothesis.

Work: Community lead for https://steampipe.io.

Play: Using #steampipe to prototype alternate UX for Mastodon, cycling and hiking in the North Bay.

Known for: LibraryLookup (https://jonudell.info/LibraryLookup.html), Heavy Metal Umlaut (https://jonudell.info/umlaut.mp4), screencasting (https://en.wikipedia.org/wiki/Screencast).

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

https://www.infoworld.com/article/3691029/mastodon-timelines-for-teams.html

#SteamPipe #Mastodon

@judell big thanks for the Mastodon tools for #Steampipe, made the data-gathering part of this post trivial

Blogged:
Finding 'connectors' in Mastodon
Exploring the behaviour of people who act as ‘connectors’, steered by @harold, with some tools by @judell #PKMastery #Mastodon #Steampipe #SocialNetworks #100DaysToOffload
https://www.synesthesia.co.uk/2023/03/01/finding-connectors-in-mastodon/

"Enabling SQL to query diverse APIs in a common way is one of Steampipe’s core superpowers. Enabling such queries to form the nodes and edges of relationship graphs is another. Used together, these two superpowers enable maps that select what is helpful, omit what isn’t, and thus “re-present” information for a given purpose."

https://blog.jonudell.net/2023/02/26/mapping-people-and-tags-on-mastodon/

#steampipe #tags #dataviz

https://blog.jonudell.net/2023/02/14/news-in-the-fediverse/

#fedilab #steampipe

The new TagExplore tab in the #Steampipe dashboard for Mastodon seems like a good way to find people based on their interests. It makes use of the tag enrichment strategy described in https://blog.jonudell.net/2022/12/06/mastodon-steampipe-and-rss/ to show tags that co-occur with the input tag. And of course relationship graphs as described in https://blog.jonudell.net/2023/01/16/mastodon-relationship-graphs/.

#Steampipe #Mastodon #Tagging #Discovery

@judell explores the #fediverse with #steampipe https://www.infoworld.com/article/3687132/mapping-the-wider-fediverse.amp.html

"ActivityPub and WebFinger are formal standards. I would describe the Mastodon API as a de-facto standard. But this prefixing maneuver is just a convention. It’s not guaranteed to work with another web client, and not even guaranteed to work across all URLs presented by the stock Mastodon client. That’s OK by me. Conventions are incredibly useful."

#mastodon #elk #steampipe

https://blog.jonudell.net/2023/02/06/protocols-apis-and-conventions/

@k9ox Here is that graph in #Steampipe: https://cloud.steampipe.io/user/judell/workspace/personal/snapshot/snap_cfg0b0klsio6br7nuehg_3c54n21uav7rr6a5wmji2tau8

The first screen shot shows the simplest possible version, and then a slightly more advanced version with icons.

The second shows that you can see the underlying data by hovering the graphs.

The third shows the SQL that produced the data.

I learned about #Steampipe yesterday. For the advanced #Mastodon user that would like a top-down look or your account. I would recommend giving it a look.