Research:Ideas/Oxford Hackathon Notes
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
editThere 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
editCool 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:
SELECT rc_user_text, count(*)
FROM recentchanges
WHERE rc_title="Fluorine" AND rc_namespace=0 GROUP BY 1 ORDER BY 2;
WikiData example: get Spanish title for English United Kingdom article
SELECT b.ips_site_page FROM wb_items_per_site a
LEFT JOIN wb_items_per_site b
ON a.ips_item_id=b.ips_item_id
WHERE a.ips_site_id='enwiki' AND a.ips_site_page='United Kingdom' AND b.ips_site_id='eswiki';
Ready to create a project page?