Wikimedia CEE Meeting 2019/Programme/Submissions/How to write queries using SQL
How to write queries using SQL
- Title of the submission
- 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
- Username(s)
--Tohaomg (talk) 17:56, 18 April 2019 (UTC)
- Affiliation
Wikimedia Ukraine
- Topic(s)
Technology
- 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
none
- Slides or further information
- Documentation
Interested attendees
editIf 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. (# ~~~~).