Page MenuHomePhabricator

So9q (Dennis Priskorn)
User

Projects

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Tuesday

  • Clear sailing ahead.

User Details

User Since
Sep 16 2019, 11:47 AM (105 w, 6 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
So9q [ Global Accounts ]

Recent Activity

Thu, Sep 23

So9q closed T291621: wdqs1007 lags 6 hours please depool as Resolved.

fixed now

Thu, Sep 23, 6:38 PM · Wikidata, Wikidata-Query-Service
So9q added a comment to T104750: Make low year numbers less ambiguous .

Nice work :)

Thu, Sep 23, 11:52 AM · MW-1.38-notes (1.38.0-wmf.2; 2021-09-28), Patch-For-Review, Wikidata-Campsite (Wikidata-Campsite-Iteration-∞), Wikidata-Sprint-2015-12-01, Wikidata-Sprint-2015-11-03, DataValues, Wikidata
So9q added a comment to T291488: wdqs1004 lags 16 hours please depool.

Wow 10 min reaction time! 🤩

Thu, Sep 23, 11:11 AM · Wikidata, Discovery-Search (Current work), Wikidata-Query-Service
So9q renamed T291621: wdqs1007 lags 6 hours please depool from wdqs1007 lags 16 hours please depool to wdqs1007 lags 6 hours please depool.
Thu, Sep 23, 11:09 AM · Wikidata, Wikidata-Query-Service
So9q created T291621: wdqs1007 lags 6 hours please depool.
Thu, Sep 23, 11:08 AM · Wikidata, Wikidata-Query-Service
So9q added a comment to T285944: Toolforge: beta phase for the new jobs framework.

I succeeded with help from Cloud Services Support to get https://github.com/dpriskorn/ItemSubjector/tree/prepare-batch working

bild.png (1×1 px, 79 KB)

Thu, Sep 23, 10:57 AM · cloud-services-team (Kanban), Toolforge
So9q awarded T285944: Toolforge: beta phase for the new jobs framework a Love token.
Thu, Sep 23, 10:15 AM · cloud-services-team (Kanban), Toolforge

Wed, Sep 22

Dzahn awarded T291488: wdqs1004 lags 16 hours please depool a Like token.
Wed, Sep 22, 4:31 PM · Wikidata, Discovery-Search (Current work), Wikidata-Query-Service

Tue, Sep 21

So9q created T291488: wdqs1004 lags 16 hours please depool.
Tue, Sep 21, 12:05 PM · Wikidata, Discovery-Search (Current work), Wikidata-Query-Service

Wed, Sep 15

So9q added a comment to T290839: Evaluate a double backend strategy for WDQS.

@Hannah_Bast I could not find the date of the wikidata dump used in the service, is that available in the UI?

bild.png (432×1 px, 37 KB)

Wed, Sep 15, 7:51 AM · Wikidata, Wikidata-Query-Service
So9q added a comment to T290839: Evaluate a double backend strategy for WDQS.

PS: Note that large query throughputs are not a problem for a SPARQL engine that runs on a single standard PC or server. Depending on the overall demand, you can just run multiple instances on separate machines and trivially distribute the queries. What's more important, I think, is the processing time for individual queries because you cannot easily distribute the processing of an individual query. And it does make quite a difference for the user experience whether a query takes seconds, minutes, or hours. The current SPARQL endpoint for Wikidata (realized using Blazegraph) times out a lot when the queries are a bit harder.

Wed, Sep 15, 7:46 AM · Wikidata, Wikidata-Query-Service

Mon, Sep 13

So9q added a comment to T290858: Senses and their statements should not be tied to a language, but instead shared between languages.

This sounds like a really good idea. We would probably need a new namespace: Sense for this to work.

Mon, Sep 13, 2:53 PM · Wikidata, Wikidata Lexicographical data
So9q added a comment to T206561: Evaluate Virtuoso as alternative to Blazegraph.

@KingsleyIdehen maybe you can help shed some light on the questions about Virtuoso here?

Mon, Sep 13, 6:34 AM · Wikidata, Wikidata-Query-Service
So9q added a comment to T206561: Evaluate Virtuoso as alternative to Blazegraph.

I took a glance at Virtuoso.

