feed_fdw

RSS and Atom Foreign Data Wrapper for PostgreSQL, via Multicorn.

Uses the feedparser library, which supports many different feed formats.

Installation

1. Install multicorn

2. Install feedparser:

sudo pip install feedparser

3. Copy feedfdw.py to the multicorn plugin directory:

cp ./feedfdw.py /usr/local/lib/python2.7/dist-packages/multicorn-1.3.4-py2.7-linux-x86_64.egg/multicorn

Usage

create server feed_srv foreign data wrapper multicorn options (
    wrapper 'multicorn.feedfdw.FeedFdw'
);

create foreign table example_feed (
    id text,
    link text,
    title text,
    published text,
    updated text,
    summary text,
    content text
) server feed_srv options (
    url 'http://example.org/rss/'
);