Wikimedia CEE Meeting 2019/Programme/Submissions/How to write queries using SQL

From Meta, a Wikimedia project coordination wiki
Title of the submission

How to write queries using SQL

Type of submission (lecture, panel, workshop, lightning talk, roundtable, poster)

Half of time lecture, half of time workshop.

Author(s) of the submission

Anton Obozhyn


--TohaomgTohaomg (talk) 17:56, 18 April 2019 (UTC)[reply]


Wikimedia Ukraine



Abstract (up to 100 words)

SQL is a powerful and comparatively easy, but not widely known, tool to make queries about articles, categories, users, etc. People who organize article contests may find it very useful to be able to make a query "List of articles created during certain period and belonging to certain category". For patrols the query "New users who made more than 100 edits during last week" might be useful. For filemovers a query "Files with title smaller than 8 letters" might be handy. Wikipedians interested in aircraft might use a query "All pages whose title contains the word 'aircraft'". This tool enables to get needed information in seconds, which would otherwise take hours to collect.

How will this session be beneficial for the communities in the region of Central and Eastern Europe?

Every community should have at least one user able to make queries in SQL, which would make activities in Wikimedia projects for members of those communities much more efficient in some situations.

Special requirements


Slides or further information

Interested attendees[edit]

If you are interested in attending this session, please sign with your username below. This will help reviewers to decide which sessions are of high interest. Sign with a hash and four tildes. (# ~~~~).

  1. Jetam2 (talk) 19:03, 25 June 2019 (UTC)[reply]
  2. Yupik (talk) 23:45, 26 July 2019 (UTC)[reply]
  3. Juandev (talk) 18:05, 10 August 2019 (UTC)[reply]
  4. Pinky sl (talk) 16:59, 17 September 2019 (UTC)[reply]