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


Click here to return to the '10.4: Manually clean Safari RSS articles' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
10.4: Manually clean Safari RSS articles
Authored by: guybrush on Aug 12, '05 06:48:20PM

Combined comments from above into 1 command :)

sqlite3 ~/Library/Database3 'DELETE FROM Articles WHERE source_id NOT IN(SELECT id FROM Sources)' Also @fungus, why are the possibilities endless now because its stored in a sqlite database?

[ Reply to This | # ]
10.4: Manually clean Safari RSS articles
Authored by: gaoshan on Aug 16, '05 01:09:21PM

You accidentally left out the "Syndication" directory from that... Here is the whole command:

sqlite3 ~/Library/Syndication/Database3 'DELETE FROM Articles WHERE source_id NOT IN(SELECT id FROM Sources)'



[ Reply to This | # ]
10.4: Manually clean Safari RSS articles
Authored by: fungus on Aug 19, '05 12:27:32PM

All RSS feeds that Safari RSS tracks are stored in this database. That means that Safari RSS does the heavy lifting of downloading and parsing the feeds. With direct access to the database one could write their own RSS aggregator without any knowledge of HTTP retrieval or RSS parsing.

Example: I wrote a ticker program to display article titles across the bottom of the screen, clicking the titles marked the item as read, and opened the URL in Safari. All this just required a few SQL queries, and absolutely no RSS parsing.



[ Reply to This | # ]