I found nothing about scaling Virtuoso to a cluster (which is IMO what WMF needs because of growing amounts of data and reaching the limits of what 1 machine can handle)

A snippet from WP:
"Virtuoso is designed to take advantage of operating system threading support and multiple CPUs. It consists of a single process with an adjustable pool of threads shared between clients. Multiple threads may work on a single index tree with minimal interference with each other. One cache of database pages is shared among all threads and old dirty pages are written back to disk as a background process."

Virtuoso IMO is not the way forward for WMF. We need a distributed graph/column database with SPARQL on top. See https://phabricator.wikimedia.org/T289561 for an application that has exactly that (but seems abandoned since dec 2020 unfortunately)

Again, Virtuoso 7.x Open Source Edition scales up to 80 Billion Triples as demonstrated by Uniprot's live instance.

You don't need the Virtuoso Cluster Edition until the scalability of the single-server edition is exhausted. Wikidata is a long way from reaching 80 Billion+ triples.

Key factor here is memory which you get via virtual machines, courtesy of cloud services these days.

Virtuoso has also hosted DBpedia for the last 14 years i.e., since its inception . Growth hasn't been an issue, and won't be going forward.

I hope that helps.

Kingsley

Mon, Sep 13, 6:28 AM · Wikidata, Wikidata-Query-Service
So9q added a comment to T206561: Evaluate Virtuoso as alternative to Blazegraph.

Unfortunately, since all clustering and replication solutions seem to be non-opensource, we would not be able - at least without either using commercial version or getting some kind of special solution or special deal - to use other paradigm of clustering that we're using now.

Mon, Sep 13, 5:33 AM · Wikidata, Wikidata-Query-Service
So9q added a subtask for T206560: [Epic] Evaluate alternatives to Blazegraph: T290839: Evaluate a double backend strategy for WDQS.
Mon, Sep 13, 5:19 AM · MediaWiki-Stakeholders-Group, Wikidata, Epic, Wikidata-Query-Service
So9q added a parent task for T290839: Evaluate a double backend strategy for WDQS: T206560: [Epic] Evaluate alternatives to Blazegraph.
Mon, Sep 13, 5:19 AM · Wikidata, Wikidata-Query-Service
So9q created T290839: Evaluate a double backend strategy for WDQS.
Mon, Sep 13, 5:19 AM · Wikidata, Wikidata-Query-Service
So9q closed T290832: wdqs1004 is lagging as Resolved.

problem solved!

Mon, Sep 13, 5:12 AM · Discovery-Search (Current work), Wikidata, Wikidata-Query-Service

Sun, Sep 12

So9q created T290832: wdqs1004 is lagging.
Sun, Sep 12, 8:10 PM · Discovery-Search (Current work), Wikidata, Wikidata-Query-Service

Sat, Sep 11

So9q added a comment to T290061: improve WD update performance.

I agree, the system is working as designed. Edits on-wiki are prioritized over API edits, which are throttled when WDQS cannot keep up. The worst bottleneck at the moment is Blazegraph and copying over every single item there on every edit.
I suggest closing this ticket.

Sat, Sep 11, 7:20 PM · Data-Quality-Days-2021
So9q added a comment to T221741: Define REST API interface in MediaWiki using OpenAPI 3.0 definition.

I would very much like this. I tried diving into the query-API on Wikidata today and I did not like the format of the current documentation at all. Confusing to say the least. Thanks to the telegram group I got my query working using the https://www.mediawiki.org/wiki/Help:Extension:WikibaseCirrusSearch extensions but they are not found anywhere in the generated API documentation what I could see.

Sat, Sep 11, 3:06 PM · Platform Team Initiatives (MW REST API in PHP), MediaWiki-REST-API

Thu, Sep 9

So9q added a comment to T290635: Evaluate whether WMDE can take over our essential community run constraints bot.

Maybe someone in the community can adopt it from Ivan Krestinin? It should be able to run fine on VPS I assume.

