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 thewhere
orjoin
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, descriptionfrom rss_channelwhere feed_link = 'https://steampipe.io/blog/feed.xml';
select title, link, descriptionfrom rss_channelwhere 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, descriptionfrom rss_channelwhere feed_link in ( 'https://steampipe.io/blog/feed.xml', 'https://www.podcastinsights.com/feed/' );
select title, link, descriptionfrom rss_channelwhere 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_versionfrom rss_channelwhere feed_link = 'https://steampipe.io/blog/feed.xml';
select title, feed_type, feed_versionfrom rss_channelwhere 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, categoriesfrom rss_itemwhere feed_link = 'https://www.podcastinsights.com/feed/';
select title, categoriesfrom rss_itemwhere 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