[11:39:49] Here is my pickle...mildly putting it....I will try and skip the irrelevant info, yet I literally have absolutely no one except my mother and a few of her cronies that I don't really communicate with ...it was for precautionary measures in case we both my disappear or die abruptly; our acquired accolades and info was copied and sent to 5 of her [11:39:50] closest confidants.lly [16:44:34] is it possible to export wiki data from the database as something like text, csv or latex ? [16:55:35] ? [16:55:44] what would be the point of that? [16:56:20] zleap: there was release of wikidata + wikipedia into csv, check out the wikidata mailing list. [16:56:32] thanks [16:56:53] this isn't for me as such I am talking to someone on #chemistry wanting to make a table of chemistry data [16:57:05] it is not a full wikidata / wikipedia dump, it is meant to be "practical for research purpose" [16:57:25] it should be possible to interrogate wikidata with sparql and extract info on different elements [16:57:32] zleap: the easiest path is to learn some SPARQL and query the data... [16:57:34] exactly. [16:57:51] btw https://data.world/ has a nice SPARQL tutorial. [16:58:14] (that is not content marketing ;P) [16:58:38] i did some, addshore introduced me to it a while back, well two of the tech jam attendees mostly [16:58:50] https://docs.data.world/tutorials/sparql/ [16:59:02] thanks [16:59:26] zleap: what programming language are you familiar with? SQL? [16:59:35] a little [17:00:41] to my mind, SPARQL basics, is pattern matching. You describe what the data looks like, and the database will try to fill-the-blanks. [17:01:23] there is also aggregation and other stuff, but the basic idea is pattern matching with exact match predicate. [17:02:55] it can possibly yield multiple solution to the pattern, usually that is the case there is several solutions. [17:03:02] i have asked if openbsdtai123 can come in to here, [17:07:42] the problem with sparql and in general rdf and computers, is that even if you know something is in the database, you still need to figure how it is encoded / stored. Computers are picky about the vocabulary. [17:08:10] (and the grammar) [17:11:15] yeah [17:36:42] PROBLEM - wikidata-alerts grafana alert on icinga1001 is CRITICAL: CRITICAL: Wikidata Alerts ( https://grafana.wikimedia.org/d/TUJ0V-0Zk/wikidata-alerts ) is alerting: API: Write modules execution time p95 is above 1 minute (for 2 minutes). https://wikitech.wikimedia.org/wiki/WMDE/Wikidata/Alerts https://grafana.wikimedia.org/d/TUJ0V-0Zk/ [17:41:04] RECOVERY - wikidata-alerts grafana alert on icinga1001 is OK: OK: Wikidata Alerts ( https://grafana.wikimedia.org/d/TUJ0V-0Zk/wikidata-alerts ) is not alerting. https://wikitech.wikimedia.org/wiki/WMDE/Wikidata/Alerts https://grafana.wikimedia.org/d/TUJ0V-0Zk/