Thu, Sep 9, 9:10 AM · wdwb-tech, Wikidata
So9q added a subtask for T201150: Regularly run constraint checks for all items: T290635: Evaluate whether WMDE can take over our essential community run constraints bot.
Thu, Sep 9, 9:09 AM · User-Addshore, wdwb-tech, Wikidata-Query-Service, Wikibase-Quality, Wikidata, Wikibase-Quality-Constraints
So9q added a parent task for T290635: Evaluate whether WMDE can take over our essential community run constraints bot: T201150: Regularly run constraint checks for all items.
Thu, Sep 9, 9:09 AM · wdwb-tech, Wikidata
So9q added a comment to T201150: Regularly run constraint checks for all items.
Thu, Sep 9, 9:08 AM · User-Addshore, wdwb-tech, Wikidata-Query-Service, Wikibase-Quality, Wikidata, Wikibase-Quality-Constraints
So9q created T290635: Evaluate whether WMDE can take over our essential community run constraints bot.
Thu, Sep 9, 9:07 AM · wdwb-tech, Wikidata
So9q added a comment to T201150: Regularly run constraint checks for all items.

Can I make two related requests? Not sure how to post them as separate tasks related to this task, can someone from WMD do that?

Thu, Sep 9, 9:05 AM · User-Addshore, wdwb-tech, Wikidata-Query-Service, Wikibase-Quality, Wikidata, Wikibase-Quality-Constraints
So9q added a comment to T285459: What UI vs API based revisions data do we have for Wikidata?.

Happy to be of service, and nice to meet you too. I liked the presentation a lot. I feel like doing a ph.D myself on knowledge graphs like Wikidata 😆

Thu, Sep 9, 7:36 AM · Wikidata, Wikidata Analytics, WMDE-Analytics-Engineering, User-GoranSMilovanovic

Wed, Sep 8

So9q added a comment to T285459: What UI vs API based revisions data do we have for Wikidata?.

FWIW a week-based quarry on semi-automated edits from the most popular tools (manually selected based on another query) is here: https://quarry.wmcloud.org/query/58473
Results:
OAuth CID: 1776 869604 aka QS
wikidata-ui 403984
client-linkitem-change 30437
client-automatic-update 20785
WikibaseJS-cli 20100
OAuth CID: 1740 13024 aka Author-Disambiguator 2.0
openrefine-3.4 6980
apps-suggested-edits 6628
OAuth CID: 1768 6002 aka Mix'n match 1.0
termbox 3422
openrefine-3.3 2324
data-bridge 1

Wed, Sep 8, 8:46 PM · Wikidata, Wikidata Analytics, WMDE-Analytics-Engineering, User-GoranSMilovanovic

Fri, Sep 3

So9q updated subscribers of T290298: It is impossible to distinguich which entityselector list belong to a certain textarea.
Fri, Sep 3, 7:19 AM · Wikidata
So9q renamed T290298: It is impossible to distinguich which entityselector list belong to a certain textarea from Textareas and entityselector lists are not easily paired to It is impossible to distinguich which entityselector list belong to a certain textarea.
Fri, Sep 3, 7:19 AM · Wikidata
So9q created T290298: It is impossible to distinguich which entityselector list belong to a certain textarea.
Fri, Sep 3, 7:18 AM · Wikidata
So9q added a comment to T107693: Add "Create new item" link to property value drop-down menu (particularly when no item matches) in Wikidata.

I tried porting this script to use the new mutation observer but failed.
For some reason after making the replace the entityselector resets and the replacement disappears.
See https://www.wikidata.org/wiki/User:So9q/CreateNewEntity.js

Fri, Sep 3, 7:11 AM · Google-Code-in-2017, Wikidata-Gadgets, MediaWiki-extensions-WikibaseRepository, Wikidata

Thu, Sep 2

So9q created T290244: Evaluate whether RDF Thrift is a suitable dump format.
Thu, Sep 2, 12:13 PM · Wikidata
So9q added a comment to T290240: Evaluate whether RDF Delta is a good idea to have in the backend.

We should probably start with a problem we're be trying to solve. What would this be for this one?

Thu, Sep 2, 12:02 PM · Wikidata, Wikidata-Query-Service
So9q created T290240: Evaluate whether RDF Delta is a good idea to have in the backend.
Thu, Sep 2, 11:10 AM · Wikidata, Wikidata-Query-Service
So9q added a comment to T211754: PDF/DJVU defaults to first page for Page images.

