Monday work

[scripting]

First thing --

ALTER TABLE feeds ADD ctErrors INT DEFAULT 0;
ALTER TABLE feeds ADD ctConsecutiveErrors INT DEFAULT 0;
ALTER TABLE feeds ADD ctChecks INT DEFAULT 0;
ALTER TABLE feeds ADD whenLastError DATETIME;

Now I'm going to add code to track these values for feeds.

[scripting]

Version 0.4.19 is up, it updates the new columns in the feeds table as we do our periodic check.

This is a major change because we have to read the record before updating it so we can add 1 to the counts that are now in the record.

Here's the changes.

[scripting]

v0.4.20 is up.

We now write out the feedInfo in JSON to a sub-folder of the data folder every time we check.

This makes restoring the database faster, and preserves the computed fields.

Only protecting the feeds table. We're already saving the user's OPML file, so the subscriptions table can be reconstructed from that.

[scripting]

There's now a ping call. If you update your feed's metadata and want feedBase to record the change right away.

http://feedbase.io/ping?feedurl=http://scripting.com/rss.xml