search

scripting / feedBase

A project to get feeds into a base.
MIT License
33 stars 3 forks source link

Monday work #10

Open scripting opened 6 years ago

scripting commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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