This also affects Wikidata. I manually extracted and reuploaded this https://commons.wikimedia.org/wiki/File:Complete_English-Jewish_Dictionary,_6th_ed._-_Harkavy_-_1910.djvu-page5.jpg but that is cumbersome and introduces redundancy

Thu, Sep 2, 10:40 AM · Readers-Web-Backlog (Tracking), PageImages

Tue, Aug 31

So9q added a comment to T285156: Add termbox language code mul.

I totally support finding a way to avoid this redundancy. It's a terrible waste of resources and time to input it for all languages in the world/supported by the system, and does not add knowledge to the whole at all.

Tue, Aug 31, 7:30 PM · Wikidata, Wikidata-Campsite, Language codes
So9q added a comment to T289561: Evaluate Rya as alternative to Blazegraph.

The dependencies for Rya is here:
https://www.mail-archive.com/dev@rya.apache.org/msg00126.html

Tue, Aug 31, 3:47 PM · Wikidata, Wikidata-Query-Service
So9q added a comment to T289561: Evaluate Rya as alternative to Blazegraph.

Here is the report for 2021:

Tue, Aug 31, 3:43 PM · Wikidata, Wikidata-Query-Service
So9q added a comment to T289561: Evaluate Rya as alternative to Blazegraph.

The dev mailing list of Rya is unfortunately very quiet. https://www.mail-archive.com/dev@rya.apache.org/maillist.html

Tue, Aug 31, 3:41 PM · Wikidata, Wikidata-Query-Service
So9q added a comment to T206560: [Epic] Evaluate alternatives to Blazegraph.

I recommend the Search Team to attend the ApacheCon to gather insights from others using Big Data succesfully:
https://www.apachecon.com/acah2021/tracks/bigdata.html
e.g.:

Tue, Aug 31, 3:38 PM · MediaWiki-Stakeholders-Group, Wikidata, Epic, Wikidata-Query-Service
So9q updated the task description for T290082: Evaluate Apache HBase and RDF4J as alternative to Blazegraph.
Tue, Aug 31, 3:23 PM · Wikidata, Wikidata-Query-Service
So9q renamed T290082: Evaluate Apache HBase and RDF4J as alternative to Blazegraph from Evaluate Apache HBase as alternative to Blazegraph to Evaluate Apache HBase and RDF4J as alternative to Blazegraph.
Tue, Aug 31, 3:22 PM · Wikidata, Wikidata-Query-Service
So9q added a comment to T290082: Evaluate Apache HBase and RDF4J as alternative to Blazegraph.

See institutions already using HBase in production: http://hbase.apache.org/poweredbyhbase.html
It is very widely used to handle PB of data, it seems.

Tue, Aug 31, 3:11 PM · Wikidata, Wikidata-Query-Service
So9q added a comment to T289561: Evaluate Rya as alternative to Blazegraph.

Slides https://events.static.linuxfound.org/sites/events/files/slides/Rya_ApacheBigData_20170518.pdf

Tue, Aug 31, 3:10 PM · Wikidata, Wikidata-Query-Service
So9q added a subtask for T206560: [Epic] Evaluate alternatives to Blazegraph: T290082: Evaluate Apache HBase and RDF4J as alternative to Blazegraph.
Tue, Aug 31, 3:05 PM · MediaWiki-Stakeholders-Group, Wikidata, Epic, Wikidata-Query-Service
So9q added a parent task for T290082: Evaluate Apache HBase and RDF4J as alternative to Blazegraph: T206560: [Epic] Evaluate alternatives to Blazegraph.
Tue, Aug 31, 3:05 PM · Wikidata, Wikidata-Query-Service
So9q created T290082: Evaluate Apache HBase and RDF4J as alternative to Blazegraph.
Tue, Aug 31, 3:05 PM · Wikidata, Wikidata-Query-Service
So9q added a comment to T206560: [Epic] Evaluate alternatives to Blazegraph.
Tue, Aug 31, 2:47 PM · MediaWiki-Stakeholders-Group, Wikidata, Epic, Wikidata-Query-Service
So9q added a comment to T289760: Evaluate Oxigraph as alternative to Blazegraph.

