Tool to monitor additions of articles to categories, for use in WikiProjects.

Example: http://no.wikipedia.org/w/index.php?title=Portal:Russland/Nye_artikler

Category members are read from the Wikipedia MySql database, using the replicated copy at Toolserver, and cached in a local SQLite3 file.

To get started, run sqlite3 catmonitor.db and

CREATE TABLE articles (
  category TEXT NOT NULL,
  article TEXT NOT NULL,
  date_added DATE NOT NULL, 
  date_created DATE,
  PRIMARY KEY (category,article)
);
CREATE INDEX date_added ON articles(date_added);
CREATE INDEX date_created ON articles(date_created);