[Commons-l] Towards a Commons API

[Gregory Maxwell]

On 8/17/07, Stephen Bain <stephen.bain at gmail.com> wrote:
> We do keep timestamp data in the categorylinks table, so it's possible
> to work out roughly when a page was added to a category. However,
> AFAIK this is not actually used anywhere.

Enwp used the category timestamps for some automated prod tool on
toolserver a while back. I think they found the data lacking, since
any blanking/revert cycle renewed it.

For us it will probably be okay.

> Note that it would be good if some technical types can check this out
> to make sure it actually works.

We carry an index on cl_to,cl_timestamp  and it appears your query
will correctly use it.. I don't see anything obviously broken from
that perspective. But thats about all I can offer because my mediawiki
internal kungfu is weak.