#soylent | Logs for 2020-04-08
« return
[00:07:23] -!- SoyCow8505 [SoyCow8505!~adefc76c@173.239.tly.rsk] has joined #soylent
[00:10:42] -!- SoyCow8505 has quit [Client Quit]
[00:16:25] <Bender> [SoylentNews] - Google Tests Hiding Chrome Extension Icons by Default, Developers Definitely Not Amused by Change - https://sylnt.us - why-not-add-an-icon-to-customize-your-icon-bar
[00:16:52] -!- driveby has quit [Quit: Leaving.]
[01:05:58] -!- AzumaHazuki [AzumaHazuki!~hazuki@the.end.of.time] has joined #soylent
[01:48:27] -!- boru` [boru`!~boru@dsfb-83-232-727-36.dynamic.mnet-online.de] has joined #soylent
[01:48:29] -!- boru has quit [Killed (NickServ (GHOST command used by boru`!~boru@dsfb-83-232-727-36.dynamic.mnet-online.de))]
[01:48:32] boru` is now known as boru
[02:17:12] <Bender> [SoylentNews] - Verizon Refuses to Give DSL Users its Low-Income Deals During Pandemic - https://sylnt.us - not-eligible
[02:48:01] -!- Sulla has quit [Ping timeout: 244 seconds]
[03:59:19] <chromas> What kind of sick and twisted world is this?
[03:59:30] <chromas> A whole pile of CR2032s and they're all dead
[03:59:46] <chromas> import morrisette;
[04:05:14] <GrandFireWizard> exeute alanis;
[04:06:46] <chromas> The lost ditty of Alanis
[04:06:48] <Bender> [SoylentNews] - Disagreements Help Team Perception, Study Finds - https://sylnt.us - marriages-must-be-very-perceptive
[04:12:04] <carny> chromas: is amazon still delivering for you?
[04:12:22] <carny> you can get 20 from amazon for the price of 2 at target
[04:12:43] <chromas> Probably. All the trucks still go by
[04:12:59] <chromas> UPS, Fedex, USPS. Not DHL. Nobody uses DHL
[04:13:35] <chromas> Thanks for the pointer
[04:13:46] * chromas checks for null before dereferencing
[04:16:12] <carny> 2032s have stable chemistry so they can sit on the shelf for a long time
[04:16:48] <carny> if you can find sony branded blister packs they usually come with a prominent manufacture date so you know your not getting 10 year old stock
[04:17:22] <carny> more expensive but worth it if you have a bunch of stuff that uses them and only want to order once every decade ;]
[04:23:08] <chromas> Only need one. Just trying to get a PC working. Dead battery shouldn't affect that but I've seen it cause problems before for some reason
[04:23:58] <carny> you only have one pc that takes a cr2032?
[04:24:23] <chromas> Not gonna steal from my pc. I need it :)
[04:28:21] <chromas> Ah. Found some out in storage
[04:29:57] <chromas> Didn't help
[04:30:10] <chromas> Well now I know. But knowing is only half the battle
[04:31:10] <chromas> A cell in one hand is worth two-and-a-half volts
[04:41:07] -!- AzumaHazuki has quit [Remote host closed the connection]
[04:48:05] <carny> um i think it's supposed to be 3.3v ;]
[04:48:46] <carny> and i meant if you have a bunch of things that take cr2032 you can at least feel good about having plenty for the future if you get a bulk pack
[05:56:31] <Bender> [SoylentNews] - The Spacecraft That Utterly Transformed SpaceX Has Flown its Last Mission - https://sylnt.us - to-infinity-and-beyond
[07:46:54] <Bender> [SoylentNews] - Boeing to Launch Starliner Spacecraft for Second Go at Reaching the ISS after First Mission Failed - https://sylnt.us - second-time's-a-charm?
[08:00:06] -!- Web_weasel [Web_weasel!~Stefan@swuj76-290-96-345.range40-314.btcentralplus.com] has joined #soylent
[09:36:42] <Bender> [SoylentNews] - Senators Raise Privacy Questions About Google's COVID-19 Tracker - https://sylnt.us - I-see-you
[09:40:01] <chromas> But only Google's?
[09:49:51] <chromas> windows--
[09:49:51] <Bender> karma - windows: -27
[09:50:07] <chromas> Disc has contents. Erase? Y
[09:50:20] <chromas> [erase, eject disc] There's no disc in the drive!
[09:50:30] <chromas> [insert disc] no blank disc!
[09:50:34] <chromas> [disc not erased]
[10:57:40] <FatPhil> https://i.imgur.com
[11:19:42] <boru> I need a second opionion. Reading the introduction/summary for this book (click read more); it bas to be a scam, right? This looks like it was text generated by a spambot or computer: https://www.amazon.de
[11:19:47] <systemd> ^ 03RISC-V A Clear and Concise Reference: Amazon.de: Blokdyk, Gerardus: Fremdsprachige Bücher
[11:26:21] <Bender> [SoylentNews] - Deep-Sea Worms and Bacteria Team up to Harvest Methane - https://sylnt.us - So-they-feed-off-Jumpin'-Jack-Flash?
[11:29:07] <boru> Actually, all of his books (must be nearly a hundred) are basically search/replace for a term, and worded exactly the same. This scammer is prolific.
[11:32:51] <AndyTheAbsurd> The only way being a scammer pays is by being prolific.
[11:33:18] <boru> True enough. I'm just surprised that this one hasn't blown his cover.
[11:33:32] <boru> All of this "books" are quite literally find/replace with the term on the cover.
[11:33:39] <boru> It's remarkable.
[12:01:56] <janrinok> I've just read a bit further and spotted things like : Language: Englisch
[12:02:14] <janrinok> why translate one word and not the other...
[12:25:24] <FatPhil> I'm guessing this is the same problem the other way round - Taschenbuch: 282 pages
[12:26:32] <FatPhil> the review's pretty unambiguous: "Ce livre a du être écrit par un générateur automatique de texte"
[12:37:38] <inz> Someone had to do it: https://inz.fi (pardon my lousy gimp-fu)
[12:39:27] <FatPhil> That reminds me of what I did when Nokia Networks sold Nokia Cambridge Product Development to Marconi back in 1999...
[12:42:09] <inz> Oh, I'd missed that altogether
[12:44:19] <inz> The best part of having worked for nokia: I knew the font to use for the "connecting people" already
[12:45:57] <FatPhil> this one: http://fatphil.org
[12:46:27] <FatPhil> From the Kuopio office, taken on a classic Motorola clamshell potato.
[12:49:10] <inz> Classy.
[12:49:39] <inz> I didn't even know there ever was an office in Kuopio
[12:50:02] <inz> Then again, most of my Nokia time was in Toijala, which is/was probably even less known.
[13:54:12] <FatPhil> the collapse of the Korean shipping industry: https://www.youtube.com
[13:54:13] <systemd> ^ 03Major incident declared at Busan New Port, South Korea. 6th April 2020
[14:26:18] <Bender> [SoylentNews] - Stealth Quantum Computing Company Raises $215M to Build 1M Qbit Computer - https://sylnt.us - who-has-the-power?
[14:33:16] <Bytram> .
[14:35:40] <Bytram> I've got a simple MySQL question, but I cannot think of how to search for it. :P Any suggestions? I want to be able to do: SELECT something, date, id, value FROM table ORDER BY date; and have the value displayed for "something" being its ordinal in the result. e.g.:
[14:36:12] <Bytram> 1 2020-04-01 23 text1
[14:36:22] <Bytram> 2 2020-04-01 31 text2
[14:36:37] <Bytram> 2 2020-04-01 32 text3
[14:36:40] <Bytram> ugh.
[14:36:44] <Bytram> 3 2020-04-01 32 text3
[14:37:16] <Bytram> 4 2020-04-03 33 more text
[14:37:19] <Bytram> etc.
[14:37:24] <Bytram> suggestions?
[14:43:17] <gozar> select cast(something as int),date,id...
[14:43:35] <gozar> Is something a column?
[14:44:10] <AndyTheAbsurd> I think that's his problem: "something" isn't a column, he just wants to have a number there like it was an <li> item in an HTML <ol> list.
[14:44:32] <Bytram> gozar: no, it is not
[14:45:36] <Bytram> SELECT something, date, title FROM stories WHERE auid = 76 ORDER BY date;
[14:46:29] <Bytram> so I can see what stories I've pushed out, in order and find out what my, say 40th story was, or 8400th (that one, especially) was.
[14:46:31] <FatPhil> it can be done with a cursor in a stored procedure
[14:46:46] <gozar> Look at ROW_NUMBER().
[14:46:48] <Bytram> hmm,
[14:47:10] <Bytram> SELECT something, date, sid, title FROM stories WHERE auid = 76 ORDER BY date;
[14:47:17] <gozar> select ROW_NUMBER() OVER ( order by id) something,date,id...
[14:47:23] <Bytram> helps to have the story id, too. =)
[14:47:47] <Bytram> "something" is the placeholder where I'd like the ordinal to appear.
[14:48:25] <gozar> I think ROW_NUMBER will do it like in my example. It returns the row number of the result as something.
[14:48:59] <Bytram> SELECT ROW_NUMBER() OVER (ORDER BY date) date, sid, title FROM stories WHERE auid = 76 ORDER BY date;
[14:49:07] <Bytram> ^^^ like that?
[14:49:14] <Bytram> missing comma
[14:49:20] <Bytram> SELECT ROW_NUMBER() OVER (ORDER BY date), date, sid, title FROM stories WHERE auid = 76 ORDER BY date;
[14:49:39] <gozar> What do you want to name the column for the row number?
[14:50:03] <Bytram> not important... how about "ordinal"
[14:50:09] <gozar> SELECT ROW_NUMBER() OVER (ORDER BY date) row_num,date,sid,title...
[14:50:45] <gozar> I've never used ROW_NUMBER before, but that looks like it would work from looking at the examples on the web.
[14:50:54] <Bytram> nod nod
[14:51:02] <Bytram> I'll give it a try. Thanks!
[14:53:46] <Bytram> PASTE_BEGIN
[14:53:49] <Bytram> mysql> SELECT ROW_NUMBER() OVER (ORDER BY date), date, sid, title FROM stories WHERE auid = 76 ORDER BY date;
[14:53:49] <Bytram> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(ORDER BY date), date, sid, title FROM stories WHERE auid = 76 ORDER BY date' at line 1
[14:53:55] <Bytram> PASTE_END
[14:55:38] <Bytram> would help if I used the correct table and column names! biab
[14:59:24] <FatPhil> holy fuck, those windowing functions are a game changer, this ain't no 4GL any more. LAG() and LEAD() in particular.
[15:03:50] * TheMightyBuzzard yawns
[15:03:50] * MrPlow flips a Skittle into TheMightyBuzzard's gaping mouth
[15:04:26] <TheMightyBuzzard> long sleep
[15:04:58] <Bytram> sleep++
[15:04:58] <Bender> karma - sleep: 26
[15:05:07] <Bytram> =gday TheMightyBuzzard
[15:05:08] * systemd abnormally inserts a slice of milo into TheMightyBuzzard
[15:05:14] <Bytram> lol
[15:05:38] <TheMightyBuzzard> ~gday Bytram
[15:05:39] * exec scientifically hangs a trigger warning sign about a splash of goop on Bytram
[15:06:41] <TheMightyBuzzard> whatcha breakin?
[15:07:51] * Bytram just passed 8400 stories posted and trying to find out which one it was
[15:10:15] <FatPhil> limit
[15:11:01] <FatPhil> in particular: limit 8400,1
[15:11:35] <TheMightyBuzzard> row_number is mysql 8+, we're on 7.5
[15:11:48] <Bytram> good to know!
[15:13:43] <TheMightyBuzzard> https://www.mysqltutorial.org
[15:13:44] <systemd> ^ 03MySQL row_number, This Is How You Emulate It.
[15:21:41] <Bytram> clicky
[15:21:47] <TheMightyBuzzard> title is not a stories column. think it's story_text
[15:22:06] <Bytram> yes, tru dat.
[15:23:05] <Bytram> Kewel! That tip will work perfectly.
[15:23:10] <Bytram> TheMightyBuzzard++ TYVM!
[15:23:10] <Bender> karma - themightybuzzard: 377
[15:23:28] <TheMightyBuzzard> set @row_number = 0; select (@row_number := @row_number + 1) as num, time as date, sid from stories where uid = 18 order by date desc limit 10;
[15:26:12] <TheMightyBuzzard> if you wanna get your funkiness on you can pull the title in from story_text. not strictly necessary though since just add the sid to "https://soylentnews.org/article.pl?sid=" and you have a link
[15:26:13] <systemd> ^ 03Error
[15:26:55] <Bytram> nod nod on the latter. no need to put any excess load on the db
[15:27:20] <TheMightyBuzzard> what's a join between friends?
[15:29:12] <Bytram> What is violating social distancing recommendations? Alex.
[15:29:17] <Bytram> =)
[15:29:57] <Bytram> kinda worked, but the @row_number is within the limit 10 results, not the entire table.
[15:30:13] <TheMightyBuzzard> ahhh
[15:30:31] <TheMightyBuzzard> um, if you're sorting by date it should be the same
[15:31:02] <TheMightyBuzzard> unless you're looking for which row id from the entire db
[15:31:26] * Bytram is trying to find out which story was his 8400th
[15:31:33] <Bytram> so, yes. from entire DB
[15:31:48] <TheMightyBuzzard> YOUR 8400th not the whole db's
[15:31:49] <Bytram> I just went and queried them all =)
[15:31:58] <Bytram> oh, yeah.
[15:32:18] <Bytram> got it anyway. that @ var was key. THANKS!
[15:33:14] <Bytram> https://soylentnews.org
[15:33:16] <systemd> ^ 03FDA Requests Removal of All Ranitidine Products (Zantac) from the Market - SoylentNews
[15:33:27] <Bytram> heartburn++
[15:33:27] <Bender> karma - heartburn: 1
[15:33:36] <Bytram> thanks for the help everybody!!
[15:33:39] <Bytram> teamwork++
[15:33:39] <Bender> karma - teamwork: 51
[15:37:04] <TheMightyBuzzard> for future reference: set @row_number = 0; select * from (select (@row_number := @row_number + 1) as num, time as date, sid from stories where uid = 18 order by date desc) as t where num = 10;
[15:38:18] <TheMightyBuzzard> replace 18 with whoever's uid and 10 with which row number ya want
[15:38:37] * Bytram leans forward
[15:39:46] <TheMightyBuzzard> prolly help to read if you python'd it up
[15:41:04] <TheMightyBuzzard> it's a select * from FOO as t where num = therow; where foo is the nested statement from earlier.
[15:45:34] <FatPhil> why not: select * from time as date, sid from stories where uid=18 order by date desc limit 10,1
[15:46:09] * TheMightyBuzzard shurgs
[15:48:02] <TheMightyBuzzard> cause it was the first way i thought of that made it work mostly
[15:48:33] <Bytram> I tried this:
[15:48:34] <TheMightyBuzzard> nicotine++ #smoke break
[15:48:35] <Bender> karma - nicotine: 763
[15:48:35] <Bytram> set @row_number = 0; select * from (select (@row_number := @row_number + 1) as num, time as date, sid from stories where uid = 76 order by date desc) as t where num = 8400;
[15:48:47] <Bytram> and got a hit for a story from 2014
[15:48:57] <TheMightyBuzzard> remove the desc
[15:49:01] <Bytram> nod nod
[15:49:32] <TheMightyBuzzard> serious about that smoke break
[15:49:43] <Bytram> looks much bettah
[15:49:43] <Bytram> | 8400 | 2020-04-07 14:56:00 | 20/04/07/0222234 |
[15:50:10] <Bytram> ya, break time for me, too.
[15:50:15] <Bytram> laters everybody
[16:25:11] <Bender> [SoylentNews] - NASA Expands Groundwater Maps Globally to Help Reveal Remote Droughts - https://sylnt.us - dry-research
[16:37:18] <alexbst> ho
[16:37:20] <alexbst> hoi
[16:39:21] <AndyTheAbsurd> hai
[16:56:53] -!- arti|work has quit [Quit: My Mac has gone to sleep. ZZZzzz…]
[16:57:06] -!- arti|work [arti|work!~textual@fhv-836-375-856-960.socal.res.rr.com] has joined #soylent
[16:59:21] <pinchy> taxes caused the civil war!
[16:59:48] <pinchy> hi my names lincoln and im going to raise tarriffs 47%
[17:04:29] <AndyTheAbsurd> I'm starting to get convinced that Trump is trying to start a second civil war
[17:06:17] <AndyTheAbsurd> Trump is telling states to get their own medical supplies, so states are ordering and paying ahead for medical supplies, then FEMA is confiscating them "for redistribution" which does not happen.
[17:06:54] <AndyTheAbsurd> It's fucking outright theft, and I think Trump wants people to start shooting at federal forces over it so that he can have a war.
[17:14:34] <pinchy> thats absurd!
[17:15:03] <pinchy> looks like japan finally did something
[17:15:14] <pinchy> let each city decide the best policy
[17:15:18] <FatPhil> you haven't had a good war for a while, and he wants to be an actual war president
[17:15:32] <FatPhil> That, and he's a huge fan of Fight Club
[17:24:53] -!- fungus_ has quit [Remote host closed the connection]
[17:25:05] -!- fyngyrz has quit [Quit: Leaving...]
[17:32:07] <FatPhil> Carny: I have this week's 3-ply medicinal face masks hanging up in my sauna presently - humidity's not going to have any reduction on the heat-denaturing, is it? It's at ~90, which is way higher than the "20 mins in the oven" recommendations.
[17:33:42] <FatPhil> (I can probably vary it between 110 and 60, depending on what level I hang it at, as the temperature gradient is quite steep.
[17:38:49] -!- Sulla [Sulla!~18153d4f@h-83-92-68-69.hsd3.or.comcast.net] has joined #soylent
[17:50:16] <carny> https://soundcloud.com
[17:50:17] <systemd> ^ 03Acting SECNAV Modley criticizing Capt. Crozier to sailors onboard USS Theodore Roosevelt
[17:51:19] <carny> FatPhil: honestly i wouldn't use humidity if i had access to dry heat at a controlled temp anywhere between 90f and 150f
[17:51:46] -!- fungus [fungus!~ben@66.171.jo.vll] has joined #soylent
[17:51:50] <carny> the real value of high quality respirator material is the static filtration aspect of the fibers
[17:52:04] <carny> and liquids can affect that
[17:52:48] <chromas> Put it n the drier for a bit without a sheet
[17:53:43] -!- fyngyrz [fyngyrz!~fyngyrz@Soylent/Staff/Editor/fyngyrz] has joined #soylent
[17:53:43] -!- mode/#soylent [+v fyngyrz] by Aphrodite
[17:57:40] <carny> chromas: i don't know how well driers regulate their temps but i would be concerned
[17:58:17] <carny> actually let me correct that 150f to 140f because i'd be worried about damage to the elastic
[18:01:21] <carny> having your elastic snap while you're leaning over an infected patient is not a beneficial outcome
[18:02:39] <carny> i've already had the polymer strap on one mask snap on me but lucky for me it was at home as i was in decontamination
[18:05:39] <chromas> Put it in air dry
[18:06:05] <chromas> Throw in some mixed fabrics. Profit!
[18:09:27] <Deucalion> <carny> https://soundcloud.com Moldy resigned the post of SecNav over that debacle.
[18:11:02] <carny> as he should have
[18:11:17] <carny> more heads need to roll over this cluster fuck
[18:12:18] <carny> and people need to go to prison and have their ill gotten wealth confiscated not just be fired from one cushy job and get another one 3 weeks later
[18:16:43] <Bender> [SoylentNews] - 3-D Printing, Biology Research Make the Journey Back to Earth Aboard Spacex's Dragon - https://sylnt.us - to-space-and-back
[18:18:22] <Deucalion> How the other half live. It's been the same way for centuries. Symptomatic of intrinsic human greed unfortunately - good luck changing that in any lasting way.
[19:21:02] <FatPhil> carny: ditto, it's just that I didn't think about using the sauna until we were just about to go in! Seems obvious in retrospect. It takes 70 mins to go from 20 to 75, so I can just leave it in there for the warm-up time.
[19:21:33] <FatPhil> The paper bag I was keeping them in self-destructed, as the handle was glued on with a crappy glue!
[19:37:04] -!- Sulla has quit [Ping timeout: 244 seconds]
[20:06:21] <Bender> [SoylentNews] - Android Users Hit With 'Unkillable Malware' - https://sylnt.us - rooted-in-your-phone
[20:07:43] -!- Sulla [Sulla!~18153d4f@h-83-92-68-69.hsd3.or.comcast.net] has joined #soylent
[20:12:51] <carny> FatPhil: are you saying ditto to my temp control point or my idea of live streaming capital punishment of incompetent officials? ;]
[20:18:58] <chromas> The Windows DVD ISO is just barely too big to fit onto a DVD
[20:19:07] <chromas> "Use a dual-layer disc", the comments say
[20:19:26] <chromas> Well nobody has those because DVD burning was dead by the time those came out
[20:30:31] <carny> chromas: how much too big?
[20:31:05] <carny> if you want to make one some linux burning apps will let you overburn a single layer disc a little bit
[20:32:40] <chromas> .3GB too big
[20:33:00] <chromas> I have overburn enabled but maybe it's not enough
[20:33:32] <chromas> For reasons unknown, this box won't boot from USB even though the option is there and it detects the thumbdrive
[20:33:46] * chromas blames beta
[20:34:59] <FatPhil> carny: both, at the same time!
[20:35:56] <chromas> Make them turn up their own heat and live stream it?
[20:36:19] <FatPhil> chromas: weren't these things designed to be printable larger than burnable, deliberately to permit uncopiable-by-virtue-of-size discs?
[20:37:56] <chromas> Seems plausible.
[20:38:05] * chromas blames Disney
[20:38:18] <FatPhil> mouse-puncher
[20:38:58] <chromas> Could be a Donkey puncher but I don't even know if Dreamworks was around back then
[21:00:46] -!- Sulla has quit [Ping timeout: 244 seconds]
[21:08:08] <chromas> Aha! It appears this os one of those 64-bit CPUs that doesn't like 64-bit operating systemd
[21:21:42] <FatPhil> 32 bits should be enough for anyone
[21:34:02] <chromas> It should, what with PAE and all
[21:57:59] <Bender> [SoylentNews] - Researchers Suggest a Special Diet Against Asthma - https://sylnt.us - carnivores++
[22:35:57] -!- Web_weasel has quit [Read error: Connection reset by peer]
[23:46:25] <Bender> [SoylentNews] - Blocking the Iron Transport Could Stop Tuberculosis - https://sylnt.us - no,-not-the-railway