#soylent | Logs for 2020-04-08

« return
[23:46:25] <Bender> [SoylentNews] - Blocking the Iron Transport Could Stop Tuberculosis - https://sylnt.us - no,-not-the-railway
[22:35:57] -!- Web_weasel has quit [Read error: Connection reset by peer]
[21:57:59] <Bender> [SoylentNews] - Researchers Suggest a Special Diet Against Asthma - https://sylnt.us - carnivores++
[21:34:02] <chromas> It should, what with PAE and all
[21:21:42] <FatPhil> 32 bits should be enough for anyone
[21:08:08] <chromas> Aha! It appears this os one of those 64-bit CPUs that doesn't like 64-bit operating systemd
[21:00:46] -!- Sulla has quit [Ping timeout: 244 seconds]
[20:38:58] <chromas> Could be a Donkey puncher but I don't even know if Dreamworks was around back then
[20:38:18] <FatPhil> mouse-puncher
[20:38:05] * chromas blames Disney
[20:37:56] <chromas> Seems plausible.
[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:35:56] <chromas> Make them turn up their own heat and live stream it?
[20:34:59] <FatPhil> carny: both, at the same time!
[20:33:46] * chromas blames beta
[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:00] <chromas> I have overburn enabled but maybe it's not enough
[20:32:40] <chromas> .3GB 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:30:31] <carny> chromas: how much too big?
[20:19:26] <chromas> Well nobody has those because DVD burning was dead by the time those came out
[20:19:07] <chromas> "Use a dual-layer disc", the comments say
[20:18:58] <chromas> The Windows DVD ISO is just barely too big to fit onto a DVD
[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:07:43] -!- Sulla [Sulla!~18153d4f@h-83-92-68-69.hsd3.or.comcast.net] has joined #soylent
[20:06:21] <Bender> [SoylentNews] - Android Users Hit With 'Unkillable Malware' - https://sylnt.us - rooted-in-your-phone
[19:37:04] -!- Sulla has quit [Ping timeout: 244 seconds]
[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: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.
[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.
[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: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:11:17] <carny> more heads need to roll over this cluster fuck
[18:11:02] <carny> as he should have
[18:09:27] <Deucalion> <carny> https://soundcloud.com Moldy resigned the post of SecNav over that debacle.
[18:06:05] <chromas> Throw in some mixed fabrics. Profit!
[18:05:39] <chromas> Put it in air dry
[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:01:21] <carny> having your elastic snap while you're leaning over an infected patient is not a beneficial outcome
[17:58:17] <carny> actually let me correct that 150f to 140f because i'd be worried about damage to the elastic
[17:57:40] <carny> chromas: i don't know how well driers regulate their temps but i would be concerned
[17:53:43] -!- mode/#soylent [+v fyngyrz] by Aphrodite
[17:53:43] -!- fyngyrz [fyngyrz!~fyngyrz@Soylent/Staff/Editor/fyngyrz] has joined #soylent
[17:52:48] <chromas> Put it n the drier for a bit without a sheet
[17:52:04] <carny> and liquids can affect that
[17:51:50] <carny> the real value of high quality respirator material is the static filtration aspect of the fibers
[17:51:46] -!- fungus [fungus!~ben@66.171.jo.vll] has joined #soylent
[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:50:17] <systemd> ^ 03Acting SECNAV Modley criticizing Capt. Crozier to sailors onboard USS Theodore Roosevelt
[17:50:16] <carny> https://soundcloud.com
[17:38:49] -!- Sulla [Sulla!~18153d4f@h-83-92-68-69.hsd3.or.comcast.net] has joined #soylent
[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: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:25:05] -!- fyngyrz has quit [Quit: Leaving...]
[17:24:53] -!- fungus_ has quit [Remote host closed the connection]
[17:15:32] <FatPhil> That, and he's a huge fan of Fight Club
[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:14] <pinchy> let each city decide the best policy
[17:15:03] <pinchy> looks like japan finally did something
[17:14:34] <pinchy> thats absurd!
[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: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:04:29] <AndyTheAbsurd> I'm starting to get convinced that Trump is trying to start a second civil war
[16:59:48] <pinchy> hi my names lincoln and im going to raise tarriffs 47%
[16:59:21] <pinchy> taxes caused the civil war!
[16:57:06] -!- arti|work [arti|work!~textual@fhv-836-375-856-960.socal.res.rr.com] has joined #soylent
[16:56:53] -!- arti|work has quit [Quit: My Mac has gone to sleep. ZZZzzz…]
[16:39:21] <AndyTheAbsurd> hai
[16:37:20] <alexbst> hoi
[16:37:18] <alexbst> ho
[16:25:11] <Bender> [SoylentNews] - NASA Expands Groundwater Maps Globally to Help Reveal Remote Droughts - https://sylnt.us - dry-research
[15:50:15] <Bytram> laters everybody
[15:50:10] <Bytram> ya, break time for me, too.
[15:49:43] <Bytram> | 8400 | 2020-04-07 14:56:00 | 20/04/07/0222234 |
[15:49:43] <Bytram> looks much bettah
[15:49:32] <TheMightyBuzzard> serious about that smoke break
[15:49:01] <Bytram> nod nod
[15:48:57] <TheMightyBuzzard> remove the desc
[15:48:47] <Bytram> and got a hit for a story from 2014
[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:35] <Bender> karma - nicotine: 763
[15:48:34] <TheMightyBuzzard> nicotine++ #smoke break
[15:48:33] <Bytram> I tried this:
[15:48:02] <TheMightyBuzzard> cause it was the first way i thought of that made it work mostly
[15:46:09] * TheMightyBuzzard shurgs
[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:41:04] <TheMightyBuzzard> it's a select * from FOO as t where num = therow; where foo is the nested statement from earlier.
[15:39:46] <TheMightyBuzzard> prolly help to read if you python'd it up
[15:38:37] * Bytram leans forward
[15:38:18] <TheMightyBuzzard> replace 18 with whoever's uid and 10 with which row number ya want
[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:33:39] <Bender> karma - teamwork: 51
[15:33:39] <Bytram> teamwork++
[15:33:36] <Bytram> thanks for the help everybody!!
[15:33:27] <Bender> karma - heartburn: 1
[15:33:27] <Bytram> heartburn++
[15:33:16] <systemd> ^ 03FDA Requests Removal of All Ranitidine Products (Zantac) from the Market - SoylentNews
[15:33:14] <Bytram> https://soylentnews.org
[15:32:18] <Bytram> got it anyway. that @ var was key. THANKS!
[15:31:58] <Bytram> oh, yeah.
[15:31:49] <Bytram> I just went and queried them all =)
[15:31:48] <TheMightyBuzzard> YOUR 8400th not the whole db's
[15:31:33] <Bytram> so, yes. from entire DB
[15:31:26] * Bytram is trying to find out which story was his 8400th
[15:31:02] <TheMightyBuzzard> unless you're looking for which row id from the entire db
[15:30:31] <TheMightyBuzzard> um, if you're sorting by date it should be the same
[15:30:13] <TheMightyBuzzard> ahhh
[15:29:57] <Bytram> kinda worked, but the @row_number is within the limit 10 results, not the entire table.
[15:29:17] <Bytram> =)
[15:29:12] <Bytram> What is violating social distancing recommendations? Alex.
[15:27:20] <TheMightyBuzzard> what's a join between friends?
[15:26:55] <Bytram> nod nod on the latter. no need to put any excess load on the db
[15:26:13] <systemd> ^ 03Error
[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: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:23:10] <Bender> karma - themightybuzzard: 377
[15:23:10] <Bytram> TheMightyBuzzard++ TYVM!
[15:23:05] <Bytram> Kewel! That tip will work perfectly.
[15:22:06] <Bytram> yes, tru dat.
[15:21:47] <TheMightyBuzzard> title is not a stories column. think it's story_text
[15:21:41] <Bytram> clicky
[15:13:44] <systemd> ^ 03MySQL row_number, This Is How You Emulate It.
[15:13:43] <TheMightyBuzzard> https://www.mysqltutorial.org
[15:11:48] <Bytram> good to know!
[15:11:35] <TheMightyBuzzard> row_number is mysql 8+, we're on 7.5
[15:11:01] <FatPhil> in particular: limit 8400,1
[15:10:15] <FatPhil> limit
[15:07:51] * Bytram just passed 8400 stories posted and trying to find out which one it was
[15:06:41] <TheMightyBuzzard> whatcha breakin?
[15:05:39] * exec scientifically hangs a trigger warning sign about a splash of goop on Bytram
[15:05:38] <TheMightyBuzzard> ~gday Bytram
[15:05:14] <Bytram> lol
[15:05:08] * systemd abnormally inserts a slice of milo into TheMightyBuzzard
[15:05:07] <Bytram> =gday TheMightyBuzzard
[15:04:58] <Bender> karma - sleep: 26
[15:04:58] <Bytram> sleep++
[15:04:26] <TheMightyBuzzard> long sleep
[15:03:50] * MrPlow flips a Skittle into TheMightyBuzzard's gaping mouth
[15:03:50] * TheMightyBuzzard yawns
[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.
[14:55:38] <Bytram> would help if I used the correct table and column names! biab
[14:53:55] <Bytram> PASTE_END
[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:49] <Bytram> mysql> SELECT ROW_NUMBER() OVER (ORDER BY date), date, sid, title FROM stories WHERE auid = 76 ORDER BY date;
[14:53:46] <Bytram> PASTE_BEGIN
[14:51:02] <Bytram> I'll give it a try. Thanks!
[14:50:54] <Bytram> nod nod
[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:09] <gozar> SELECT ROW_NUMBER() OVER (ORDER BY date) row_num,date,sid,title...
[14:50:03] <Bytram> not important... how about "ordinal"
[14:49:39] <gozar> What do you want to name the column for the row number?
[14:49:20] <Bytram> SELECT ROW_NUMBER() OVER (ORDER BY date), date, sid, title FROM stories WHERE auid = 76 ORDER BY date;
[14:49:14] <Bytram> missing comma
[14:49:07] <Bytram> ^^^ like that?
[14:48:59] <Bytram> SELECT ROW_NUMBER() OVER (ORDER BY date) date, sid, title FROM stories WHERE auid = 76 ORDER BY date;
[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:47:47] <Bytram> "something" is the placeholder where I'd like the ordinal to appear.
[14:47:23] <Bytram> helps to have the story id, too. =)
[14:47:17] <gozar> select ROW_NUMBER() OVER ( order by id) something,date,id...
[14:47:10] <Bytram> SELECT something, date, sid, title FROM stories WHERE auid = 76 ORDER BY date;
[14:46:48] <Bytram> hmm,
[14:46:46] <gozar> Look at ROW_NUMBER().
[14:46:31] <FatPhil> it can be done with a cursor in a stored procedure
[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:45:36] <Bytram> SELECT something, date, title FROM stories WHERE auid = 76 ORDER BY date;
[14:44:32] <Bytram> gozar: no, it is not
[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:43:35] <gozar> Is something a column?
[14:43:17] <gozar> select cast(something as int),date,id...
[14:37:24] <Bytram> suggestions?
[14:37:19] <Bytram> etc.
[14:37:16] <Bytram> 4 2020-04-03 33 more text
[14:36:44] <Bytram> 3 2020-04-01 32 text3
[14:36:40] <Bytram> ugh.
[14:36:37] <Bytram> 2 2020-04-01 32 text3
[14:36:22] <Bytram> 2 2020-04-01 31 text2
[14:36:12] <Bytram> 1 2020-04-01 23 text1
[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:33:16] <Bytram> .
[14:26:18] <Bender> [SoylentNews] - Stealth Quantum Computing Company Raises $215M to Build 1M Qbit Computer - https://sylnt.us - who-has-the-power?
[13:54:13] <systemd> ^ 03Major incident declared at Busan New Port, South Korea. 6th April 2020
[13:54:12] <FatPhil> the collapse of the Korean shipping industry: https://www.youtube.com
[12:50:02] <inz> Then again, most of my Nokia time was in Toijala, which is/was probably even less known.
[12:49:39] <inz> I didn't even know there ever was an office in Kuopio
[12:49:10] <inz> Classy.
[12:46:27] <FatPhil> From the Kuopio office, taken on a classic Motorola clamshell potato.
[12:45:57] <FatPhil> this one: http://fatphil.org
[12:44:19] <inz> The best part of having worked for nokia: I knew the font to use for the "connecting people" already
[12:42:09] <inz> Oh, I'd missed that altogether
[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:37:38] <inz> Someone had to do it: https://inz.fi (pardon my lousy gimp-fu)
[12:26:32] <FatPhil> the review's pretty unambiguous: "Ce livre a du être écrit par un générateur automatique de texte"
[12:25:24] <FatPhil> I'm guessing this is the same problem the other way round - Taschenbuch: 282 pages
[12:02:14] <janrinok> why translate one word and not the other...
[12:01:56] <janrinok> I've just read a bit further and spotted things like : Language: Englisch
[11:33:39] <boru> It's remarkable.
[11:33:32] <boru> All of this "books" are quite literally find/replace with the term on the cover.
[11:33:18] <boru> True enough. I'm just surprised that this one hasn't blown his cover.
[11:32:51] <AndyTheAbsurd> The only way being a scammer pays is by being prolific.
[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: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:19:47] <systemd> ^ 03RISC-V A Clear and Concise Reference: Amazon.de: Blokdyk, Gerardus: Fremdsprachige B&uumlcher
[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
[10:57:40] <FatPhil> https://i.imgur.com
[09:50:34] <chromas> [disc not erased]
[09:50:30] <chromas> [insert disc] no blank disc!
[09:50:20] <chromas> [erase, eject disc] There's no disc in the drive!
[09:50:07] <chromas> Disc has contents. Erase? Y
[09:49:51] <Bender> karma - windows: -27
[09:49:51] <chromas> windows--
[09:40:01] <chromas> But only Google's?
[09:36:42] <Bender> [SoylentNews] - Senators Raise Privacy Questions About Google's COVID-19 Tracker - https://sylnt.us - I-see-you
[08:00:06] -!- Web_weasel [Web_weasel!~Stefan@swuj76-290-96-345.range40-314.btcentralplus.com] has joined #soylent
[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?
[05:56:31] <Bender> [SoylentNews] - The Spacecraft That Utterly Transformed SpaceX Has Flown its Last Mission - https://sylnt.us - to-infinity-and-beyond
[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
[04:48:05] <carny> um i think it's supposed to be 3.3v ;]
[04:41:07] -!- AzumaHazuki has quit [Remote host closed the connection]
[04:31:10] <chromas> A cell in one hand is worth two-and-a-half volts
[04:30:10] <chromas> Well now I know. But knowing is only half the battle
[04:29:57] <chromas> Didn't help
[04:28:21] <chromas> Ah. Found some out in storage
[04:24:23] <chromas> Not gonna steal from my pc. I need it :)
[04:23:58] <carny> you only have one pc that takes a cr2032?
[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: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: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:16:12] <carny> 2032s have stable chemistry so they can sit on the shelf for a long time
[04:13:46] * chromas checks for null before dereferencing
[04:13:35] <chromas> Thanks for the pointer
[04:12:59] <chromas> UPS, Fedex, USPS. Not DHL. Nobody uses DHL
[04:12:43] <chromas> Probably. All the trucks still go by
[04:12:22] <carny> you can get 20 from amazon for the price of 2 at target
[04:12:04] <carny> chromas: is amazon still delivering for you?
[04:06:48] <Bender> [SoylentNews] - Disagreements Help Team Perception, Study Finds - https://sylnt.us - marriages-must-be-very-perceptive
[04:06:46] <chromas> The lost ditty of Alanis
[04:05:14] <GrandFireWizard> exeute alanis;
[03:59:46] <chromas> import morrisette;
[03:59:30] <chromas> A whole pile of CR2032s and they're all dead
[03:59:19] <chromas> What kind of sick and twisted world is this?
[02:48:01] -!- Sulla has quit [Ping timeout: 244 seconds]
[02:17:12] <Bender> [SoylentNews] - Verizon Refuses to Give DSL Users its Low-Income Deals During Pandemic - https://sylnt.us - not-eligible
[01:48:32] boru` is now known as boru
[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:27] -!- boru` [boru`!~boru@dsfb-83-232-727-36.dynamic.mnet-online.de] has joined #soylent
[01:05:58] -!- AzumaHazuki [AzumaHazuki!~hazuki@the.end.of.time] has joined #soylent
[00:16:52] -!- driveby has quit [Quit: Leaving.]
[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:10:42] -!- SoyCow8505 has quit [Client Quit]
[00:07:23] -!- SoyCow8505 [SoyCow8505!~adefc76c@173.239.tly.rsk] has joined #soylent