[Labs-l] Cross database joins

Brad Jorsch (Anomie) bjorsch at wikimedia.org
Sat Oct 19 15:33:06 UTC 2013


On Sat, Oct 19, 2013 at 6:49 AM, Maarten Dammers <maarten at mdammers.nl> wrote:
> On the Toolserver both Commons and Wikidata are on each database cluster,
> unfortunately that's not the case for labs. When can I do cross database
> joins? I would like to join Commons with Wikipedia and Wikidata with
> Wikipedia.

Last I heard there's supposed to be commonswiki_f_p and
wikidatawiki_f_p for that purpose (the "_f" stands for "foreign"), but
they seem to only exist on s1 at the moment.


-- 
Brad Jorsch (Anomie)
Software Engineer
Wikimedia Foundation



More information about the Labs-l mailing list