Re: [Wikitech-l] Querying the database

2013-05-23 Thread Tuszynski, Jaroslaw W.
to handle queries like mine. Jarek T. User:jarekt -Original Message- From: wikitech-l-boun...@lists.wikimedia.org [mailto:wikitech-l-boun...@lists.wikimedia.org] On Behalf Of Ryan Kaldari Sent: Wednesday, May 22, 2013 8:06 PM To: wikitech-l@lists.wikimedia.org Subject: Re: [Wikitech-l

Re: [Wikitech-l] Querying the database

2013-05-23 Thread Tim Landscheidt
Tuszynski, Jaroslaw W. jaroslaw.w.tuszyn...@saic.com wrote: Thanks for all the advice and for Tim.Landscheidt who run for me https://jira.toolserver.org/browse/DBQ-201, the query that was the catalyst for my email. I wish there were clones or alternatives to toolserver based CatScan2

[Wikitech-l] Querying the database

2013-05-22 Thread Tuszynski, Jaroslaw W.
I do a lot of maintenance tasks on Commons, and many tasks require some sort of database query to find the oddball cases. The queries can be done through one of several ways: 1) Using CatScan and CatScan2[2] tools 2) Database query service [3] 3) Weekly Database reports [4] Unfortunately lately

Re: [Wikitech-l] Querying the database

2013-05-22 Thread Petr Onderka
This is probably not what you want to hear, but one way would be to get a Toolserver account. That way, you wouldn't need the query service, you could run those queries by yourself. Petr Onderka [[en:User:Svick]] On Wed, May 22, 2013 at 10:03 PM, Tuszynski, Jaroslaw W.

Re: [Wikitech-l] Querying the database

2013-05-22 Thread John
Feel free to drop me a mail off list, Ive got a TS account and will gladly lend a hand with the reports On Wed, May 22, 2013 at 4:24 PM, Petr Onderka gsv...@gmail.com wrote: This is probably not what you want to hear, but one way would be to get a Toolserver account. That way, you wouldn't

Re: [Wikitech-l] Querying the database

2013-05-22 Thread Marc A. Pelletier
On 05/22/2013 04:03 PM, Tuszynski, Jaroslaw W. wrote: So are there any non-toolserver based alternatives for database queries? Well, there are always the Tool Labs[1]. Database replica access is still experimental/in trial but it works. -- Marc [1]

Re: [Wikitech-l] Querying the database

2013-05-22 Thread Ryan Kaldari
There's also stat1.wikimedia.org, but I'm not sure who all has access to that. I think just WMF staff and WMF-approved researchers, but I could be wrong. Ryan Kaldari On 5/22/13 2:28 PM, Marc A. Pelletier wrote: On 05/22/2013 04:03 PM, Tuszynski, Jaroslaw W. wrote: So are there any