[00:14:26] PROBLEM - High lag on wdqs1001 is CRITICAL: CRITICAL: 48.28% of data above the critical threshold [1800.0] [00:15:26] RECOVERY - High lag on wdqs1001 is OK: OK: Less than 30.00% above the threshold [600.0] [08:44:24] what are the aspects in https://www.mediawiki.org/wiki/Wikibase/API#wbentityusage ? [08:45:28] I cannot find them documented anywhere [08:47:24] or more generally, what is the best way to query wikidata ids for list of pages in wikipedia? [08:48:56] Nikerabbit: if you mean a list of many thousands, the answer has often been SPARQL; for millions, if SPARQL doesn't cope, a dump [08:49:58] Nemo_bis: programmatically... as far as I know there is no production SPARQL I can use in a deployed extension [08:51:06] query.wikidata.org is still considered production but yes, there are ongoing debates on whether a deployed extension could/should rely on it [08:53:40] Nemo_bis: it is out of question for this use case [08:56:45] https://en.wikipedia.org/wiki/Special:ApiSandbox#action=query&format=json&prop=wbentityusage&titles=Helsinki%7CTurku%7CLahti%7CLondon%7CNew+York+City seems not to do what I expect/want [08:58:10] https://en.wikipedia.org/wiki/Special:ApiSandbox#action=query&format=json&prop=pageprops&titles=Helsinki%7CTurku%7CTampere%7CLondon%7CNew+York+City&formatversion=2&ppprop=wikibase_item does [09:16:43] Nikerabbit: I cannot answer the question about querying you had (hopefully someone else could) but the place documenting those aspect I know is docs/usagetracking.wiki in Wikibase repository [09:16:48] ie https://phabricator.wikimedia.org/diffusion/EWBA/browse/master/docs/usagetracking.wiki [09:34:52] leszek_wmde: thanks, though it turned out I don't need those in the end [09:49:57] even with the docs usagetracking can be hard to understand ;) [12:13:00] DanielK_WMDE: I joined but no one is there. [12:20:06] Amir1: it is in one hour (the planning etc meeting) [12:20:16] we're out of DST now :) [12:20:24] leszek_wmde: Oh, I forgot :)))) [12:20:47] thanks for reminding [12:21:01] doesn't google calendar do those calculations? [12:21:16] but yeah, it is probably tricky [12:23:10] my google calendar seems to be not happy. [12:23:24] takes forever to load [12:31:48] :P [15:43:26] Q: Is anyone working on a visual/non-text-based wikidata query editor? Is one planned? [16:19:05] YairRand: I have trouble imagining one, tbh [16:20:48] dennyvrandecic: Really? I have several competing ideas in my head for what one would look like, any of which seem like it could be usable. (Very complex queries might be somewhat difficult, though.) [16:21:22] it's ok to start with less complext but more frequent ideas, YairRand - I'd love to see those ideas. [16:21:44] I'm imagining a whole bunch of boxes representing ?values with draggable arrows and stuff [16:21:54] YairRand: If you have the time, it would be great just to sketch them. As said, I have trouble imagining them. [16:22:13] yes, i don't really see how that would work, but maybe that's just me :) [16:22:52] let's put it this way: I haven't seen anything that convinced me so far, neither for SQL nor SPARQL, which is why I am probably negatively biased to the idea [16:23:02] but I would positively love to have to change my mind on this [16:23:30] because i think that if this is done well, it could open up wikidata to a whole new set of people [16:23:37] which would be great [22:15:40] YairRand dennyvrandecic_ I am also very interested in that topic! [22:18:14] I have some experience with the tools (sparqljs, visjs network) we use on query.wikidata.org and how users appreciate that possibilities. The challenge I see is not only SPARQL, but also the data model