So I'll be busy finding uses of this table, and changing them, for the next week or two...
Note that since now I have to use substring comparisons in queries (instead of integer comparisons), for example with wb_terms, SQL queries will run slower as a result. On Thu, Jun 1, 2017 at 2:08 PM Lydia Pintscher <[email protected]> wrote: > Hi everyone, > > This is an important message to all the people running external tools. > > About 2 years ago we said we want to get rid of the > "wb_entity_per_page" table. This is still the case and is becoming > more pressing now with the introduction of support for lexicographical > data. > > On July 12th, we are going to stop updating the "wb_entity_per_page" > table from the Wikibase database and stop its replication on ToolLabs. > At a later point we will remove it completely. > > "wb_entity_per_page" was a secondary database table, mapping Wikibase > entity IDs (e.g. "Q42") to MediaWiki page IDs (e.g. 138, which can be > seen at https://www.wikidata.org/wiki/Q42?action=info). > "wb_entity_per_page" stored entity IDs as numbers, while page titles > are always full entity IDs. > > This mapping existed because Wikibase was designed with the > possibility to have entity pages where the ID does not match the > title. This idea was never used, and finally removed in 2015 > (documented in https://phabricator.wikimedia.org/T95685). We decided > to get rid of the table because it contains outdated information that > could mislead users, it costs resources and could conflict in the > future with our new entity types for lexicographical data. > > Please check if you are maintaining any code that accesses the > "wb_entity_per_page" table, and replace it with lookups to MediaWiki's > "page" and "redirect" tables. > > We will drop the replica of the table on ToolLabs for > test.wikidata.org on June 28th. We will do the same for wikidata.org > on July 12th. > > If you have any question or issue, feel free to add a comment on the > ticket (http://phabricator.wikimedia.org/T95685) or to ping me. Thanks > for your understanding > > > Cheers > Lydia > > -- > Lydia Pintscher - http://about.me/lydia.pintscher > Product Manager for Wikidata > > Wikimedia Deutschland e.V. > Tempelhofer Ufer 23-24 > 10963 Berlin > www.wikimedia.de > > Wikimedia Deutschland - Gesellschaft zur Förderung Freien Wissens e. V. > > Eingetragen im Vereinsregister des Amtsgerichts Berlin-Charlottenburg > unter der Nummer 23855 Nz. Als gemeinnützig anerkannt durch das > Finanzamt für Körperschaften I Berlin, Steuernummer 27/029/42207. > > _______________________________________________ > Wikidata-tech mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikidata-tech >
_______________________________________________ Wikidata-tech mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-tech
