Submissions:2019/Quarry tutorial: Using SQL to get info about wikis

From WikiConference North America
Jump to: navigation, search

This submission has been accepted for WikiConference North America 2019.


Quarry tutorial: Using SQL to get info about wikis


Relationship Building & Support
+ Tech & Tools

Type of session:



This will be an introduction to SQL, with a specific focus on using to do data analysis about Wikimedia wikis. It is hoped that this tutorial will especially be helpful to people involved in doing outreach so they can run stats to see how successful various activities are.

Participants do not need any previous experience with SQL or programming, but should have at least a basic understanding of how to edit Wikipedia. It is recommended but not required that participants bring laptops so they can try things out throughout the workshop.

By the end of the workshop, participants would for example, know how to:

  • Given a list of users, see how many edits they have made in a specific time frame (e.g. Check to see if people stay active after an event)
  • Given a specific category, see how many edits there are to pages in that category over time (e.g. To see if an event made a noticeable difference in the editing pattern of some articles, and did the effect persist)
  • TODO: Come up with more examples that would be especially relevant to this audience.


Academic Peer Review option:


Author name:

Brian Wolff

E-mail address:

Wikimedia username:


Affiliated organization(s):

Estimated time:

60 min

Preferred room size:


Special requests:


Have you presented on this topic previously? If yes, where/when?:

If your submission is not accepted, would you be open to presenting your topic in another part of the program? (e.g. lightning talk or unconference session)

It could perhaps fit in an unconference session