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.
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
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
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
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,
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?
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
I mean by date--say delete everything before 2020?
Menu - Tools - Clean Up
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.
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
I have a SQLite editor now. Do I execute a SQL statement?
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
Thanks! That worked. The database is smaller, but QuiteRSS still hangs.
https://quiterss.org/en/forums/bugs/quiterss-01812-hangs
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
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/.
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
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,
Please go to
Tools -> Options -> Feeds -> Tab "Clean Up"
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?
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