#soylent | Logs for 2020-07-09

« return
[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
[22:11:37] <carny> they might do it here if they didn't learn their lesson
[22:11:03] <carny> they did it in spain
[22:08:50] * chromas dials up the local antifa chapter
[22:08:25] <chromas> Graves are memorials? This gives me an idea
[20:48:22] <Bender> [SoylentNews] - Cancer Vaccine Ready for Clinical Trials - https://sylnt.us - Hope-Springs-Eternal
[20:39:45] <carny> and of course some vets prefer to be buried in the cemetery of their family instead
[20:39:12] <carny> i forget how many wars and decades are represented at arlington but it's a lot
[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:36:27] <AndyTheAbsurd> Serves me right for not proofreading.
[20:36:17] <AndyTheAbsurd> 400,000 graves - I missed a zero the first time around.
[20:30:15] <FatPhil> Which is why I would recommend it. Put your life in perspective.
[20:29:42] <FatPhil> I did in Arlington, even though I had no connection to it at all.
[20:29:33] <carny> agreed
[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: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:28:50] <carny> i'm sure some were but the cemeteries in france are still huge
[20:26:52] <FatPhil> Was there no post hoc repatriation of the bodies?
[20:26:13] <carny> FatPhil: a lot of dead americans are buried in france
[20:25:21] <FatPhil> Ah, Washington/Lincoln/Reflecting Pool too.
[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: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:19:57] <FatPhil> But I was unable to put a number on my visual memory.
[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:18:26] <FatPhil> 40K? OK, the comparison I was after was Brit deaths on the 1st day at the Somme. Which was 20K.
[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:09:23] <AndyTheAbsurd> wikipedia says approximately 400,00 graves on 253 hectares.
[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)
[19:07:43] -!- carny [carny!~irc@az1490859.ip-82-14-486.eu] has joined #soylent
[18:36:42] <Bender> [SoylentNews] - Snap removed from Mint - https://sylnt.us - working-behind-your-back
[18:32:02] -!- carny has quit [Ping timeout: 265 seconds]
[17:54:19] -!- fyngyrz_ has quit [Quit: Leaving...]
[17:53:22] -!- fungus_ has quit [Remote host closed the connection]
[16:26:01] <Bender> [SoylentNews] - Apple Exports Independent Repair Provider Program to Europe and Canada - https://sylnt.us - IRP=RIP?
[15:37:20] -!- driveby has quit [Quit: Leaving.]
[15:24:38] -!- SoyGuest271828 has quit []
[15:22:15] -!- driveby [driveby!~amnesia@nz5219452.ip-58-662-29.eu] has joined #soylent
[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:06:41] <systemd> Submitting "Harvard, MIT sue Trump administration over ICE foreign-student rule, deeming it cruel and reckless"...
[15:06:40] <exec> └─ 13Harvard, MIT sue Trump administration over ICE foreign-student rule
[15:06:38] <SoyGuest271828> =asub https://www.usatoday.com
[15:06:17] <systemd> ✓ Sub-ccess! "03Google Open-sources Tsunami Vulnerability Scanner" (0 paragraphs) -> https://soylentnews.org
[15:05:56] <systemd> Submitting "Google open-sources Tsunami vulnerability scanner"...
[15:05:56] <FatPhil> Don't immanentize the Eschaton = Damn, he atomizes the continent! (anagram)
[15:05:55] <exec> └─ 13Google open-sources Tsunami vulnerability scanner | ZDNet
[15:05:52] <SoyGuest271828> =asub https://www.zdnet.com
[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:22] <exec> └─ 13Probe of failed Boeing Starliner launch finds a long list of problems | Engadget
[15:05:22] <systemd> Submitting "Probe of failed Boeing Starliner launch finds a long list of problems"...
[15:05:20] <SoyGuest271828> =asub https://www.engadget.com
[15:05:15] -!- SoyGuest271828 [SoyGuest271828!~4039920c@64.57.quj.nm] has joined #soylent
[15:04:30] <pinchy> stop all the data analysis
[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: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)
[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.
[14:38:22] <Bytram> how much data do you have, in all? GB?
[14:37:43] <Bytram> or, use software.
[14:37:29] <Bytram> create a temp table containing intermediate results and then do your actual query, later, from that temp table?
[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: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: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: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: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:31:58] <FatPhil> In fact I'm sure I'm wrong :-/
[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:30:00] <FatPhil> I just hate the fact that next year I'll need to edit it just to add another line.
[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:19:31] <Bytram> FYI: If you'd like, is easy for me to delete the story and comments afterwards, if desired
[14:18:37] <Bytram> FatPhil: comment posted
[14:16:26] <Bender> [SoylentNews] - Liquid Crystal Integrated Metalens for Versatile Color Focus - https://sylnt.us - color-me-impressed
[14:11:36] <Bytram> FatPhil: that helps a lot... I'll post a reply
[14:02:32] <exec> └─ 13Code Playground #1 - Dev.SN
[14:02:31] <systemd> ^ 03Code Playground #1 - Dev.SN ( https://dev.soylentnews.org )
[14:02:30] <FatPhil> https://dev.soylentnews.org
[13:49:28] <FatPhil> coolbeenz!
[13:12:07] <Bytram> FatPhil: ^^^
[13:11:15] <exec> └─ 13Code Playground #1 - Dev.SN
[13:11:14] <systemd> ^ 03Code Playground #1 - Dev.SN
[13:11:13] <Bytram> Here ya go: https://dev.soylentnews.org
[13:10:38] <Bytram> hold on...
[13:08:58] <Bytram> paste it on dev so I can see?
[13:08:31] <FatPhil> _that onyl sums one non-zero value
[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:07:50] <Bytram> good to hear
[13:07:33] <FatPhil> The horribly verbose multiple-SUM expression seems to be working
[13:07:09] <Bytram> use <ecode> ... <ecode> to bracket your code examples (functions like a combo of <pre> and <tt>)
[13:04:37] <Bytram> create a journal entry on dev? dev.soylentnews.org you have an acct there :)
[13:03:15] <Bytram> that would help
[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:01:56] <FatPhil> soylentnews needs a new service - a pastebin!
[13:01:30] <FatPhil> x=years, y=months
[13:01:15] <Bytram> y is a year taken from a table, years, with values: 2014, 2015, ... 2020.
[13:00:50] <FatPhil> I want n-tuples <y,v1,v2,v3> with <0,2,5,11>, <1,3,7,0>
[13:00:04] <Bytram> hold on
[12:59:58] <Bytram> oy!
[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:57:30] <Bytram> still am struggling... concrete examples, please?
[12:57:08] <FatPhil> then again, I need some expression for every year, so it makes sense.
[12:56:56] <FatPhil> but I need a sum expression for every year.
[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:13] * Bytram is *much* better working with concrete examples of data inputs and desired outputs.
[12:55:43] <FatPhil> yup.
[12:55:15] <Bytram> and XXXX is a 4-digit year?
[12:55:05] <FatPhil> (and the appropriate y)
[12:54:49] <FatPhil> vXXXX is the v for x=XXXX
[12:54:14] <Bytram> what does vXXXX mean? And does the XXXX signify a year and vXXXX denote the vale for that year?
[12:51:49] <Bytram> off the top of my head, and for simplicity sake, I'd thinking maybe use subqueries?
[12:51:00] <Bytram> and I'm not fully understanding the question.
[12:49:53] <Bytram> my SQL experience is rusty...
[12:47:16] <FatPhil> where vXXXX is the v for x=XXXX, obvs
[12:46:54] <FatPhil> And what I want is a set of n-tuples <y, v2014, v2015, v2016...v2020>
[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:42:02] <FatPhil> can anyone help me with some mysql?
[12:37:08] <Bender> karma - coffee: 5303
[12:37:08] <Bytram> coffee++
[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
[10:05:59] <Bender> [SoylentNews] - Shock-Dissipating Fractal Cubes Could Forge High-Tech Armor - https://sylnt.us - now-make-it-out-of-graphene
[10:05:53] <exec> └─ 13A Microsoft Addition For systemd 246 Exposes Host OS Information To Containers - Phoronix
[10:05:52] <systemd> ^ 03A Microsoft Addition For systemd 246 Exposes Host OS Information To Containers - Phoronix ( https://www.phoronix.com )
[10:05:51] <chromas> http://www.phoronix.com
[10:05:35] <chromas> Even Microsoft is working on systemd now
[07:58:20] <Bender> [SoylentNews] - 15 Billion Credentials Currently Up for Grabs on Hacker Forums - https://sylnt.us - get-your-hot-fresh-credentials-here!
[07:28:06] <FatPhil> if it hovers, and hums as it does so, I can accept that
[07:05:41] <inz> The wording gives me an impression that land cruiser cannot be considered a car
[06:57:32] <exec> └─ 13Oregon man driving stolen vehicle crashes into woman driving stolen car: police
[06:57:31] <systemd> ^ 03Oregon man driving stolen vehicle crashes into woman driving stolen car: police
[06:57:30] <chromas> https://www.fox10phoenix.com
[05:46:25] <Bender> [SoylentNews] - Free Tool Enables Recovery of Files Encrypted by ThiefQuest Mac Malware - https://sylnt.us - software-wants-to-be-freed
[03:50:11] -!- AzumaHazuki has quit [Quit: Leaving]
[03:37:52] <Bender> [SoylentNews] - IT Pros Indicted after Arranging Credit Card Payments for Weed Startup - https://sylnt.us - weeding-out-illegal-transactions
[02:42:29] <Bytram> ^^^ Boca Chica Build *and* Launch sites in ONE photo -- full size: https://pbs.twimg.com
[02:41:49] <Bytram> ^^^ Boca Chica Build *and* Launch sites in ONE photo
[02:41:08] <Bytram> https://pbs.twimg.com
[01:28:13] boru` is now known as boru
[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:07] -!- boru` [boru`!~boru@xlmp-33-232-722-158.dynamic.mnet-online.de] has joined #soylent
[01:25:32] <Bender> [SoylentNews] - Spider Silk Made by Photosynthetic Bacteria - https://sylnt.us - no-radioactive-bites-required
[00:17:25] -!- AzumaHazuki [AzumaHazuki!~hazuki@the.end.of.time] has joined #soylent
[00:08:19] -!- Teckla [Teckla!sid172075@fe-405803.highgate.irccloud.com] has joined #soylent
[00:08:03] -!- Teckla has quit []
[00:06:35] Teckla_ is now known as Teckla
[00:06:35] -!- Teckla has quit [Quit: leaving]