I'm looking at creating a personal aggregator for myself which will take advantage of YQL but i'm wondering what will be the best way to keep the data in chronological order over multiple feeds.My first thought was to parse and store each feed in a local DB which would allow me to keep the data in line, but it feels really dirty to duplicate the data just for the sake of ordering it. Apart from parsing each feed and merge the data at the point of display is there any other option i could use? Could this be an ideal place to use a JOIN?Just wondering if anyone with better experience with YQL might have come across a similar situation before. Many thanks in advance.
select * from rss where url in ('http://rss.news.yahoo.com/rss/topstories', 'http://rss.cnn.com/rss/cnn_topstories.rss') | sort(field='pubDate', descending='true')