#editorial | Logs for 2016-05-28
« return
[01:16:44] <takyon> hey Bytram|away
[01:17:40] <takyon> I'd like to try a query that gets the average number of comments for stories posted during every hour of the week (168) plus data on science vs nonscience stories in those time slots
[01:18:21] <takyon> If there's an Entity Relationship Diagram for Soylent or something, I'd like to try and craft the SQL statement myself
[01:43:53] <Bytram> takyon: afaik, there is no ERD for Soylent; many is the time I wish there were one...
[01:44:41] <Bytram> be aware that working against our live DB may have performance impacts on the site.
[01:44:42] <takyon> a list of table and column names? lool
[01:44:52] <takyon> I could use a backup
[01:45:03] <takyon> this was only a random thought bubble of mine anyway
[01:45:17] <Bytram> I've got something I can send you, but I need to take care of someting atm...
[01:45:18] <Bytram> give me a bit
[01:58:22] <Bytram> takyon: email, nick@sn.org?
[01:58:49] <takyon> yes
[01:58:50] <takyon> thanks
[02:00:09] <Bytram> still kinda busy, will send soon as I can; will let you know when on its way
[02:09:44] <Bytram> email written; trying to send now; my lappy is running really slow... is on it's way. let me know if you got it.
[02:12:30] <Bytram> Tachyon: you should have it now; pls confirm
[02:12:36] <Bytram> ugh, wrong one!
[02:12:51] <Bytram> takyon: you should have received the e-mail by now. pls confirm.
[02:17:40] <Bytram> takyon: btw, click on a column header and watch the column contents sort in ascending order; click again and then they get displayed in descending order. To retrieve the original order, click on the first column title 'SEQ'
[02:20:00] <Bytram> cmn32480: !! wb
[03:07:11] <Bytram> drat! I just remembered that SpaceX had to reschedule yesterday's launch to today. missed it!
[03:07:22] * Bytram hopes he can find a link to the video.
[03:08:56] <Bytram> http://arstechnica.com
[03:08:56] <Schwifty> ^ 03SpaceX takes another crack at launching, landing today [Updated] | Ars Technica
[03:09:17] <Bytram> "Update: SpaceX did it, successfully delivering its payload and landing the first stage of the Falcon 9 rocket for the third time in a row on an autonomous drone ship. It's safe to say the future has arrived."
[03:09:55] <Bytram> whereto? https://www.youtube.com
[03:09:56] <Schwifty> ^ 03THAICOM 8 Hosted Webcast - YouTube
[03:38:40] <takyon> cough
[03:40:21] * Bytram is still looking for the offical spacex one
[03:41:12] <Bytram> ah, this should be it: https://www.youtube.com
[03:41:12] <Schwifty> ^ 03THAICOM 8 Technical Webcast - YouTube
[03:41:34] <Bytram> and, the booster landing, too: https://www.youtube.com
[03:41:34] <Schwifty> ^ 03First-stage landing | Onboard camera - YouTube
[05:00:39] -!- audioguy has quit [Quit: Leaving]
[05:01:55] -!- audioguy [audioguy!~audioguy@Soylent/Staff/Developer/audioguy] has joined #editorial
[12:25:59] -!- nick [nick!~nick@Soylent/Staff/Editor/n1] has joined #editorial
[12:25:59] -!- mode/#editorial [+v nick] by Hephaestus
[13:15:15] <takyon> don't forget to use the correct Topics
[13:15:27] <takyon> for example I put dev/random instead of news on the Thai toilet story
[13:17:12] <takyon> unplagiarized NTP article
[13:20:30] -!- nick has quit [Remote host closed the connection]
[13:34:18] zz_janrinok is now known as janrinok
[13:51:01] <takyon> hi janrinok
[13:51:26] <janrinok> ~gday takyon
[13:51:28] * exec defiantly shoves a keg of vespene gas in takyon
[13:52:19] <takyon> I require more
[13:53:19] <janrinok> I'm not sure where I get vespene gas from .....?
[13:53:27] <janrinok> Ah, starcraft!
[13:54:28] <takyon> yeap, I'm quoting the voice acting
[13:55:01] <janrinok> I might have sounded more knowledgeable about Star Craft in my comment than is actually the case ...
[14:17:13] <takyon> is the SpyBot program from the same people who make SpyBot: Search and Destroy?
[14:19:47] <janrinok> Possibly - I don't know enough about either
[14:20:37] <janrinok> looking at their web-site I would say Yes
[14:21:14] <janrinok> but not being a Windows user I've got no real experience of their software.
[15:15:44] -!- User [User!~User@45.32.svi.mqs] has joined #editorial
[15:15:58] User is now known as nick
[15:16:11] -!- nick has quit [Changing host]
[15:16:11] -!- nick [nick!~User@Soylent/Staff/Editor/n1] has joined #editorial
[15:16:11] -!- mode/#editorial [+v nick] by Hephaestus
[15:38:19] <cmn32480> takyon - YES same compnay
[15:42:56] -!- User_ [User_!~User@buy07843-ltcv3-3-0-ulmt29.8-2.cable.virginm.net] has joined #editorial
[15:42:56] -!- nick has quit [Read error: Connection reset by peer]
[15:53:38] User_ is now known as nick
[15:53:40] -!- nick has quit [Changing host]
[15:53:40] -!- nick [nick!~User@Soylent/Staff/Editor/n1] has joined #editorial
[15:53:40] -!- mode/#editorial [+v nick] by Hephaestus
[15:59:45] -!- nick has quit [Quit: Leaving]
[19:06:05] janrinok is now known as zz_janrinok