On Thu, Jan 15, 2015 at 4:42 PM, Dan Andreescu <dandreescu(a)wikimedia.org
Sorry, old thread, but I wanted to point out
that
http://quarry.wmflabs.org seems like a good tool for this use case.
On Wednesday, December 24, 2014, Leila Zia <leila(a)wikimedia.org> wrote:
> Hi Neta,
>
> On Wed, Dec 24, 2014 at 7:19 AM, Neta Livneh <neta.livneh(a)gmail.com>
> wrote:
>
>>
>> Actually, this is a great opportunity to say that I would love to get
>> you guys involved or at least hear insights from the analytics team
>> regarding the project's direction.
>>
>
> Feel free to keep me in the loop for the latter.
>
> Best,
> Leila
>
>
>>
>>
>> On Wed, Dec 24, 2014 at 4:39 PM, Aaron Halfaker <
>> ahalfaker(a)wikimedia.org> wrote:
>>
>>> Here's the instructions that Christian gave with some screenshots
>>> and discussion:
>>>
https://meta.wikimedia.org/wiki/Research:Labs2/Getting_started_with_Tool_La…
>>>
>>> If you're just looking to run a few queries, you might consider
>>>
http://quarry.wmflabs.org which requires no shell access -- just a
>>> Wikimedia sites account.
>>>
>>> -Aaron
>>>
>>> On Wed, Dec 24, 2014 at 7:22 AM, Christian Aistleitner <
>>> christian(a)quelltextlich.at> wrote:
>>>
>>>> Hi Neta,
>>>>
>>>> On Wed, Dec 24, 2014 at 11:28:33AM +0200, Neta Livneh wrote:
>>>> > For my project, we will need to sql queries on current wikipedia
>>>> data
>>>> > (mostly revision history table).
>>>> >
>>>> > I already have a Gerrit account. Can I get SSH access for running
>>>> such
>>>> > queries?
>>>>
>>>> It sounds like the redacted labs databases would nicely fit your use
>>>> case. The easiest way to get access there is to apply for Tool Labs
>>>> [1].
>>>>
>>>> To get access, please file a request through
>>>>
>>>>
>>>>
https://wikitech.wikimedia.org/wiki/Special:FormEdit/Tools_Access_Request
>>>>
>>>> (Many parts around the WMF are currently getting migrated to
>>>>
phabricator.wikimedia.org, so if someone knows a phabricator
>>>> procedure
>>>> for that please chime in!)
>>>>
>>>>
>>>> Once you've got Tool Labs [1] access you can ssh to
>>>>
>>>>
tools-login.wmflabs.org
>>>>
>>>> and running
>>>>
>>>> sql enwiki
>>>>
>>>> on that host connects you to labsdb's enwiki database and you can
>>>> run
>>>> your queries there (similar for other wikis).
>>>>
>>>> Have fun,
>>>> Christian
>>>>
>>>>
>>>>
>>>> [1]
https://wikitech.wikimedia.org/wiki/Help:Tool_Labs
>>>> has more information and links about Tool Labs.
>>>>
>>>>
>>>> --
>>>> ---- quelltextlich e.U. ---- \\ ---- Christian Aistleitner ----
>>>> Companies' registry: 360296y in Linz
>>>> Christian Aistleitner
>>>> Kefermarkterstrasze 6a/3 Email: christian(a)quelltextlich.at
>>>> 4293 Gutau, Austria Phone: +43 7946 / 20 5 81
>>>> Fax: +43 7946 / 20 5 81
>>>> Homepage:
http://quelltextlich.at/
>>>> ---------------------------------------------------------------
>>>>
>>>> _______________________________________________
>>>> Analytics mailing list
>>>> Analytics(a)lists.wikimedia.org
>>>>
https://lists.wikimedia.org/mailman/listinfo/analytics
>>>>
>>>>
>>> _______________________________________________
>>> Analytics mailing list
>>> Analytics(a)lists.wikimedia.org
>>>
https://lists.wikimedia.org/mailman/listinfo/analytics
>>>
>>>
>>
>> _______________________________________________
>> Analytics mailing list
>> Analytics(a)lists.wikimedia.org
>>
https://lists.wikimedia.org/mailman/listinfo/analytics
>>
>>
>
_______________________________________________
Analytics mailing list
Analytics(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics