Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the '10.5: Set per-feed update/expire intervals in Safari RSS' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
10.5: Set per-feed update/expire intervals in Safari RSS
Authored by: t0fukrunch on Mar 02, '08 11:17:20PM
I was looking for a way to set Mail.app's default refresh interval. It appears this information is also stored in the Subscriptions table. Here is an excerpt from mine:

rowID|client|feed|refreshInterval|expirationInterval|expirationDate|refreshesInBackground|downloadsEnclosures|maxEnclosureSize|enclosureTypesString|unreadCount
...
82|1|81|-1.0|0.0|224917200.0|1|0|0.0||0
299|2|0|1800.0|1209600.0|224917200.0|0|0|8388608.0||0
301|3|0|604800.0|-1.0|214027200.0|1|0|8388608.0||0
...

which was produced by the command: select * from subscriptions;. Note the entries with rowID=299,301, which have feed=0. I believe these entries store the default settings for the corresponding client. So since row 299 has client=2, it corresponds to Mail.app. I verified this by changing the refresh interval in Mail.app, which changed the refreshInterval for row 299 from 1800.0 (i.e. 30 minutes) to the modified value. I wanted a refresh interval of 10 minutes, so I executed:

update subscriptions set refreshInterval=600 where client=2 and feed=0;

As the original poster mentioned, the proper way to do this is through the API. It's actually pretty easy to get and set the refreshInterval for a client with a few lines of code, but this is useful for those of us that want a quick hack.



[ Reply to This | # ]