Wikipedia:Wikipedia Signpost/2019-06-30/Technology report

Actor migration
Early this month, the mediawiki databases underwent a significant change, with 8 database tables each dropping 2 columns and gaining a new one, and a new database table being created. Each of the 8 tables formerly held references to both the s, and  s of the users/IPs that had performed the relevant log entry / edited the relevant revision / had been blocked / etc. Storing this information in each of the 8 tables, in addition to its existence in the   table, was a waste of storage and led to performance issues. Accordingly, these references were replaced with references to the relevant  instead, and a new table, the (coincidentally named)   table, was created. The new table associates an  with a   and a , and different revisions or log entries need only refer to the relevant. This change is also forecasted to dramatically speed up global renames, since, rather than changing the  and   associated with all of a user's edits and log entries, only the information in a single   row needs to be updated.

For more information, see:
 * T223406 - the phabricator task corresponding to the actor migration
 * T188327 - the phabricator task corresponding to the schema change
 * mw:Actor migration - the explanation on mediawiki

Recently approved tasks

 * (Tasks: 6, 7)
 * (Tasks: 38, 45)

Current requests for approval

 * Open
 * (Tasks: 49, 50)
 * (Tasks: 8, 9)
 * (Tasks: 18, 19)
 * (Tasks: 18, 19)


 * In trial


 * Trial complete
 * (Tasks: 5, 7)
 * (Tasks: 5, 7)
 * (Tasks: 5, 7)

Latest tech news
Latest tech news from the Wikimedia technical community: 2019 #23, #24, #25, & #26. Please tell other users about these changes. Not all changes will affect you. Translations are available on Meta.


 * You can now write all special letters in all African Wikipedia languages. This works in the desktop version.
 * There is now a field called  on Commons. This is a way to show what is in a picture with the help of Wikidata. It is still in development.
 * Some tools on Toolforge may break on or after 3 June because of database changes. Maintainers should update their tools to use the new schema.
 * Some wikis have one tab for the visual editor and one tab for a wikitext editor. Others wikis just have one tab. If your wiki has two tabs, clicking a link to create a new page has always opened a wikitext editor. It will now open the editor you used the last time you edited.
 * When you create a PDF from a page on the wiki this is now done by Proton. Before this we used Electron. It should look the same but work better. Both use Chromium. This is a different system from when you collect several articles into a book and make a PDF from them.
 * Most wikis were slow and then briefly read-only last week due to one of the database servers having a problem. It is now replaced.
 * You can watch or join the Wikimedia Language showcase. It was about the usage of Machine Translation in Wikimedia projects. The showcase was on 26 June at 13:00 (UTC). A recording was kept for later viewing.


 * Flagged Revisions
 * The Flagged Revisions extension now uses the standard OOUI icons. There will be additional minor fixes for positioning in the next deployment.
 * Octicons-tools.svg Bots and other scripts that do not set an identifiable User-Agent may find their requests strictly rate-limited until they identify themselves properly.
 * Please check if the Flagged Revisions configuration on your wiki is as you expect (or as it was a few weeks ago). If not, please report it.


 * Media
 * MIDI files can soon be played without the Score extension. You can then add them with . Later   and   will stop working. Instead you will need to add the MIDI file below the music score.
 * A new video player will soon replace the old one. You will be able to enable it as a beta feature in your preferences. It will later be enabled for everyone if there are no big problems.
 * Octicons-tools.svg Some gadgets and user scripts still use the old  and   values. These values are always true. They will soon be removed. This might break the gadgets and scripts. You should fix your gadgets to not use these values.

Meetings

 * Octicons-sync.svg Octicons-tools.svg You can join the technical advice meeting on IRC. During the meeting, volunteer developers can ask for advice. The meeting takes place every Wednesday from 4:00–5:00 p.m. UTC. See how to join here.