#soylent | Logs for 2020-07-09
« return
[00:06:35] -!- Teckla has quit [Quit: leaving]
[00:06:35] Teckla_ is now known as Teckla
[00:08:03] -!- Teckla has quit []
[00:08:19] -!- Teckla [Teckla!sid172075@fe-405803.highgate.irccloud.com] has joined #soylent
[00:17:25] -!- AzumaHazuki [AzumaHazuki!~hazuki@the.end.of.time] has joined #soylent
[01:25:32] <Bender> [SoylentNews] - Spider Silk Made by Photosynthetic Bacteria - https://sylnt.us - no-radioactive-bites-required
[01:28:07] -!- boru` [boru`!~boru@xlmp-33-232-722-158.dynamic.mnet-online.de] has joined #soylent
[01:28:10] -!- boru has quit [Killed (NickServ (GHOST command used by boru`!~boru@xlmp-33-232-722-158.dynamic.mnet-online.de))]
[01:28:13] boru` is now known as boru
[02:41:08] <Bytram> https://pbs.twimg.com
[02:41:49] <Bytram> ^^^ Boca Chica Build *and* Launch sites in ONE photo
[02:42:29] <Bytram> ^^^ Boca Chica Build *and* Launch sites in ONE photo -- full size: https://pbs.twimg.com
[03:37:52] <Bender> [SoylentNews] - IT Pros Indicted after Arranging Credit Card Payments for Weed Startup - https://sylnt.us - weeding-out-illegal-transactions
[03:50:11] -!- AzumaHazuki has quit [Quit: Leaving]
[05:46:25] <Bender> [SoylentNews] - Free Tool Enables Recovery of Files Encrypted by ThiefQuest Mac Malware - https://sylnt.us - software-wants-to-be-freed
[06:57:30] <chromas> https://www.fox10phoenix.com
[06:57:31] <systemd> ^ 03Oregon man driving stolen vehicle crashes into woman driving stolen car: police
[06:57:32] <exec> └─ 13Oregon man driving stolen vehicle crashes into woman driving stolen car: police
[07:05:41] <inz> The wording gives me an impression that land cruiser cannot be considered a car
[07:28:06] <FatPhil> if it hovers, and hums as it does so, I can accept that
[07:58:20] <Bender> [SoylentNews] - 15 Billion Credentials Currently Up for Grabs on Hacker Forums - https://sylnt.us - get-your-hot-fresh-credentials-here!
[10:05:35] <chromas> Even Microsoft is working on systemd now
[10:05:51] <chromas> http://www.phoronix.com
[10:05:52] <systemd> ^ 03A Microsoft Addition For systemd 246 Exposes Host OS Information To Containers - Phoronix ( https://www.phoronix.com )
[10:05:53] <exec> └─ 13A Microsoft Addition For systemd 246 Exposes Host OS Information To Containers - Phoronix
[10:05:59] <Bender> [SoylentNews] - Shock-Dissipating Fractal Cubes Could Forge High-Tech Armor - https://sylnt.us - now-make-it-out-of-graphene
[12:07:35] <Bender> [SoylentNews] - Millions in Hong Kong Losing Access to Open Net; Downloads of Signal & VPN Surge on Crackdown Fears - https://sylnt.us - communication-wants-to-be-free
[12:37:08] <Bytram> coffee++
[12:37:08] <Bender> karma - coffee: 5303
[12:42:02] <FatPhil> can anyone help me with some mysql?
[12:44:34] <FatPhil> I have a simple query that yields triplets <x,y,v> for a small range of x (years from 2014 to 2020), and a small range of y (months from jan to dec, surprisingly)
[12:46:54] <FatPhil> And what I want is a set of n-tuples <y, v2014, v2015, v2016...v2020>
[12:47:16] <FatPhil> where vXXXX is the v for x=XXXX, obvs
[12:49:53] <Bytram> my SQL experience is rusty...
[12:51:00] <Bytram> and I'm not fully understanding the question.
[12:51:49] <Bytram> off the top of my head, and for simplicity sake, I'd thinking maybe use subqueries?
[12:54:14] <Bytram> what does vXXXX mean? And does the XXXX signify a year and vXXXX denote the vale for that year?
[12:54:49] <FatPhil> vXXXX is the v for x=XXXX
[12:55:05] <FatPhil> (and the appropriate y)
[12:55:15] <Bytram> and XXXX is a 4-digit year?
[12:55:43] <FatPhil> yup.
[12:56:13] * Bytram is *much* better working with concrete examples of data inputs and desired outputs.
[12:56:33] <FatPhil> What I've got at the moment is sum(if(x=2014,v,0)) as v2014 from (select...)... group by y
[12:56:56] <FatPhil> but I need a sum expression for every year.
[12:57:08] <FatPhil> then again, I need some expression for every year, so it makes sense.
[12:57:30] <Bytram> still am struggling... concrete examples, please?
[12:59:44] <FatPhil> OK, lets simplify it to 2 years, 1 and 2, and 2 months 0 and 1: inner query gives <x,y,v> triplets of <1,0,2>, <1,1,3>, <2,0,5>, <2,1,7>, <3,0,11>
[12:59:58] <Bytram> oy!
[13:00:04] <Bytram> hold on
[13:00:50] <FatPhil> I want n-tuples <y,v1,v2,v3> with <0,2,5,11>, <1,3,7,0>
[13:01:15] <Bytram> y is a year taken from a table, years, with values: 2014, 2015, ... 2020.
[13:01:30] <FatPhil> x=years, y=months
[13:01:56] <FatPhil> soylentnews needs a new service - a pastebin!
[13:03:01] <Bytram> m is a month taken from a table, months, with values ??? (numeric or text?) either: 'JAN', 'FEB', ... 'DEC' or 1, 2, 3, ..., 12
[13:03:15] <Bytram> that would help
[13:04:37] <Bytram> create a journal entry on dev? dev.soylentnews.org you have an acct there :)
[13:07:09] <Bytram> use <ecode> ... <ecode> to bracket your code examples (functions like a combo of <pre> and <tt>)
[13:07:33] <FatPhil> The horribly verbose multiple-SUM expression seems to be working
[13:07:50] <Bytram> good to hear
[13:08:10] <FatPhil> It's just really horrid to have to use a sum(if(correct year, its value, 0)) as value foryear
[13:08:31] <FatPhil> _that onyl sums one non-zero value
[13:08:58] <Bytram> paste it on dev so I can see?
[13:10:38] <Bytram> hold on...
[13:11:13] <Bytram> Here ya go: https://dev.soylentnews.org
[13:11:14] <systemd> ^ 03Code Playground #1 - Dev.SN
[13:11:15] <exec> └─ 13Code Playground #1 - Dev.SN
[13:12:07] <Bytram> FatPhil: ^^^
[13:49:28] <FatPhil> coolbeenz!
[14:02:30] <FatPhil> https://dev.soylentnews.org
[14:02:31] <systemd> ^ 03Code Playground #1 - Dev.SN ( https://dev.soylentnews.org )
[14:02:32] <exec> └─ 13Code Playground #1 - Dev.SN
[14:11:36] <Bytram> FatPhil: that helps a lot... I'll post a reply
[14:16:26] <Bender> [SoylentNews] - Liquid Crystal Integrated Metalens for Versatile Color Focus - https://sylnt.us - color-me-impressed
[14:18:37] <Bytram> FatPhil: comment posted
[14:19:31] <Bytram> FYI: If you'd like, is easy for me to delete the story and comments afterwards, if desired
[14:29:19] <FatPhil> Well, I do have a solution that works, and it executes in 0s on the real database, so I don't really need to simplify it.
[14:30:00] <FatPhil> I just hate the fact that next year I'll need to edit it just to add another line.
[14:31:37] <FatPhil> This is only an intermediate result - I'm trying to detect yearly trends in the data, and I reckoned that the best thing for that is 2D data - I might be wrong. I might be thinking too mathematically rather the 4GL-ey.
[14:31:58] <FatPhil> In fact I'm sure I'm wrong :-/
[14:33:24] <FatPhil> The 12 questions I'm trying to answer are 'on average, since time began, what proportion of the sales have been in January', and s/January/other-months/.
[14:33:42] <Bytram> yeaah, I was thinking there are some things best done in the DB, and then there are languages which are the better place to do procedural stuff. Imagine trying to keep this up to date for the next several years. Not terribly self-documenting / maintainable, :/
[14:35:03] <FatPhil> That (probably wrong) query is trivially maintainable - even my pet rabbit could work out how to cope with a new year, and it's been dead for years.
[14:35:42] <FatPhil> One of the annoying thing about SQL is that it seems you can't use columns as subexpressions in other columns.
[14:36:38] <FatPhil> select complex_expression as complex_thing, log(complex_thing) from ... is not possible, you need to literally copy the whole complex expression.
[14:37:29] <Bytram> create a temp table containing intermediate results and then do your actual query, later, from that temp table?
[14:37:43] <Bytram> or, use software.
[14:38:22] <Bytram> how much data do you have, in all? GB?
[14:40:03] <Bytram> Read the whole DB, tallying sums as you go, and then output the results. If it is very little data (MB), then just read the whole table into memory and do your work there.
[15:00:57] <FatPhil> I'm not sure how to create a temp table, I've only got access to a crappy web front end and think I can only write a single query (which of course may have nested queries)
[15:01:50] <FatPhil> The raw data's quite big (few meg), but all I care about is the monthly consolidated data, and that's tiny (7 years, 12 months, so <100 values)
[15:04:30] <pinchy> stop all the data analysis
[15:05:15] -!- SoyGuest271828 [SoyGuest271828!~4039920c@64.57.quj.nm] has joined #soylent
[15:05:20] <SoyGuest271828> =asub https://www.engadget.com
[15:05:22] <systemd> Submitting "Probe of failed Boeing Starliner launch finds a long list of problems"...
[15:05:22] <exec> └─ 13Probe of failed Boeing Starliner launch finds a long list of problems | Engadget
[15:05:43] <systemd> ✓ Sub-ccess! "03Probe of Failed Boeing Starliner Launch Finds a Long List of Problems" (4 paragraphs) -> https://soylentnews.org
[15:05:52] <SoyGuest271828> =asub https://www.zdnet.com
[15:05:55] <exec> └─ 13Google open-sources Tsunami vulnerability scanner | ZDNet
[15:05:56] <FatPhil> Don't immanentize the Eschaton = Damn, he atomizes the continent! (anagram)
[15:05:56] <systemd> Submitting "Google open-sources Tsunami vulnerability scanner"...
[15:06:17] <systemd> ✓ Sub-ccess! "03Google Open-sources Tsunami Vulnerability Scanner" (0 paragraphs) -> https://soylentnews.org
[15:06:38] <SoyGuest271828> =asub https://www.usatoday.com
[15:06:40] <exec> └─ 13Harvard, MIT sue Trump administration over ICE foreign-student rule
[15:06:41] <systemd> Submitting "Harvard, MIT sue Trump administration over ICE foreign-student rule, deeming it cruel and reckless"...
[15:07:03] <systemd> ✓* Sub-ccess! "03Harvard, MIT Sue Trump Administration Over ICE Foreign-student Rule, Deeming It Cruel and Reckless" (0 paragraphs) -> https://soylentnews.org
[15:22:15] -!- driveby [driveby!~amnesia@nz5219452.ip-58-662-29.eu] has joined #soylent
[15:24:38] -!- SoyGuest271828 has quit []
[15:37:20] -!- driveby has quit [Quit: Leaving.]
[16:26:01] <Bender> [SoylentNews] - Apple Exports Independent Repair Provider Program to Europe and Canada - https://sylnt.us - IRP=RIP?
[17:53:22] -!- fungus_ has quit [Remote host closed the connection]
[17:54:19] -!- fyngyrz_ has quit [Quit: Leaving...]
[18:32:02] -!- carny has quit [Ping timeout: 265 seconds]
[18:36:42] <Bender> [SoylentNews] - Snap removed from Mint - https://sylnt.us - working-behind-your-back
[19:07:43] -!- carny [carny!~irc@az1490859.ip-82-14-486.eu] has joined #soylent
[20:03:50] <FatPhil> Quick Q: How many graves in Arlington? google fails me (watching a documentary about WWI at the moment, so can't deep dive)
[20:09:23] <AndyTheAbsurd> wikipedia says approximately 400,00 graves on 253 hectares.
[20:13:27] <AndyTheAbsurd> the cited source for that number is a Washington Post article from 2012 about the cemetary's finances, but which also mentions that they'd recently recounted the graves while attempting to rectifying some errors resulting in unmarked or mismarked graves.
[20:18:26] <FatPhil> 40K? OK, the comparison I was after was Brit deaths on the 1st day at the Somme. Which was 20K.
[20:18:53] <FatPhil> And the first thing that went through my head was "20K sounds a lot, but I've been to Arlington..."
[20:19:57] <FatPhil> But I was unable to put a number on my visual memory.
[20:22:30] <FatPhil> It was shocking and mesmorising, to someone who sees straight lines and vanishing points. Honestly, I would recommend it to anyone visiting anywhere near DC. Depressing to be honest, no other word for it.
[20:24:04] <FatPhil> I have only 3 clear memories of my trip to the states - the Vietnam Memorial, Arlington, and the size of the steaks in the first pub we went to when we arrived in Boston.
[20:25:21] <FatPhil> Ah, Washington/Lincoln/Reflecting Pool too.
[20:26:13] <carny> FatPhil: a lot of dead americans are buried in france
[20:26:52] <FatPhil> Was there no post hoc repatriation of the bodies?
[20:28:50] <carny> i'm sure some were but the cemeteries in france are still huge
[20:29:11] <FatPhil> Graves are memorials, and the people who deserve the symbolism of same are the relatives, so it's a real shame to not have repatriation.
[20:29:19] <carny> i have no idea what the numbers are but people who go there often break down in tears at the sheer magnitude
[20:29:33] <carny> agreed
[20:29:42] <FatPhil> I did in Arlington, even though I had no connection to it at all.
[20:30:15] <FatPhil> Which is why I would recommend it. Put your life in perspective.
[20:36:17] <AndyTheAbsurd> 400,000 graves - I missed a zero the first time around.
[20:36:27] <AndyTheAbsurd> Serves me right for not proofreading.
[20:37:42] <FatPhil> Thanks, if I'd had to ballpark it it would have been "must be hundreds of thousands", it was almost endless.
[20:39:12] <carny> i forget how many wars and decades are represented at arlington but it's a lot
[20:39:45] <carny> and of course some vets prefer to be buried in the cemetery of their family instead
[20:48:22] <Bender> [SoylentNews] - Cancer Vaccine Ready for Clinical Trials - https://sylnt.us - Hope-Springs-Eternal
[22:08:25] <chromas> Graves are memorials? This gives me an idea
[22:08:50] * chromas dials up the local antifa chapter
[22:11:03] <carny> they did it in spain
[22:11:37] <carny> they might do it here if they didn't learn their lesson
[23:08:12] <Bender> [SoylentNews] - Comet Neowise Could be a "Great" One. Here's How to Catch It Throughout July - https://sylnt.us - no-comet