Table: rss_channel - Query RSS Channel using SQL

RSS (Really Simple Syndication) Channel is a web feed that allows users to access updates to online content in a standardized, computer-readable format. These feeds can, for example, allow a user to keep track of many different websites in a single news aggregator. The news aggregator will automatically check the RSS feed for new content, allowing the content to be automatically passed from website to user.

Table Usage Guide

The rss_channel table provides insights into RSS channels across various websites. As a content manager or a web developer, explore channel-specific details through this table, including title, description, link, language, and copyright. Utilize it to monitor the updates of different websites in an automated and efficient manner.

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

Basic channel info

Discover the segments of a specific RSS feed by analyzing the title, link, and description. This could be beneficial for understanding the content and structure of the feed for further analysis or content curation.

select
  title,
  link,
  description
from
  rss_channel
where
  feed_link = 'https://steampipe.io/blog/feed.xml';

select
  title,
  link,
  description
from
  rss_channel
where
  feed_link = 'https://steampipe.io/blog/feed.xml';

Basic channel info for multiple feeds

Explore multiple RSS feeds to uncover their basic channel information. This can be useful for comparing content across different sources or tracking updates from preferred feeds.

select
  title,
  link,
  description
from
  rss_channel
where
  feed_link in (
    'https://steampipe.io/blog/feed.xml',
    'https://www.podcastinsights.com/feed/'
  );

select
  title,
  link,
  description
from
  rss_channel
where
  feed_link in (
    'https://steampipe.io/blog/feed.xml',
    'https://www.podcastinsights.com/feed/'
  );

Get the type of the channel

Explore the type and version of a specific RSS feed to understand its format and compatibility. This is particularly useful when integrating or troubleshooting RSS feed readers.

select
  title,
  feed_type,
  feed_version
from
  rss_channel
where
  feed_link = 'https://steampipe.io/blog/feed.xml';

select
  title,
  feed_type,
  feed_version
from
  rss_channel
where
  feed_link = 'https://steampipe.io/blog/feed.xml';

Get categories for the channel

Discover the segments that categorize a specific podcast channel, which can be useful for understanding the content scope and audience interest areas of the channel.

select
  title,
  categories
from
  rss_item
where
  feed_link = 'https://www.podcastinsights.com/feed/';

select
  title,
  categories
from
  rss_item
where
  feed_link = 'https://www.podcastinsights.com/feed/';

Schema for rss_channel

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
author_email	text		Email of the author.
author_name	text		Name of the author.
categories	jsonb		Specify one or more categories that the channel belongs to.
copyright	text		Copyright notice for content in the channel.
description	text		Phrase or sentence describing the channel.
extensions	jsonb		Extension data (e.g. Dublin Core, ITunes) for the channel.
feed_link	text	=	URL of the feed itself.
feed_type	text		Type of the feed: rss, atom or json.
feed_version	text		Version of the feed type, e.g. 2.0
generator	text		A string indicating the program used to generate the channel.
image_title	text		The title of a GIF, JPEG or PNG image that can be displayed with the channel.
image_url	text		The URL of a GIF, JPEG or PNG image that can be displayed with the channel.
language	text		The language the channel is written in. This allows aggregators to group all Italian language sites, for example, on a single page. A list of allowable values for this element, as provided by Netscape, is here. You may also use values defined by the W3C.
link	text		The URL to the HTML website corresponding to the channel.
published	timestamp with time zone		Timestamp when the feed was published.
title	text		The name of the channel. It's how people refer to your service. If you have an HTML website that contains the same information as your RSS file, the title of your channel should be the same as the title of your website.
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_channel