Research:Ideas/Oxford Hackathon Notes
From Meta, a Wikimedia project coordination wiki
Contact
Computermacgyver 
This page documents a proposed research project.
Information may be incomplete and may change before the project starts.
Notes from the 9 November hackathon meetup in Oxford
Documentation
[edit ]There are two getting started tutorials:
- https://wikitech.wikimedia.org/wiki/Getting_started
- https://meta.wikimedia.org/wiki/Research:Labs2/Getting_started_with_Tool_Labs
Database schema are at:
- https://wiki.toolserver.org/view/Database_schema
- https://www.mediawiki.org/wiki/Manual:Database_layout
Wikidata database scheme at (not sure if this is the latest?)
Other useful resources are
Other
[edit ]Cool projects
- https://snuggle.grouplens.org/
- http://en.wikichecker.com/
- Adding geotagged data and articles for municipal monuments in the Netherlands through CSV bulk upload facility. Desire to translate and make available on other wikis where useful. interface progress
Example SQL queries:
SELECTrc_user_text,count(*) FROMrecentchanges WHERErc_title="Fluorine"ANDrc_namespace=0GROUPBY1ORDERBY2;
WikiData example: get Spanish title for English United Kingdom article
SELECTb.ips_site_pageFROMwb_items_per_sitea LEFTJOINwb_items_per_siteb ONa.ips_item_id=b.ips_item_id WHEREa.ips_site_id='enwiki'ANDa.ips_site_page='United Kingdom'ANDb.ips_site_id='eswiki';
Ready to create a project page?