(2023-01-16) Udell Mastodon Relationship Graphs

Jon Udell: making Mastodon relationship graphs. The new release of Steampipe is all about relationship graphs. Our blog post shows how these graphs provide contextual awareness for devops and security pros who can now see all the resources related to an EC2 instance

These relationship graphs are driven by SQL queries that define nodes and edges.

this graph shows people on a selected server boosting people on other servers

Let’s build up the first graph step by step.

Step 1: Identify the selected server

Step 2: Identify boosted servers

Step 3: Identify people who boost others

Step 4: Identify people who are boosted

Step 5: Connect boosters on the selected server to that server

Step 6: Connect people on boosted servers to their servers

Step 7: Connect boosters to the people they boost

Graphing GitHub relationships

Lifting the burden of context assembly

In What TimeDance got right I mourned the passing of a tool for scheduling meetings that had excelled at bringing together the messages and documents related to a meeting. I called this “context assembly” — a term I’d picked up from Jack Ozzie, cofounder of Groove, another collaboration tool whose passing I mourn. Context assembly is hard work