On dim, 2002-03-31 at 14:22, Lorraine Lee wrote:
I think I'm metadata-aware enough to be trusted with read-only SQL access to wikipedia, but I've been wrong in the past and can't think of anything immediately useful I'd do if I did have select access.
Since it appears to be a fairly strongly copyleft project, I assume you have published its SQL data model?
The table setup statements are in "wikipedia.sql" in the source tree; nothing's really documented as such, but it's mostly pretty self-explanatory*. You can browse the files in the CVS repository: http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/wikipedia/phpwiki/fpw/
* The cur_id, old_id, cur_old_version, and old_old_version fields are used to put together linked lists of version histories.
A dump of the database (80 megs compressed) is available at: http://www.wikipedia.com/tarballs/wikipedia_dump_20020321.sql.gz
-- brion vibber (brion @ pobox.com)