[04:22:50] 10Quarry, 10Cloud-Services: Consider moving Quarry to be an installation of Redash - https://phabricator.wikimedia.org/T169452#3428933 (10Tbayer) Don't know whether it should be considered dealbreaker, but FWIW: Apart from permalinks ensuring reproducibility of individual anayses, the history is also an accide... [14:47:03] Hey folks. Google reminded me that I had some photos from July 12th, 2015 -- the Analytics/Research offsite in Mexico City. See https://goo.gl/photos/QVw1bkjSjcWXCFmR8 [14:55:32] 10Quarry, 10Cloud-Services: Consider moving Quarry to be an installation of Redash - https://phabricator.wikimedia.org/T169452#3430771 (10Halfak) > history is also an accidental but very valuable source of knowledge To clarify, the decision to include a query history was not accidental at all. That was very... [15:00:27] halfak: Question for you related to parsing the stub-meta-history xml dump file for wikidatawiki: do you know in what circumstance the "user" field of a certain revision would be set to "None"? [15:00:56] suppressed. [15:01:14] If you check the "deleted" value, one of the options is "user" [15:01:39] http://pythonhosted.org/mwtypes/revision.html#mwtypes.Revision.Deleted [15:02:34] If you make your username Andrew_Hall_lives_at_742_Evergreen_Terrace_in_Springfield, then that'll get suppressed for doxxing. [15:02:50] BTW, that address is the address for the Simpsons :) [15:03:12] Which, of course, has it's own Wikipedia article because why not? [15:03:13] https://en.wikipedia.org/wiki/The_Simpsons_house [15:07:50] Jeez trying to give out my address to everybody? :P haha [15:08:06] Thanks for the explanation! [15:09:09] It seems like its a fairly rare case [15:12:01] I'll just set the user_id in my database table to "-1" for those revisions [15:26:18] I wouldn't do that [15:26:22] I'd set it to NULL [15:27:12] eval(NULL = NULL) == NULL [15:27:15] Which is False [15:27:18] That's good. [15:27:30] You don't want the user with ID -1 to get a lot of edits [15:36:18] Sounds good, I'll set it to NULL [18:11:15] https://wikimedia-research.github.io/ :) [18:16:11] bearloga, nice. Did you set that up? [18:24:15] halfak: yeah, erik b nudged me about how it was weird that there was absolutely nothing there (especially because chelsy and i host our reports on there -- e.g. https://wikimedia-research.github.io/Discovery-Search-Test-CrosswikiSidebar/) so I put something minimal-but-hopefully-nice-looking together [18:24:36] I like it. [18:24:48] But one note is that there's going to be a research.wikimedia.org soon. [18:24:50] J-Mo, ^ [18:25:08] Seems like both should exist [18:25:21] One as an index to research repos/projects and another to the Research Dept. [18:26:24] hence the first link being to the repos :) [18:26:37] :) [19:03:04] 10Quarry: Quarry query in unknown state - https://phabricator.wikimedia.org/T170464#3432141 (10awight) [20:37:50] 10Quarry: Quarry query in unknown state - https://phabricator.wikimedia.org/T170464#3432726 (10awight) p:05Normal>03Low [20:37:59] 10Quarry: Quarry query in unknown state - https://phabricator.wikimedia.org/T170464#3432141 (10awight)