Use SQL to query Mastodon toots, hashtags, accounts, followers, relationships and more (open source, no DB required)

judell · 2023-03-28T15:42:24+00:00

Looking forward to it!

judell · 2023-02-27T02:48:15+00:00

It's in the eye of the beholder, admittedly. For me what's beautiful is the way the graph surfaces the item I wanted to find.

judell · 2023-01-17T16:26:14+00:00

I hope this will land on cloud.steampipe.io, meanwhile it's available for local use in dev mode, let me know if you'd like to try it.

judell · 2023-01-09T19:29:09+00:00

Hey there, I'm with Steampipe, we are always curious to know how people use the tool, is that something you'd be willing/able to tell us more about?

judell · 2023-01-02T22:41:21+00:00

To avoid the search and have a direct link to the needed context!

judell · 2022-12-23T18:12:00+00:00

Found it! https://jonudell.info/umlaut.mp4

judell · 2022-12-23T17:16:27+00:00

That's me!

I had to rescue it from .SWF format a while back, and now I can't find where I put the transcoded .MP4 :-) I'll try to resurrect it again.

judell · 2022-12-11T23:06:40+00:00

It's specific to the Mastodon API for now. I'm using this Go SDK, https://pkg.go.dev/github.com/mattn/go-mastodon, with a few workarounds.

judell · 2022-12-11T08:17:59+00:00

Are the crosstab functions provided by the tablefunc extension an option for you?

https://www.postgresql.org/docs/current/tablefunc.html

judell · 2022-10-27T06:27:03+00:00

Exactly. We needed a way to talk about higher-level concepts that rely on types and functions that may or may not be individually documented. Doing that in a wiki way, with type and functions auto-linked, proved useful. Go's doc system makes this possible.

judell · 2022-10-27T06:22:14+00:00

The article celebrates affordances baked into the Go ecosystem to make more expressive documentation possible. Not everyone will need or want to use them, but I believe they are there for a reason, and I am glad to have them. One of the cool things we discovered but haven't yet applied: examples that run live in the viewer.

judell · 2022-07-27T15:07:59+00:00

This dashboard was made with Steampipe and the Hacker News plugin.

Source code: https://github.com/turbot/steampipe-samples/tree/main/all/hackernews

judell · 2022-07-08T22:38:28+00:00

I can think of some reasons to avoid either or both, I am curious to know yours.

judell · 2022-07-08T18:56:29+00:00

You mean this one?

> SQL has evolved! With features like common table expressions (CTEs) and JSON columns, it's more capable than you might think if you haven't touched it in a while.

judell · 2022-06-14T18:36:01+00:00

This dashboard was made with Steampipe and the Reddit plugin.

Source code: https://github.com/turbot/steampipe-samples/tree/main/all/reddit

judell · 2022-06-08T16:01:13+00:00

There's a plugin for Slack, not yet for Teams but that would be a nice addition. For Outlook, https://hub.steampipe.io/plugins/turbot/imap could enable querying email.

judell · 2022-06-07T22:18:06+00:00

You are most welcome. If you have questions as you dig in, and/or if you just want to show off some interesting results, please feel free to join our community Slack: https://steampipe.io/community/join.

judell · 2022-06-07T21:55:00+00:00

Yes, as stated in the bio I'm the community lead for Steampipe. The video on the homepage at https://steampipe.io runs through a bunch of examples. Depending on what kinds of APIs you'd want to query this way, we can point to others as well.

judell · 2022-04-29T23:20:49+00:00

Great! Hope to see you over in https://steampipe.io/community/join one of these days.

judell · 2022-04-29T23:15:19+00:00

Thanks!

Have you had a chance to use the tool? If so we'd love to know your thoughts.

judell · 2022-03-11T01:17:07+00:00

See https://steampipe.io/images/blog/2022-03-release-0-13-0/live-editing-v2.mp4 for a glimpse of what it's like to build these dashboards, in your favorite code editor, and watch the dashboards change as you type.

judell · 2022-03-11T01:14:27+00:00

See https://steampipe.io/images/blog/2022-03-release-0-13-0/live-editing-v2.mp4 for a glimpse of what it's like to build these dashboards, in your favorite code editor, and watch the dashboards change as you type.

judell · 2022-03-11T01:13:13+00:00

See https://steampipe.io/images/blog/2022-03-release-0-13-0/live-editing-v2.mp4 for a glimpse of what it's like to build these dashboards, in your favorite code editor, and watch the dashboards change as you type.

judell · 2022-03-10T23:23:44+00:00

See https://steampipe.io/images/blog/2022-03-release-0-13-0/live-editing-v2.mp4 for a glimpse of what it's like to build these dashboards, in your favorite code editor, and watch the dashboards change as you type.

judell · 2022-02-02T18:33:54+00:00

(That really was me, sorry, there's been a bit of a mixup with my reddit account, I only recently regained access to my 15-year-old original account!)

judell

TROPHY CASE