Hi Nuria and Adrian,

I also need to develop some Wikidata related Data Science things for WMDE, where I've started working as a Data Analyst in March. I work from R entirely (+SPARQL +SQL +etc). It is not impossible that I will be facing a problem similar to Adrian's, so I have hoped you wouldn't mind if I hijack this discussion for a mail or two. 

A question for Nuria: I understand that the production machines can be used to run analyses, as well as that we should avoid doing development there (I have a Labs instance where the development will be taking place), but I do not understand your following advise to Adrian: "It seems like you would benefit from querying a development instance of wikidatata and looking at development logs to know what to expect." - Nuria, what exactly do you have in mind when you say "a development instance of Wikidata"? 

Also, very important for me: are you implying that no attempts to access the SPARQL endpoint from production should be made? If yes, why, and what would be the alternative, suggested route to Wikidata from production? Or - this is my final attempt at the correct interpretation of your words - do you want to say that we should use production for statistics *exclusively*, in a sense that no datasets (except for, say, weblogs and mariaDB replicas on equiad) shoul be fetched from the production machines (i.e. implying that we need to collect the data somewhere else, and move to production for number crunching only)?

Thank you.

Best regards,
Goran Milovanović
Data Analyst, WMDE 


On 13 May 2017 22:40, "Nuria Ruiz" <nuria@wikimedia.org> wrote:
Adrian,

>At the moment I'm working on checking which entries equal one of the example queries at https://www.wikidata.org/>wiki/Wikidata:SPARQL_query_service/queries/examples using this code.

The stats machines are useful to analyze data but we do not use them to do development. It seems like you would benefit from querying a development instance of wikidatata and looking at development logs to know what to expect. We strongly advise against doing development in production, looking at logs in a development environment would be synchronous so you can get your answers fast.

Thanks,

Nuria

On Sat, May 13, 2017 at 5:47 PM, Addshore <addshorewiki@gmail.com> wrote:
You should be able to connect to query.wikidata.org via the webproxy.


On Sat, 13 May 2017 at 15:23 Adrian Bielefeldt <Adrian.Bielefeldt@mailbox.tu-dresden.de> wrote:
Hello Nuri,

I'm working on a project analyzing the wikidata SPARQL-queries. We extract specific fields (e.g. uri_query, hour) from wmf.wdqs_extract, parse the queries with a java program using open_rdf as the parser and then analyze it for different metrics like variable count, which entities are being used and so on.

At the moment I'm working on checking which entries equal one of the example queries at https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples using this code. Unfortunately the program cannot connect to the website, so I'm assuming I have to create an exception for this request or ask for it to be created.

Greetings,

Adrian
_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics

_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics



_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics