Home

Just finished sailing the world aboard sailinghannahpenn.co.uk.

Now working at lightbug.io

Previously a staff software engineer working for Wikimedia Deutschland on various projects including Wikibase, Wikidata and MediaWiki.

My side projects are numerous, and you can read about them on a dedicated page.

I use the username “addshore” in most places, such as GitHub, Mastodon, Twitter, Keybase & Wikimedia. Hence the name of this site.

Take a look at my latest posts or various projects.

You can also get in touch with me using my contact page.

Latest Posts

  • Wikidata, instance of and subclass of through time (P31 & P279)
    Last month I looked at all Wikimedia Commons revisions and managed to generate some data and graphs for the usage of depicts statements since they were introduced on the project. This month, I have applied the same analysis on Wikidata but looking at instance of and subclasses of…
  • Online RDS column type modification, using pt-online-schema-change from EC2
    I’m using percona-tools to do an online schema modification today, and thought I would document the process, especially as even the installation guides seem to be badly linked, out of date, and did not work out of the box… EC2 instance This is all running on a t3.micro…
  • What is Wikibase “Federated Properties” in 2025
    I recently wrote a post looking at the history of the Wikibase “Federated Properties” feature. While at Wikimania 2025 the topic of federation came up a few times, particularly given the current discussions ongoing on the Wikidata project chat page including discussions about wikicite, and the recent Wikidata…
  • What was Wikibase “Federated Properties”
    The “Federated Properties” feature allows / allowed a local Wikibase instance to access and utilise properties directly from a remote Wikibase, primarily Wikidata. Its primary purpose is to enable partial federation between a local Wikibase and Wikidata, broadening the base of available data without needing to create a…
  • Wikimedia Commons Depicts statements over time
    Wikimedia Commons now uses Structured Data on Commons (SDC) to make media information multilingual and machine-readable. A core part of SDC is the ‘depicts’ statement (P180), which identifies items clearly visible in a file. Depicts statements are crucial for MediaSearch, enabling it to find relevant results in any…