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 the where or join 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,
  link
from
  rss_item
where
  feed_link = 'https://www.hardcorehumanism.com/feed/'
order by
  published desc;

select
  title,
  published,
  link
from
  rss_item
where
  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 category
where
  feed_link = 'https://www.podcastinsights.com/feed/'
group by
  category
order by
  count desc;

select
  category,
  count(*)
from
  rss_item,
  json_each(categories) as category
where
  feed_link = 'https://www.podcastinsights.com/feed/'
group by
  category.value
order by
  count(*) desc;

Schema for rss_item

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
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