Skip to content

README.md

Latest commit

 

History

History
38 lines (30 loc) · 918 Bytes

README.md

File metadata and controls

38 lines (30 loc) · 918 Bytes

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
  1. 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/'
);