@Tpt is it possible to run a cluster of say 2 oxigraph instances on the same sled store?
I could then manually update the sled store in some way and the changes are visible in both of the oxigraph endpoints?

Tue, Aug 31, 2:31 PM · Wikidata, Wikidata-Query-Service
So9q added a comment to T289760: Evaluate Oxigraph as alternative to Blazegraph.

@Tpt thanks for the corrections!

Tue, Aug 31, 2:29 PM · Wikidata, Wikidata-Query-Service
So9q updated the task description for T289760: Evaluate Oxigraph as alternative to Blazegraph.
Tue, Aug 31, 2:27 PM · Wikidata, Wikidata-Query-Service
So9q added a comment to T286903: Track and monitor items per editor ratio for Wikidata.

@Lucas_Werkmeister_WMDE
Hi, I fail to understand the descriptions on 2 of the new dashboards.

Tue, Aug 31, 1:21 PM · Patch-For-Review, Wikidata-Campsite (Wikidata-Campsite-Iteration-∞), Wikidata, Wikidata Analytics

Mon, Aug 30

So9q renamed T289970: Recommend exponential waiting time to tool authors? from Recommend exponential waiting time to tool authors to Recommend exponential waiting time to tool authors?.
Mon, Aug 30, 6:07 AM · Wikidata, Wikidata-Query-Service, Wikidata Analytics
So9q updated the task description for T289970: Recommend exponential waiting time to tool authors?.
Mon, Aug 30, 6:06 AM · Wikidata, Wikidata-Query-Service, Wikidata Analytics
So9q created T289970: Recommend exponential waiting time to tool authors?.
Mon, Aug 30, 6:01 AM · Wikidata, Wikidata-Query-Service, Wikidata Analytics

Sun, Aug 29

So9q added a comment to T104750: Make low year numbers less ambiguous .

Possible solution here https://phabricator.wikimedia.org/T289940
And they should probably be merged

Sun, Aug 29, 12:30 PM · MW-1.38-notes (1.38.0-wmf.2; 2021-09-28), Patch-For-Review, Wikidata-Campsite (Wikidata-Campsite-Iteration-∞), Wikidata-Sprint-2015-12-01, Wikidata-Sprint-2015-11-03, DataValues, Wikidata
So9q created T289940: Increase clarity for users by displaying ISO dates yyyy-mm-dd onmouseover.
Sun, Aug 29, 9:48 AM · Wikidata
So9q created T289939: Wikidata does not accept dates with the year first.
Sun, Aug 29, 9:39 AM · Wikidata

Aug 26 2021

So9q updated subscribers of T289760: Evaluate Oxigraph as alternative to Blazegraph.
Aug 26 2021, 8:37 AM · Wikidata, Wikidata-Query-Service
So9q updated the task description for T289760: Evaluate Oxigraph as alternative to Blazegraph.
Aug 26 2021, 8:34 AM · Wikidata, Wikidata-Query-Service
So9q added a comment to T289621: Evaluate Halyard as alternative to Blazegraph.

cons:

Aug 26 2021, 8:33 AM · MediaWiki-Stakeholders-Group, Wikidata, Epic, Wikidata-Query-Service
So9q updated the task description for T289760: Evaluate Oxigraph as alternative to Blazegraph.
Aug 26 2021, 8:31 AM · Wikidata, Wikidata-Query-Service
So9q updated the task description for T289760: Evaluate Oxigraph as alternative to Blazegraph.
Aug 26 2021, 8:29 AM · Wikidata, Wikidata-Query-Service
So9q added a subtask for T206560: [Epic] Evaluate alternatives to Blazegraph: T289760: Evaluate Oxigraph as alternative to Blazegraph.
Aug 26 2021, 8:27 AM · MediaWiki-Stakeholders-Group, Wikidata, Epic, Wikidata-Query-Service
So9q added a parent task for T289760: Evaluate Oxigraph as alternative to Blazegraph: T206560: [Epic] Evaluate alternatives to Blazegraph.
Aug 26 2021, 8:27 AM · Wikidata, Wikidata-Query-Service
So9q created T289760: Evaluate Oxigraph as alternative to Blazegraph.
Aug 26 2021, 8:26 AM · Wikidata, Wikidata-Query-Service

