#soylent | Logs for 2021-02-28
« return
[00:05:21] -!- SoyCow4528 [SoyCow4528!~bdae6573@189.174.ptk.kkj] has joined #soylent
[00:06:22] -!- kyonko3 has quit [Read error: Connection reset by peer]
[00:06:27] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[00:12:26] -!- SoyCow4528 has quit [Quit: Web client closed]
[00:25:48] <chromas> Don't remember us the one with the team info
[00:26:39] * chromas blames phone keyboard for misgrammars
[01:00:35] * Subsentient rejoined the folding@home team
[02:06:07] <kyonko3> folding@home to cure covid19?
[02:17:21] <Bytram> F@H Played a *huge* part in isolating the COVID-19 "spike" protein and characterizing it. AWS, Azure, Google, Oracle, and many others contributed gobs of spare capacity to the effort!
[02:27:04] -!- boru` [boru`!~boru@tymk-71-920-910-35.dynamic.mnet-online.de] has joined #soylent
[02:27:06] -!- boru has quit [Killed (NickServ (GHOST command used by boru`!~boru@tymk-71-920-910-35.dynamic.mnet-online.de))]
[02:27:09] boru` is now known as boru
[02:32:40] <kyonko3> I just came back from going "out", nobody believes in covid19 any more
[02:33:16] <kyonko3> road traffic is equivalent to the holidays (hint hint) of the past 15 years
[02:34:14] <kyonko3> if anything, we inncoluted the world with fear
[02:34:33] <kyonko3> end game: mankind will fear nothing
[02:36:03] <kyonko3> NYC will never return to its former post 9-|| world glory 20 years later
[02:55:35] <chromas> Ask Soylent: is it possible for a True Random™️ number generator to output an infinite series of the same number?
[02:56:58] <kyonko3> heh
[02:57:23] <kyonko3> it would quickly indicate intelligent life in the universe
[02:59:14] <kyonko3> not even nature knows where the electron will go
[02:59:44] <kyonko3> this is why you can't trust thin air
[03:00:37] <kyonko3> poke a whole on a cereal box on earth and you get an air lens
[03:00:41] <kyonko3> just like water forms
[03:01:00] <kyonko3> poke a hole in a titanium cereal box in space, and you get nothing
[03:03:46] <kyonko3> whats the best age to tell a kid about pie?
[03:20:22] <AzumaHazuki> what happened to the first two models of you?
[03:34:26] <Runaway1956> https://www.thegatewaypundit.com
[03:34:36] <Runaway1956> WhatamIdoinghere Biden
[03:35:58] <AzumaHazuki> =submit https://newatlas.com from the shake-it-off dept
[03:36:03] <systemd> ✓ Sub-ccess! "03Ultrasound Triggers Brain's Waste Disposal System in Alzheimer's Patients" (10p) -> https://soylentnews.org
[03:57:29] <Runaway1956> https://youtu.be
[03:57:31] <systemd> ^ 03TWiV 615: Peter Daszak of EcoHealth Alliance ( https://www.youtube.com )
[03:58:14] <Runaway1956> at 29:52 they are talking about how easy it is to manipulate COVID/SARS viruses
[03:58:19] -!- kyonko3 has quit [Read error: Connection reset by peer]
[04:03:50] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[04:07:24] <TheMightyBuzzard> chromas, mathematically? yes. it's just infinitely unlikely, even with a keyspace of two.
[04:52:58] -!- lld has quit [Ping timeout: 265 seconds]
[04:57:38] -!- lld [lld!~lld@2001:f40:uow::jzhl] has joined #soylent
[05:56:58] <Bender> [SoylentNews] - The Famous Basic Computer Games Book Gets a 2021 Update - https://sylnt.us
[06:12:08] <kyonko3> AzumaHazuki: just trying to figure out how irssi works
[06:12:34] <AzumaHazuki> it's kind of tricky. you need a config file with the usual settings you want in it
[06:12:49] <AzumaHazuki> good news is, once you get that set up you don't have to futz around with it much afterwards
[06:13:24] <kyonko3> now I have to install gnu icecat
[06:13:37] <kyonko3> but linux mint 20 doesn't have console or a compiler
[06:13:57] * kyonko3 searches for compiler on software manager
[06:14:28] <AzumaHazuki> mint uses debian's repos i thought
[06:14:42] <kyonko3> there is mint debin and mint ubuntu
[06:14:42] <AzumaHazuki> if you're going to tinker with things like this, might i suggest Devuan itself?
[06:15:03] <kyonko3> yeah but I know this decade is going to be a rough one and big data can't be trusted
[06:15:06] <chromas> regular mint is ubuntu, then there's mint debian edition
[06:15:21] -!- kyonko3 has quit [Read error: Connection reset by peer]
[06:15:32] <chromas> inb4 kyonko4
[06:15:51] <AzumaHazuki> ...uhh, what the non-seq?
[06:20:29] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[06:20:44] <chromas> https://www.youtube.com
[06:20:45] <systemd> ^ 03North Korean Red Star OS - First Impressions
[06:23:23] <kyonko3> who wants to bet it has a vpn trojan
[06:23:44] <kyonko3> sends everything you type and draw to big brother
[06:23:56] <kyonko3> kim jong un personally
[06:25:47] <kyonko3> I mean, bibi netanyahu
[06:26:01] <kyonko3> did you guys notice how much of a creep netanyahu was over covid19?
[06:30:58] -!- kyonko3 has quit [Read error: Connection reset by peer]
[06:31:22] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[07:21:24] -!- c0lo [c0lo!~7892de8c@zqs-646-162-243-166.static.vic.bigpond.net.au] has joined #soylent
[07:37:59] <c0lo> “The Republican party really no longer stands for any kind of principles, conservative or otherwise,” https://www.huffingtonpost.com.au
[07:38:00] <systemd> ^ 03Former CPAC Chair Minces No Words Slamming What The Event, GOP Have Now Become
[07:39:08] <c0lo> https://www.huffingtonpost.com.au
[07:39:10] <systemd> ^ 03Republicans At CPAC Are 'Horny For Another Insurrection’ In Stinging Supercut
[07:39:13] -!- kyonko3 has quit [Read error: Connection reset by peer]
[07:39:19] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[07:39:51] <c0lo> Kinkeyyy this ^
[07:53:24] <c0lo> https://www.huffingtonpost.com.au
[07:53:25] <systemd> ^ 03Trump Will Run Again In Part To Fleece The 'Rubes,' Predicts Anthony Scaramucci
[08:00:32] <AzumaHazuki> fine with me. by then i'll be canadian. this is a fitting end for the GOP, and indeed any nation that allows someone like Trump to get away with what he did
[08:11:26] <c0lo> Never larning, are they? https://pbs.twimg.com
[08:12:21] <c0lo> s/larning/larning [sic]/
[08:12:21] <SedBot> <c0lo> Never larning [sic], are they? https://pbs.twimg.com
[08:30:30] <AzumaHazuki> w0www
[09:08:51] <FatPhil> wiw
[09:13:19] <FatPhil> could've been worse, could've been "you're"
[09:14:00] <FatPhil> I think I'm almost more offended by the commas.
[09:23:23] -!- kyonko3 has quit [Read error: Connection reset by peer]
[09:23:29] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[09:26:53] -!- kyonko3 has quit [Read error: Connection reset by peer]
[09:28:30] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[09:44:02] <c0lo> On top of that, the cognitive dissonance. If she resolved to always ignore the past, why the heck did she carved that past in her skin?
[09:55:00] <FatPhil> Well, the thought itself is present aspect and tense, only referring to the past, reminding her to ignore it. However, once it's on her arm, it itself becomes a thought from the past.
[09:55:51] <FatPhil> She could have saved ink, and been a lot wittier, had she just got "Ignore this" tattooed.
[09:58:50] <AzumaHazuki> people should put more thought into their tattoos
[09:59:57] <FatPhil> AzumaHazuki: s/tattoos/life/
[09:59:57] <SedBot> <FatPhil> <AzumaHazuki> people should put more thought into their life
[10:00:10] <AzumaHazuki> yes, that too
[10:00:22] <c0lo> Anal paralysis
[10:00:34] <AzumaHazuki> if i ever did get one i was thinking of something that looks like the sigils of mercury and jupiter intertwined
[10:00:36] <c0lo> s/Anal/Analysis/
[10:00:37] <SedBot> <c0lo> Analysis paralysis
[10:01:11] <AzumaHazuki> which has a bunch of different meanings. "air and water" for one. "giant nerd" for another. "Yes I ship Sailor Mercury and Sailor Jupiter it's basically canon anyway" for a third =P
[10:02:42] <FatPhil> mercury just says "devil woman" to me
[10:02:47] <FatPhil> it's venus with horns
[10:02:54] <AzumaHazuki> right. odd sign
[10:03:22] <FatPhil> No idea what Jupiter is off the top of my head
[10:04:52] <AzumaHazuki> like a weird-looking 4
[10:05:46] <FatPhil> ah, yeah "24" I always see
[10:06:10] <FatPhil> Aesthetically, I'm no fan of either of the gas giants
[10:06:24] <FatPhil> By which I mean Trump and Boris, obviously
[10:06:26] <FatPhil> boom tish
[10:07:30] <FatPhil> Pluto is the stickman flailing in pain as he's had a stake driven through his belly by the IAU.
[10:24:49] <c0lo> And have fun. https://pbs.twimg.com
[10:45:56] <c0lo> Maybe fun next Thu, more likely a nothingburger https://www.forbes.com
[10:45:57] <systemd> ^ 03How Donald Trump’s Washington, D.C. Hotel Feeds QAnon’s March 4 Conspiracy
[10:47:07] <Bender> [SoylentNews] - Researchers Say They’ve Solved the Puzzling Mystery of the Moons of Mars - https://sylnt.us - ♂
[10:50:14] -!- kyonko3 has quit [Read error: Connection reset by peer]
[10:50:18] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[11:20:57] <c0lo> Teehee - setting up the shearing shed already https://edition.cnn.com
[11:21:01] <systemd> ^ 03Trump makes fundraising moves ahead of CPAC speech
[11:23:20] <AzumaHazuki> c0lo, this isn't funny anymore. a large portion of the US is out of its collective fucking mind
[11:23:29] <AzumaHazuki> nations do not survive this. we've lost the thread
[11:31:21] -!- kyonko3 has quit [Read error: Connection reset by peer]
[11:31:27] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[12:11:18] <c0lo> AzumaHazuki, do you believe more than half of the nation will align with Trump? I can tell you the "business establisment" won't.
[12:12:00] <AzumaHazuki> i have no idea what will happen aside from the "business establishment" completing their utter takeover of the Democrat party and ALL of us losing no matter who wins
[12:12:06] <AzumaHazuki> the next few decades are going to be ugly
[12:12:16] <c0lo> And, for better or for worse, the American system geared itself to "money talks".
[12:12:31] <AzumaHazuki> hence why i'm trying to get to the other side of the Canadian border before the midterms
[12:17:36] -!- kyonko3 has quit [Read error: Connection reset by peer]
[12:22:36] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[12:48:37] <c0lo> Make a canadian Trump statue when you get there https://thehill.com
[12:48:38] <systemd> ^ 03Artist behind golden Trump statue at CPAC says he made it in Mexico
[13:14:07] <AzumaHazuki> why are all these good Christians worshiping a literal golden idol?
[13:14:29] <AzumaHazuki> if this was the script of a movie it'd be rejected for being too heavy handed. reality has gone beyond even my capacity to satirize
[13:17:54] -!- kyonko3 has quit [Read error: Connection reset by peer]
[13:17:58] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[13:21:22] -!- kyonko3 has quit [Read error: Connection reset by peer]
[13:23:00] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[13:30:45] <FatPhil> the cult-like vibe of the whole trump thing is amusing (to someone with marshmallows).
[13:32:33] <FatPhil> as you point, the idolatry of this latest move is beyond hilarious.
[13:34:37] <c0lo> Because they need an object for their faith. See also: https://twitter.com
[13:34:38] <systemd> ^ 03Twitter
[13:49:48] <c0lo> I would laugh if it wouldn't be tragic. These people want to be lied to https://edition.cnn.com
[13:49:52] <systemd> ^ 03These Trump supporters are convinced he will be president again on March 4 - CNN Video
[14:01:35] <AzumaHazuki> i don't care if someone is deluded. it's when they start sinking the country out of insanity i've got a problem
[14:01:43] <AzumaHazuki> and this goes back to 1980. Reagan started all this
[14:37:37] <pinchy> started with the traiter george washington
[14:38:33] <AzumaHazuki> oh fuck off
[14:40:27] <c0lo> pinchy: s/george/gorge/
[14:40:27] <SedBot> <c0lo> <pinchy> started with the traiter gorge washington
[14:40:39] <c0lo> ftfy
[14:44:11] <c0lo> Heh, this rabbit's deep https://www.forbes.com
[14:44:13] <systemd> ^ 03How Donald Trump’s Washington, D.C. Hotel Feeds QAnon’s March 4 Conspiracy
[14:44:33] <c0lo> This QAnon theory borrows from the discredited sovereign citizens movement, which insists that a law enacted in 1871 secretly ended the United States government and turned the country into a corporation.
[14:44:52] <c0lo> Which means that the last true American president was Ulysses S. Grant, the 18th president, who was serving in 1871. All of which somehow adds up to Trump returning to power on March 4 as the 19th president of the United States. And Trump’s Washington hotel has now become Conspiracy Central.
[14:44:57] -!- kyonko3 has quit [Read error: Connection reset by peer]
[14:45:37] <requerdanos> Also, the world isn't round. Yep! It's shaped like a burrito.
[14:45:46] <c0lo> At least the evolved from the non-existing basement pf a pizza shop to a real hotel.
[14:47:11] <FatPhil> it's shaped like a meatball, and the oceans are the gravy. respect the gravy, boys and girls, there are no second portions.
[14:47:15] <requerdanos> I hesitate to ask, but by what mechanism shall all this come to pass?
[14:50:32] <FatPhil> Have you not heard the creation myth of the high school canteen dinner lady?!?!
[14:50:46] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[14:51:00] <Runaway1956> Wow - this is big news
[14:51:02] <Runaway1956> https://www.lawenforcementtoday.com
[14:51:03] <systemd> ^ 03Police stop arresting people after drug possession laws deemed 'unconstitutional' by state Supreme Court
[14:51:13] <requerdanos> my hesitation is, in fact, turning to disinterest.
[14:54:46] <c0lo> requerdanos, how can you show disinterest to a burrito?
[14:55:12] <AzumaHazuki> because i got to it and ate it first =P
[15:00:28] <c0lo> AzumaHazuki https://sayingimages.com
[15:04:58] <c0lo> Can God microwave a burrito so hot he himself can't eat it?
[15:09:32] <Runaway1956> https://ifpnews.com
[15:09:35] <systemd> ^ 03Second Iranian COVID-19 Vaccine Undergoes Human Trial
[15:10:48] <c0lo> Lemme guess, on Israelis? Who promised to share the data back if the price is right?
[15:13:01] <Runaway1956> Probably on their own people c0lo - they do have a prison population, and if they run out, they can use Kurds
[15:27:12] <Bender> [SoylentNews] - Heavily Used Node.js Package Has a Code Injection Vulnerability - https://sylnt.us - bugs-happen
[15:30:56] <Runaway1956> https://i2.wp.com
[15:32:31] <FatPhil> not that I respect the cunt at all, but why the misspelling?
[15:37:30] <Runaway1956> https://www.winterwatch.net
[15:37:37] <systemd> ^ 03The Latest from the New York Slimes is an Op-ed: Don’t Go Down the Rabbit Hole.
[15:43:19] <Runaway1956> https://www.dailydot.com
[15:43:20] <systemd> ^ 03Girl made TikTok of neighbor allegedly trying to force his way into her home moments before she was killed
[15:48:30] <Runaway1956> https://web.archive.org
[15:48:32] <systemd> ^ 03PE 1641: BIPOC Rock Climbing
[15:49:04] <Runaway1956> When racism isn't racism
[16:09:45] -!- lld has quit [Quit: leaving]
[16:10:44] <Runaway1956> =submit https://www.inc.com
[16:10:47] <systemd> ✓ Sub-ccess! "03Facebook Just Admitted It Has Lost the Battle With Apple Over Privacy" (14p) -> https://soylentnews.org
[16:17:30] <Runaway1956> =submit https://www.zerohedge.com
[16:17:33] <systemd> ✓ Sub-ccess! "03ZeroHedge" (18p) -> https://soylentnews.org
[16:18:07] -!- lld [lld!~lld@2001:f40:uow::jzhl] has joined #soylent
[16:46:01] -!- kyonko3 has quit [Read error: Connection reset by peer]
[16:46:10] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[16:54:54] <Bytram> I have a SQL puzzle if anyone can help? table foo with column ts of type timestamp. I want to get the delta timestamp (in minutes in this case) between entry N and entry N+1 in sequential order, newest first, for the last M entries.
[16:55:20] <requerdanos> entry N is not defined behavior
[16:55:41] <requerdanos> you could trust the ids to be sequential, but again, not defined behavior
[16:55:54] <Bytram> yeah, requires look-ahead
[16:56:48] <Bytram> so I was thinking *maybe* create a temp table to query in parallel to the original table?
[16:57:22] <requerdanos> this is only important on https://soylentnews.org ?
[16:57:23] <systemd> ^ 03backSlash 16:57:22 = 16:57:22 GMT
[16:57:23] <Bytram> specifically, I am looking at SoylentNews' stories table.
[16:57:54] <requerdanos> or do you want deltas also on the sidebar of the preview of upcoming stories as they are being edited?
[16:58:18] <Bytram> ATM, yes. But I'd like to come up with a general technique that this is an instance of.
[16:58:32] <Bytram> YES! =)
[17:00:24] <Bytram> ISTM, that sidebar would be most useful when trying to *schedule* a story, but stuff still happens, so having the delta on the stories list page would let any Ed quickly note when there's an issue.
[17:01:44] <Bytram> it does NOT help that different date formats are used to display the dates in those two places.
[17:03:06] <Bytram> So, I had the idea of maybe having a SQL query, instead...
[17:03:21] <requerdanos> a delta report?
[17:03:29] <Bytram> Hmmm!
[17:04:05] <Bytram> In addition to what we currently have?
[17:04:29] <requerdanos> sounds like a good, non-invasive first step, even if not perhaps the desired permanent solution
[17:05:22] <Bytram> (1) it would simplify implementation, yes. (2) I like having it on the Story List page which saves having to make a special effort to notice something is amiss.
[17:06:17] <Bytram> On the story list page, I'd output it to the right of Comments column and left of the Date column
[17:08:58] <Bytram> it may be possible to do it entirely in the Story List template
[17:09:09] -!- kyonko3 has quit [Read error: Connection reset by peer]
[17:12:50] <Bytram> ./plugins/Admin/templates/listStories;admin;default
[17:14:58] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[17:30:04] -!- AzumaHazuki has quit [Remote host closed the connection]
[17:59:38] <TheMightyBuzzard> Bytram, SUBTIME(ts1, ts2) will get you a datetime formatted difference
[17:59:47] -!- kyonko3 has quit [Read error: Connection reset by peer]
[17:59:57] <Bytram> TheMightyBuzzard: Kewel!
[18:01:11] <Bytram> ISRM, that an update to the story list page with a delta-t column is possible, but I don't grok the data structures well enough to be sure how to proceed,
[18:04:19] <Bytram> I'm thinking a pre-pass through the storylistref's constructing the delta T (in minutes) for entry x from entry x+1 would get us there. And then reference those deltas when actually outputting the table.
[18:05:06] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[18:06:09] <Bytram> right before where we currently have: FOREACH story = storylistref;
[18:06:13] -!- kyonko3 has quit [Read error: Connection reset by peer]
[18:07:02] <Bytram> We accidentally had a 7-hour gap in stories this AM.
[18:07:33] <c0lo> Nobody notices, Bytram.
[18:07:52] <Bytram> c0lo: https://soylentnews.org
[18:07:53] <c0lo> s/notices/noticed/
[18:07:53] <systemd> ^ 03SoylentNews Comments | The Famous Basic Computer Games Book Gets a 2021 Update ( https://soylentnews.org )
[18:07:53] <SedBot> <c0lo> Nobody noticed, Bytram.
[18:08:05] <TheMightyBuzzard> we had a bigass one yesterday, we've had five hour spreads today
[18:08:47] <Bytram> w/e's we drop to ~4.75 hrs between stories.
[18:09:12] <Bytram> weekdays we try to keep it to ~2.5 hrs
[18:09:42] <c0lo> Ah, that one. My statement still stands, nobody noticed.
[18:09:51] <TheMightyBuzzard> i did
[18:10:13] <c0lo> You're still a nobody, TMB.
[18:10:54] <Bytram> it gets especialy "interesting" when trying to deal with UTC vs local time, end-of-the-month date change, and an absolutely unforgiving UI (A malformatted date/time schedules the story for 1980-01-01)
[18:11:05] <FatPhil> 'entry N is not defined behavior' - nope: entry N+1 is not defined behaviour.
[18:11:26] <FatPhil> you're on entry N at every stage
[18:11:32] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[18:11:56] <FatPhil> mysql and others do provide 'entry N-1' behaviour, though
[18:12:28] <FatPhil> I encountered, but never implemented, it in the context of moving averages
[18:12:28] <Bytram> and different formatting for the display of the date/time stamp (DTS from here-on-out) in the upcoming-stories listed in the story edit page versus the story list page.
[18:12:47] <FatPhil> so I can't quote a solution, but that's a decent starting point for a googoo search
[18:12:51] -!- kyonko3 has quit [Read error: Connection reset by peer]
[18:14:18] <FatPhil> quick hack solution - select all the primary keys and timestamps, calculate the deltas in the clients and remember the primary keys for which you want the rest of the data.
[18:15:24] <FatPhil> oh - yup - that's exactly what you suggested 10 minutes ago
[18:15:35] <TheMightyBuzzard> c0lo, well that's what your mom tells your dad when i call, yeah
[18:15:54] <TheMightyBuzzard> either way, i'm tired from all the church work this morning and need some food n a nap.
[18:16:10] <Bytram> Hence my thinking a pre-pass through the storyrefs to gather the DTSs and calculate the deltas. That could sit in an array. Then, when actually outputting the StoryList page, have access to the current record's data and the DT until the next story (last entry wold be N/A, of course)
[18:16:36] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[18:18:06] <Bytram> This happens often enough to be an outright pain. And it's "only" the Eds who have to deal with it. :/ So we just soldier on as best we can and somehow do a damn fine job of keeping the mishaps to a minimum.
[18:18:21] <TheMightyBuzzard> Bytram, you're still going to have to do the math to adjust them if you're not happy with the current spacing. it can give you control or training wheels, not both.
[18:18:38] <TheMightyBuzzard> yup, you do
[18:18:39] <Bytram> So, "It's working.. why fix it?"
[18:18:43] <Bytram> yes, but there'
[18:18:47] <TheMightyBuzzard> no, there is no fixing it
[18:19:06] <Bytram> two things going one (at least)
[18:19:08] <c0lo> Fantasies involving women 80yo, TMB? Otherwise, yes, my mother would be right to describe you as a nobody.
[18:19:12] <requerdanos> a relational database controlled by purpose-built scripts can compute times better than a human can.
[18:19:27] <requerdanos> therefore, the human is the wrong one to be computing the times here in most cases
[18:19:35] -!- kyonko3 has quit [Read error: Connection reset by peer]
[18:19:35] <TheMightyBuzzard> c0lo, what can i say, she's got mad experience
[18:19:42] <Bytram> (1) Entering the DTS is an outright pain, but we've managed 35K+ times so far.
[18:20:05] <Bytram> (2) No clear feedback as to what the deltas are.
[18:20:17] <Bytram> the latter is MUCH easier to deal with
[18:21:40] <TheMightyBuzzard> if you say so. i been doing basic time arithmetic so long having it done for me doesn't really help
[18:21:44] <Bytram> I can glance at the story list page, scan down the list and see a delta that is off MUCH easier than looking at two DTSs and having to do the mental math... 40 times for a whole page.
[18:21:56] <TheMightyBuzzard> mmm
[18:22:29] <requerdanos> a relational database controlled by purpose-built scripts can compute $_SOMETHING better than a human can.
[18:22:32] <Bytram> what is 4h 45m after 02/27 20:16
[18:23:17] <TheMightyBuzzard> requerdanos, when the granularity is "about two n a half hours"? nah.
[18:23:18] <requerdanos> "Buh Buh But I'm really good!" Not better than the aforementioned system, you're not.
[18:24:00] <TheMightyBuzzard> Bytram, 1:01 the next day
[18:25:04] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[18:25:10] <Bytram> Also, the DTSs for UTC and local are just mashed side-by-side, so it's not trivial to pick out the right stuff for the calcs. Well, not for me, at least. And of the people I've trained to edit on the site, and of the current batch, It's been a "bone of contention" all along
[18:25:11] <TheMightyBuzzard> i appreciate not everyone maths like i do though
[18:25:40] <Bytram> TheMightyBuzzard: well done! Now look at this page and do that 40 times: https://soylentnews.org
[18:25:42] <systemd> ^ 03backSlash 18:25:41 = 18:25:41 GMT
[18:25:49] <requerdanos> Yeah, calculating that time in under two minutes is pretty impressive. You've concinced me.
[18:26:00] <Bytram> requerdanos++ LOL!
[18:26:00] <Bender> karma - requerdanos: 24
[18:26:22] <Bytram> so... he could do the whole page in ~1 hour and 20 minutes?
[18:26:29] <TheMightyBuzzard> Bytram, i can tell at a glance. it doesn't take any actual processing.
[18:27:15] <requerdanos> Guess who can also tell at a glance? Mr. MySQL and Mr. Perl.
[18:27:28] <requerdanos> Guess who can't? Me n bytran
[18:27:30] <Bytram> TheMightyBuzzard: are you volunteering to do our story shceduling?
[18:27:30] <TheMightyBuzzard> no, mr perl sucks all of the ass at time math
[18:27:53] <TheMightyBuzzard> nope, just saying what you're saying does not click to me
[18:28:08] * Bytram tried!
[18:29:07] <Bytram> so, I did not see anything about mrSQL, which you already offered has time math
[18:29:08] <TheMightyBuzzard> they're going to stay mashed side(by side) too. that's far, far easier to differentiate than two columns where you have to scan to the top to see which is which.
[18:29:40] <requerdanos> While all the particulars are here, I'd like to stump for three choices instead of one for the story schedule input on the story editing page. (radio button) Default like it is now, manual entry; (radio button) Latest story + 2.5 hrs; (radio button) Latest story + 4.75 hrs
[18:29:55] <Bytram> first normal form violation -- we have two values in one field
[18:30:14] <requerdanos> 1nf is overrated in production :)
[18:30:24] <TheMightyBuzzard> okay, we can take the local time out. you're the one who wanted it there in the first place =P
[18:30:57] * Bytram thought it was there all along
[18:31:05] <TheMightyBuzzard> nope, you asked specifically for it
[18:31:23] <requerdanos> Thank you kind sir for the local time, very helpful feature
[18:31:28] * TheMightyBuzzard chuckles
[18:32:00] <TheMightyBuzzard> granted, it was half a decade ago
[18:32:27] <Bytram> okays, maybe I did! At the time I was trying to deal with way-too-much-new-stuff(TM) at the time.
[18:32:41] <Bytram> I've learned some stuff since then.
[18:32:51] <Bytram> (At least I *hope* so!)
[18:33:57] <Bytram> So, given that no coding changes are going in for a while, I'm looking at what *CAN* be done. Looks like my option is: change a template.
[18:34:41] <TheMightyBuzzard> can't really do the deltas in perl unless you want to write a bunch of pseudo-perl in templates
[18:35:20] <TheMightyBuzzard> perl sucks balls at time math. you'd have to basically write a time library in the template.
[18:35:47] * Bytram is not sure how to define/use an array in a template. foo[1], foo[2], foo[x], foo[x+1]. If I can do *that*, then I *think* I can take it from there.
[18:36:34] * Bytram is certain that we are absolutely the very first ones who wanted to do time math in perl.
[18:36:36] -!- kyonko3 has quit [Read error: Connection reset by peer]
[18:36:44] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[18:37:00] <TheMightyBuzzard> oh there are libraries for it but we don't currently use them, so it would require code changes not template changes.
[18:37:14] <Bytram> fair 'nuf.
[18:37:38] <Bytram> so, how do I define/ref an array and its elements?
[18:38:08] <TheMightyBuzzard> beats me. haven't played with anything complex in templates in years.
[18:38:43] <requerdanos> ping me when it's testable on dev and I'll be glad to help test
[18:40:10] <Bytram> requerdanos: obliged!
[18:40:22] <Bytram> I have an idea...
[18:42:05] <TheMightyBuzzard> http://template-toolkit.org
[18:42:07] <systemd> ^ 03Template Toolkit Home Page
[18:43:01] <Bytram> gracias
[18:43:07] -!- kyonko3 has quit [Read error: Connection reset by peer]
[18:43:09] <Bytram> bi5-10
[18:43:20] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[18:43:49] <TheMightyBuzzard> anyway, i'm tired from church stuff. food n nap time.
[18:47:35] <Bytram> TheMightyBuzzard: thanks for the feedback and help!
[18:48:49] <Bytram> requerdanos: join me in #dev
[19:36:36] -!- kyonko3 has quit [Read error: Connection reset by peer]
[19:36:41] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[20:13:40] -!- kyonko3 has quit [Read error: Connection reset by peer]
[20:13:46] -!- kyonko3 [kyonko3!~toor@97.73.orz.rzl] has joined #soylent
[20:16:27] <Bender> [SoylentNews] - Google's DeepMind Plays "Diplomacy" Board Game - https://sylnt.us - all-the-better-for-Google-to-negotiate-with-governments
[20:36:51] <FatPhil> AAAAAGH!
[20:37:04] <FatPhil> Admins, is there a way to post-facto make a post A/C?
[20:37:39] <chromas> bwahahahaha
[20:37:57] <FatPhil> I don't care about the infinite upmods I will definitely get, I just think my post would be *funnier* if it was from an AC, not me.
[20:38:05] <FatPhil> all I care about is the humour
[20:38:15] <FatPhil> downmod me if you don't believe me
[21:04:07] <halibut> Bytram: I'm not solid enough with SQL (and do not know your schema) to give a full answer, but the LAG function may be of use. See: https://stackoverflow.com
[21:04:08] <systemd> ^ 03Calculate Time Difference Between Two Rows
[21:04:20] <halibut> Check the second answer for a shorter version of one of the ones in the first answer.
[21:04:33] <halibut> Also: https://mariadb.com
[21:04:34] <systemd> ^ 03LAG
[21:04:43] <halibut> (description of how to use LAG in a query)
[21:10:17] <Bytram> halibut: thanks for that!
[21:11:15] <halibut> You are welcome. Hope it helps.
[21:12:01] <Bytram> it would be an interim fallback if I caqn't get some template "magic" to work
[21:15:20] <chromas> nobody on there suggested using a variable
[21:17:45] <chromas> select string, time, TIMEDIFF(time, @x) as diff, @x:= time as x from table;
[21:18:00] <chromas> s/x/delta/g
[21:18:00] <SedBot> <chromas> select string, time, TIMEDIFF(time, @delta) as diff, @delta:= time as delta from table;
[21:18:16] <chromas> or s/x/old_time/g
[21:18:20] <chromas> whatevs
[21:18:31] * chromas puts on best valley girl accent
[21:18:54] <Bytram> values are in consecutive rows
[21:19:08] <chromas> that's why you have a variable
[21:19:33] <Bytram> tablename == stories
[21:19:48] <Bytram> fieldname == timestamp
[21:20:00] <chromas> for each row, you read the variable set last row, then set it to the current row's time
[21:20:06] <Bytram> https://forum.nasaspaceflight.com
[21:20:44] <Bytram> better link: https://forum.nasaspaceflight.com
[21:20:57] <Bytram> Raptor SN47 delivered with a "Wen Hop? Much Wow" note on it. Love it!
[21:21:23] <Bytram> all coming from: https://forum.nasaspaceflight.com
[21:21:24] <systemd> ^ 03SpaceX Boca Chica - Production Updates - MASTER Thread (4) ( https://forum.nasaspaceflight.com )
[21:21:53] <Bytram> #weather boca chica, TX
[21:21:55] <MrPlow> 4911 Boca Chica, Henderson County, TX 75148, USA - Today: "Rain starting in the afternoon." 78/49F, Humidity: 82%, Precip: 88%, Wind ~12mph. Mon: "Rain throughout the day." 50/42F, Humidity: 78%, Precip: 99%, Wind ~14mph. Tue: "Light rain in the morning." 54/35F, Humidity: 71%, Precip: 89%, Wind ~10mph.
[21:24:46] -!- EWBtCiaST3 has quit [Ping timeout: 265 seconds]
[21:33:13] <kyonko3> he gets a lot of shit china cheap from mexico
[22:55:20] -!- c0lo has quit []
[23:00:19] -!- c0lo [c0lo!~7892de8c@zqs-646-162-243-166.static.vic.bigpond.net.au] has joined #soylent
[23:00:43] <c0lo> Site's CSS gone missing again.
[23:04:39] <FatPhil> does it come from the same server?
[23:05:48] <c0lo> I don't have time to look. Gtg
[23:05:52] -!- c0lo has quit []
[23:06:00] <FatPhil> the problem with that problem is that it's usually intermittent, so you don't have the net logs turned on when it fails