issues
search
turbot
/
steampipe-plugin-rss
Use SQL to instantly query RSS channels and Atom Feeds. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/rss
Apache License 2.0
11
stars
2
forks
source link
Recompile plugin with Go version 1.17
#12
Closed
misraved
closed
2 years ago
misraved
commented
2 years ago
Example query results
Results
``` select category, count(*) from rss_item, jsonb_array_elements_text(categories) as category where feed_link = 'https://www.podcastinsights.com/feed/' group by category order by count desc; +-----------------------------------------+-------+ | category | count | +-----------------------------------------+-------+ | Podcast | 7 | | Podcasting Deals, Coupons & Promo Codes | 5 | | Software | 2 | | Start | 2 | | Monetize | 1 | | Grow | 1 | | WordPress | 1 | +-----------------------------------------+-------+ ```
Example query results
Results
``` select category, count(*) from rss_item, jsonb_array_elements_text(categories) as category where feed_link = 'https://www.podcastinsights.com/feed/' group by category order by count desc; +-----------------------------------------+-------+ | category | count | +-----------------------------------------+-------+ | Podcast | 7 | | Podcasting Deals, Coupons & Promo Codes | 5 | | Software | 2 | | Start | 2 | | Monetize | 1 | | Grow | 1 | | WordPress | 1 | +-----------------------------------------+-------+ ```