Research:Ideas/Oxford Hackathon Notes

Contact

Computermacgyver

---

Research:Projects

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

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?)

• https://www.mediawiki.org/wiki/Wikibase/Schema
• https://www.wikidata.org/wiki/Wikidata:Glossary

Other useful resources are

• list of namespace ids

Other

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:

    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?