Here are the steps to manually remove old entries from the nntp//rss database. More flexible expiration options will be in the v0.4 release of nntp//rss, however in the interim these instructions will allow you control the size of an existing database.

Within a few moments a GUI window will appear. It should have a tree view in the left pane showing the three nntprss tables - CHANNELS, ITEMS, CONFIG. If these do not appear, stop the Database Manager, wait a few moments, then restart. It may be possible that the database is still being initialized.

6. To purge items older than a certain date, enter the following command into the text entry pane of the Database Manager: (this example removes all entries that were received before 1st July 2003)

Note that this will delete in all channels items that were created before the specified date .

7. Click on the EXECUTE button to execute the request. Depending upon the size of your database, this process may take some time. At the end of deletion, you'll be presented with a result that indicates the number of items removed.

9. Click on the EXECUTE button. The database will now compact itself, recovering the space of the deleted items. Again, this process may take a few moments. When it has completed, you will note that the database process you started in step 3 has terminated. At this stage you can shutdown the Database Manager.

I'm using nntp//rss v0.5b1 since january, and I have yet to see it purge anything. So far all messages retrieved since then are still in the database. And expiration is set to 2 weeks.
Any idea why "purge" doesn't work on my system ? (win98)

jason wrote:Zed - I will look into this issue. Please confirm how are you checking to see if items have been purged.

e.g. Using a different newsreader, Monitoring the list of messages in the groups in your current newsreader, monitoring the size of the Derby database files / MySQL tables.

First there is a clue: reading new messages automatically in the "slashdot" group is getting slower and slower.

Then, there is the confirmation with all the groups. I purge the messages in my newsreader, then ask it to fetch headers for all available messages. Bingo, I'm getting messages as old as 23/1/2005 in all the group existing at this date.
I don't remember anymore if I've kept (probably not) all the messages in the database when I've upgraded to v0.5, and if somehow they have been purged since then. But 23/1/2005 is not 2 weeks old.

nntp//rss uses Apache Derby as its default embedded database. If you download the Derby distribution (available from http://incubator.apache.org/derby ), derbytools.jar in the distribution contains an interactive command line interface through which you can execute SQL queries.

You should also be able to use any JDBC-capable database manager. I believe there are a few available in open source.

Apologies for the delayed response. I haven't had much time to work on nntp//rss recently, due to other obligations. I will try and make a new build available of nntp//rss within the next week which will include the patches.

If you're interested in helping me out with some pre-release tests, please send a email to me (jason at methodize.org).