Aug 24 2021

So9q updated the task description for T289561: Evaluate Rya as alternative to Blazegraph.
Aug 24 2021, 12:19 PM · Wikidata, Wikidata-Query-Service
So9q updated the task description for T289561: Evaluate Rya as alternative to Blazegraph.
Aug 24 2021, 12:16 PM · Wikidata, Wikidata-Query-Service
So9q updated the task description for T289561: Evaluate Rya as alternative to Blazegraph.
Aug 24 2021, 12:16 PM · Wikidata, Wikidata-Query-Service
So9q added a comment to T289561: Evaluate Rya as alternative to Blazegraph.

Rya is build on Accumulo which was never evaluated according to https://docs.google.com/spreadsheets/d/1MXikljoSUVP77w7JKf9EXN40OB-ZkMqT8Y5b2NYVKbU/edit?usp=sharing

Aug 24 2021, 12:04 PM · Wikidata, Wikidata-Query-Service
So9q added a comment to T206561: Evaluate Virtuoso as alternative to Blazegraph.

I took a glance at Virtuoso.

Aug 24 2021, 11:59 AM · Wikidata, Wikidata-Query-Service
So9q added a subtask for T206560: [Epic] Evaluate alternatives to Blazegraph: T289561: Evaluate Rya as alternative to Blazegraph.
Aug 24 2021, 11:58 AM · MediaWiki-Stakeholders-Group, Wikidata, Epic, Wikidata-Query-Service
So9q added a parent task for T289561: Evaluate Rya as alternative to Blazegraph: T206560: [Epic] Evaluate alternatives to Blazegraph.
Aug 24 2021, 11:58 AM · Wikidata, Wikidata-Query-Service
So9q created T289561: Evaluate Rya as alternative to Blazegraph.
Aug 24 2021, 9:04 AM · Wikidata, Wikidata-Query-Service

Aug 23 2021

So9q created T289517: DCAT AP endpoint is down.
Aug 23 2021, 5:45 PM · Patch-For-Review, Discovery-Search (Current work), Wikidata, Wikidata-Query-Service

Aug 20 2021

So9q added a comment to T287563: slow indexing of new Items on Wikidata?.

@EBernhardson That is a very nice script! Thanks for annotating it, so I almost understand everything going on. 😅
I just ran it for a few minutes and I saw lags of 70-162 seconds. The highest being of a lexeme.

Aug 20 2021, 10:29 PM · Discovery-Search (Current work), wdwb-tech, Wikidata, Elasticsearch

Aug 16 2021

So9q updated subscribers of T161491: list of larger re-users of our data.

@Salgo60 has documented that Google tracks the change stream and update their searches within 20 minutes. So I guess they are 1 to mention. :)

Aug 16 2021, 9:47 PM · patch-welcome, Wikidata.org, Wikidata

Aug 15 2021

So9q updated the task description for T288904: Cannot find interfixes using search box.
Aug 15 2021, 10:30 AM · Wikidata, Wikidata Lexicographical data, Discovery
So9q updated the task description for T288904: Cannot find interfixes using search box.
Aug 15 2021, 10:26 AM · Wikidata, Wikidata Lexicographical data, Discovery
So9q updated subscribers of T288904: Cannot find interfixes using search box.
Aug 15 2021, 10:25 AM · Wikidata, Wikidata Lexicographical data, Discovery
So9q created T288904: Cannot find interfixes using search box.
Aug 15 2021, 10:24 AM · Wikidata, Wikidata Lexicographical data, Discovery

Aug 9 2021

So9q added a comment to T288462: Filenames are unstable on Commons. Switch to MID datatype on P18 and other properties?.

This would affect https://www.mediawiki.org/wiki/Wikibase/Indexing/RDF_Dump_Format#Commons_media which is a stable interface.

Aug 9 2021, 2:36 PM · Wikidata
So9q renamed T288462: Filenames are unstable on Commons. Switch to MID datatype on P18 and other properties? from Filenames are unstable on Commons. Switch to MID on P18 and other properties? to Filenames are unstable on Commons. Switch to MID datatype on P18 and other properties?.
Aug 9 2021, 1:59 PM · Wikidata
So9q added a comment to T258776: Add Structured Data on Commons M-ID to Wikidata dumps.

