#dev | Logs for 2018-09-11
« return
[11:31:02] <TheMightyBuzzard> nothing. been busy making the place presentable. at least the bits i use. TR can clean his own shit.
[11:31:10] <Bytram> nod nod
[11:31:41] <Bytram> ISTR your mentioning getting the query down to a few(?) seconds
[11:31:51] <Bytram> was wondering what you can come up with at that point
[11:32:06] <TheMightyBuzzard> no, said it's possible i could but i doubted it. i think.
[11:32:49] <Bytram> oh, could be. am still underccaffeinated
[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:33:56] <Bytram> ouch.
[11:33:57] * TheMightyBuzzard is displeased with our db structure
[11:34:46] <Bytram> third normal form it is not, I take it
[11:35:14] * Bytram vaguely recalls normal form constructions from WAY back when
[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:36:45] <Bytram> hmmm,
[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:37:59] <TheMightyBuzzard> or have a discussion column on stories/polls/journals
[11:38:24] <Bytram> oh, right
[11:38:35] * Bytram forgot comments apply not just to stories
[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:40:15] <Bytram> whelp, IIRC, there IS a journal id and a poll id, right?
[11:40:26] <TheMightyBuzzard> yes, which is the problem
[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:41:32] <Bytram> an "id type" flag and a column with the [story|journal|poll] id in it... wouldn't that work?
[11:41:58] <TheMightyBuzzard> yeah, s'what i'm saying.
[11:42:10] <Bytram> ok, so we are in furious agreement, then. =)
[11:42:31] <Bytram> I am not, however, understanding what the problem with that would be?
[11:42:47] <TheMightyBuzzard> a fuckton of rewriting
[11:43:47] <Bytram> oh. yeah, that WOULD do it.
[11:45:02] * Bytram really needs to get a linuc box
[11:45:08] <Bytram> s/c/x/
[11:45:19] <Bytram> ~sed on
[11:45:20] <exec> sed enabled for 10#dev
[11:46:20] * TheMightyBuzzard ponders
[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:34] <TheMightyBuzzard> get a raspberry pi or something
[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:47:14] <TheMightyBuzzard> board n all the necessary accessories should run under $100
[11:47:22] <Bytram> we already have ubuntu and gentoo here,.
[11:47:34] <Bytram> raspbian on top of that
[11:47:35] <TheMightyBuzzard> so run gentoo on it
[11:47:42] <Bytram> hrm
[11:48:00] <TheMightyBuzzard> https://wiki.gentoo.org
[11:48:03] <exec> └─ 13Raspberry Pi - Gentoo Wiki
[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:49:00] <Bytram> 24" 1920x1200 monitor feels cramped atm
[11:49:07] <TheMightyBuzzard> hehe
[11:49:21] <Bytram> didn't know about gentoo on RPi, though... now you've got me thinking.
[11:49:29] <TheMightyBuzzard> if you got the spare coin, by all means.
[11:49:33] <Bytram> yes, I know, that oculd be dangerous!
[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: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: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:35] <TheMightyBuzzard> 1.3 does 4k fine i think. could be wrong though.
[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:42] <Bytram> k
[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:52:27] <TheMightyBuzzard> nod nod
[11:52:33] <Bytram> wonders if any of the Intel on-chip gpus are adequate for 4K
[11:52:47] * Bytram does not need gaming, just an ocdasional video (mostly mp4)
[11:52:48] <TheMightyBuzzard> dunno. prolly.
[11:53:05] <Bytram> yeah, I've started looking at *that* off and on lately.
[11:53:19] <Bytram> well, need to be at work in an hour...
[11:53:31] <Bytram> can't procrastinate much longer so time to jump in the shower.
[11:53:43] <TheMightyBuzzard> okay. try that whole "making lots of money" thing today. see if you enjoy it.
[11:53:49] <Bytram> thanks a bunch for looking into the query and the computer feedback!
[11:54:14] <Bytram> The things I gotta do in the name of research! Geeesh!!
[11:54:17] <Bytram> =)
[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: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:55:49] <Bytram> which one wants to actually 'buy' stuff, AND can afford it, too, is the trick
[11:56:18] <Bytram> best of luck with the de-beeing and home repairs/renovations!
[11:56:21] <Bytram> ciao for now