Seeing that YQL is being promoted as a good way to do things, I was curious as to how to use YQL to fetch and merge 2 different feeds into one (sorted by pubDate).
It's pretty trivial to fetch 2 feeds but it turns out that the feeds are just concatenated together and not merged.
Here's the sample code.
select channel.title,channel.link,channel.item.title,channel.item.link
from xml where url in(
'http://code.flickr.com/blog/feed/rss/',
'http://feeds.delicious.com/v2/rss/codepo8?count=15',
'http://www.stevesouders.com/blog/feed/rss',
'http://www.yqlblog.net/blog/feed/',
'http://www.quirksmode.org/blog/index.xml'
)
As to the RSS question - YQL always returns XML - if you want to turn it into an RSS feed you can also use Yahoo Pipes and the YQL module to get it as RSS.
This should do the trick
use the post-query functions unique to filter out duplicates and sort to re-order your result. Here the link to the documentation of those functions http://developer.yahoo.com/yql/guide/sorting.html
Thanks for this info. It works when accessing the rss object, too:
This is a very simple way to create a newsroom or a lifestream. Don't forget to force-cache the YQL return :)