It is nice to have also a status message of the unread RSS feeds on the desktop. Here comes my solution on 3 lines. It just needs the path to be adjusted on line #1 and may be set to run every 3600 s.

sqlite3 ~/Library/PubSub/Database/Database.sqlite3 <<SQL_ENTRY_TAG_1
select sum(unreadCount) || ' unread feeds' from subscriptions;

[Admin Note: I've changed the first line so it should work for anyone without changing. I've also embedded the script in a downloadable geeklet file below]

Geeklet files to download


Log in to comment or register here.