Jump to content

Research:Ideas/Oxford Hackathon Notes

From Meta, a Wikimedia project coordination wiki


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:

Database schema are at:

Wikidata database scheme at (not sure if this is the latest?)

Other useful resources are

Other

[edit]

Cool projects

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?


References

[edit]