Different Clean-Up Rules for Folders... or a way to juggle Databases?

Seventh Horse

I have a large number of Feeds for which I need to implement different Clean-Up Rules:  short term for regular news, longer term for scientific journals, and permanent for podcasts and a few photoblogs.  Unfortunately, as far asI can tell the settings for Clean-Up are global.

Is there a way I can set up different rules for the three different groups?  (Or more than three:  ideally, I'd subdivide the Clean-Up calendars even further if it's easy:  just a single a week for "NPR News All Things Considered" podcasts, for example, but probably six months for "Fresh Air".)

Alternately, is there a way to juggle three different databases (in a manner that's not as challenging to implement as the Gordian Knot!).

I realize I *could* go back and simply star all those podcasts and photoblogs to keep them in the database permanently, but that's going to be a pretty tall order in and of itself.  The pessimist in me says that's what I'll end up doing!

The seeming lack of variable Clean-Up rules is the only regret so far for the switch from RSSOwl.  I *have* considered the awkward option of using RSSOwl for the feeds I want to store long term, but I find the QuiteRSS interface sufficiently superior that I just can't go back to it for everyday newsreading.

 

 

Sheldon
Hi,

Hi,

unfortunately iwith the current implementation it's not possible to set up individual clean-up rules for feeds in the application.
But you can do that using SQL on db level by connecting to the feeds.db directly.
For further information refer to http://www.tutorialspoint.com/sqlite/sqlite_useful_functions.htm.

Kind regards

Sheldon.

Seventh Horse
Quote: ...but you can do that

Quote:
...but you can do that using SQL on db level by connecting to the feeds.db directly. For further information refer to http://www.tutorialspoint.com/sqlite/sqlite_useful_functions.htm. 
Thanks much for the timely reply.

I'll take a stab at it (and report back if I have any success).

Regards,

7th
 

Sheldon
To access the db you can use

To access the db you can use f.e. DB Browser for SQLite Portable .
http://portableapps.com/apps/development/sqlite_database_browser_portable
But you should quit QuiteRSS before you do that!

Seventh Horse
Quote: To access the db you

Quote:
To access the db you can use f.e. DB Browser for SQLite Portable . http://portableapps.com/apps/development/sqlite_database_browser_portable But you should quit QuiteRSS before you do that!
That was the first freeware I installed upon your earlier advice, and the one I eventually came back to.  The PortableApps.com link you provided is still much appreciated, as I had to chase DB Browser to its new home page from the old SouroceForge location.  PortableApps.com is now my newest RSS subscription.

I appreciate the advice for noobs, too.  While I've been dealing databases via SAS, S-Plus and the like for close to two decades now,  I'm not immune the occasional dain bramaged file handling error.  I'd imagine unlocking the DB while QuiteRSS is still in play would be a very bad thing indeed!

 

Sheldon
So the SQL stuff shouldn't be

So the SQL stuff shouldn't be a big deal for you.

Just get the feed ids from table feeds and for the rest refer to table news.

Feel free to ask if there is any question left.