0

Handling chronological ordering over multiple feeds

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.

by
1 Reply
  • QUOTE (irphunkster @ May 10 2009, 02:02 AM) <{POST_SNAPBACK}>
    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.


    How about using the post query function like on the output of multiple feeds? sort(field='field.name', descending='true')
    CODE
    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')


    The above query should print the news articles from either yahoo or cnn ordered by data (descending)

    http://developer.yahoo.com/yql/console/?q=...'true')

    -- Nagesh
    0

Recent Posts

in YQL