convert/insert RSS feeds to a database

Can anyone recommend an RSS feedreader which I can use and then convert the feeds (all the threads in a newsgroup for example) into a database?
onyourmarkAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

oleberCommented:
note that a RSS is just a XML, so any XML reader can help you. The real problem with genereic feed reader is that many modules are source specific.

You can consider the Rome to do some of this work:
https://rome.dev.java.net/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dr_dedoCommented:
what you want to do is a simple thing, you only need to "read" that feed, and then insert each line to mySQL
reading the feed is the tricky part, so have a look here on how to get that reading
http://www.sitepoint.com/article/php-xml-parsing-rss-1-0

then, it is easy to build inserts into your database, either insert it line by line (a row at a time) with multiple quries, or you can generate one query that does it all like this
insert into table (field1,field2) values (value1,value1), (value2,value2),(value3,value3), etc....
0
oleberCommented:
Processing a generic RSS (diferent version) coming from different sources as a XML Document, is a nithmare since you have tags with diferent names, namespaces.

You have multiple RSS, try to get a generic library to do the work.

I looked for some time a way of converting RSS/Atom into a RSS version 1 and I have stop in the Rome library.

The only problem was that it was Java, but I adapt myself.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.