The URI for the image is https://commons.wikimedia.org/entity/M6919529 (yes, https, not http, that got messed up, see T258590). You can see an RDF representation of that at https://commons.wikimedia.org/entity/M6919529.rdf . We should someone include this URI on Wikidata too. The royal way would be to update the image data type which accepts the Mediainfo ID and does all the logic like the current image data type.

Currently it something like this:

{"snaktype":"value","property":"P18","datavalue":{"value":"Woman Mending Stockings f888r jh68.jpg","type":"string"},"datatype":"commonsMedia"},

Would be something like:

{"snaktype":"value","property":"P18","datavalue":{"value":{"entity-type":"mediainfo","numeric-id":82541649,"id":"M82541649"},"type":"wikibase-entityid"},"datatype":"commonsMedia"},
Aug 9 2021, 1:57 PM · StructuredDataOnCommons, Wikidata-Query-Service, Wikidata
So9q added a comment to T258608: Image results on WCQS should be available.

Community already found a workaround for this, e.g.

select ?file ?image {
  ?file schema:contentUrl ?url ;
        schema:height 100 ;
        schema:width 100 .
  # workaround to show the images in an image grid
  bind(iri(concat("http://commons.wikimedia.org/wiki/Special:FilePath/", replace(substr(str(?url),53),"_","%20"))) AS ?image)
} limit 2000

I think that it makes sense to pursue a way of doing exactly that, without workaround.

Aug 9 2021, 1:52 PM · Wikidata, Wikidata-Query-Service
So9q updated the task description for T264006: Deploy Flink (rdf-streaming-updater) to kubernetes (k8s).
Aug 9 2021, 1:30 PM · serviceops, wdwb-tech, Patch-For-Review, Discovery-Search (Current work), Wikidata, Wikidata-Query-Service
So9q updated subscribers of T288462: Filenames are unstable on Commons. Switch to MID datatype on P18 and other properties?.
Aug 9 2021, 1:25 PM · Wikidata
So9q created T288462: Filenames are unstable on Commons. Switch to MID datatype on P18 and other properties?.
Aug 9 2021, 1:25 PM · Wikidata
So9q added a comment to T277665: [L] Determine an IRI to join commons mediainfo entities and wikidata properties referencing commons images.

File names are bad URI's. Files get renamed all the time (see https://commons.wikimedia.org/w/index.php?title=Special:Log&offset=&limit=500&type=move ) causing all sorts of breakage. The pageid stays the same so the mediaid also stays the same. That's a much more stable identifier.

Aug 9 2021, 1:20 PM · MW-1.37-notes (1.37.0-wmf.17; 2021-08-02), Structured-Data-Backlog (Current Work), WikibaseMediaInfo
So9q added a comment to T263088: Allow to download WDQS and WCQS results as Excel spreadsheet.

Libreoffice works fine with the CSV from WDQS. I have used multiple versions over the parst 2 years and never had a problem.
I propose to close this as won't fix. CSV is good enough IMO.

Aug 9 2021, 1:09 PM · Wikidata, Wikidata-Query-Service
So9q created T288459: wdqs1007 is lagging 7 hours more than the others.
Aug 9 2021, 12:58 PM · Wikidata, Wikidata-Query-Service
So9q updated So9q.
Aug 9 2021, 12:15 PM
So9q updated subscribers of T281854: Get baseline measurements/expectations for splitting scholarly articles from Wikidata.
Aug 9 2021, 12:14 PM · Discovery-Search (Current work), Wikidata, Wikidata-Query-Service
So9q awarded T281854: Get baseline measurements/expectations for splitting scholarly articles from Wikidata a Burninate token.
Aug 9 2021, 12:10 PM · Discovery-Search (Current work), Wikidata, Wikidata-Query-Service

Aug 8 2021

So9q updated the task description for T288419: No commits since march, is the project dead? abandoned?.
Aug 8 2021, 7:11 PM · ISA
So9q created T288419: No commits since march, is the project dead? abandoned?.
Aug 8 2021, 7:09 PM · ISA
So9q created T288418: Hard to find where to report bugs from ISA.
Aug 8 2021, 7:09 PM · ISA