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);