| 01:25.43 | *** join/#uphpu swb (n=sheri@cpe-67-248-88-31.nycap.res.rr.com) |
| 01:25.43 | *** mode/#UPHPU [+v swb] by ChanServ |
| 01:32.58 | *** join/#uphpu romanovic (n=romanovi@c-24-10-174-152.hsd1.ut.comcast.net) |
| 01:55.48 | *** join/#uphpu romanovic-away (n=romanovi@c-24-10-174-152.hsd1.ut.comcast.net) |
| 02:37.51 | *** join/#uphpu jsmith (n=nnjsmith@asterisk/training-and-documentation-guru/jsmith) |
| 02:37.51 | *** mode/#UPHPU [+v jsmith] by irc.freenode.net |
| 02:41.07 | *** join/#uphpu mindjuju_ (n=mindjuju@mail.billgood.us) |
| 02:41.11 | *** join/#uphpu jtsnow_ (n=chatzill@VDSL-151-118-129-72.DNVR.QWEST.NET) |
| 02:51.11 | *** join/#uphpu mindjuju (n=mindjuju@mail.billgood.us) |
| 02:51.11 | *** join/#uphpu brasto (n=brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 02:51.11 | *** join/#uphpu jnbek (n=jnbek@unaffiliated/jnbek) |
| 02:51.11 | *** mode/#UPHPU [+ov mindjuju brasto] by irc.freenode.net |
| 03:08.12 | *** join/#uphpu supernovia1 (n=Velda@c-98-202-112-234.hsd1.ut.comcast.net) |
| 03:24.55 | supernovia1 | hey guys - fungus in particular - is there any way to recursively back up file permissions? I'm running an upgrade script that wants a bazillion files set to 777 |
| 03:25.55 | herlo | supernovia1: 777 is a bad idea |
| 03:25.57 | herlo | period |
| 03:25.58 | herlo | but |
| 03:26.13 | supernovia1 | I agree. that's why it'd be nice to set them all back immediately after i'm done |
| 03:26.26 | herlo | ahh |
| 03:26.33 | DexterTheDragon | I think you need a better upgrade script |
| 03:26.44 | supernovia1 | that'd be nice. |
| 03:26.57 | herlo | supernovia1: what app is this? |
| 03:26.59 | supernovia1 | xcart upgrade scripts suck |
| 03:27.08 | herlo | most upgrades can work with just 755 |
| 03:27.16 | herlo | because all you really need is read and execute |
| 03:27.21 | supernovia1 | this wants everything writeable :( |
| 03:27.50 | herlo | hrm, I wonder what user is running the script, probably the apache user :) |
| 03:28.24 | supernovia1 | yeah I'd guess so .. it's via the browser |
| 03:28.33 | herlo | supernovia1: do you know which linux distro it's running? |
| 03:28.52 | supernovia1 | looks like FreeBSD 6.3 |
| 03:30.35 | supernovia1 | bah. it might be easier to do a fresh cart install and copy my db and skin changes over. this sucks |
| 03:30.48 | herlo | do you know what user the apache uses?? |
| 03:31.02 | supernovia1 | mmm, well I would assume nobody |
| 03:31.06 | herlo | probably not |
| 03:31.19 | supernovia1 | I'm not sure how to tell with the permissions I've got |
| 03:31.22 | herlo | it probably runs as www or apache or wwwrun |
| 03:31.28 | supernovia1 | maybe www then. |
| 03:32.08 | herlo | so you chould change the user ownership to www maybe? |
| 03:32.48 | supernovia1 | change file ownership on all of these to www? |
| 03:33.46 | undertakingyou | mindjuju_: :), that is funny. |
| 03:34.27 | *** join/#uphpu brasto (n=brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 03:34.27 | *** join/#uphpu jnbek (n=jnbek@unaffiliated/jnbek) |
| 03:34.27 | *** mode/#UPHPU [+v brasto] by irc.freenode.net |
| 03:35.31 | herlo | yes |
| 03:35.35 | supernovia1 | hmm. |
| 03:35.43 | herlo | supernovia1: it's just as much work |
| 03:35.49 | herlo | as changing perms |
| 03:35.55 | herlo | chown www * |
| 03:36.12 | supernovia1 | well, I doubt the script would run if I did that |
| 03:36.14 | supernovia1 | I can try though. |
| 03:36.31 | herlo | well, if you want to restore the perms, this would be easier |
| 03:37.26 | supernovia1 | mm, operation not permitted |
| 03:37.37 | herlo | oh, true |
| 03:37.42 | herlo | you are probably not root |
| 03:37.44 | supernovia1 | yeah I'm not |
| 03:37.47 | herlo | can you do it as sudo?? |
| 03:37.52 | herlo | er with sudo |
| 03:38.00 | supernovia1 | doubt it :-( |
| 03:38.05 | supernovia1 | I think what I will do , even though it sucks |
| 03:38.13 | herlo | k, sorry, that's lame |
| 03:39.19 | supernovia1 | yeah can't sudo |
| 03:39.36 | supernovia1 | sigh |
| 03:39.57 | supernovia1 | anyway I do think I'll just export a file that shows what every file's permission is right now |
| 03:40.00 | supernovia1 | which totally sucks. |
| 03:40.25 | supernovia1 | but then at least I'll know what everything needs to go back to for the cart to function |
| 03:41.57 | herlo | yup |
| 04:00.58 | *** join/#uphpu jnbek (n=jnbek@unaffiliated/jnbek) [NETSPLIT VICTIM] |
| 04:05.36 | *** join/#uphpu brasto (n=brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 04:05.36 | *** mode/#UPHPU [+v brasto] by irc.freenode.net |
| 04:05.53 | *** join/#uphpu romanovic-away (n=romanovi@c-24-10-174-152.hsd1.ut.comcast.net) |
| 04:06.37 | supernovia1 | this is so silly. |
| 04:08.51 | beandog | supernovia1: o hai |
| 04:09.02 | beandog | whatd you break |
| 04:09.07 | supernovia1 | hehe |
| 04:09.12 | supernovia1 | hi beandog :-) |
| 04:09.38 | supernovia1 | this silly upgrade script requires 777 permissions on a ton of files (well, 528 files really) |
| 04:09.58 | beandog | sounds like a poorly written application. |
| 04:10.14 | supernovia1 | yeah. it sucks really |
| 04:10.26 | supernovia1 | at least the upgrade does. royally |
| 04:10.33 | beandog | which app? |
| 04:10.37 | supernovia1 | X-cart |
| 04:11.08 | supernovia1 | cp -a eh? |
| 04:11.15 | beandog | preserves permissions |
| 04:11.17 | beandog | so does rsync |
| 04:11.21 | beandog | tar has an option for it too |
| 04:12.15 | supernovia1 | Mmmm, well basically what I have to do is set all this stuff to 777 then go back and set it to 644 or whatever it was before, after the files have been written via the upgrade script |
| 04:13.17 | supernovia1 | can tar -just- back up permissions? |
| 04:13.27 | supernovia1 | without backing up the files themselves I mean.. |
| 04:14.20 | herlo | not that I know of |
| 04:15.35 | supernovia1 | *wishing there were a really great -- and fast -- FOSS cart out there* |
| 04:16.28 | herlo | ya, have you looked at magento? might be a bit of overkill if you are just looking for a simple cart though... |
| 04:16.42 | supernovia1 | magento is a tad slow |
| 04:17.13 | supernovia1 | slower than x-cart by quite a bit anyhow and that's saying something |
| 04:18.46 | beandog | supernovia1: well you don't really need to change the permissions |
| 04:18.55 | beandog | I'm guessing theyre going to be 755 for directories and 644 for filfes |
| 04:18.56 | beandog | files |
| 04:19.07 | supernovia1 | Yeah that's what most of them should be |
| 04:19.10 | beandog | find . -type f -print0 | xargs -0 chmod 644; find . -type d -print0 | xargs -0 chmod 755 |
| 04:19.30 | supernovia1 | Neat |
| 04:19.31 | beandog | that'll fix ya right up |
| 04:19.40 | supernovia1 | You rock, beandog |
| 04:19.51 | supernovia1 | ~beandog++ |
| 04:19.55 | beandog | yay, karma |
| 04:20.02 | supernovia1 | oops.. I didn't do that right, did I |
| 04:20.11 | beandog | yah |
| 04:20.14 | supernovia1 | ~beandog ++ |
| 04:20.20 | supernovia1 | d'oh. |
| 04:20.23 | beandog | heh |
| 04:20.24 | beandog | ~beandog |
| 04:20.25 | ibot | [beandog] the gentoo guru, or a wannabe racer. a skater. the enlightened one, or <3 Janeway, or a non-girl, or has a large intestine filled with mealworms |
| 04:20.27 | herlo | supernovia1: no, you did it right the first time |
| 04:20.28 | beandog | ~karma beandog |
| 04:20.28 | ibot | beandog has karma of 10 |
| 04:20.35 | beandog | \o/ |
| 04:20.38 | supernovia1 | hehehe |
| 04:21.05 | beandog | supernovia1: thats actually an alias I use |
| 04:21.08 | beandog | when I b0rk files. |
| 04:21.30 | supernovia1 | hehe |
| 04:22.08 | supernovia1 | goodness. Well, thanks for that. Once this is done I will run that script and it should save me some time :) |
| 04:23.28 | *** join/#uphpu romanovic-away (n=romanovi@c-24-10-174-152.hsd1.ut.comcast.net) |
| 04:23.28 | *** join/#uphpu brasto (n=brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 04:23.28 | *** mode/#UPHPU [+v brasto] by irc.freenode.net |
| 04:24.31 | supernovia1 | so hey, while people are on break we should do our uphpu movie, beandog |
| 04:24.43 | beandog | thats a good idea |
| 04:24.58 | supernovia1 | any great ones out there? |
| 04:25.00 | beandog | if I could think of a movie |
| 04:25.24 | herlo | beandog: you too, sir |
| 04:25.43 | herlo | beandog: Star Trek |
| 04:25.44 | beandog | I did watch this IMAX movie the other day |
| 04:25.45 | beandog | holy crap |
| 04:25.59 | beandog | that'll make you wanna buy blu-ray, watching one of those. |
| 04:26.05 | supernovia1 | ya? |
| 04:26.14 | beandog | Oh yah, wonderful use of colors |
| 04:26.16 | beandog | which movie was it |
| 04:26.21 | beandog | The Living Sea, I think |
| 04:26.25 | *** join/#uphpu Jacolyte (n=blaine@unaffiliated/jacolyte) |
| 04:27.02 | beandog | oh I remember, I thought we were gonna watch Galaxy Quest |
| 04:28.03 | supernovia1 | I *still* don't get out to movies nearly enough |
| 04:28.09 | supernovia1 | where was The Living Sea? |
| 04:28.16 | beandog | Oh this was like 15 years ago |
| 04:28.21 | beandog | its an older imax film |
| 04:28.23 | supernovia1 | Oh :-) |
| 04:28.29 | beandog | maybe not that long |
| 04:28.33 | beandog | but its not new |
| 04:28.35 | beandog | really good though |
| 04:28.35 | supernovia1 | got ya |
| 04:28.40 | beandog | imax rawks. |
| 04:28.58 | supernovia1 | I saw one of the StarWars on imax, and it was cool |
| 04:29.16 | beandog | I cant stand watching movies on imax |
| 04:29.27 | beandog | like, non-imax release movies |
| 04:29.29 | beandog | er, if that makes sense. |
| 04:29.29 | supernovia1 | except the guy who was sponsoring the movie had some scary looking plastic surgery (I think) and his face was plastered across the screen for the first 15 minutes or so |
| 04:29.42 | supernovia1 | Oh, I must have never seen a real imax |
| 04:29.57 | supernovia1 | just seemed like it was a giant screen and that was all |
| 04:29.59 | beandog | "The Living Sea is probably the most highly regarded of the IMAX films, as it was nominated for an Academy Award for Best Documentary Short" |
| 04:30.10 | beandog | supernovia1: oh no, it's a whole different filming process for IMAX |
| 04:30.15 | beandog | big screen is just part of |
| 04:30.16 | beandog | it |
| 04:30.29 | beandog | Its something like 13 discrete channels |
| 04:30.35 | supernovia1 | Really ... that's cool |
| 04:30.36 | beandog | I dont even know what the mm is |
| 04:30.37 | beandog | its huge. |
| 04:30.49 | beandog | which is why the *actual* IMAX films are so amazing |
| 04:31.00 | beandog | ah, theya re 70mm |
| 04:31.01 | beandog | there ya go |
| 04:31.02 | DexterTheDragon | 70mm |
| 04:31.06 | supernovia1 | I will have to make it a point to watch a real one sometime then... it'll specify if it's IMAX or normal movie on a big fat screen right? |
| 04:31.17 | beandog | supernovia1: yah, just go to the planetarium |
| 04:31.20 | beandog | they have IMAX movies year round |
| 04:31.27 | beandog | I think the Deep Sea 3-D is the one playing right now |
| 04:31.33 | beandog | or the dinosaur museum, either one |
| 04:31.34 | supernovia1 | one of these days I will go :) |
| 04:32.18 | beandog | http://www.blu-ray.com/movies/The-Living-Sea-Blu-ray-Review/690/ |
| 04:32.21 | beandog | good review |
| 04:32.58 | beandog | freak, they are on sale at amazon too right now, $11 |
| 04:32.59 | beandog | sheesh! |
| 04:33.08 | beandog | and I *just* bought like 4 of them the other day |
| 04:33.10 | beandog | rargh. |
| 04:33.16 | supernovia1 | heheh |
| 04:33.58 | supernovia1 | sorry the rargh made me laugh. That does stink when something goes on sale *right* after you buy it |
| 04:34.04 | supernovia1 | I avoid that by not buying anything |
| 04:34.20 | beandog | oh well |
| 04:34.26 | beandog | I actually got all the ones worth buying, I think |
| 04:34.37 | beandog | er, I mean, Im not really excited about the other ones |
| 04:35.10 | supernovia1 | well I guess that works. |
| 04:35.14 | supernovia1 | So .. galaxy quest |
| 04:35.29 | beandog | that works |
| 04:35.48 | beandog | hmm, this water tastes funny |
| 04:35.56 | beandog | I wonder if I forgot to wash my glass |
| 04:36.05 | supernovia1 | paper cups ftw |
| 04:36.24 | beandog | aye |
| 04:36.24 | supernovia1 | although those make the water taste funny too.. and you know, they kill trees and all that |
| 04:36.37 | beandog | they had it coming to them |
| 04:36.45 | supernovia1 | I bought myself paper plates for Christmas in spite of it all |
| 04:36.54 | supernovia1 | since washing dishes with my shoulder goofed up = not fun |
| 04:36.56 | beandog | I buy plastic and then recycle em |
| 04:37.09 | beandog | supernovia1: thats still bugging you? freek |
| 04:37.13 | supernovia1 | yeah :-( |
| 04:37.16 | beandog | go see a physical therapist or something |
| 04:37.23 | supernovia1 | yeah I've been to a chiropractor 3x now |
| 04:37.32 | beandog | oh ok |
| 04:37.50 | DexterTheDragon | there's your problem |
| 04:38.03 | supernovia1 | well, it did hurt pretty bad before I went there too |
| 04:38.05 | beandog | whats that |
| 04:38.17 | DexterTheDragon | chiropractors == bad |
| 04:38.21 | supernovia1 | I kinda think I ... tore my rotator cuff |
| 04:38.22 | herlo | DexterTheDragon: that's not true |
| 04:38.23 | beandog | how come? |
| 04:38.47 | supernovia1 | so I am just trying to chill and not lift the arm up and down as that's what hurts the most |
| 04:38.57 | herlo | totally an opinion on your part. I've been to several and they are quite good for their purpose... |
| 04:39.08 | DexterTheDragon | cracking all your bones isn't good |
| 04:39.20 | herlo | DexterTheDragon: they don't crack bones |
| 04:39.37 | herlo | they put the bones back in place so the muscles can do their jub |
| 04:39.40 | herlo | s/jub/job/ |
| 04:39.54 | supernovia1 | jub sounds good too though |
| 04:40.15 | herlo | lol |
| 04:40.15 | supernovia1 | anyway, I am willing to try anything at this point... |
| 04:40.27 | herlo | yup |
| 04:40.33 | supernovia1 | reminds me of that jabberwok song |
| 04:40.43 | herlo | thing about chiropractic is that ti takes a while |
| 04:40.57 | supernovia1 | mmm, yeah I'm a little .. put off by that really |
| 04:41.38 | supernovia1 | the whole 'come back tomorrow... and the next day.. and the next...' thing is not so cool |
| 04:41.47 | herlo | why? |
| 04:42.01 | supernovia1 | because even with a student discount that adds up really fast |
| 04:42.12 | herlo | think of it as maintenance. You don't do preventative maintenance to your car, it doesn't work so well |
| 04:42.29 | supernovia1 | my car worked fine until a little over 2 weeks ago |
| 04:42.31 | herlo | supernovia1: sure, the money thing is an issue. And insurance companies should really accommodate them... |
| 04:42.49 | herlo | it sure would save us all a bunch of money, but htat's just my opinion :) |
| 04:42.52 | supernovia1 | my insurance co covers next to nothing |
| 04:42.55 | herlo | I sure hope you feel better... |
| 04:43.01 | herlo | supernovia1: yeah, it's lame |
| 04:43.09 | supernovia1 | yeah, my plan of action has been to chill like crazy.. arm is in a sling |
| 04:43.32 | supernovia1 | bum rides off people so I dn't have to mangle things all up again with my stick shift |
| 04:43.35 | herlo | has it been working?? |
| 04:43.51 | supernovia1 | well, I can turn my head pretty well, so that's an improvement |
| 04:44.05 | supernovia1 | last night I woke up and my arm was behind my head, also an improvement - that would have hurt like crazy before |
| 04:44.35 | supernovia1 | my bicept still hurts like mad |
| 04:44.57 | supernovia1 | if I do anything with it. but the sling seems to be helping everything else relax |
| 04:45.38 | supernovia1 | not sure how I'll manage at the temple tomorrow am |
| 04:48.26 | supernovia1 | anyway. |
| 04:48.42 | beandog | :( |
| 04:48.43 | beandog | thas poopy |
| 04:48.46 | beandog | I hope you get better |
| 04:49.16 | supernovia1 | thanks. I am sure things will be OK here sooner or later |
| 04:50.24 | supernovia1 | and I don't have my kids this week, so I don't have to do as much.. should give it a chance to heal |
| 04:51.05 | beandog | :) |
| 04:51.56 | supernovia1 | plus now that everything else has calmed down it's only a few actions that make it hurt.. avoid those for a while and I'll be OK I think |
| 04:52.05 | supernovia1 | typing = OK, thank goodness :) |
| 04:52.14 | beandog | heh |
| 04:52.23 | beandog | how do you describe a function in postgres? |
| 04:52.31 | beandog | I was gonna say, typing seems unaffected |
| 04:52.57 | supernovia1 | it's fine as long as my arm is propped up w. this sling :) |
| 04:53.32 | beandog | tahts cool |
| 04:54.03 | beandog | you can tweet |
| 04:54.50 | supernovia1 | hehe, that's what counts |
| 05:00.27 | herlo | supernovia1: good to hear about your body |
| 05:00.57 | beandog | now herlo wants to talk about his |
| 05:01.02 | supernovia1 | goodness |
| 05:01.06 | beandog | :) |
| 05:01.08 | supernovia1 | I could tell you more :-p |
| 05:05.13 | beandog | Sadly, we're out of time for today |
| 05:05.18 | beandog | Other children want to do show and tlel |
| 05:05.19 | beandog | tell |
| 05:05.20 | beandog | :) |
| 05:05.57 | beandog | Okay, who is up for a really funky query |
| 05:06.09 | beandog | I'm trying to figure out how to do a join on a LIKE clause |
| 05:06.24 | supernovia1 | ya? |
| 05:07.13 | beandog | SELECT bug_id FROM bugzilla, view_package WHERE short_short_desc LIKE view_package.cp LIMIT 1; |
| 05:07.16 | beandog | it's thinking |
| 05:07.19 | beandog | so the query actually works |
| 05:07.23 | beandog | who knows what its going to return |
| 05:07.44 | beandog | Im not sure I can even explain what Im trying to do... |
| 05:08.02 | supernovia1 | shoot |
| 05:08.27 | beandog | well I have a bug description in one table |
| 05:08.29 | beandog | and the keyword to search for in another |
| 05:08.37 | beandog | and I basically wanna see if I can do a join on a like |
| 05:08.43 | beandog | where bug description ~ keyword |
| 05:08.49 | beandog | but en masse |
| 05:08.54 | beandog | so I can do a mass import into another table |
| 05:09.01 | beandog | Oh wait, subselect |
| 05:09.02 | beandog | duh |
| 05:09.22 | beandog | maybe not. |
| 05:09.27 | beandog | crap. |
| 05:10.43 | supernovia1 | so one of these tables is a single keyword (or keyphrase) and you basically want to full text search those words against the description right? |
| 05:11.02 | supernovia1 | rather, one of those tables has that single keyword.. |
| 05:11.16 | beandog | right |
| 05:11.34 | herlo | beandog: haha |
| 05:13.15 | beandog | SELECT bug_id FROM bugzilla b INNER JOIN view_package vp ON b.short_short_desc LIKE vp.cp |
| 05:13.18 | beandog | that *works* |
| 05:13.22 | beandog | I imagine it would crush my server though. |
| 05:13.36 | beandog | meh |
| 05:13.41 | beandog | Oh well. |
| 05:13.42 | herlo | ask eggyknap |
| 05:13.49 | herlo | he's a postgres genius :) |
| 05:13.51 | supernovia1 | you're way better at postgres than I am |
| 05:14.17 | beandog | herlo: yah |
| 05:16.41 | beandog | oh well, easy workaround |
| 05:16.42 | beandog | no biggie |
| 05:16.49 | beandog | still, its always nice to be able to do it in one query |
| 05:17.19 | herlo | yup |
| 05:17.45 | beandog | Im joining against a view |
| 05:17.49 | beandog | that probably isn't helping. |
| 05:18.01 | beandog | Hmm |
| 05:23.49 | beandog | Total runtime: 224799.361 ms |
| 05:24.35 | beandog | that kinda puts a crimp on debugging. :) |
| 05:24.45 | supernovia1 | hehe |
| 05:26.38 | herlo | uh, that's not long at all :) |
| 05:29.03 | supernovia1 | do you have any full text indexing mod installed? |
| 05:30.00 | supernovia1 | not even sure if that's barking up the right tree |
| 05:30.24 | beandog | no |
| 05:30.29 | beandog | I would like to install it, tho |
| 05:31.08 | supernovia1 | it -sounds- like it would do what you're trying to do much faster.. |
| 05:31.17 | supernovia1 | http://wiki.postgresql.org/wiki/Full_Text_Indexing_with_PostgreSQL |
| 05:31.22 | beandog | yah |
| 05:31.25 | beandog | I thought 8.x had it |
| 05:31.40 | beandog | still in contrib, tho |
| 05:31.43 | beandog | foo. |
| 05:32.08 | supernovia1 | mm |
| 05:32.39 | beandog | I really, really do need that tho |
| 05:32.58 | supernovia1 | and a subquery doesn't do it? would probably be super slow though even if it did |
| 05:33.05 | beandog | yah |
| 05:34.19 | supernovia1 | surely some sort of index would save the day |
| 05:34.59 | eggyknap | beandog: that query doesn't look too bad. If you're doing LIKE queries (which is different than PostgreSQL's full text search), you can create an index to help it out. |
| 05:35.43 | eggyknap | Anyway, look for text_pattern_ops in the index creation vocabulary. At least in some versions, you need to be particular about how you create the index for LIKE to be able to use it. |
| 05:36.03 | beandog | Ok |
| 05:36.05 | eggyknap | If you're using 8.3 or above, full text search is built in -- no need for contrib. |
| 05:36.21 | beandog | Yah Im on 8.4.1 |
| 05:36.27 | eggyknap | But in order to debug why the query takes so long, EXPLAIN ANALYZE would be most useful. |
| 05:36.55 | beandog | http://pastebin.com/m27789f4c |
| 05:36.57 | beandog | eggyknap: there it is |
| 05:37.02 | beandog | I'm still not great at interpreting it. |
| 05:37.30 | eggyknap | Yeah, that requires some ... magic^Wexperience |
| 05:39.25 | beandog | well, its not really a big deal. I was just hoping for a shortcut |
| 05:39.29 | eggyknap | If you had something like <field> LIKE <string constant> then you could index it, but <table_a.foo> LIKE <table_b.bar> isn't index-able. |
| 05:39.50 | eggyknap | I suspect, though, that given a little better knowledge of what data you expect, you could optimize it somewhat. |
| 05:39.54 | beandog | http://www.postgresql.org/docs/8.4/static/textsearch.html |
| 05:40.13 | eggyknap | I don't think text search would help you much there either, because agian, you're not looking for a constant. |
| 05:40.13 | beandog | yah |
| 05:40.18 | beandog | Oh |
| 05:40.34 | beandog | Right, I do lots of text searches on the site though |
| 05:40.38 | beandog | It might be helpful |
| 05:40.41 | beandog | Im kinda looking at two things at once |
| 05:40.51 | eggyknap | Well that's always a recipe for disaster :) |
| 05:40.52 | eggyknap | j/k |
| 05:41.11 | beandog | Actually, its not *bad* right now |
| 05:41.18 | beandog | but if I can optimize this thing, that'd be nice |
| 05:43.37 | beandog | thx eggyknap |
| 05:43.38 | beandog | :) |
| 05:43.50 | eggyknap | Sorry I don't have a better generic answer :) |
| 05:44.03 | beandog | actually thats been really helpful |
| 05:44.08 | beandog | confirms I'm at least going in the right direction |
| 05:44.11 | eggyknap | Indeed? Well W00t, then :) |
| 05:44.22 | beandog | get some sleep |
| 05:45.37 | eggyknap | g'night, all. |
| 05:45.46 | supernovia1 | spakoi, eggyknap |
| 05:45.54 | beandog | I think Im too tired to tackle this too |
| 05:46.01 | herlo | eggyknap: gnight sir |
| 05:46.01 | beandog | nn |
| 05:46.34 | supernovia1 | you taking off too beandog? |
| 05:47.53 | beandog | yah |
| 05:48.30 | supernovia1 | have a good night :) |
| 05:48.47 | supernovia1 | and thanks again for your help with the neat find/chmod thingy |
| 05:52.03 | beandog | yahp |
| 05:55.20 | eggyknap | I realized I was being an idiot, and than an index could very well help after all. |
| 05:55.21 | supernovia1 | oh? |
| 05:55.38 | eggyknap | ...and of course, I had to mention it, or I wouldn't have been able to fall asleep :) |
| 05:55.51 | supernovia1 | hehe, well you could tweet it his way |
| 05:56.38 | eggyknap | It's doing a nested loop join, which means it scans one row in the outer relation, and then looks for matches in the inner relation. So at the beginning of each inner relation scan, it *has* a constant value it can search an index for. |
| 05:57.09 | eggyknap | So if he indexed tmp_bugzilla.short_short_desc it might help. |
| 05:57.53 | supernovia1 | sweet |
| 05:58.12 | eggyknap | no, tweet. |
| 05:58.35 | supernovia1 | hehe |
| 05:59.18 | supernovia1 | sweet, tweet, they do rhyme you know... |
| 05:59.38 | supernovia1 | sorry, bizarre sesame street reference |
| 06:00.54 | eggyknap | That sudden burst of activity has given a second wind. I'll have to spend a while now hacking PostgreSQL's ANALYZE command, and watching hulu. |
| 06:01.16 | supernovia1 | lol |
| 06:58.29 | *** join/#uphpu PoeticIntensity (n=jason@c-98-202-190-14.hsd1.ut.comcast.net) |
| 06:59.12 | PoeticIntensity | Hey guys... anyone around? |
| 06:59.24 | supernovia1 | I'm here.. |
| 06:59.30 | PoeticIntensity | hey girl! What's up? |
| 06:59.40 | supernovia | Oh, you know :) |
| 06:59.42 | supernovia | how are things? |
| 06:59.56 | PoeticIntensity | just helping someone work his way through Linux.... :) |
| 07:00.03 | PoeticIntensity | Showing him how freaking awesome UPHPU is. |
| 07:00.04 | PoeticIntensity | :) |
| 07:00.08 | supernovia | Sweet :) |
| 07:00.32 | PoeticIntensity | oh yes.... |
| 07:00.36 | PoeticIntensity | Did you have a good Christmas? |
| 07:00.55 | supernovia | Yeah, it was really sweet |
| 07:01.02 | supernovia | and serendipitous |
| 07:01.05 | supernovia | how was yours? |
| 07:01.26 | PoeticIntensity | oh, man... It was wonderful. |
| 07:01.32 | PoeticIntensity | the kids loved it! |
| 07:01.50 | PoeticIntensity | I can't say mine was serendipidousosuous (sp?), but.... It was a'ight... :) |
| 07:01.56 | supernovia | My kids were totally pleased with the Christmas we had here, then they went to their Dad's and got an even bigger haul :-p Totally spoiled |
| 07:02.50 | supernovia | origami paper and books and school clothes here... DSi and pixos and an erector set there ... they're happy as clams |
| 07:03.40 | supernovia | how old are your kids again? |
| 07:05.28 | herlo | supernovia: kids do that |
| 07:05.53 | herlo | especially when parents play disneyland dad/mom |
| 07:05.55 | herlo | :) |
| 07:05.57 | supernovia | hehe |
| 07:06.03 | supernovia | I'm afraid I contributed |
| 07:06.10 | PoeticIntensity | hehe... |
| 07:06.15 | supernovia | "Oh, maybe you should ask Santa for /that/ while you're with Dad..." |
| 07:06.22 | PoeticIntensity | I've got 3... a 6-year old, 3, and 1. |
| 07:06.22 | herlo | lol |
| 07:06.31 | PoeticIntensity | right... |
| 07:06.39 | PoeticIntensity | how many kids do you have, herlo ? |
| 07:06.53 | herlo | PoeticIntensity: 1 (9yo boy) and one on the way |
| 07:07.09 | PoeticIntensity | nice, bro! |
| 07:07.12 | PoeticIntensity | Congratulations! |
| 07:07.16 | PoeticIntensity | when are you due? |
| 07:07.20 | PoeticIntensity | (or your wife, as the case may be) |
| 07:07.21 | PoeticIntensity | : |
| 07:07.22 | PoeticIntensity | :) |
| 07:07.25 | supernovia | hehe |
| 07:07.29 | herlo | well, I'm due before Thursday |
| 07:07.38 | herlo | but my gf is due in August :) |
| 07:07.43 | herlo | she's about 7 wks along |
| 07:08.15 | orsonj | anyone here on a linux box at the moment? |
| 07:08.27 | PoeticIntensity | orsonj, I am |
| 07:08.29 | PoeticIntensity | what do ya need? |
| 07:08.31 | supernovia | this one I'm on isn't but I could pull up a vm |
| 07:08.35 | PoeticIntensity | browser testing? |
| 07:08.39 | orsonj | ls /sys/block/sd?/queue/rotational; cat /sys/block/sd?/queue/rotational |
| 07:08.48 | PoeticIntensity | heh... you want me to run that? |
| 07:09.21 | orsonj | I'm trying to figure out if it is just me or if anyone else can get an output of 0 on solid state drives (flash drives workd) |
| 07:09.24 | orsonj | yes |
| 07:09.52 | PoeticIntensity | ok... |
| 07:10.04 | PoeticIntensity | I don't have any SDD drives, but all of mine are "sda sdb" etc.... |
| 07:10.06 | orsonj | it just queries the drive to see if it is ssd or a rotating medium |
| 07:10.08 | PoeticIntensity | lemme run it. |
| 07:10.18 | orsonj | If you have a flash drive handy, plug it in |
| 07:10.33 | PoeticIntensity | JMUSIC hd2 # ls /sys/block/sd?/queue/rotational; cat /sys/block/sd?/queue/rotational |
| 07:10.34 | PoeticIntensity | 1 |
| 07:10.40 | PoeticIntensity | 1 |
| 07:10.42 | PoeticIntensity | JMUSIC hd2 # ls /sys/block/sd?/queue/rotational; cat /sys/block/sd?/queue/rotational |
| 07:10.44 | PoeticIntensity | 1 |
| 07:10.48 | PoeticIntensity | 1 |
| 07:10.54 | PoeticIntensity | ok... that's what mine did (sorry for the spam... I clicked twice) |
| 07:10.56 | PoeticIntensity | I don't have a flash on me, sorry. |
| 07:11.36 | orsonj | well, if they are spinning drives, that is to be expected, but mine show 1 for usb drives. (can't afford real ssds yet) |
| 07:12.09 | orsonj | https://bugs.launchpad.net/ureadahead/+bug/499237 <-- this is the bug I am working on figuring out. |
| 07:12.13 | herlo | PoeticIntensity: ever heard of pastebin?? |
| 07:12.16 | herlo | :-D |
| 07:12.22 | PoeticIntensity | hrmph.... |
| 07:12.34 | PoeticIntensity | I thought you reserved that kind of talk for #utah... ;-) |
| 07:12.35 | orsonj | pastebin only applies during normal waking hours |
| 07:12.39 | PoeticIntensity | OL |
| 07:12.41 | PoeticIntensity | LOL |
| 07:12.43 | PoeticIntensity | yes! |
| 07:12.52 | herlo | orsonj: oh, I think NOT |
| 07:13.01 | PoeticIntensity | You're just a nazi, herlo |
| 07:13.08 | PoeticIntensity | try /join #nazis |
| 07:13.09 | PoeticIntensity | :-D |
| 07:13.46 | herlo | lol, conversation ended |
| 07:13.50 | herlo | gnight |
| 07:13.53 | PoeticIntensity | hahah.... |
| 07:13.55 | PoeticIntensity | nothin' but love, brother. |
| 07:21.07 | orsonj | I'm also curious why my system has a 6 second sleep at the beginning of the boot sequence |
| 07:23.52 | orsonj | bootchart has ruined my free time. |
| 07:26.11 | orsonj | fortunantly, there hasn't been anything good on tv for the last month |
| 07:26.31 | wps | there hasn't been anything good on television for the past decade |
| 07:26.38 | supernovia | amen to that. |
| 07:27.16 | orsonj | I'm obviously using good in a relative sense |
| 07:36.53 | supernovia | oi. Well, I'm tired. Good night guys. |
| 07:37.29 | *** part/#uphpu supernovia (n=Velda@c-98-202-112-234.hsd1.ut.comcast.net) |
| 13:30.29 | *** join/#uphpu romanovic-away (n=romanovi@c-24-10-174-152.hsd1.ut.comcast.net) |
| 13:30.29 | *** join/#uphpu brasto (n=brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 13:30.29 | *** mode/#UPHPU [+v brasto] by irc.freenode.net |
| 13:41.33 | *** join/#uphpu josephscott (n=josephsc@75-169-244-123.slkc.qwest.net) |
| 13:41.33 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 14:00.41 | *** join/#uphpu josephscott (n=josephsc@75-169-244-123.slkc.qwest.net) [NETSPLIT VICTIM] |
| 14:00.41 | *** join/#uphpu romanovic-away (n=romanovi@c-24-10-174-152.hsd1.ut.comcast.net) |
| 14:00.41 | *** join/#uphpu brasto (n=brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 14:00.41 | *** mode/#UPHPU [+vv josephscott brasto] by irc.freenode.net |
| 16:02.28 | *** join/#uphpu Utah_Dave (n=David@72-166-51-162.dia.static.qwest.net) |
| 16:02.28 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 16:02.57 | Utah_Dave | morning everyone! |
| 16:03.19 | *** join/#uphpu fungus (n=olsonl@bromine.sosstaffing.com) |
| 16:03.19 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 16:19.38 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 16:19.38 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 16:30.20 | *** join/#uphpu Utah_Dave (n=David@72-166-51-162.dia.static.qwest.net) [NETSPLIT VICTIM] |
| 16:30.20 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 16:33.08 | *** join/#uphpu fungus (n=olsonl@bromine.sosstaffing.com) |
| 16:33.08 | *** join/#uphpu josephscott (n=josephsc@75-169-244-123.slkc.qwest.net) [NETSPLIT VICTIM] |
| 16:33.08 | *** join/#uphpu romanovic-away (n=romanovi@c-24-10-174-152.hsd1.ut.comcast.net) |
| 16:33.08 | *** join/#uphpu brasto (n=brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 16:33.08 | *** mode/#UPHPU [+ovv fungus josephscott brasto] by irc.freenode.net |
| 16:33.13 | *** join/#uphpu josephscott (n=josephsc@75-169-244-123.slkc.qwest.net) |
| 16:33.13 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 16:33.50 | utahcon | morning Utah_Dave ! |
| 16:38.30 | *** join/#uphpu redroy (n=Adium@66.60.105.178) |
| 16:45.46 | DexterTheDragon | ~lart Utah_Dave |
| 16:45.46 | ibot | farts in Utah_Dave's general direction |
| 16:48.14 | beandog | sure beats coffee |
| 17:04.40 | beandog | eggyknap: ping |
| 17:04.44 | eggyknap | pong |
| 17:05.02 | beandog | eggyknap: did you thinko f a way to index this thing? |
| 17:05.12 | eggyknap | beandog: I tweeted it to you, in fact :) |
| 17:05.18 | eggyknap | Well, not the exact command... |
| 17:05.30 | beandog | I found a similar query in my code that I ran, which was actually much faster |
| 17:05.37 | beandog | er, not as slow |
| 17:05.51 | beandog | INSERT INTO package_bugs (bug, package, description, status) select b.bug_id AS bug, p.id AS package, b.short_short_desc, 1 FROM package p INNER JOIN category c ON p.category = c.id INNER JOIN bugzilla b ON b.short_short_desc LIKE ('%' || c.name || '/' || p.name || '%'); |
| 17:07.18 | eggyknap | I'm guessing (your mileage may vary, of course) that you want this: CREATE INDEX my_spiffy_fix_everything_index ON tmp_bugzilla (short_short_desc text_pattern_ops); |
| 17:10.13 | beandog | Hmm |
| 17:10.14 | beandog | okay |
| 17:10.54 | eggyknap | It looks weird. Given some understanding of PostgreSQL's operator classes, it eventually makes sense. The point is, it makes an index you can use LIKE against. |
| 17:11.34 | *** join/#uphpu justincarmony (n=justinca@ip70-181-212-144.sd.sd.cox.net) |
| 17:11.34 | *** mode/#UPHPU [+v justincarmony] by ChanServ |
| 17:11.51 | justincarmony | hola :P |
| 17:12.38 | eggyknap | justincarmony: say hi to my family for me. You'll find them in precisely the most boring parts of town. |
| 17:12.56 | beandog | eggyknap: interesting stuff, I havent looked into the different index types of postgres before |
| 17:13.03 | beandog | and its not really speeding up my query, but thats okay |
| 17:13.19 | eggyknap | There are index types, and then there are operator classes. The latter are far more inscrutable :) |
| 17:13.35 | justincarmony | mindjuju_: ping |
| 17:13.47 | eggyknap | Another option, if that didn't work, is to do a similar thing but with the name field of the package table. |
| 17:13.56 | eggyknap | Does explain analyze suggest it's using your new index? |
| 17:14.13 | beandog | lemme check |
| 17:14.28 | beandog | it takes a few minutes to execute |
| 17:14.41 | eggyknap | Sorry, I should have just asked for EXPLAIN, w/out analyze. |
| 17:15.39 | beandog | doesnt look like it |
| 17:15.48 | eggyknap | Bummer. Still a Seq Scan on both tables? |
| 17:16.15 | beandog | http://pastebin.com/m576370a1 |
| 17:18.14 | eggyknap | Ah, you've thrown a new table in there, it seems. But the new table doesn't make a difference. Unfortunately, neither does the index |
| 17:18.30 | *** join/#uphpu fungus (n=olsonl@bromine.sosstaffing.com) |
| 17:18.30 | *** join/#uphpu josephscott (n=josephsc@75-169-244-123.slkc.qwest.net) [NETSPLIT VICTIM] |
| 17:18.30 | *** join/#uphpu romanovic (n=romanovi@c-24-10-174-152.hsd1.ut.comcast.net) |
| 17:18.30 | *** join/#uphpu brasto (n=brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 17:18.30 | *** mode/#UPHPU [+ovv fungus josephscott brasto] by irc.freenode.net |
| 17:20.17 | *** join/#uphpu fungus_ (n=olsonl@bromine.sosstaffing.com) |
| 17:20.40 | eggyknap | That way it doesn't involve joins based on string pattern matching :) |
| 17:21.01 | beandog | eggyknap: hmm, playing around, it *does* use the idx when I use regexp |
| 17:21.15 | eggyknap | Interesting. Does it go any faster? |
| 17:21.21 | beandog | still checking |
| 17:22.15 | beandog | oh wait, no it doesn't. |
| 17:22.16 | beandog | meh |
| 17:22.47 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 17:28.03 | *** join/#uphpu josephscott (n=josephsc@75-169-244-123.slkc.qwest.net) [NETSPLIT VICTIM] |
| 17:28.03 | *** join/#uphpu romanovic (n=romanovi@c-24-10-174-152.hsd1.ut.comcast.net) |
| 17:28.03 | *** join/#uphpu brasto (n=brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 17:28.03 | *** mode/#UPHPU [+vv josephscott brasto] by irc.freenode.net |
| 17:30.52 | *** join/#uphpu xtrementl (n=xtrement@174-23-196-143.slkc.qwest.net) |
| 17:31.18 | *** join/#uphpu brasto (n=brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 17:31.18 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 17:43.31 | tierra | roads are pretty crazy this morning... 18-wheeler started jackknifing in the lane right next to me turning onto i-15 nb from i-80 eb... |
| 17:44.04 | tierra | a car in front of it started spinning out |
| 17:44.45 | tierra | I think he hit his brakes too hard when he realized there was already a wreck in front of him with a bumper just laying out in the lane we were in |
| 17:44.58 | tierra | but I couldn't see the wreck in front of the 18-wheeler |
| 17:45.29 | tierra | really glad I just replaced my tires with some really nice winter tires |
| 17:46.40 | tierra | in the end, myself, the car in front of me, and the 18-wheeler made it out fine, but it was a close call |
| 17:46.55 | *** join/#uphpu jtsnow (n=chatzill@VDSL-151-118-129-72.DNVR.QWEST.NET) |
| 17:58.36 | macnewbold | humor of the day: http://thishelpdesk.com/ |
| 17:59.05 | macnewbold | (if you have good ideas for future comics, i know happen to know the authors) |
| 18:08.44 | mindjuju_ | 01hey macnewbold |
| 18:08.54 | mindjuju_ | 01i decided on the tom selleck mustache |
| 18:09.41 | mindjuju_ | 01i think i need to go stand out in the sun though, my face isn't weather-beaten enough to pull it off |
| 18:10.02 | herlo | mindjuju_: did you change the font of your messages or something? They are coming through black on my screen... |
| 18:10.12 | mindjuju_ | 01again? |
| 18:10.18 | herlo | and my background happens to be black |
| 18:11.16 | herlo | apparently |
| 18:11.37 | *** join/#uphpu mindjuju (n=mindjuju@mail.billgood.us) |
| 18:11.38 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 18:11.43 | herlo | I didn't know it had happened before |
| 18:11.56 | mindjuju | how is it now? |
| 18:12.34 | mindjuju | herlo^^ |
| 18:13.37 | herlo | mindjuju: better |
| 18:13.52 | mindjuju | so herlo, i gave myself a tom selleck mustache |
| 18:14.12 | herlo | mindjuju: yeah, facebook told me, but I didn't seen any pics |
| 18:14.55 | mindjuju | @beandog - don't faint - http://www.frys.com/product/5947254 |
| 18:15.15 | herlo | mindjuju: that's a pretty good deal |
| 18:15.18 | mindjuju | 2 TB Hdd - $129 |
| 18:15.29 | mindjuju | yup, i'm seriously thinking of getting one |
| 18:15.36 | mindjuju | great reviews for it on newegg |
| 18:16.02 | *** join/#uphpu jtsnow (n=chatzill@VDSL-151-118-129-72.DNVR.QWEST.NET) |
| 18:16.10 | beandog | mindjuju: oh, man |
| 18:16.34 | mindjuju | it's like $40 cheaper than new egg |
| 18:16.42 | mindjuju | like $50 cheaper than tiger direct |
| 18:16.58 | beandog | and $450 cheaper than Best Buy |
| 18:23.39 | herlo | Best buy is for impulse buyers who don't know any better (or don't have time) |
| 18:26.04 | *** join/#uphpu jtsnow (n=chatzill@VDSL-151-118-129-72.DNVR.QWEST.NET) |
| 18:52.04 | *** join/#uphpu fungus__ (n=olsonl@bromine.sosstaffing.com) |
| 18:52.40 | beandog | oh, man |
| 18:55.06 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 19:02.16 | xtrementl | very nice |
| 19:04.02 | *** join/#uphpu justincarmony_ (n=justinca@ip70-181-212-144.sd.sd.cox.net) |
| 19:04.02 | *** mode/#UPHPU [+v justincarmony_] by ChanServ |
| 19:11.56 | *** join/#uphpu jtsnow (n=chatzill@VDSL-151-118-129-72.DNVR.QWEST.NET) |
| 19:17.19 | romanovic | where is mgeary this week? |
| 19:17.39 | romanovic | on holiday somewhere warmer than here? |
| 19:17.48 | herlo | probably |
| 19:19.10 | romanovic | hmm |
| 19:20.27 | mindjuju | so fungus |
| 19:20.35 | mindjuju | do you work with unix also? |
| 19:20.45 | fungus | unfortunately |
| 19:20.54 | mindjuju | so here is my question then |
| 19:21.00 | mindjuju | why don't you have a unix beard? |
| 19:21.12 | fungus | lol |
| 19:21.16 | mindjuju | :) |
| 19:21.19 | fungus | cause I can't stand them |
| 19:21.20 | jsmith | mindjuju: You going to post pictures of your 'stash? |
| 19:21.26 | utahcon | fungus: can you grow facial hair? |
| 19:21.29 | mindjuju | i did, they are on FB |
| 19:21.40 | mindjuju | though i took it in bad light to reduce the corniness factor |
| 19:22.10 | mindjuju | in fact, i just lamented that i don't have the unix skills for a unix beard, I don't have the face for a stache , got to drop back to scruff |
| 19:22.51 | fungus | I couldn't grow a beard if I tried. |
| 19:24.29 | jsmith | mindjuju: I left you a comment :-p |
| 19:24.31 | fungus | uh oh |
| 19:25.02 | *** join/#uphpu jtsnow (n=chatzill@VDSL-151-118-129-72.DNVR.QWEST.NET) |
| 19:36.46 | herlo | grow one beandog |
| 19:36.59 | beandog | all my lady friends wont let me |
| 19:37.06 | jsmith | beandog couldn't grow a beard if his life depended on it |
| 19:37.23 | macnewbold | hehe |
| 19:37.47 | beandog | on the plus side, its nice not having to shave all the time |
| 19:37.48 | beandog | :) |
| 19:37.52 | macnewbold | i need to go find pics of a unix beard |
| 19:37.58 | macnewbold | sounds like a fun project for 2010 |
| 19:38.20 | macnewbold | at the rate i'm graying, i'll be a graybeard too... |
| 19:38.26 | beandog | http://www.drbill.cc/images/dilbert.png |
| 19:38.30 | jsmith | macnewbold: Going gray already? |
| 19:38.39 | macnewbold | yeah, i can get away with the goatee and mustache, but my wife isn't a fan of the full beard |
| 19:38.54 | macnewbold | jsmith: yeah... heredity. my mom was almost fully gray by 30 |
| 19:39.05 | jsmith | macnewbold: Sorry to hear that |
| 19:39.31 | beandog | I think I definately have Unix Butt |
| 19:39.37 | macnewbold | i'm not that bad, but you have to count my gray hairs by the dozens at least, if not by the 100s |
| 19:39.52 | macnewbold | i'm not complaining... i wouldn't mind looking a little older at this point |
| 19:40.11 | beandog | I cant wait to be an old man. You can get away with so much more |
| 19:46.25 | Utah_Dave | beandog: I can't find a picture of Unix Butt anywhere on the internet! |
| 19:47.08 | beandog | Utah_Dave: this glaring error must be remedied at once! |
| 19:47.14 | beandog | to the batcave! |
| 19:53.36 | mindjuju | k, here is fungus with his unix beard! |
| 19:53.36 | mindjuju | http://www.facebook.com/photo.php?pid=3146404&l=0afad40817&id=741364607 |
| 19:53.57 | mindjuju | not perfect, not great, but good for being done while I ate nachos |
| 19:54.57 | fungus | yikes |
| 19:55.52 | mindjuju | it's patterned after gandolfs |
| 19:57.13 | utahcon | I am glad fungus can't grow a beard... he is creepy looking with one |
| 19:58.02 | mindjuju | is there anybody who looks good with a beard besides Moses? |
| 19:58.16 | mindjuju | Charlton Heston's Moses, that is |
| 19:58.34 | fungus | David Beckham. |
| 19:59.06 | mindjuju | does he have a beard now, last i saw it was scruff |
| 19:59.45 | fungus | Well... not a big beard, but enough scruff to be called a beard |
| 20:08.01 | utahcon | unix beards... no |
| 20:08.08 | utahcon | trimmed but full beards... yes |
| 20:13.58 | utahcon | Sevendust... yeah buddy! |
| 20:14.31 | fungus | :P |
| 20:14.53 | mindjuju | love julie andrews, saw mary poppins on sunday as the family movie of the week |
| 20:15.20 | utahcon | back in the day I would have given Julie Andrews a good shake :D |
| 20:21.25 | fungus | OMG! Big Love is coming back. |
| 20:21.53 | utahcon | w00t |
| 20:23.14 | stderr | fungus: it was never going anywhere |
| 20:23.37 | fungus | I got worried because it's been so long. |
| 20:24.16 | stderr | season 4 was announced a year ago |
| 20:24.21 | stderr | right after season 3 ended |
| 20:25.17 | stderr | should be pretty awesome though, things are definitely coming to a head |
| 20:25.18 | fungus | It's been so long I have forgotten |
| 20:25.31 | herlo | fungus: yeah, it's been a while |
| 20:25.48 | herlo | they did announce it though |
| 20:25.53 | fungus | I just saw the trailer and the christmas video, so now I am really excited. |
| 20:26.09 | stderr | pft, after waiting between seasons of the Sopranos, my television series patience is incredible. |
| 20:26.15 | herlo | fungus: link plz |
| 20:26.33 | fungus | http://jezebel.com/5431433/big-love-returns-in-a-big-way |
| 20:26.45 | herlo | stderr: yeah, sopranos was annoying that way. But I just watched it on my own terms... |
| 20:26.48 | fungus | http://www.cityweekly.net/utah/blog-2774-big-love-a-juniper-creek-christmas.html |
| 20:26.49 | herlo | fungus: tx |
| 20:27.58 | fungus | No way, Barb is sooo much more awesome |
| 20:28.08 | stderr | I'm with utahcon on this one |
| 20:28.13 | utahcon | :d |
| 20:28.27 | fungus | Yeah, well... Barb can kick her ass. :) |
| 20:28.52 | utahcon | Chloe has her moments... Ginnifer is hot all the time. |
| 20:28.54 | fungus | lol, yeah, she is one scary bitch. |
| 20:28.56 | herlo | http://www.imdb.com/title/tt0330099/ <-- here's why |
| 20:29.01 | utahcon | Did you see her in He's Just Not That Into YOu? |
| 20:29.03 | utahcon | damn! |
| 20:29.04 | stderr | the first thing I saw Sevigny in was Kids and I can't shake it when I watch it |
| 20:29.24 | herlo | utahcon: no, she does something very different in Big Brown Bunny :) |
| 20:29.32 | utahcon | yeah I know |
| 20:29.34 | fungus | I always have flashbacks to Boys Don't Cry |
| 20:30.14 | stderr | have you ever seen Kids? |
| 20:30.24 | fungus | of course |
| 20:30.29 | fungus | been a very long time though |
| 20:31.22 | herlo | yeah, Big Love looks really good this season |
| 20:34.26 | *** join/#uphpu bander (n=bander@c-24-10-214-244.hsd1.ut.comcast.net) |
| 20:39.13 | mindjuju | so if cat /proc/meminfo shows memory, what shows processes? |
| 20:39.38 | fungus | ps |
| 20:40.07 | wps | you know, as in "processes show" |
| 20:40.31 | wps | ps |
| 20:41.01 | fungus | ps has a million and one options to get the output "just right" |
| 20:42.38 | bander | "ps aux | grep foo" is often useful |
| 20:44.07 | bander | looks like those are equivalent on my system (I think maybe mine is BSD-style and yours is Unix-style?) |
| 20:44.10 | fungus | -ef doesn't show cpu% mem% or state |
| 20:44.13 | beandog | ps auxf |
| 20:44.33 | wps | ha ha, I was trying to be funny but I was actually close |
| 20:44.37 | wps | just manned it |
| 20:44.40 | wps | it's process status |
| 20:44.47 | fungus | but -ef works everywhere and aux only works on GNU |
| 20:45.37 | herlo | fungus: right-o |
| 20:46.01 | fungus | it pisses me off every time I have to look at my Solaris box |
| 20:46.06 | herlo | lol |
| 20:46.09 | herlo | alias it :) |
| 20:46.46 | fungus | not a bad idea |
| 20:53.40 | xtrementl | what about macs? |
| 20:56.31 | stderr | most newer versions of ps have both the BSD and unix98 style options, to include ps on OS X |
| 20:57.54 | bander | mindjuju: see also "top" |
| 20:58.34 | xtrementl | makes sense.. seems like -ef and axuf weren't working on 10.6.2 |
| 20:59.08 | macnewbold | when in doubt, "man ps" or "man top" usually work and give appropriate details for the version you're using |
| 21:00.23 | xtrementl | ya; i usually use ps axu .. but i'm a lamer :) |
| 21:00.39 | beandog | pidof is nice too to see if smoethings running |
| 21:01.10 | mindjuju | beandog, did you just send me a text message on my phone? |
| 21:01.17 | beandog | mindjuju: no |
| 21:03.37 | unum | mindjuju: did it ask if you are jeff? |
| 21:04.43 | unum | what do you guys use for site statistics? |
| 21:05.39 | beandog | awstats |
| 21:05.49 | beandog | how do you do an update across two tables w/postgres |
| 21:05.53 | beandog | I can never rmemeber the syntax |
| 21:06.18 | unum | I write a script :) |
| 21:06.28 | unum | I always screw it up when I try to do an update from |
| 21:06.43 | unum | I don't know how to specify my join columns |
| 21:06.59 | unum | ON doesn't seem to work |
| 21:09.41 | bander | beandog: "UPDATE update_table SET foo='bar' FROM join_table WHERE condition = 1"? |
| 21:09.42 | bander | http://www.postgresql.org/docs/8.1/interactive/sql-update.html |
| 21:11.28 | beandog | yah |
| 21:11.30 | beandog | that's the easy way |
| 21:11.41 | beandog | I keep making things too complex |
| 21:11.47 | jsmith | You can always do it with rules and views :-) |
| 21:17.13 | justincarmony | ping mindjuju |
| 21:21.25 | beandog | mindjuju: lmao |
| 21:21.31 | beandog | I love fungus' beard |
| 21:24.38 | justincarmony | lol, seems every time I try to talk to mindjuju I miss him :P |
| 21:25.31 | herlo | justincarmony: that's because he is *fast* |
| 21:31.04 | beandog | wow its snowing out there |
| 21:33.30 | herlo | beandog: where is you? |
| 21:33.39 | beandog | in the laundry room |
| 21:33.52 | beandog | aka "the office" |
| 21:34.21 | beandog | or did you mean city? |
| 21:34.25 | beandog | SLC |
| 21:34.50 | herlo | beandog: ahh. |
| 21:34.59 | herlo | I'm in Murray and it's not snowing here atm |
| 21:35.12 | justincarmony | its not snowing here either |
| 21:35.53 | justincarmony | but it rarely does in San Diego... :P |
| 21:36.13 | herlo | haha |
| 21:52.11 | utahcon | mindjuju: want to buy an island? |
| 21:52.19 | utahcon | http://www.privateislandsonline.com/mavuvaocfj.htm |
| 21:52.29 | herlo | woo |
| 21:52.45 | herlo | wow, that's pretty cheap |
| 21:52.57 | utahcon | and 42 acres |
| 21:52.59 | utahcon | that is sweet! |
| 21:53.20 | herlo | ya |
| 21:53.29 | herlo | until the ocean claims it again |
| 21:54.50 | bander | I think it's $65k for the cheapest lot |
| 21:54.55 | bander | and 42 acres is the combined lot size |
| 21:55.53 | utahcon | bander: think you are right |
| 21:55.59 | bander | unfortunately :-\ |
| 21:57.22 | mindjuju | ~apb justincarmony |
| 21:57.23 | ibot | ACTION hires baby Lyssa to rough up justincarmony |
| 21:58.08 | influx | ~larp mindjuju |
| 21:58.19 | influx | hrm. |
| 21:58.27 | mindjuju | fyi, it's not the island that is for sale, but a lot on the island |
| 21:58.32 | mindjuju | influx try this |
| 21:58.36 | mindjuju | ~lart influx |
| 21:58.36 | ibot | teaches influx that M$ Access is a database. No, really, a database. A real live multi-user... well, ok, not multi-user, but a database. Yeah, that sounds right. |
| 21:58.39 | mindjuju | see, that works |
| 21:58.47 | *** part/#uphpu mindjuju (n=mindjuju@mail.billgood.us) |
| 21:59.03 | *** join/#uphpu mindjuju (n=mindjuju@mail.billgood.us) |
| 21:59.04 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 22:00.59 | mindjuju | oh justincarmony |
| 22:01.00 | mindjuju | i'm here |
| 22:01.04 | mindjuju | yoohoo |
| 22:01.07 | mindjuju | hello! |
| 22:01.18 | mindjuju | justin! |
| 22:01.22 | mindjuju | carmony |
| 22:01.29 | mindjuju | ...sigh... |
| 22:01.33 | mindjuju | well, i tried |
| 22:01.48 | herlo | mindjuju: it's not like he has good timing or anything :) |
| 22:01.56 | jsmith | Timing is everything |
| 22:02.26 | influx | derp |
| 22:02.29 | influx | ~lart influx |
| 22:02.29 | ibot | whips influx with a wet and grimy noodle just because |
| 22:06.21 | influx | blur |
| 22:54.50 | mindjuju | sadly, i'm stepping away from my computer for a while justincarmony, email me your question |
| 23:02.18 | beandog | So |
| 23:02.24 | beandog | Atom feeds, RSS feeds, or provide both? |
| 23:03.14 | bander | beandog: pretty easy to provide both |
| 23:03.20 | beandog | yah |
| 23:03.21 | beandog | true. |
| 23:03.46 | bander | beandog: if I remember correctly, I even did them in the same logic flow, with a few substitutions based on mode, and it was still quite readable |
| 23:04.02 | beandog | what do you mean |
| 23:04.37 | bander | like, I had one handler, with ?type=rss or ?type=atom |
| 23:04.52 | beandog | OH OK |
| 23:04.56 | beandog | whoops |
| 23:05.03 | bander | and it just iterated over the items and chose what tag names to use with ternaries |
| 23:05.23 | beandog | yah |
| 23:05.27 | beandog | thats what I think Ill do |
| 23:05.34 | beandog | cool, cool |
| 23:05.37 | beandog | trivial to do both |
| 23:05.38 | beandog | both it is. |
| 23:16.23 | fungus | better than query string parameters.... Clean URLS |
| 23:16.34 | fungus | <PROTECTED> |
| 23:24.57 | wps | nothing like the smell of toner to get you in the mood for dinner |
| 23:25.07 | wps | ick |
| 23:32.41 | wps | what's wrong with this javascript syntax? |
| 23:32.55 | wps | (var > 0) ? return false : return true; |
| 23:32.58 | herlo | it's wrong |
| 23:33.01 | wps | shouldn't that work? |
| 23:33.06 | bander | var's a keyword? |
| 23:33.28 | wps | sorryâ¦Â yeah |
| 23:33.32 | wps | it's not really "var" |
| 23:33.35 | bander | oh |
| 23:33.38 | wps | I was just generalizing my code |
| 23:33.43 | bander | return var > 0 ? false : true;, then |
| 23:34.13 | wps | thanks |
| 23:34.16 | wps | that works |
| 23:34.25 | macnewbold | wps: the problem is that you've got statements instead of expressions on the right |
| 23:34.51 | wps | that's how I would have done it in PHP, but I thought that ternaries in javascript wanted the action on the right |
| 23:34.55 | macnewbold | the trinary operator ( ? : ) isn't equivalent to if/then/else, cause it only works with expressions |
| 23:35.00 | wps | like this: (b == 5) ? a="true" : a="false"; |
| 23:35.10 | wps | instead of |
| 23:35.19 | wps | a = (b==5) ? true : false; |
| 23:35.25 | macnewbold | i think it does it in JS same as PHP. i don't know of a lang that has trinary that works the other way. |
| 23:35.45 | bander | wps: assignments and function calls are expressions, but return statements aren't |
| 23:35.52 | wps | ahâ¦Â thanks |
| 23:35.55 | wps | that's the piece I was missing |
| 23:36.05 | orsonj | the problem is you are trying to use the ?: operator, you should use regular syntax: if then else |
| 23:36.42 | wps | I would much rather have this on one line of code instead of five |
| 23:36.44 | orsonj | ;) |
| 23:37.12 | wps | I am all about keeping code clean and legible but this is one place where it's quite appropriate in my opinion |
| 23:40.54 | josephscott | I know some folks really, really hate the ?: syntax |
| 23:41.31 | josephscott | I think it is ok for very simple things, generally short, so that it's easy for a human to parse and immediately see what it's doing |
| 23:41.39 | wps | I would venture that that's mostly due to people that have misused it, creating nearly illegible code |
| 23:42.19 | bander | I think they're like regexes: intimidating, but good for readability by minimizing boilerplate when used appropriately |
| 23:50.05 | wps | now, if you're really awesome, you'll use regex inside a ternary! |
| 23:50.45 | eco | Or you could just do "vari <= 0" instead of unnecessarily using the ternary operator. |
| 23:51.07 | romanovic | ditto |
| 23:51.11 | eco | "return var <= 0" |
| 23:51.27 | wps | explain that syntax to me? |
| 23:51.50 | eco | Umm, comparison operators always evaluate to boolean expressions. |
| 23:52.08 | wps | ohâ¦Â duh |
| 23:52.16 | romanovic | yes, no need for explicitly returning true or false with comparisons |
| 23:52.24 | wps | that's much better |
| 23:52.51 | wps | hmm |
| 23:52.52 | wps | didn't work |
| 23:52.54 | eco | I hardly know Javascript but I really doubt the "trinary" operator only works in "expressions" (read: assignments). |
| 23:53.10 | wps | I'm returning false to stop a form from submitting |
| 23:53.35 | tierra | *ternary |
| 23:54.00 | eco | tierra: I was quoting. |
| 23:54.17 | stderr | "trinary"? *Zelda theme* |
| 23:55.16 | stderr | I'm going to stop, I didn't participate in this conversation for a reason. |
| 23:55.18 | stderr | To home! |
| 23:56.51 | romanovic | is there a UJUG channel? its not #ujug |
| 23:58.26 | herlo | dont think they have one |
| 23:58.52 | romanovic | hmm. #utos good for java questions? |
| 23:59.05 | herlo | romanovic: probably not |
| 23:59.18 | herlo | romanovic: there might be java ppl there though, so feel free to try |
| 23:59.31 | romanovic | how bout here, any java programmers? |
| 23:59.56 | bander | romanovic: I know a smidge |
