Re: [syndication] Aggregating and displaying feeds

[Mark Nottingham <mnot@mnot.net>]

On Thu, May 24, 2001 at 10:32:11AM -0500, dave.cantrell@gunter.af.mil wrote:
> 
> Question: in your database, how would you store RSS data? That would be a
> new task to me, and I'd like to know what the "accepted best practice" is.
> Sounds like you are storing individual items as unique records tied to title
> and url as primary keys? Assuming you have a separate table (also keyed off
> title and url) that holds the "meta" information on the feed, such as
> author, date, etc? And why not just key off the url, since it has to be
> unique?

I recently looked at doing this by using persistent RDF storage;
there are tools which allow you to convert RSS0.9x into 1.0, and then
it's just a matter of sucking the RDF in, and then accessing the
triples as needed. Should be easy.

Unfortunately, there aren't too many RDF persistence mechanisms that
perform well yet. I played with 4RDF and dbms, but it didn't work
very well. RDFdb looks neat, but doesn't have a Python (my poison of
choice) interface. If you use Perl, this might be an interesting
avenue to pursue.

Cheers,


-- 
Mark Nottingham
http://www.mnot.net/