Hello all,
This is a follow-up on previous announcements related to the migration of
wb_terms table (March 23rd
<https://www.wikidata.org/wiki/Wikidata:Project_chat/Archive/2020/03#Important_for_tool_maintainers:_last_steps_of_wb_terms_table_migration>,
April 6th
<https://www.wikidata.org/wiki/Wikidata:Project_chat/Archive/2020/04#wb_terms_table_will_be_empty_today>)
that concerns tool developers querying the database replicas on Labs.
As the last step of the migration, and as mentioned in the previous
discussions, the table wb_terms_no_longer_updated will be dropped. We are
doing this because the last steps of database migration have been achieved
and announced a month ago, and we don’t want to keep a table containing
outdated information accessible for too long. The table has already been
deleted in production (without any impact on tools or users) and the
replicas on Labs will be deleted on April 29th. (Ticket
<https://phabricator.wikimedia.org/T248086>)
If you’re maintaining tools querying the database with the replicas, you
can adapt your code to the new table structure
<https://doc.wikimedia.org/Wikibase/master/php/md_docs_storage_terms.html>
(the former shared link doesn't work anymore). You can also have a
look at suggestions
to optimize your queries
<https://www.wikidata.org/wiki/User:Amir_Sarabadani_(WMDE)/Database_normalization>.
If you have any questions or issues, feel free to reach out to me. Thanks
for your understanding,
--
Léa Lacroix
Project Manager Community Communication 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.