[00:28:50] hey leila, got a sec to check the calendars, I don’t see what you’re referring to [00:29:04] sure [00:29:36] so starting this wednesday, I have meetings with you every Wednesday, some Wednesdays two events at the same time DarTar [00:29:50] do we have a meeting in two days? [00:29:58] if yes, I can delete the middle meetings. [01:34:34] halfak: what does the vertical line on https://meta.wikimedia.org/wiki/File:Itwiki_anon_test.mobile_registrations.trend.svg mean? [01:44:41] Emufarmers: it’s the time at which a setting was changed allowing anonymous users to edit on the mobile version of itwiki [01:45:42] see https://meta.wikimedia.org/wiki/Research_talk:Anonymous_mobile_editing_in_Italian_Wikipedia/Work_log/2014-12-31 [01:47:48] ooh [01:48:26] I gotta run, ttyl [17:59:53] * Nettrom skips standup today, nothing new to report [18:03:35] Gotcha Nettrom. :) [18:52:42] thanks halfak ! [20:55:16] hi halfak [20:55:30] Hi fhocutt [20:55:44] So, today I learned they make a JFK G.I. Joe figurine [20:55:53] not just any JFK. PT boat captain JFK. With a coconut as an accessory. [20:55:55] http://www.amazon.com/Joe-Kennedy-Action-Figure-Commander/dp/B000JY38CE [20:56:26] I have some questions on the IdeaLab version of the script I've been working on, if you have some time [20:58:38] basically: we're now filtering on criteria that aren't easily gotten from the API (number of contributors in the last 2-3 weeks) [21:00:29] J-Mo and I were thinking of having a separate script that keeps a database of IdeaLab ideas and updates that information ~daily, and then the main script would get the ideas that fit the criteria from that DB [21:00:44] is this a plausible approach? is there an obviously-easier one? [21:10:34] fhocutt, sounds reasonable to me. [21:10:50] It might be performant enough that you can use a sub-query. [21:11:12] sub-query? [21:11:53] e.g. SELECT * FROM (SELECT page_id, COUNT(DISTINCT rev_user_text) as recent_edits FROM revision WHERE ...) WHERE recent_editors > 5; [21:12:08] * halfak already sees a type in that SQL [21:12:13] *typo! [21:12:14] bah [21:12:41] Ironholds, you' [21:12:47] re going to make one or order one? [21:13:04] Oh I misread. Thought you learned how to make one. [21:13:09] * halfak needs to slow down a bit. [21:13:27] naw, although I did learn how to make gummy bears shaped like Phineas Gage's skull. [21:13:46] halfak: are you talking about just pulling from the metawiki DB, or still keeping a small DB of our own? [21:13:47] Those are gonna be a hoot. 3D CT Model of gage's skull + my friend Alice's access to NEU's 3D printers == win. [21:14:03] Ironholds: ... [21:14:06] fhocutt, pulling from metawikiwiki [21:14:52] that would be more convenient. [21:14:57] fhocutt: everyone needs a hobby, and mindspillage can verify that my hobby is taking so-stupid-they're-almost-fantastic ideas and implementing them. [21:15:11] fhocutt, it's worthwhile to figure out if that will run fast enough before complicating things. [21:15:20] It might not be fast enough and then we're back on square #1 [21:15:30] Oh yeah. I remember reading about https://en.wikipedia.org/wiki/Phineas_Gage [21:16:52] Gage is the "index case for personality change due to frontal lobe damage" [21:17:12] And Jenny is a nueroscientist, so... [21:17:14] yup! [21:17:19] would she appreciate a model of his skull? [21:17:30] I feel like I should probably have got y'all a non-perishable wedding gift. [21:18:37] It could go next to the phrenology busts. [21:18:56] phrenology is pretty bust as a theory, yeah. [21:19:08] :P [21:19:09] (also, you have phrenology busts?! Damn. I should've paid closer attention) [21:19:23] We have a couple, but they are small novelties. [21:20:37] well, of course you'd say that, you've got a skull pattern strongly indicative of one who doesn't believe in the importance of phrenology models. [21:21:23] But I still get to be amused and informed by the history of Science they represent. [21:21:53] yup! [21:26:02] today is sure a day. I'm not connecting to metawiki on labs and I'm not sure why [21:30:02] * halfak shakes his fist at the labs gods [21:30:21] Regretfully, that is the extent of my LabsDB powers. [21:45:13] I'll go ahead and work on the other bits of this thing, then. [21:45:28] thanks, halfak [21:46:13] No problem. My fist shaking is yours to direct. ;) [21:48:39] the issue appears to be that the metawiki and metawiki_p DBs are down [22:01:55] DarTar, staff? [23:14:00] hey halfak. do you know if we have a table of redlinks somewhere? [23:14:09] I thought somewhere like enwiki.page should have that info [23:14:37] you could do pagelinks left join page where page is null? [23:14:39] We generated one a long time ago by joining the pagelinks table with page. [23:14:49] Yeah. What legoktm said [23:14:54] ah! cool. thanks, halfak. [23:15:01] I meant thank legoktm. ;-) [23:15:04] :) [23:15:09] :( [23:15:12] and thanks halfak. we will do the same [23:15:14] :) [23:15:22] :| [23:15:26] o/ Emufarmers [23:16:29] o/ [23:16:58] do you know how frequently the pagelinks table gets updated halfak, or legoktm? [23:17:21] leila, on save [23:17:30] ^ [23:17:30] So it should be 100% up-to-date with the DB [23:17:43] that's perfect. thanks! [23:18:23] * halfak imagines a small crowd elbowing to the front to answer leila's Qs