Hi Marius,
hoo schreef op 7-8-2015 om 19:55:
Hey folks,
we plan to drop the wb_entity_per_page table sometime soon[0], because
it is just not required (as we will likely always have a programmatic
mapping from entity id to page title) and it does not supported non
-numeric entity ids as it is now.
In the past I was alway told to use the
wb_entity_per_page table instead
of doing page_title=CONCAT('Q', <id>). The Wikibase code used to contain
warnings not to make this assumption. I don't know, they might still be
there.
Due to this removing it is a blocker
for the commons metadata.
That's unfortunate.
Is anybody using that for their tools (on tool labs)?
If so, please
tell us so that we can give you instructions and a longer grace period
to update your scripts.
Of the 117 Wikidata related sql queries that seem to be in
my homedir,
48 of them use this table. Basically any Wikidata related tool that uses
the sql database will break. What do you propose? That we start messing
around with CONCAT()s in our SQL queries? Besides the hours of wasted
volunteer time, that's probably a lot slower.
Maarten