Jerry 🦙💝🦙How am I just now learning about steampipe and the mastodon plugin for it? 🤯
[𝚜𝚒𝚍𝚗𝚎𝚢𝚜𝟷@~/𝚜𝚛𝚌]$
@jerry new mastodon client idea: you can only browse posts via SQL queries.
SELECT timestamp,author,content FROM public_feed
Jon Udell@Sidneys1 @jerry There's a Steampipe dashboard that works that way, I demoed it at the last FediForum: https://jonudell.info/video/fediforum.mp4
https://github.com/turbot/steampipe-mod-mastodon-insights
I wrote a whole bunch of posts about it.
https://blog.jonudell.net/2022/12/06/mastodon-steampipe-and-rss/
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.