#dev | Logs for 2018-09-11
« return
[11:56:21] <Bytram> ciao for now
[11:56:18] <Bytram> best of luck with the de-beeing and home repairs/renovations!
[11:55:49] <Bytram> which one wants to actually 'buy' stuff, AND can afford it, too, is the trick
[11:55:23] <Bytram> too much of a good thing when they are 'just looking', along with several other people who want to look at stuff at the same time
[11:54:56] <Bytram> there's a ship in port with over 4K tourists... and it's raining pretty good atm; they'll prolly want to leave intown and head to the mall... and me.
[11:54:17] <Bytram> =)
[11:54:14] <Bytram> The things I gotta do in the name of research! Geeesh!!
[11:53:49] <Bytram> thanks a bunch for looking into the query and the computer feedback!
[11:53:43] <TheMightyBuzzard> okay. try that whole "making lots of money" thing today. see if you enjoy it.
[11:53:31] <Bytram> can't procrastinate much longer so time to jump in the shower.
[11:53:19] <Bytram> well, need to be at work in an hour...
[11:53:05] <Bytram> yeah, I've started looking at *that* off and on lately.
[11:52:48] <TheMightyBuzzard> dunno. prolly.
[11:52:47] * Bytram does not need gaming, just an ocdasional video (mostly mp4)
[11:52:33] <Bytram> wonders if any of the Intel on-chip gpus are adequate for 4K
[11:52:27] <TheMightyBuzzard> nod nod
[11:52:14] <Bytram> as I'm currently sporting a core 2 duo, most other things I'd look at would be an upgrade
[11:51:42] <Bytram> k
[11:51:36] <Bytram> seems depending on ^^^ affects what resolution can be sent to the monitor/tv as far as I can tell
[11:51:35] <TheMightyBuzzard> 1.3 does 4k fine i think. could be wrong though.
[11:51:14] <TheMightyBuzzard> nothing you can do about those except keep patches applied. every cpu going back to the first multi-core ones are vulnerable.
[11:51:00] <Bytram> and then I need to figure out what I would need for graphics processor that could support 4k, and what kind of cable e.g. HDMI 1.2? 1.3? 1.4? Display port? etc
[11:50:15] <Bytram> problem is, with spectre and meltdown still about, means I doin't want to pay any more coin than I need to... so a used box is what I am considering
[11:49:33] <Bytram> yes, I know, that oculd be dangerous!
[11:49:29] <TheMightyBuzzard> if you got the spare coin, by all means.
[11:49:21] <Bytram> didn't know about gentoo on RPi, though... now you've got me thinking.
[11:49:07] <TheMightyBuzzard> hehe
[11:49:00] <Bytram> 24" 1920x1200 monitor feels cramped atm
[11:48:43] <Bytram> I've also been eyeing 4K 40"-43" TVs on sale for ~$300 and am tempted to step up to a box that could not only run linux, but also drive something with more screen real estate
[11:48:03] <exec> └─ 13Raspberry Pi - Gentoo Wiki
[11:48:00] <TheMightyBuzzard> https://wiki.gentoo.org
[11:47:42] <Bytram> hrm
[11:47:35] <TheMightyBuzzard> so run gentoo on it
[11:47:34] <Bytram> raspbian on top of that
[11:47:22] <Bytram> we already have ubuntu and gentoo here,.
[11:47:14] <TheMightyBuzzard> board n all the necessary accessories should run under $100
[11:47:12] <Bytram> thought of that.... but don't want to have two many distrobutions to keep track of as I get back up to speed
[11:46:34] <TheMightyBuzzard> get a raspberry pi or something
[11:46:26] * Bytram is going to have one VERY busy day at work today, and there's only two of us on for the whole day.
[11:46:20] * TheMightyBuzzard ponders
[11:45:20] <exec> sed enabled for 10#dev
[11:45:19] <Bytram> ~sed on
[11:45:08] <Bytram> s/c/x/
[11:45:02] * Bytram really needs to get a linuc box
[11:43:47] <Bytram> oh. yeah, that WOULD do it.
[11:42:47] <TheMightyBuzzard> a fuckton of rewriting
[11:42:31] <Bytram> I am not, however, understanding what the problem with that would be?
[11:42:10] <Bytram> ok, so we are in furious agreement, then. =)
[11:41:58] <TheMightyBuzzard> yeah, s'what i'm saying.
[11:41:32] <Bytram> an "id type" flag and a column with the [story|journal|poll] id in it... wouldn't that work?
[11:41:21] <TheMightyBuzzard> if they just had a story id and a means to declare what kind of story they were, our db would be massively more efficient.
[11:40:26] <TheMightyBuzzard> yes, which is the problem
[11:40:15] <Bytram> whelp, IIRC, there IS a journal id and a poll id, right?
[11:39:26] <TheMightyBuzzard> why they didn't just give polls/journals story ids and add a bitmask flag to declare what kind of stories they are is beyond me.
[11:38:35] * Bytram forgot comments apply not just to stories
[11:38:24] <Bytram> oh, right
[11:37:59] <TheMightyBuzzard> or have a discussion column on stories/polls/journals
[11:37:58] <Bytram> doesn't sounds (at firt glance) to add the column and back fill it... the more interesting thing would be to populate it at the time that record is constructed. (As well as fixing the table defs in the install scripts)
[11:36:45] <Bytram> hmmm,
[11:36:10] <TheMightyBuzzard> the comments table really, really needs to have a column for the story id. having a discussions table to correlate a comment to a story/journal/poll is a huge fucking pain.
[11:35:14] * Bytram vaguely recalls normal form constructions from WAY back when
[11:34:46] <Bytram> third normal form it is not, I take it
[11:33:57] * TheMightyBuzzard is displeased with our db structure
[11:33:56] <Bytram> ouch.
[11:33:12] <TheMightyBuzzard> it takes two lookups and correlation between two very, very large tables that requires a lookup in a third to even associate them.
[11:32:49] <Bytram> oh, could be. am still underccaffeinated
[11:32:06] <TheMightyBuzzard> no, said it's possible i could but i doubted it. i think.
[11:31:51] <Bytram> was wondering what you can come up with at that point
[11:31:41] <Bytram> ISTR your mentioning getting the query down to a few(?) seconds
[11:31:10] <Bytram> nod nod
[11:31:02] <TheMightyBuzzard> nothing. been busy making the place presentable. at least the bits i use. TR can clean his own shit.