Table: rss_item - Query RSS Feed Items using SQL
An RSS Feed Item is an individual content piece from an RSS feed. These items contain the actual content of the feed, including titles, descriptions, and links to the original content. Each item also carries metadata such as publishing dates, authorship, and categories.
Table Usage Guide
The rss_item
table provides insights into individual items within an RSS feed. As a content manager or data analyst, explore item-specific details through this table, including content, metadata, and associated links. Utilize it to uncover information about items, such as their publishing timeline, authorship details, and categorization.
Important Notes
- It's not possible to list all feeds in the world, so this table requires a
feed_link
qualifier to be passed in thewhere
orjoin
clause for all queries.
Examples
Query items from a channel, newest first
Explore the latest items from a specific RSS feed to stay updated with the most recent content. This is especially useful for keeping track of the latest updates on frequently updated websites or blogs.
select title, published, linkfrom rss_itemwhere feed_link = 'https://www.hardcorehumanism.com/feed/'order by published desc;
select title, published, linkfrom rss_itemwhere feed_link = 'https://www.hardcorehumanism.com/feed/'order by published desc;
Count items by category
Explore the distribution of podcast topics from a specific feed. This query helps you understand the most frequent themes or categories in the chosen podcast, providing insights into its content focus.
select category, count(*)from rss_item, jsonb_array_elements_text(categories) as categorywhere feed_link = 'https://www.podcastinsights.com/feed/'group by categoryorder by count desc;
select category, count(*)from rss_item, json_each(categories) as categorywhere feed_link = 'https://www.podcastinsights.com/feed/'group by category.valueorder by count(*) desc;
Schema for rss_item
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
author_email | text | Email address of the author of the item. | |
author_name | text | Name of the author of the item. | |
categories | jsonb | Specify one or more categories that the item belongs to. | |
content | text | Content of the item. | |
description | text | The item synopsis. | |
enclosures | jsonb | Media objects attached to the item. | |
extensions | jsonb | Extension data (e.g. Dublin Core, ITunes) for the item. | |
feed_link | text | = | URL of the feed itself. |
guid | text | A string that uniquely identifies the item. | |
image_title | text | ||
image_url | text | ||
link | text | The URL of the item. | |
published | timestamp with time zone | Timestamp when the feed was published. | |
title | text | The title of the item. | |
updated | timestamp with time zone | Timestamp when the feed was updated. |
Export
This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.
You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh
script:
/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- rss
You can pass the configuration to the command with the --config
argument:
steampipe_export_rss --config '<your_config>' rss_item