med-mastodon.com is one of the many independent Mastodon servers you can use to participate in the fediverse.
Medical community on Mastodon

Administered by:

Server stats:

412
active users

#steampipe

0 posts0 participants0 posts today

Progress report, day 2: The #osmose has been set up as #mpe controller for the #hydrasynth desktop and the #steampipe. It took an anonymous poster to help me figure out how to send mpe to the steampipe (reduce the midi channels/voices to 8). The recording below titled “The puppet dances” - my first recoding for this configuration - is a tribute to our dear leader Marionetka Krasnov. Next stop, adding the #digitone for sequencing and percussion.

00:00/01:02

"Users of the WordPress API may enjoy the abstraction — and standardization — that a SQL interface provides. If you need to query multiple WordPress sites, Steampipe's connection aggregator will be really handy. And if you want to integrate data from WordPress with data from other APIs wrapped by other plugins, performing literal SQL JOINs across disparate APIs is a heady experience."

thenewstack.io/building-a-stea

The New Stack · Building a Steampipe Dashboard for WordPress, With LLM HelpHow I made a Steamipe plugin to query WordPress with SQL, then built dashboards to visualize query results — all with LLM assistance.
Replied in thread

@KingShawn I keep up by categorizing followed accounts into #Mastodon lists and have started to remove non-VIPs from my home feed. I subscribe to #RSS feeds for posts from accounts I don't want to miss at all.

Also, @judell turned me on to creating custom queries and dashboards with #Steampipe: hub.steampipe.io/plugins/turbo

Steampipe HubMastodon plugin | Steampipe HubQuery Mastodon with SQL! Open source CLI. No DB required.

All the Steampipe plugins are now also:

- standalone Postgres foreign data wrapper (FDW) extensions that translate APIs to foreign tables

- SQLite extensions that transate APIs to virtual tables

- standalone binaries that export data from APIs

It's kind of a big deal! I'm especially curious to know what @simon thinks about all the new SQLite extensions that just appeared in the world.

steampipe.io/blog/2023-12-sqli

SteampipeZero-ETL for SQLite: Live-query cloud APIs with 100+ new extensions | Steampipe Blog A new family of SQLite extensions enable SQL queries that translate APIs to foreign tables.
Replied in thread

@Sidneys1 @jerry There's a Steampipe dashboard that works that way, I demoed it at the last FediForum: jonudell.info/video/fediforum.

github.com/turbot/steampipe-mo

I wrote a whole bunch of posts about it.

blog.jonudell.net/2022/12/06/m

It turns out not to be super-practical going against the live Mastodon API, because rate limits. So I'm working on a version that uses scheduled queries to cache data so the dashboards can run instantly.

Excellent work by @sjvn.

I only roughly get what GitOps is, as both a conceptual framework and a set of tools. But this article suggests to me that as git becomes the source of truth for infra as well as appdev the #Steampipe GitHub/GitLab plugins will become even more interesting than they already are.

thenewstack.io/gitops-as-an-ev

The New StackGitOps as an Evolution of KubernetesBrendan Burns, Kubernetes' co-founder shared his thoughts on GitOps and Kubernetes at GitOpsCon.

The software demo videos from #FediForum are now on-line, including demos of #Mammoth, #Owncast, #Steampipe, #Bridgy Fed, #Flipboard, #Whalebird / #Fedistar, #Planetary, #microblog and #Wordpress ActivityPub plugin.

There are also extensive notes from almost all sessions that people ran on so many #Fediverse subjects, ranging from technology and standards to moderation, to enterprise needs to community building and more.

Check them out at fediforum.org/ . And join us next time?

FediForumFediForumFediForum: moving the Open Social Web forward

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?

Replied to Dave Mackey

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.

#introduction

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

Work: Community lead for steampipe.io.

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

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

SteampipeSteampipe | select * from cloud;Steampipe is an open source tool to instantly query your cloud services (e.g. AWS, Azure, GCP and more) with SQL. No DB required.