Delete Old Unread News

14 posts / 0 new
Last post
windpc10

Is there a way to delete old unread news?  I'm trying to decrease the size of my feeds database.  I have too many individual feeds to delete manually.

windpc10
I mean by date--say delete

I mean by date--say delete everything before 2020?
 

Funcy-dcm
Menu - Tools - Clean Up

Menu - Tools - Clean Up

windpc10
I ran Clean Up with "Maximum

I ran Clean Up with "Maximum age of news to keep"=365 and "Never delete unread news" checked.  After Clean Up there are unread titles from 2009 but read titles from 2020 were deleted. I ran Clean Up again with "Never delete unread news" unchecked but the 2009 titles remain. I want to delete all titles before 2019 regardless of wether they've been read and I want to keep all 2019 and 202 titles read or not. The only way I see how to do that is to manually delete them from each feed individually.

Sheldon
Hi,

Hi,

unfortunately there is no such on board functionality available in QuiteRSS.

But you can use a db tool like SQLite Expert to do this.

Please download the setup from

http://www.sqliteexpert.com/

and install it.

Come back to me when you are done. 

Kind regards,

Sheldon

windpc10
I have a SQLite editor now.

I have a SQLite editor now. Do I execute a SQL statement?

Sheldon
I assume it's SQLite Expert.

I assume it's SQLite Expert.

So you simply want to delete all news from before 2019-01-01.
First you need to decide which date to refer to.
published: the date the news was published
received: the date the news was received by QuiteRSS
Let's assume you choose received.

Please follow these instructions:

- Quit QuiteRSS if it is running
- Create a backup/copy of feeds.db !!!
For the location refer to
Help -> About -> Information

- Start SQLiteExpert
- Go to

File -> Open Database

and select feeds.db

- Go to

Database -> Check

What's the result?

- If it's "OK" copy this query

Select *
  from news
 where received < '2019-01-01'

to the SQL panel and click "Execute SQL".
This provides the data you want to delete.

- If the data is correct go to

Transaction -> Begin Transaction

and do the same as before with this query

update  news
    set deleted = 2
 where received < '2019-01-01';
commit;

- Close SQlite Expert and check the data in QuiteRSS.

- To  physically delete the data start SQlite expert and go to

Transaction -> Begin Transaction

and do the same as before with this query

delete news
where deleted = 2;
commit;

- Go to

Database -> Vacuum

 

windpc10
Thanks! That worked. The

Thanks! That worked. The database is smaller, but QuiteRSS still hangs.

https://quiterss.org/en/forums/bugs/quiterss-01812-hangs

Woody
Woody's picture
Does it have to be Expert or

Does it have to be Expert or can you simply use Lite?

Off topic, but would like to know if there are any command switches with QuiteRSS
Something like -c to close or -b to backup

Reason that I am asking is that I was hoping to maybe write a batch file so that I can automate this process somewhat in dos or PS

Thank you,
Wøødy

Sheldon
You can use the SQLite editor

You can use the SQLite editor of your choice. But for an example I need to stick to one.
SQlite Expert is quite convenient because of some features other editors don't provide.

Unfortunately there are no such switches. But there are shortcuts.
For automization I recommend using AutoHotkey. You can get it from here

https://www.autohotkey.com/download/.

Woody
Woody's picture
I don't do a lot of work in

I don't do a lot of work in SQL, actually this is a learning curve kind of thing... Last time I did database work, DB-V was all the rage Wink
Clicking an Icon, I can manage. I am more interested and automating the older than 90 days thing. The rest is minor stuff
Thank You Sheldon,

Sheldon
Please go to

Please go to

Tools -> Options -> Feeds -> Tab "Clean Up"

windpc10
After running Update Feed the

After running Update Feed the database size is doubled. Some old articles come in as newly published and a lot of old articles show up in the feeds again. So I ran Clean Up and Purge DB but the file size didn't change. Is there any way to shrink the feeds database and keep it small?

Woody
Woody's picture
Hello

Hello
As a followup I am perplexed to say that the 'Clean Up' icon now works without making any changes...
I had done some testing on my Gaming PC but never just got the same results so I never carried any changes to my Work PC
I will take the positive, but things 'just' starting to work without intervention always leaves me a little uneasy.
Cordially,
Wøødy