#Soylent | Logs for 2019-01-08

« return
[00:07:22] <AndyTheAbsurd> I'd buy a branded RPN calculator for .... </me thinks> ... maybe $30 plus shipping?
[00:07:50] <boru> HP's latest are quite expensive.
[00:08:45] <boru> I designed and built my own some time ago. I was considering designing another, and porting my Forth implementation to it.
[00:09:00] <boru> I'd send you one, if you wanted it, and would actually use it.
[00:10:35] <boru> Snail mail to the NA continent is pretty cheap.
[00:33:18] * chromas invents the (forward) polish notation calculator
[00:53:03] <Bytram> boru: Not sure I follow you... what do you want sorted out?
[00:53:40] <chromas> The SN store needs moar swag
[00:54:27] <chromas> Did anyone ever buy one of the platinum keychains?
[00:54:48] <boru> I would like large ceramic beer steins and RPN calculators in the SN store.
[00:56:56] <Bytram> ahhh, *that* Ummm, nope. IIRC that was set up by mrcoolbp and another person or two. Have no idea how to start or even what our account/password stuff is.
[00:57:11] <boru> Fiddlesticks.
[00:57:15] <Bytram> for all I know, we might even have some moneys sitting there?
[00:57:24] <Bytram> Sorry!
[00:57:40] <boru> I s
[00:57:41] <Bytram> back in a few minutes... need to put dinner on
[00:57:49] <Bytram> afk
[00:57:57] <boru> Err, I have access to a laser etcher, so I supposed I could make my own.
[00:58:20] <chromas> Services running all on there own and nobody knows what how or why? SN's growing into a real enterprise!
[01:14:03] <Bytram> chromas: s/there/they're/
[01:14:05] <exec> <Bytram> <chromas> Services running all on they're own and nobody knows what how or why? SN's growing into a real enterprise!
[01:14:08] <Bytram> ;)
[01:26:48] <Bender> [SoylentNews] - Engineers Can Now Reverse-Engineer 3D Models - http://sylnt.us - metamesh
[01:30:58] <Bytram> #g twitch Awesome Games Done Quick
[01:30:58] <MrPlow> https://www.twitch.tv - "Welcome to GamesDoneQuick's channel on Twitch. Watch them stream Castlevania: Aria of Sorrow and other content live and join the community!"
[01:32:05] <Bytram> #g twitch "Awesome Games Done Quick"
[01:32:05] <MrPlow> https://www.twitch.tv - "Expand All · Awesome Games Done Quick 2019 benefiting Prevent Cancer Foundation. 29:51:02. 52.1K views. 8 hours ago. Hollow Knight ..."
[01:32:36] <Bytram> #g Sanic
[01:32:37] <MrPlow> https://github.com - "Dec 30, 2018 ... Sanic is a Python web server and web framework that's written to go fast. It allows usage the async and await syntax added in Python 3.5, which ..."
[01:40:54] <Bytram> whereto? http://feedproxy.google.com
[01:40:55] <upstart> ^ 03Samsung expands 8K TV to 98 inches at CES, because why the hell not ( https://www.cnet.com )
[01:41:28] <chromas> I must be gettin young. I've never maid that miss steak before
[01:42:35] <chromas> 98 inches? probably "98-inch class" but it's really only 95
[01:44:33] <fyngyrz> "their"
[01:45:40] <Bytram> fyngyrz: ware?
[01:45:46] <Bytram> ;)
[01:46:03] <Bytram> oh, sorry... wear?
[01:46:06] <chromas> where and tare
[01:46:19] <Bytram> two shay!
[01:46:45] <Bytram> wye knot?
[01:48:08] <chromas> Do scouts start the day early making dawn knotts?
[01:50:15] <Bytram> hard work is in tents!
[01:50:36] <Bytram> afk - back in a few minutes
[02:15:33] * Bytram is back
[02:16:48] <fyngyrz> You're grammar would be ashamed of you, as would your grand paw. Relatively speaking.
[02:17:55] <fyngyrz> s/you/ewe/
[02:17:57] <exec> <fyngyrz> You're grammar would be ashamed of ewe, as would your grand paw. Relatively speaking.
[02:18:06] <fyngyrz> feeling a bit sheepish about missing that one
[02:18:22] <fyngyrz> bah.
[02:18:25] <Bytram> you wood wouldn't you
[02:18:43] <Bytram> iow you mist another opportunity
[02:19:12] <fyngyrz> Humid one, and they think you're all whet.
[02:19:31] <Bytram> fyngyrz: s/all/awl/
[02:19:32] <exec> <Bytram> <fyngyrz> Humid one, and they think you're awl whet.
[02:19:37] <fyngyrz> screw that
[02:20:05] <Bytram> and just after you "nailed" it, two!
[02:20:29] <fyngyrz> eye
[02:21:03] <Bytram> aye sea watt ewe did their
[02:21:28] <Bytram> #g rhymes with did
[02:21:29] <MrPlow> http://www.rhymezone.com - "Words and phrases that rhyme with did: (81 results). 1 syllable: bid, cid, clwyd, cyd, good, grid, hid, id, ihde, kid, kidd, kidde, kyd, lid, mid, mrsid, nlpid, quid, rid, ..."
[02:22:00] <Bytram> O_O !!!
[02:22:05] <fyngyrz> lol
[02:22:05] <Bytram> I was just kidding!
[02:23:01] <fyngyrz> okay, capitan, my capitan
[02:23:27] <fyngyrz> pie racy is bad, m'key?
[02:23:43] <fyngyrz> no matter how ewe slice it
[02:24:12] <fyngyrz> and don't give me a plank look about this, ether.
[02:24:39] <Bytram> good wons!
[02:25:34] <fyngyrz> it was a gas
[02:25:59] <Bytram> #g beano
[02:25:59] <MrPlow> https://www.beanogas.com - "Unlike other gas and bloating medicines, Beano contains a natural digestive enzyme that can help prevent gas from beans before it starts."
[02:26:32] <fyngyrz> Fart out, man
[02:26:42] <Bytram> *chuckles*
[02:43:44] <Bytram> brake thyme
[02:53:28] -!- Sulla [Sulla!~6b4dcd67@fmjkbr-628-24-657-555.mobile.att.net] has joined #Soylent
[02:55:56] <Bender> [SoylentNews] - SAE CyberAuto Challenge - http://sylnt.us - it-takes-a-thief-...
[02:57:45] -!- Sulla has quit [Client Quit]
[03:02:15] <Bytram> #g astronomical unit
[03:02:15] <MrPlow> https://en.wikipedia.org - "The astronomical unit is a unit of length, roughly the distance from Earth to the Sun. However, that distance varies as Earth orbits the Sun, from a maximum ..."
[03:15:00] <Bytram> #g how many hours in one year
[03:15:00] <MrPlow> https://www.rapidtables.com - "1 common year = 365 days = (365 days) × (24 hours/day) = 8760 hours ... One sidereal year is the time it takes the Earth to do a single rotation around the sun."
[03:20:08] <Bytram> #g distance to the moon
[03:20:09] <MrPlow> https://spaceplace.nasa.gov - "Average distance? Why mention the average distance? Well, the moon is not always the same distance away from Earth. The orbit is not a perfect circle."
[03:20:19] <Bytram> #g average distance to the moon miles
[03:20:20] <MrPlow> https://en.wikipedia.org(astronomy) - "Lunar distance also called Earth–Moon distance, Earth–Moon characteristic distance, or distance to the Moon, is a unit of measure in astronomy. It is the average distance from the center of Earth to the center of the Moon. ... The lunar distance is approximately a quarter of a million miles (7008400000000000000♤400000 ..."
[03:28:02] <Bytram> #g lunar mares
[03:28:03] <MrPlow> https://en.wikipedia.org - "The lunar maria /ˈmɑːriə are large, dark, basaltic plains on Earth's Moon, formed by ancient volcanic eruptions. They were dubbed maria, Latin for \"seas\", by ..."
[03:44:14] <Bytram> time for bed
[03:44:26] <Bytram> have a great night everyone!
[04:37:13] <Bender> [SoylentNews] - Largest Semi-Annual Speed-Gaming Marathon -- Awesome Games Done Quick -- is Running Now - http://sylnt.us - we've-come-a-long-way-since-Colossal-Cave
[06:15:31] <Bender> [SoylentNews] - Amazon Overtakes Microsoft and Apple in Market Value - http://sylnt.us - down-from-a-trillion
[07:46:41] <Bender> [SoylentNews] - Fast-Moving Spacecraft Could be Sent to Study a Kuiper Belt Object - http://sylnt.us - now-THAT-is-fast-(for-humans)
[09:25:54] <Bender> [SoylentNews] - Nvidia Announces RTX 2060 GPU - http://sylnt.us - picture-this
[09:34:58] <chromas> linus_torvalds.jpg
[11:07:12] <Bender> [SoylentNews] - Sierra Nevada Corporation's Dream Chaser Spacecraft Could Spell Trouble for Northrop Grumman - http://sylnt.us - to-the-moon-and-back
[11:21:10] <TheMightyBuzzard> coffee++
[11:21:10] <Bender> karma - coffee: 4535
[11:21:25] <TheMightyBuzzard> blarg
[11:22:03] <TheMightyBuzzard> i hate waking up and having to hear stupid first thing in the morning. i gotta get TR to quit listening to educated idiots on youtube.
[11:29:34] <Bytram> coffee++
[11:29:34] <Bender> karma - coffee: 4536
[11:29:48] <Bytram> ~gday TheMightyBuzzard
[11:29:50] * exec unwittingly ejaculates an easter basket of hotcakes at TheMightyBuzzard
[11:30:02] <TheMightyBuzzard> ~gday Bytram
[11:30:03] * exec brazenly gives birth to a mail spool of rocks for Bytram
[11:30:08] * TheMightyBuzzard wins
[11:30:10] <Bytram> ou win, bigtime
[11:30:18] <Bytram> s//y/
[11:30:27] <Bytram> s/^/y/
[11:30:29] <exec> <Bytram> you win, bigtime
[11:30:51] <Bytram> legcramps--
[11:30:51] <Bender> karma - legcramps: -6
[11:31:17] <TheMightyBuzzard> too much exercise or not enough potassium?
[11:32:16] <Bytram> I dunno...
[11:32:33] <Bytram> am on my feet all day, that may have something to do with it
[11:33:06] <Bytram> had a boatload of baked potatoes last night...
[11:33:14] <Bytram> #g potatoes wikipedia
[11:33:14] <MrPlow> https://en.wikipedia.org - "The potato is a starchy, tuberous crop from the perennial nightshade Solanum tuberosum. In many contexts, potato refers to the edible tuber, but it can also refer ..."
[11:35:53] <Bytram> https://en.wikipedia.org
[11:35:54] <upstart> ^ 03Potato - Wikipedia ( https://en.wikipedia.org )
[11:48:26] <TheMightyBuzzard> eat a nanner
[11:48:28] <TheMightyBuzzard> smoke break
[11:48:28] <TheMightyBuzzard> nicotine++
[11:48:28] <Bender> karma - nicotine: 682
[12:10:56] <chromas> What kind of educated idiots? Buzzfeed? YouTube Rewind?
[12:35:21] <Bender> [SoylentNews] - Monogamy in Animals May Have a Telltale Signature of Gene Activity - http://sylnt.us - if-your-parents-didn't-have-children,-then-you-probably-won't,-either
[12:38:00] <Bytram> chromas: educated != intelligent != wise
[12:38:11] * chromas gasps
[12:38:25] * Bytram is NOT doing CPR
[12:39:37] * Bytram CTCPs chromas a brochure on Heimlich maneuver
[12:40:06] <chromas> cordial peneumatic registration
[12:40:38] <chromas> you can keep that extra e too
[12:40:51] <Bytram> s/e//g
[12:40:52] <exec> <Bytram> CTCPs chromas a brochur on Himlich manuvr
[12:41:02] <Bytram> bttr?
[12:41:17] <TheMightyBuzzard> chromas, no licking anyone's heim in here.
[12:41:26] <chromas> Ah, I meant my extra. it's a Free Giveaway to the channel
[12:41:28] * Bytram *chuckles*
[12:41:59] <Bytram> so... it used to be a "tra", but not anymore, so now it's an ex-tra?
[12:42:16] <TheMightyBuzzard> aight, already found one query that's slower than shit.
[12:42:45] <Bytram> TheMightyBuzzard++ (although /me does not really want to see *fast* shit)
[12:42:45] <Bender> karma - themightybuzzard: 336
[12:43:46] <TheMightyBuzzard> fast shit means no numb legs or hemorrhoids
[12:44:52] <Bytram> tru dat
[12:52:25] <Bytram> TheMightyBuzzard: what does the query do and what would I do to make it run (view main page, edit story, other?)
[12:52:55] * TheMightyBuzzard shurgs
[12:53:03] <TheMightyBuzzard> still trying to find it in the code
[12:53:24] <Bytram> so... how do you know it's there?
[12:57:19] <TheMightyBuzzard> can't be anywhere else. we don't run queries that aren't in the code.
[12:58:56] <Bytram> lemme try again.
[12:59:10] <Bytram> you found a query that's slower than shit
[12:59:19] <Bytram> where is it? how'd you find it?
[12:59:51] <Bytram> if you are looking for it in the code, then there must(?) have been something you did on the site to manifest it... what was it?
[12:59:52] <TheMightyBuzzard> slow query logging on mysql. i don't know for sure where it is in the code yet.
[12:59:59] <Bytram> Ahhhhh!
[13:00:08] <Bytram> *now* I got ya. THANKS!
[13:00:22] <Bytram> best of luck to ya!
[13:00:23] <TheMightyBuzzard> we don't have our selects all on one line like they're displayed in the slow query log
[13:02:28] <Bytram> flatten each file into one record and do a case-insensitive search on "select.*;" ??
[13:03:03] <TheMightyBuzzard> looks like adding an index on stories.in_trash would speed things up some at least.
[13:03:12] <Bytram> gawk "{x=x $0} END {print x}" somefile | grep -io "select.*;"
[13:03:33] <Bytram> that'd be nice... anything you can do would be *much* appreciated
[13:04:00] <Bytram> takes 5-10 seconds for each open / refresh / update of a story in the story editor
[13:04:13] <Bytram> and, with that, really need to start getting ready for work... laters!
[13:04:19] <Bytram> thanks again!
[13:04:35] <TheMightyBuzzard> completely misunderstood. a select statement in our code can span dozens of lines and go through multiple subs before it has a final form
[13:04:41] <TheMightyBuzzard> laters
[13:05:03] <Bytram> Doh! Yup, constructed on the fly; got it.
[13:06:14] <Bytram> And... you are looking at the logging of those statements being executed, but lacking any indication of where in the code the statements were invoked from. Now I gots it!
[13:06:18] <Bytram> ciao for now
[14:16:08] <Bender> [SoylentNews] - Gene Editing Could be Used to Create Spicy Tomatoes - http://sylnt.us - zesty-sauce
[14:20:06] <chromas> salsa++
[14:20:06] <Bender> karma - salsa: 9
[14:30:06] -!- SoyCow1984 [SoyCow1984!~40399c0b@64.57.orv.ry] has joined #Soylent
[14:32:29] <SoyCow1984> #submit https://techcrunch.com
[14:32:29] <MrPlow> Submitting. There is a mandatory delay, please be patient.
[14:32:55] <MrPlow> Submission successful. https://soylentnews.org
[14:33:08] <SoyCow1984> #submit https://www.zdnet.com
[14:33:09] <MrPlow> Submitting. There is a mandatory delay, please be patient.
[14:33:34] <MrPlow> Submission successful. https://soylentnews.org
[14:36:20] <SoyCow1984> #submit https://www.bloomberg.com
[14:36:21] <MrPlow> Unable to find a summary for that page
[14:36:50] <SoyCow1984> =submit https://www.bloomberg.com
[14:36:51] <upstart> Submit failed: No title.
[14:37:04] <SoyCow1984> $submit https://www.bloomberg.com
[14:37:20] <SoyCow1984> #submit https://www.theverge.com
[14:37:21] <MrPlow> Submitting. There is a mandatory delay, please be patient.
[14:37:46] <MrPlow> Submission successful. https://soylentnews.org
[14:45:55] -!- SoyCow1984 has quit [Ping timeout: 248 seconds]
[14:47:33] * TheMightyBuzzard scratches his head
[14:56:05] <TheMightyBuzzard> well well... seems i found a huge problem that's easily solved.
[14:56:32] <chromas> Does the solution involve a regex?
[14:57:28] <chromas> For this April 1, the site should take a cue from StackExchange. On the bottom of each comment string it should say
[14:57:28] <chromas> "Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count)."
[15:01:27] <TheMightyBuzzard> nope, just moving a "group by" to where it actually belongs. testing retrieved data vs expected data now.
[15:14:28] <TheMightyBuzzard> fuckin a. 15s query down to 0.04s.
[15:15:22] <TheMightyBuzzard> now i just gotta fix up a pull request and plug a hotfix into the live code cause i don't wanna deploy everything we have staged yet.
[15:16:02] <fyngyrz> noice!
[15:19:16] <chromas> Slap a beta sticker on it and deploy it all
[15:22:57] <TheMightyBuzzard> we don't do beta. we go straight from alpha to prod.
[15:23:48] <chromas> You could for April
[15:24:09] <chromas> Just make up a little rotated graphic and paste it on the candy bar. or make it say alpha
[15:26:37] -!- Runaway1956 [Runaway1956!~guy@69.57.mki.vun] has joined #Soylent
[15:26:39] <exec> welcome Runaway1956: Dallas, TX, 14°C/57°F, 9:26 am CST, Tuesday, 8 January 2019
[15:27:46] <Runaway1956> I think Aristarchus wants to masturbate someone who is not himself - https://soylentnews.org
[15:27:47] <upstart> ^ 03Not a submission: SoylentNews Submission
[15:33:50] <chromas> Mutual masturbation isn't masturbation. Change my mind.
[15:50:54] <TheMightyBuzzard> blarg. that was the query that's being done but it looks like we craft the same fucking thing elsewhere
[15:55:53] <Bender> [SoylentNews] - Researchers Create Qubits on a Chip With Two Layers - http://sylnt.us - shave-and-a-haircut-qubits
[16:03:20] <TheMightyBuzzard> my grep skills ain't up to finding it just this moment apparently
[16:08:06] <TheMightyBuzzard> oh hell. i forgot to take into account them queries was taking 15s to run and expecting them to stop showing up immediately.
[16:19:23] <TheMightyBuzzard> looks like we're all fixed on that slowass bitch
[16:31:51] <TheMightyBuzzard> quick meta note about the fix posted 1m from now
[16:36:52] <chromas> Maybe it'd be less effort to start from scratch
[16:37:20] <chromas> Time to sell out for big cash and start a new site
[16:46:32] <Bender> [SoylentNews] - Meta: Site Performance - http://sylnt.us - spit-and-baling-wire
[17:17:45] -!- bacterium has quit [Quit: leaving]
[17:17:47] -!- bacterium [bacterium!1125@76-051-167-000.static.roch.mn.charter.com] has joined #Soylent
[17:27:03] <Bender> [SoylentNews] - Can a Set of Equations Keep U.S. Census Data Private? - http://sylnt.us - making-a-difference
[18:06:05] -!- Web_weasel [Web_weasel!~Stefan@haxp83-042-067-156.range88-597.btcentralplus.com] has joined #Soylent
[18:43:09] -!- guy_ [guy_!~guy@69.57.mki.vun] has joined #Soylent
[18:45:54] -!- Runaway1956 has quit [Ping timeout: 248 seconds]
[18:58:13] <Bender> [SoylentNews] - ARP Founder Alan R. Pearlman Has Died - http://sylnt.us - RIP
[19:26:23] -!- Sulla [Sulla!~8cd35204@140.211.gj.y] has joined #Soylent
[19:26:27] <Sulla> #submit https://motherboard.vice.com
[19:26:28] <MrPlow> Submitting. There is a mandatory delay, please be patient.
[19:26:53] <MrPlow> Submission successful. https://soylentnews.org
[19:27:56] <Sulla> “The allegation here would violate our contract and Privacy Policy,” an AT&T spokesperson told Motherboard in an email.
[19:49:49] -!- Runaway1956 [Runaway1956!~guy@69.57.mki.vun] has joined #Soylent
[19:49:51] <exec> welcome Runaway1956: Dallas, TX, 19°C/67°F, 1:49 pm CST, Tuesday, 8 January 2019
[19:50:27] -!- guy_ has quit [Ping timeout: 248 seconds]
[20:14:24] <chromas> TheMightyBuzzard++
[20:14:24] <chromas> speed++
[20:14:24] <Bender> karma - themightybuzzard: 337
[20:14:28] <Bender> karma - speed: 1
[20:16:04] <TheMightyBuzzard> there's plenty of other instances of that bug still in there but they're not in queries where you're hitting multiple of our larger tables
[20:31:55] -!- Sulla has quit [Quit: Web client closed]
[20:36:31] <Bender> [SoylentNews] - New BGU System Produces High-Res Images at Low Cost - http://sylnt.us - scoping-things-out
[20:53:30] -!- SoyCow8363 [SoyCow8363!~5e45d641@gjk-77-97-547-43.home.otenet.gr] has joined #Soylent
[20:54:41] -!- SoyCow8363 has quit [Client Quit]
[21:52:50] -!- SoyCow5063 [SoyCow5063!~c6657a86@476-989-450-417.static-ip.telepacific.net] has joined #Soylent
[21:54:13] -!- SoyCow5063 has quit [Client Quit]
[22:14:09] -!- Web_weasel has quit [Read error: Connection reset by peer]
[22:17:18] <Bender> [SoylentNews] - Intel Promises "10nm" Chips by the End of 2019, and More - http://sylnt.us - seeing-the-future
[23:04:17] -!- Xyem has quit [Quit: ZNC - http://znc.in]
[23:29:29] -!- Xyem [Xyem!~xyem@2a01:7e00::znpv:pygj:pvjy:kivh] has joined #Soylent
[23:29:30] -!- Xyem has quit [Changing host]
[23:29:30] -!- Xyem [Xyem!~xyem@Soylent/Staff/Developer/Xyem] has joined #Soylent
[23:29:30] -!- mode/#Soylent [+v Xyem] by Aphrodite
[23:46:54] <Bender> [SoylentNews] - Some Academics at the Indian Science Congress Dismiss Einstein's Theories - http://sylnt.us - einstein-dismisses-india-scientists