| 00:04.51 | beandog | blipX, ask in #utah |
| 00:08.17 | blipX | beandog: Will do. Someone just indicated the other day someone in here did and I could not recall the nick. Thanks. |
| 00:08.20 | *** part/#uphpu blipX (n=jnielsen@ip67-88-113-150.z113-88-67.customer.algx.net) |
| 00:33.13 | *** part/#uphpu brasto (n=brasto@out.lnxi.com) |
| 00:43.43 | *** join/#uphpu cycokilr (n=cycokilr@66.114.120.2) |
| 00:53.39 | *** join/#uphpu meetingMindjuju (n=41794bc3@mail.billgood.us) |
| 00:53.54 | meetingMindjuju | greets to all |
| 00:54.00 | meetingMindjuju | meeting will be starting shortly |
| 00:54.10 | meetingMindjuju | broadcast stream should be live right now |
| 01:01.42 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 01:03.13 | *** join/#uphpu richardkmiller (n=richardk@72.8.109.118) |
| 01:04.28 | *** join/#uphpu josephscott (n=josephsc@001-790-481.area1.spcsdns.net) |
| 01:11.21 | herlo | oh crap... |
| 01:11.27 | herlo | I've gotta eat first... |
| 01:13.10 | herlo | btw, did last month's presentation get uploaded somewhere? |
| 01:16.25 | herlo | ahh, the webmistress! |
| 01:16.29 | herlo | :) |
| 01:17.41 | Meeting | hi herlo, the audio is going to be posted shortly |
| 01:17.49 | herlo | Meeting: okay. |
| 01:18.55 | herlo | meetingMindjuju: let me know when its up as i'll announce it on the new UTOS site... |
| 01:21.11 | herlo | hey, it would be nice if we could have the slides up in advance, so we can go through them whilst the presenter is presenting... |
| 01:22.13 | herlo | also, I'd like to hear about db engines, like innodb... |
| 01:22.41 | meetingMindjuju | let me see if the slides are posted somewhere |
| 01:23.03 | herlo | meetingMindjuju: thank you |
| 01:23.14 | bradym | thanks meetingMindjuju |
| 01:24.06 | herlo | tell macnewbold I'm hurt! |
| 01:24.43 | herlo | :) |
| 01:26.40 | *** join/#uphpu Utah_Dave (n=boucha@216.143.235.130) |
| 01:26.40 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 01:26.43 | herlo | ah well... |
| 01:26.50 | Utah_Dave | herlo: !! |
| 01:26.58 | meetingMindjuju | we tried! |
| 01:27.14 | herlo | Utah_Dave: !! |
| 01:27.19 | herlo | meetingMindjuju: thanks for trying |
| 01:27.20 | Utah_Dave | how's it going, bro? |
| 01:27.25 | herlo | meetingMindjuju: next time |
| 01:27.33 | herlo | Utah_Dave: well, you? Are you listening to meetingMindjuju ? |
| 01:27.36 | herlo | er macnewbold |
| 01:27.54 | Utah_Dave | no, I'm sitting right behind macnewbold. I was able to make it this month |
| 01:28.16 | herlo | Utah_Dave: then you *are* listening |
| 01:28.20 | Utah_Dave | herlo: you're missing some good pizza |
| 01:28.21 | herlo | you are also seeing him |
| 01:28.28 | herlo | Utah_Dave: I know. |
| 01:28.36 | herlo | I'm gonna have to leave soon |
| 01:29.18 | Utah_Dave | ~orderpizza herlo |
| 01:29.27 | Utah_Dave | ~buy pizza for herlo |
| 01:29.28 | jbot | ACTION goes to S-Mart and gets a dozen for herlos for pizza |
| 01:29.37 | Utah_Dave | :) |
| 01:29.52 | Utah_Dave | ~buy herlo pizza |
| 01:29.52 | jbot | ACTION goes to S-Mart and gets a dozen pizzas for herlo |
| 01:30.02 | herlo | sweet! I just got bought for pizza |
| 01:30.38 | herlo | I wish there were ambient mics. I'm going to make a note of that for the LUG Boxes... |
| 01:31.01 | Utah_Dave | yeah |
| 01:32.04 | herlo | UTOS is working to make LUG boxes so we all can do this icecast stuff... |
| 01:33.43 | Utah_Dave | that's cool. |
| 01:35.41 | herlo | Utah_Dave: and we're gonna put in wireless routers and a few other cool things like that... |
| 01:35.58 | Utah_Dave | wow. how much do you think they're going to cost? |
| 01:36.12 | herlo | Utah_Dave: $100-200 overall |
| 01:36.22 | herlo | wireless routers only cost $30 or so |
| 01:36.26 | Utah_Dave | sweet |
| 01:36.47 | herlo | but we're gonna include power strips and network wire and probably a 10/100 switch too for installfests and things... |
| 01:38.04 | meetingMindjuju | please post any questions you want Mac to answer |
| 01:38.30 | herlo | meetingMindjuju: sorry, are we being distracting? |
| 01:42.43 | meetingMindjuju | nope, ya'll are fine |
| 01:42.49 | meetingMindjuju | not distracted at all |
| 01:46.56 | herlo | cool... |
| 01:47.32 | herlo | mysql logs could be rotated with logrotate |
| 01:47.39 | Utah_Dave | mac's got a goatee now |
| 01:47.46 | herlo | Utah_Dave: whoa! |
| 01:47.50 | Utah_Dave | :) |
| 01:47.53 | herlo | ask him to rub his goatee |
| 01:48.01 | herlo | as one of the unrelated questions |
| 01:51.56 | herlo | strange, my puter froze! that's the first time on Fedora 7 |
| 01:52.17 | Black_Chaos | herlo: and probably wont be the last :) |
| 01:53.47 | herlo | Black_Chaos: I don't know. I've had it running since may without any problems... |
| 01:56.16 | herlo | Utah_Dave: check out http://collective.utos.org, its coming along |
| 01:58.57 | Utah_Dave | herlo: brasto wants to know the name of the guy who does sasha.com |
| 01:59.05 | bradym | meetingMindjuju: so a procedure doesn't give you a return value? |
| 01:59.47 | herlo | Utah_Dave: Sasha Pachev |
| 02:00.09 | herlo | and then you don't have to commit |
| 02:00.52 | bradym | that helps, thanks mac |
| 02:08.56 | meetingMindjuju | bradym , herlo i've added ya'll to the swag list, anybody else here listening to the meeting that wants to be on the swag drawing list? |
| 02:09.14 | herlo | meetingMindjuju: what swag is there? |
| 02:09.27 | meetingMindjuju | 3 comps, 3 books |
| 02:09.42 | herlo | meetingMindjuju: what books? |
| 02:09.55 | meetingMindjuju | 2 mysql books |
| 02:10.03 | meetingMindjuju | 1 ajax in action |
| 02:10.18 | herlo | good book though |
| 02:11.05 | herlo | (lots of errors in 1st edition though) |
| 02:12.33 | herlo | Lamont is there!? |
| 02:12.38 | meetingMindjuju | yup |
| 02:12.40 | Utah_Dave | yep |
| 02:12.46 | herlo | geez, he never comes when I am home, but of course he goes when I'm not there |
| 02:12.53 | Utah_Dave | he's eating all your pizza |
| 02:13.07 | herlo | Utah_Dave: nah, GL bought my pizza, its on its way... |
| 02:14.30 | Utah_Dave | ~pizza herlo |
| 02:14.30 | jbot | ACTION gives herlo a piece of cardboard with a photo of a pizza on it |
| 02:14.38 | Utah_Dave | ~pizzapizza herlo |
| 02:15.12 | herlo | nah, papa johns |
| 02:16.09 | herlo | meetingMindjuju: so I'm curious of macnewbold's opinion on performance enhancements you could do in mysql to improve performance... |
| 02:16.32 | herlo | that'd be me that asked the questions about database engines... |
| 02:16.38 | herlo | :) |
| 02:19.43 | bradym | so if you do a view from several tables, you can write an update statement for the view and it updates the data in each table? |
| 02:19.56 | herlo | bradym: yes |
| 02:19.59 | bradym | cool |
| 02:20.08 | Utah_Dave | bradym: sometimes you can. |
| 02:20.25 | herlo | Utah_Dave: okay, get particular |
| 02:20.31 | herlo | ;-) |
| 02:20.37 | bradym | need to look more at views then :) |
| 02:20.42 | Utah_Dave | There are instances where you can't. It depends on how the view was created |
| 02:21.07 | herlo | Utah_Dave: I know, but he was asking whether it was possible IMO |
| 02:21.14 | herlo | not a big deal though... |
| 02:21.18 | Utah_Dave | true |
| 02:21.33 | herlo | Utah_Dave: plus, I like giving you trouble |
| 02:21.46 | Utah_Dave | ~needle herlo |
| 02:22.04 | herlo | ~herlo Utah_Dave |
| 02:22.04 | jbot | ACTION pokes Utah_Dave in they eye with a sharp needle |
| 02:24.29 | herlo | macnewbold: ocelot |
| 02:24.47 | herlo | supposedly it completely implements sql99 (IIRC) |
| 02:25.08 | herlo | http://www.ocelot.ca/ |
| 02:27.27 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 02:27.27 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 02:28.45 | herlo | how much does it pay? What kind of work? |
| 02:28.52 | meetingMindjuju | i'll ask |
| 02:29.07 | herlo | do we actually work? Or can we just play foosball |
| 02:29.08 | herlo | ? |
| 02:32.36 | beandog | murray? |
| 02:32.41 | beandog | the land of fruit and honey and utopia? |
| 02:32.55 | beandog | ~congrats herlo |
| 02:33.14 | herlo | exactly! |
| 02:36.32 | herlo | so what did macnewbold say? |
| 02:36.36 | Utah_Dave | bradym: you won!!!!! |
| 02:36.44 | bradym | yay! |
| 02:36.48 | bradym | what did i win? |
| 02:36.49 | Utah_Dave | You won MySQL Second Edition! |
| 02:36.56 | bradym | cool :) |
| 02:37.04 | Utah_Dave | it's a big fat book |
| 02:37.29 | herlo | Utah_Dave: cool for bradym |
| 02:39.07 | bradym | and asking a question in irc got me my current job... |
| 02:39.18 | herlo | ~w00t! |
| 02:39.18 | jbot | There it is! |
| 02:39.49 | herlo | brasto rocks! |
| 02:40.09 | herlo | mindjuju: you are a sick man! |
| 02:40.45 | Utah_Dave | later everyone |
| 02:40.54 | Utah_Dave | bradym: how you gonna get your book? |
| 02:41.03 | bradym | good question |
| 02:41.03 | herlo | Utah_Dave: hey |
| 02:41.12 | herlo | before you go |
| 02:41.22 | Utah_Dave | yeah, what's up? |
| 02:41.30 | herlo | Where can I find the job listings from macnewbold ? |
| 02:41.51 | Utah_Dave | just a sec, lemme ask |
| 02:41.55 | herlo | k, tx |
| 02:42.39 | herlo | Utah_Dave: tx |
| 02:43.50 | Utah_Dave | herlo: he'll send you an email. |
| 02:43.50 | bradym | hey Utah_Dave, thank macnewbold and mindjuju for me, having the audio for the meeting is very cool :) |
| 02:44.02 | herlo | Utah_Dave: he should post them somewhere |
| 02:44.03 | bradym | and tell mindjuju i'll email him about the book |
| 02:44.04 | Utah_Dave | or you can send him an email and he'll let you know |
| 02:44.10 | Utah_Dave | bradym: ok |
| 02:44.13 | herlo | Utah_Dave: I'll do that |
| 02:44.14 | Utah_Dave | herlo: you're right |
| 02:44.17 | bradym | thanks Utah_Dave |
| 02:44.20 | Utah_Dave | np |
| 02:44.21 | herlo | Utah_Dave: thanks for asking for me |
| 02:44.26 | Utah_Dave | later guys |
| 02:44.30 | herlo | er Utah_Dave is |
| 02:44.55 | bradym | i'm out too.. later |
| 03:38.42 | *** join/#uphpu jnbek (n=jnbek@c-67-161-221-47.hsd1.ut.comcast.net) |
| 04:34.42 | *** join/#uphpu synic (n=squish@pdpc/supporter/student/synic) [NETSPLIT VICTIM] |
| 04:34.42 | *** mode/#UPHPU [+v synic] by irc.freenode.net |
| 04:48.52 | *** join/#uphpu nAmir12 (i=Aviv@gateway/tor/x-7f898ee7ab13d00e) |
| 04:56.09 | *** join/#uphpu jsmith-away (n=jsmith@000-181-428.area3.spcsdns.net) |
| 04:56.09 | *** mode/#UPHPU [+v jsmith-away] by ChanServ |
| 05:19.09 | *** join/#uphpu brasto (n=Dad@71-219-122-120.slkc.qwest.net) |
| 05:19.09 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 05:19.13 | brasto | ~etc |
| 05:19.14 | jbot | hmm... etc is something marginally brain-dead people say when they know their statement is incomplete, but they can't figure out how to complete it or /etc, the directory that contains all the config files |
| 05:19.45 | herlo | brasto: the latter |
| 05:20.11 | brasto | lol, you'll see why i did that in about 10 seconds... |
| 05:20.47 | brasto | herlo: check your uphpu mail now... |
| 05:22.17 | brasto | doh! I said "growning" instead of "growing"... |
| 05:23.04 | herlo | brasto: did what in 10 seconds? |
| 05:23.58 | brasto | did you get an email from me addressed to the uphpu list? At the bottom of the email I put jbot's definition of etc. |
| 05:24.39 | brasto | I didn't do the email in 10 seconds, but the email, which was nearly complete, would be available in about 10 seconds from the time that I told you it would be available in 10 seconds... |
| 05:25.51 | brasto | herlo: oops, I meant the Plug list... |
| 05:25.55 | brasto | it's getting late... |
| 05:26.03 | herlo | hehe, i saw it |
| 06:13.21 | *** join/#uphpu josephscott (n=josephsc@71-32-206-120.slkc.qwest.net) |
| 10:37.06 | *** join/#uphpu jsmith-away (n=jsmith@000-181-428.area3.spcsdns.net) |
| 10:37.06 | *** mode/#UPHPU [+v jsmith-away] by ChanServ |
| 12:56.44 | *** join/#uphpu nAmir12 (i=Aviv@gateway/tor/x-4db9028b860e6028) |
| 13:32.55 | *** join/#uphpu mgeary (n=mgeary@72.8.120.115) |
| 13:32.55 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 13:33.03 | mgeary | hey |
| 13:33.07 | mgeary | anyone around? |
| 13:33.49 | mgeary | can you look at a url for me? |
| 13:33.54 | mgeary | http://www.weblessons.com/discipline.php?id=2 |
| 13:33.59 | mgeary | that page doesn't load all the way |
| 13:34.09 | mgeary | do you get any sort of error in the header? |
| 13:34.18 | mgeary | something really weird is going on on the server |
| 13:37.18 | mgeary | only *part* of a page is loading |
| 13:46.55 | jsmith | mgeary: The funny thing is... it starts loading for me, then starts taking 100% of the CPU. |
| 13:47.11 | mgeary | something really weird is happening |
| 13:47.14 | jsmith | mgeary: Could this be a javascript loop that's getting stuck? |
| 13:47.15 | mgeary | i've rebooted the server |
| 13:47.28 | mgeary | don't think so, it's too page-agnostic for that |
| 13:48.42 | mgeary | jsmith: try curl-ing that page |
| 13:48.50 | mgeary | you get a strange error |
| 13:49.12 | jsmith | Nope... I'm grabbing it with wget, and it just keeps coming and coming |
| 13:49.17 | jsmith | Over 2 megs worth of data so far |
| 13:49.20 | mgeary | really?? |
| 13:49.34 | mgeary | that's a good tim |
| 13:49.35 | mgeary | tip |
| 13:52.24 | herlo | jsmith: you should probably stop if it gets past 2Gigs |
| 13:52.34 | mgeary | well, yeah. stop it |
| 13:52.38 | mgeary | i can repro that |
| 13:52.47 | mgeary | got a ton of bad chars |
| 13:53.56 | jsmith | mgeary: I stopped it after 14 megs |
| 13:54.01 | mgeary | yeah |
| 13:54.07 | mgeary | i stopped it after 2 megs |
| 14:15.46 | mgeary | okay, consider this |
| 14:15.50 | mgeary | when i log in to the server |
| 14:16.03 | mgeary | and wget or curl the page, it comes through just fine |
| 14:16.28 | mgeary | what conclusions would you draw from that? |
| 14:20.14 | *** join/#uphpu timinator (n=timinato@c-67-171-118-199.hsd1.ut.comcast.net) |
| 14:20.14 | *** mode/#UPHPU [+v timinator] by ChanServ |
| 14:26.45 | *** join/#uphpu herlo (n=clints@166-70-63-209.ip.xmission.com) |
| 14:26.45 | *** mode/#UPHPU [+v herlo] by ChanServ |
| 14:33.02 | *** join/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net) |
| 14:33.02 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 14:38.56 | timinator | Morning ladies |
| 14:39.37 | jsmith | ~lart timinator |
| 14:39.37 | jbot | chops timinator in half with a free Solaris 7 CD |
| 14:39.55 | timinator | ~morning jsmith |
| 14:39.55 | jbot | ACTION bends space and time, trapping jsmith in a universe of eternal monday mornings |
| 14:40.03 | timinator | ~mondays jsmith |
| 14:40.03 | jbot | ACTION says looks like jsmith 's got a case of the Mondays |
| 14:40.19 | jsmith | ~whaleslap timinator |
| 14:40.19 | jbot | ACTION beats timinator upside and over the head with a freakishly huge killer whale named Hugh |
| 14:40.23 | jsmith | ~zap timinator |
| 14:40.24 | jbot | ACTION takes out a cattle prod and gives timinator a good jolt. |
| 14:40.31 | jsmith | ~nuke timinator |
| 14:40.31 | jbot | ACTION prepares 100 missle silos, and targets them at timinator ... B☢☢M! |
| 14:40.33 | timinator | ~slap jsmith |
| 14:40.34 | jbot | ACTION slaps jsmith, keep your grubby fingers to yourself! |
| 14:40.34 | *** join/#uphpu thebigdog (n=bigdog@208.177.146.102.ptr.us.xo.net) |
| 14:40.34 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 14:40.39 | timinator | ~kick jsmith |
| 14:40.40 | jbot | ACTION kicks jsmith |
| 14:40.42 | jsmith | ~wobble timinator |
| 14:40.42 | jbot | ACTION pushes timinator so that he wobbles like file |
| 14:40.45 | jsmith | ~punch timinator |
| 14:40.46 | jbot | ACTION hits timinator like the hot kiss and the end of a wet fist |
| 14:40.50 | timinator | ~lart jsmith |
| 14:40.50 | jbot | throws jsmith's poor little doggy off a cliff |
| 14:40.53 | jsmith | ~uppercut timinator |
| 14:40.58 | jsmith | ~jab timinator |
| 14:40.59 | jbot | ACTION jabs a fork in timinator |
| 14:41.04 | jsmith | Nice one! |
| 14:41.05 | timinator | LOL |
| 14:41.21 | timinator | NOW, BACK TO WORK!!! |
| 14:41.23 | jsmith | Ah, it's a great morning, isn't it? |
| 14:41.29 | timinator | fo sho |
| 14:42.37 | timinator | uurgh |
| 14:44.31 | *** join/#uphpu wps (n=wps@64.0.193.157) |
| 14:44.33 | *** mode/#UPHPU [+o wps] by ChanServ |
| 14:56.19 | *** join/#uphpu fungus (n=olsonl@2001:5c0:8fff:fffe:0:0:0:1647) |
| 14:56.19 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 14:57.27 | *** join/#uphpu thebigdog (n=bigdog@208.177.146.102.ptr.us.xo.net) |
| 14:57.28 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 14:57.45 | thebigdog | how did the meeting go last night? |
| 14:57.56 | *** topic/#UPHPU by thebigdog -> Utah PHP Users Group | uphpu.org |
| 15:05.02 | *** join/#uphpu brast1 (n=brasto@out.lnxi.com) |
| 15:05.02 | *** mode/#UPHPU [+v brast1] by ChanServ |
| 15:17.39 | wps | what's everyone's thoughts on column names in tables? |
| 15:17.54 | wps | I have a coworker that believes that they should be unique cross tables |
| 15:18.05 | wps | ie: no two columns show have the same name in the entire database |
| 15:18.15 | wps | I think that that's nuts |
| 15:19.06 | timinator | that's silly |
| 15:19.47 | timinator | you have to reference the table anyway |
| 15:19.56 | wps | that's what I think |
| 15:19.59 | timinator | (in your SQL) |
| 15:20.06 | wps | table1.id, table1.id |
| 15:20.09 | wps | oops |
| 15:20.12 | wps | table1.id, table2.id |
| 15:20.19 | timinator | then, when in your program, you'll throw stuff into separate arrays anyway |
| 15:20.30 | wps | so there's never confusion on what you're dealing with |
| 15:20.35 | *** join/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 15:20.35 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 15:20.37 | timinator | that is, if you're storing the data for use in the app |
| 15:20.42 | timinator | right |
| 15:20.48 | timinator | I think he's crazy on that one |
| 15:21.21 | thebigdog | we have a defined naming convention |
| 15:21.30 | thebigdog | table_name_column_name |
| 15:21.51 | wps | so if the table is called "users," then you name all columns like this: |
| 15:22.07 | wps | users_id, users_name, users_email, users_favoritecolor |
| 15:22.07 | wps | …? |
| 15:22.09 | thebigdog | yes |
| 15:22.16 | wps | yeah, that's how he wants me to do it |
| 15:22.57 | mgeary | hey folks |
| 15:22.57 | thebigdog | its kinda tedious but it helps out in other areas |
| 15:23.16 | mgeary | now that more of you are online, can you see if you can help me diagnose a really weird problem...? |
| 15:23.23 | thebigdog | but having a naming convention is the way to go |
| 15:23.31 | thebigdog | that way everyone knows how it should be |
| 15:23.51 | thebigdog | doesnt matter what it is as long as everyone agrees and implements it |
| 15:23.52 | mgeary | when i make a request to a certain server (http://www.weblessons.com/discipline.php?id=2), i get aborted output |
| 15:24.12 | wps | you get what? |
| 15:24.13 | mgeary | but when i make the request from *within* the server (ssh), it comes back just fine |
| 15:24.19 | mgeary | wps: try using wget to get that page |
| 15:24.29 | mgeary | hit Ctrl-C after a couple of seconds, 'cause it won't stop |
| 15:24.39 | mgeary | then open the output. it's weird |
| 15:24.54 | wps | worked for me |
| 15:25.07 | wps | that page loads in a browser fine and came down with wget fine |
| 15:25.11 | mgeary | can you view the source? do you see the close </html> tag? |
| 15:25.23 | wps | yes |
| 15:25.26 | mgeary | weeeeird |
| 15:25.33 | mgeary | not me |
| 15:25.36 | mgeary | not jsmith either |
| 15:26.22 | mgeary | apache is sending it off just fine, but somehow the content is getting munged somewhere along the way |
| 15:27.09 | mgeary | how about the rest of you? does anyone get or not get the close </html> tag on that link? |
| 15:27.17 | thebigdog | mgeary, did not work for me |
| 15:27.24 | mgeary | see? |
| 15:27.47 | wps | don't hate me because I download beautifully |
| 15:27.53 | mgeary | wps: and thebigdog: can you guys give me a traceroute dump to weblessons.com? Maybe we can triangulate the cause |
| 15:28.22 | mgeary | (via a pastebin, please) |
| 15:28.54 | wps | http://pastebin.ca/706005 |
| 15:30.26 | thebigdog | http://pastebin.ca/706008 |
| 15:30.46 | mgeary | thanks |
| 15:31.00 | thebigdog | np |
| 15:33.07 | wps | is there a way to clear the terminal screen while in MySQL monitor? |
| 15:33.24 | *** join/#uphpu eco_ (n=eco@gnuk.net) |
| 15:33.25 | wps | in the help notes it states that \c is a "clear command", but it doesn't do anything |
| 15:34.04 | timinator | I can load the page, get content, but the code stops at a </div> |
| 15:34.09 | timinator | no </html> |
| 15:34.18 | orsonj | there appear to be a large number of ^@ in the middle of the file |
| 15:34.32 | mgeary | looks like it's a virus!! |
| 15:35.42 | orsonj | somewhere in the neighborhood of 200,000 |
| 15:35.54 | mgeary | touch 1234 |
| 15:35.55 | mgeary | touch: cannot touch `1234': No such file or directory |
| 15:38.56 | fungus | wps: One benefit of having unique column names is the ability to simplify join conditions using the "USING" clause. |
| 15:41.38 | wps | yeah… I just don't like the table names so long |
| 15:41.46 | wps | s/table/column/ |
| 15:41.58 | wps | especially when they only contain numbers |
| 15:42.04 | wps | makes the column really wide |
| 15:42.13 | wps | for example, my table is called "webinar_assignments" |
| 15:42.16 | fungus | I agree with you, but that is the only argument I could think of for the opposing side. |
| 15:42.20 | wps | yeah |
| 15:42.23 | wps | and it's a weak argument |
| 15:42.30 | fungus | yup |
| 15:42.51 | wps | so, the column name might be "webinar_assignments_primary_author" |
| 15:42.58 | fungus | eek |
| 15:43.04 | wps | right… that's what I'm saying |
| 15:43.11 | *** join/#uphpu _psychic_ (n=_psychic@66.7.114.125) |
| 15:43.11 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 15:43.24 | wps | makes for ugly SQL statements |
| 15:43.40 | *** join/#uphpu cole_joplin (n=cjoplin@gw.helius.com) |
| 15:44.04 | *** join/#uphpu PoeticIntensity (n=jason@12.110.29.162) |
| 15:44.04 | *** mode/#UPHPU [+v PoeticIntensity] by ChanServ |
| 15:45.12 | orsonj | 0000-3EAA is normal html, 03EAB-34AD7 is null bytes, 34AD8-38C3F is normal html, 38C40-547E7 is null bytes, 547E8-66A5E is normal html, 66A5F-75047 is null bytes, 75048-79CBC is normal html and ends the file. |
| 15:45.20 | timinator | I think it's a lousy argument too.... because you HAVE to include the table name w/ the column name EVERY TIME |
| 15:45.31 | timinator | so an INSERT statement looks lousy |
| 15:45.41 | timinator | and single DB queries look lousy |
| 15:45.50 | timinator | and UPDATE statements look lousy |
| 15:45.56 | wps | I also like having the same column name when doing a join |
| 15:46.03 | timinator | and JOIN statements look about the same |
| 15:46.13 | wps | makes it clear that you can matching apple to apple |
| 15:46.20 | timinator | ya |
| 15:46.24 | timinator | I agree |
| 15:46.26 | wps | when table1.id = table2.id |
| 15:46.35 | cole_joplin | I love to use aliases to completely obfisctae what I'm doing |
| 15:46.40 | wps | opposed to… |
| 15:46.47 | wps | when table1.table1_id = table2.table2_id |
| 15:46.51 | timinator | right |
| 15:46.51 | *** join/#uphpu nAmir12 (i=Aviv@gateway/tor/x-b13aa2ed9453f7cf) |
| 15:46.58 | timinator | and I like aliases too |
| 15:47.07 | timinator | so it's t1.id=t2.id |
| 15:47.16 | wps | yeah |
| 15:47.40 | jsmith | Because you usually don't key off of the primary key in both tables |
| 15:48.06 | wps | right… sorry, my example was bad |
| 15:48.13 | timinator | right, but then you're doing t1.id=t2.apple_id |
| 15:51.24 | jsmith | Sure, except I never name a column "id" |
| 15:51.35 | jsmith | It's apple_id or person_id or luser_id |
| 15:51.48 | jsmith | But never just id |
| 15:52.32 | timinator | I use id, but it goes something like this: |
| 15:52.41 | timinator | there's 2 tables, Orders and Items |
| 15:52.56 | unum | employee_index |
| 15:53.02 | timinator | so, orders has `id` `date`..... etc |
| 15:53.04 | unum | I guess there's no reason to spell out index |
| 15:53.11 | mgeary | i use id |
| 15:53.25 | timinator | then the items has `id` `order_id` `prod_id` `price` |
| 15:54.25 | timinator | so, then items.order_id = order.id |
| 16:01.07 | timinator | is that what everyone else does? or am I just weird? |
| 16:05.38 | orsonj | sounds like a good idea to me |
| 16:06.06 | orsonj | I think I do that also. (it's been a while since I've touched the database, been working on other parts.) |
| 16:08.33 | PoeticIntensity | timinator, I do it that way as well. |
| 16:08.47 | PoeticIntensity | I've been in quite the discussions about this very topic with devs who are quite experienced... |
| 16:09.04 | PoeticIntensity | we all seem to do it one of the two ways mentioned. |
| 16:09.30 | PoeticIntensity | either order.id = product.order_id or order.order_id = product.order_id |
| 16:10.07 | orsonj | mgeary: did you take that server down? |
| 16:10.59 | mgeary | orsonj: yeah, it's being upgraded to FC6 |
| 16:11.52 | orsonj | I wondered why it stopped working. I was about to run wireshark while downloading the page again. |
| 16:14.44 | PoeticIntensity | Complete topic change here, but.... Do we have any Porsche fans here? |
| 16:15.19 | timinator | vehicles or drives? |
| 16:15.47 | PoeticIntensity | hehe... vehicles. |
| 16:15.51 | timinator | :) |
| 16:17.16 | PoeticIntensity | anyway... I had a pretty incredible experience yesterday. |
| 16:17.17 | PoeticIntensity | if any of ya are interested, here's a link. |
| 16:17.17 | PoeticIntensity | http://www.ilovemyjournal.com/?action=personal_entry&eid=3244&user=1 |
| 16:23.01 | timinator | that's a great story |
| 16:23.27 | timinator | what type of Mustang do you have? |
| 16:26.34 | wps | Porsches are so ugly |
| 16:26.51 | wps | I don't care how they perform… they look like crap |
| 16:27.07 | mgeary | the boxter convertable is nice |
| 16:27.10 | wps | I'd take a Mustang over that any day (not that I really like Mustangs either) |
| 16:27.17 | wps | I don't like two door cars |
| 16:27.43 | timinator | :) |
| 16:27.46 | wps | Porsches just look like cheap cars |
| 16:27.55 | PoeticIntensity | timinator, 2007 Mustang GT. |
| 16:28.02 | timinator | nice |
| 16:28.08 | wps | their headlights make them look like volkswagon beetles |
| 16:29.00 | timinator | my main client plans on buying a Shelby, removing the Shelby decals, and painting it like a normal Mustang |
| 16:29.24 | wps | why? so he can have the car without people wanting to steal it? |
| 16:29.43 | PoeticIntensity | probably wants to create a "sleeper". |
| 16:30.01 | timinator | no, so people think they are evenly matched... and he can tear them up in a race |
| 16:30.02 | wps | ah… so that he can race people and blow them away :) |
| 16:30.09 | PoeticIntensity | yup. |
| 16:30.10 | wps | that'd be fun |
| 16:30.12 | timinator | yep |
| 16:30.19 | PoeticIntensity | that's precisely why I wanna supercharge mine. |
| 16:30.41 | timinator | the shelby's at 500 HP |
| 16:35.45 | *** join/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net) |
| 16:35.45 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 16:37.18 | *** part/#uphpu cole_joplin (n=cjoplin@gw.helius.com) |
| 16:39.14 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 16:39.14 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 16:42.22 | mgeary | fungus: ping |
| 16:42.46 | fungus | pong |
| 16:42.56 | mgeary | hey, you helped before me with a mysql pipe that took a gzipped file as input. I've got to do that again. Is it something like this: |
| 16:43.08 | mgeary | gunzip -c somefile.gz | mysql -uroot -p databasename |
| 16:43.09 | mgeary | ? |
| 16:43.23 | fungus | That should work. |
| 16:43.44 | fungus | But to make it easier to remember use zcat |
| 16:43.54 | fungus | zcat somefile.gz | mysql dbname |
| 16:44.13 | fungus | zcat is easy to remember cat, but with decompression |
| 16:45.10 | mgeary | nice, gunzip is working |
| 16:45.19 | mgeary | zcat wanted to have a .Z extension on my .gz file for some reason |
| 16:45.44 | mgeary | all i can say is: |
| 16:45.51 | mgeary | daily offsite backups++ |
| 16:45.58 | fungus | hehe, yup |
| 16:59.07 | timinator | what software does everyone use for daily backups |
| 17:01.56 | orsonj | good luck? |
| 17:02.04 | wps | Synk Professional |
| 17:03.33 | beandog | tar :) |
| 17:07.03 | wps | I would just use rsync, but there are some bugs with extended attributes and files with resource forks (namely fonts) |
| 17:07.36 | wps | rsync + launchd would be a nice light solution |
| 17:09.11 | beandog | thebigdog, was that you asking about handbrake? |
| 17:09.27 | mgeary | wps: rsync with the -E |
| 17:09.33 | wps | there are bugs in it |
| 17:09.34 | mgeary | captures the extended stuff |
| 17:09.36 | mgeary | how so? |
| 17:09.37 | _psychic_ | mozy++ |
| 17:09.58 | wps | google it… it is documented all over |
| 17:10.13 | wps | the rsync build that comes with Mac OS has bugs in regards to -E |
| 17:10.34 | wps | really… really… really annoying |
| 17:11.14 | wps | the only files that I have really had issues with are fonts, so it generally isn't a problem (I'm not copying fonts much)… but it's enough that it can't be my only solution |
| 17:11.33 | fungus | rsnapshot |
| 17:11.41 | wps | I do use rysync to sync my home account between my home and work computers daily though (via my iPod) and it works great. |
| 17:11.54 | fungus | wrapper for rsync, but adds snapshot directories to keep old versions around. |
| 17:12.08 | wps | there is a flag for that fungus |
| 17:12.33 | fungus | rsnapshot is a beautiful tool that makes it all so easy. |
| 17:12.40 | wps | I wrote an article about it here: http://mac.byu.edu/2007/04/16/backup-and-archive-with-rsync/ |
| 17:14.45 | fungus | very nice |
| 17:15.46 | wps | how were the cookies last night? |
| 17:23.20 | PoeticIntensity | might be a bit late, but I use rsync as well. |
| 17:23.31 | PoeticIntensity | haven't had a problem since I set it up about 8 months ago. |
| 17:23.59 | brast1 | doh! I must have forgotten to log off at home... |
| 17:25.04 | brasto | there... |
| 17:26.55 | beandog | what do you use to delete old backups / archives |
| 17:27.48 | wps | Synk Professional does it automatically |
| 17:27.49 | brasto | beandog, i use rm |
| 17:27.54 | brasto | :) |
| 17:28.26 | beandog | hmm |
| 17:28.27 | brasto | rm -rf /backup/of/old/not/needed/data |
| 17:28.41 | beandog | I wrote one this morning, Im trying out using find |
| 17:28.43 | wps | but if I was using a rsynk + launchd solution, I would just include that in the script that runs each day and have it purge the old stuff |
| 17:29.03 | beandog | find /backup -type f -ctime 7 -delete |
| 17:29.50 | brasto | beandog, that would delete all files in /backup 7days old? |
| 17:30.04 | beandog | I think, assuming Im using the right -foo time argument |
| 17:34.00 | PoeticIntensity | beandog, I just use a very simple php script run in a cron. |
| 17:34.09 | PoeticIntensity | keeps things nice and tidy. |
| 17:34.48 | *** join/#uphpu synic (n=squish@pdpc/supporter/student/synic) |
| 17:34.48 | *** mode/#UPHPU [+v synic] by ChanServ |
| 17:35.21 | beandog | PoeticIntensity, can I see? |
| 17:35.31 | beandog | i can haz bckup? |
| 17:35.46 | PoeticIntensity | in a bit, sure.... |
| 17:35.53 | PoeticIntensity | I just do a search on filename... |
| 17:36.11 | PoeticIntensity | and delete ones that are too old as per a date variable I set. |
| 17:36.19 | PoeticIntensity | It's really quite unique to my setup. |
| 17:36.26 | PoeticIntensity | it's like.... 15 lines of code. |
| 17:36.47 | beandog | what do you guys do to back up your email |
| 17:36.55 | PoeticIntensity | never delete my inbox. :) |
| 17:36.59 | beandog | huh, that sounds cool |
| 17:54.42 | *** join/#uphpu jbot_ (i=ibot@pdpc/supporter/active/TimRiker/bot/apt) |
| 17:54.42 | *** topic/#uphpu is Utah PHP Users Group | uphpu.org |
| 17:54.42 | *** mode/#UPHPU [+v jbot_] by ChanServ |
| 17:56.44 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 17:56.49 | unum | hmm how do I pass a password to pg_dump from a script |
| 17:57.33 | beandog | usually you can do something like --password=foobar |
| 17:57.41 | beandog | or set it in an env var |
| 17:57.42 | herlo | man pg_dump |
| 17:57.58 | beandog | or rtm :) |
| 17:58.29 | unum | I tried that |
| 17:58.33 | unum | it didn't help |
| 18:00.51 | brasto | beandog, i use another folder to backup my email... |
| 18:01.20 | brasto | i use inbox as a sort of task list, once I do whatever i need to do that the email addresses, it gets deleted or archived. |
| 18:02.58 | *** part/#uphpu brasto (n=brasto@out.lnxi.com) |
| 18:04.31 | *** join/#uphpu bradym (n=bradym@Qst4FC.quinstreet.com) |
| 18:04.31 | *** mode/#UPHPU [+v bradym] by ChanServ |
| 18:33.27 | synic | mindjuju: you around? |
| 18:38.41 | mindjuju | i am now. |
| 18:38.50 | mindjuju | @ synic - i am now |
| 18:39.13 | synic | nevermind.... YOU WERE MUCH TOO SLOW! |
| 18:39.18 | synic | but thanks :) |
| 18:39.25 | mindjuju | that was just 5 minutes ago, wasn't it? |
| 18:39.48 | synic | in emergency situations, you gotta act fast |
| 18:40.37 | *** join/#uphpu brasto (n=brasto@out.lnxi.com) |
| 18:40.37 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 18:50.20 | brasto | ~reboot |
| 18:50.21 | jbot | Not on your life cowboy :(, or are you using Window$? |
| 18:50.46 | brasto | lol, how did i know it would spawn a comment about Windoze |
| 19:10.36 | *** join/#uphpu PoeticIntensity (n=jason@67.137.24.218) |
| 19:10.36 | *** mode/#UPHPU [+v PoeticIntensity] by ChanServ |
| 19:19.59 | *** join/#uphpu gibba (i=gibbagib@209-253-35-21.ip.mcleodusa.net) |
| 20:10.22 | thebigdog | beandog, i was asking about it |
| 20:10.38 | *** join/#uphpu cycokilr (n=cycokilr@66.114.120.2) |
| 20:10.39 | beandog | thebigdog, did you find anything? |
| 20:10.43 | beandog | it looks pretty jacked up |
| 20:10.52 | thebigdog | jacked up? the build process |
| 20:10.57 | beandog | yah |
| 20:11.03 | thebigdog | now i have not looked at it |
| 20:11.11 | thebigdog | i installed it under windows and the interface is nice |
| 20:11.25 | thebigdog | but i guess that's why it is not an ebuild |
| 20:11.54 | thebigdog | anyone use a serial connection to ethernet device with hosted servers? |
| 20:12.57 | wps | you can use the syntax "alter table users ADD COLUMN company varchar(100) AFTER anothercolumn;" to add a new column to a table after another column |
| 20:13.08 | wps | can you add a new column BEFORE a column? |
| 20:13.20 | wps | I tried replacing "after" with "before" and got an error |
| 20:13.28 | beandog | sure, just add it after the one you want. :) |
| 20:13.29 | beandog | ;) |
| 20:13.39 | thebigdog | heeh |
| 20:13.51 | beandog | The only alternative would be you want it the first column |
| 20:13.54 | beandog | where the syntax would be different. |
| 20:14.00 | wps | right |
| 20:14.07 | wps | I want to create a new column and want it to be first |
| 20:14.17 | beandog | dunno, ask pma |
| 20:14.23 | beandog | its probably FIRST or something |
| 20:14.32 | wps | who is pma? |
| 20:14.39 | _psychic_ | php my admin |
| 20:14.40 | beandog | phpmyadmin |
| 20:15.24 | wps | it was first |
| 20:15.26 | wps | thanks |
| 20:16.05 | mindjuju | ~flip jerks at work |
| 20:16.06 | jbot | ACTION gives jerks at work the .|.. ..|. |
| 20:16.14 | thebigdog | yeah |
| 20:16.18 | thebigdog | ~flip eveyone |
| 20:16.18 | jbot | ACTION gives eveyone the .|.. ..|. |
| 20:16.30 | thebigdog | ~stroke the world |
| 20:16.43 | wps | uh… |
| 20:16.50 | beandog | ~rawk thebigdog |
| 20:16.54 | wps | I don't want to be stroked |
| 20:17.48 | mindjuju | that cumbia song is the best |
| 20:17.57 | thebigdog | it is really good |
| 20:18.08 | thebigdog | the have a killer song on their new album too |
| 20:19.00 | mgeary | my little boy is awfully cute when he signs |
| 20:19.03 | timinator | just for you thebigdog |
| 20:19.08 | mgeary | he's 21 months |
| 20:19.09 | timinator | LOL |
| 20:19.10 | thebigdog | ~filp timinator |
| 20:19.28 | mgeary | "treat" is a finger poking your cheek |
| 20:19.33 | timinator | ~flip back to thebigdog |
| 20:19.34 | jbot | ACTION gives back to thebigdog the .|.. ..|. |
| 20:19.37 | mgeary | but his "milk" is the best |
| 20:19.49 | mindjuju | too bad jbot doesn't have audio... it should make a "nya nya" sound when doing the flip |
| 20:19.54 | mindjuju | ~flip coworkers |
| 20:19.54 | jbot | ACTION gives coworkers the .|.. ..|. |
| 20:20.48 | thebigdog | i think we all need to take a road trip to mexico |
| 20:23.35 | thebigdog | ~slap mindjuju |
| 20:23.36 | jbot | ACTION slaps mindjuju, keep your grubby fingers to yourself! |
| 20:23.38 | mindjuju | yipes! |
| 20:23.59 | mindjuju | ~nosepick thebigdog |
| 20:24.00 | jbot | ACTION plucks thebigdog out of the nose of humanity and wipes him on the couch! |
| 20:24.13 | thebigdog | ~whalefart mindjuju |
| 20:24.26 | thebigdog | for timinator |
| 20:24.40 | thebigdog | mindjuju, you get my pm |
| 20:26.49 | thebigdog | timinator, you have the whole album? |
| 20:29.04 | theblingking | oh that is a great song |
| 20:29.19 | theblingking | oh yeah...let me bring some old school |
| 20:37.02 | theblingking | she makes a man want to speak spanish |
| 20:37.16 | theblingking | ....aye...aye...aye...ojo...e |
| 20:37.35 | beandog | heh |
| 20:37.37 | beandog | ojo |
| 20:38.02 | theblingking | or the texmex equivalent = watchale |
| 20:39.22 | theblingking | the next song is for mindjuju |
| 20:39.37 | theblingking | that is my techno |
| 20:42.40 | mindjuju | nice! |
| 20:43.19 | theblingking | oh yeah |
| 20:43.45 | theblingking | here comes next song |
| 20:44.04 | theblingking | ~jump theblingking |
| 20:44.04 | jbot | ACTION scrambles up the nearest tree, screams, then leaps feet first on top of theblingking |
| 20:44.16 | theblingking | ~jump theblingking |
| 20:44.16 | jbot | ACTION scrambles up the nearest tree, screams, then leaps feet first on top of theblingking |
| 20:44.40 | orsonj | http://picasaweb.google.com/orsonj/Other/photo#5112760232833585394 |
| 20:44.58 | orsonj | Picture of a 3x5 card with "You Are The Man" written on it. |
| 20:45.06 | theblingking | orsonj, that rocks bro |
| 20:45.14 | orsonj | I was allowed a 3x5 card for one of my tests |
| 20:45.28 | mindjuju | nothing like a little bit of confidence |
| 20:45.31 | orsonj | However, I was quite confident in my knowledge of the test subject, so I used that. |
| 20:45.57 | theblingking | ~jump everybody |
| 20:45.57 | jbot | ACTION scrambles up the nearest tree, screams, then leaps feet first on top of everybody |
| 20:46.58 | theblingking | oh here we go |
| 20:47.36 | jsmith | "This one year, in band camp..." |
| 20:47.49 | timinator | LOL |
| 20:48.53 | herlo | jsmith: you drink? |
| 20:49.06 | theblingking | hehe |
| 20:49.12 | theblingking | part of the story |
| 20:49.21 | jsmith | herlo: Nope... hence the reason it was flat |
| 20:49.28 | theblingking | heeh |
| 20:49.33 | herlo | jsmith: a shame, quite a waste of beer |
| 20:49.51 | theblingking | ~wake mindjuju |
| 20:49.51 | jbot | ACTION throws a barrel-full of ice water on mindjuju and shouts "GOOD MORNING!!!!" |
| 20:52.25 | theblingking | oh yeah....next song...next song |
| 20:52.34 | mindjuju | dag! i missed Paul Revere |
| 20:52.35 | timinator | ~poo thebigdog |
| 20:52.36 | jbot | ACTION summons a troop of flying monkeys to fling their poo at thebigdog |
| 20:52.44 | theblingking | mindjuju, where you at |
| 20:52.52 | theblingking | i had to go to timinator on that song |
| 20:52.56 | herlo | ~poop timinator |
| 20:53.05 | mindjuju | dude, let ya down |
| 20:53.11 | herlo | ~whalepoo timinator |
| 20:53.18 | herlo | ~whalepoop timinator |
| 20:53.19 | jbot | ACTION catapults a truckload of whale poop from a freakishly large killer whale named Hugh at timinator |
| 20:53.25 | herlo | geez, no consistency |
| 20:53.48 | theblingking | almost done with the session mindjuju |
| 20:54.11 | theblingking | oh the next 2 songs are going to rock |
| 20:54.21 | mindjuju | man, i gots to head down to orem today @4p and i can't even go to Tucano's afterwards |
| 20:54.30 | theblingking | oh that sucks |
| 20:54.33 | mindjuju | what the point of Orem if you can't go to tucano's? |
| 20:54.34 | herlo | mindjuju: no tucanos!? |
| 20:54.41 | jsmith | Mmmmn... the meat hut |
| 20:54.48 | herlo | mindjuju: I'll be there about 8pm if you wanna hang out! |
| 20:54.56 | herlo | we could go to tucanos! |
| 20:55.11 | mindjuju | yeah, like it's my father-in-law 's bday, he's going to Sizzler... |
| 20:55.22 | theblingking | ouch that sucks |
| 20:55.25 | herlo | what!? sizzler sucks. Just don't eat any |
| 20:55.30 | herlo | then go afterward... |
| 20:55.37 | herlo | to TUCANO'S! |
| 20:55.55 | theblingking | ~fart mindjuju |
| 20:55.56 | jbot | ACTION farts in mindjuju's general direction |
| 20:56.04 | theblingking | that will drop ya today |
| 20:56.16 | theblingking | oh yeah |
| 20:56.21 | herlo | mindjuju: and the epiphany? |
| 20:56.34 | mindjuju | UPHPU GeekLunch Special Saturday - Tucano's |
| 20:56.47 | mindjuju | it'll be Saturday so everybody can come |
| 20:56.49 | herlo | mindjuju: next Saturday? |
| 20:56.50 | theblingking | ~congratulate theblingking |
| 20:56.51 | jbot | ACTION congratulates theblingking on being a new owner of a $500 brick. |
| 20:57.03 | herlo | the Ubuntu-Utah BBQ is this weekend |
| 20:57.09 | theblingking | well today it has been offically 11yrs since the mission |
| 20:58.39 | mindjuju | ~wake everybody |
| 20:58.39 | jbot | ACTION throws a barrel-full of ice water on everybody and shouts "GOOD MORNING!!!!" |
| 20:58.58 | mindjuju | How about October 6 or the 13th? |
| 20:59.20 | mindjuju | theblingking, how often do you make it down to orem? |
| 20:59.36 | PoeticIntensity | I'm down with jammin' at the meat hut. |
| 20:59.51 | mindjuju | PI, what day you think, the 6 or 13th ? |
| 21:00.09 | herlo | mindjuju: can't on the 13th, and I am going camping on the 6th |
| 21:00.21 | herlo | mindjuju: Sept 29 |
| 21:00.28 | PoeticIntensity | hrm.... |
| 21:00.36 | mindjuju | that's next saturday |
| 21:00.41 | herlo | mindjuju: also The 6th is Conference Weekend |
| 21:00.46 | herlo | mindjuju: yeah! |
| 21:00.46 | mindjuju | <PROTECTED> |
| 21:00.57 | herlo | mindjuju: why? We do geek lunches with like one day's notice |
| 21:01.00 | PoeticIntensity | well... the 6th is Conference, so some people will be attending the 6:00 session. |
| 21:01.07 | PoeticIntensity | the 13th would be best for me. |
| 21:01.47 | mindjuju | so what about Sept 29 or Oct 20 ? |
| 21:01.59 | herlo | mindjuju: sept 29 |
| 21:02.10 | herlo | mindjuju: read your pms from me, IYDM |
| 21:02.14 | herlo | its related... |
| 21:02.45 | herlo | Oct 20 seems *so* far away, but I'd be up for then too... |
| 21:03.52 | herlo | gotta run to the airport. See you soon. |
| 21:03.57 | mindjuju | c ya |
| 21:04.38 | mindjuju | in order to con the likes of the northern boys like timinator or theblingking or tierra or drip to come down, we'd have to do more than lunch |
| 21:04.42 | mindjuju | what about a movie and lunch |
| 21:04.50 | mindjuju | seems like there is a theater right there, isn't there? |
| 21:05.04 | mindjuju | or maybe a lan party |
| 21:06.35 | mindjuju | theblingking what would it take to get you down to orem on a saturday? |
| 21:06.46 | theblingking | something for the family |
| 21:06.59 | theblingking | i would have to bring the little ones |
| 21:07.07 | mindjuju | it's been more than a year since we did the family Goodwood thing |
| 21:07.13 | theblingking | yeah |
| 21:07.19 | theblingking | i would come if we did something |
| 21:07.19 | mindjuju | we could make it family friendly |
| 21:07.25 | theblingking | yeah |
| 21:07.38 | theblingking | then after i would go visit my grandma |
| 21:07.45 | orsonj | sounds fun |
| 21:07.47 | theblingking | so it would give me a reason to go there |
| 21:07.54 | mindjuju | so what day do you think? |
| 21:08.09 | theblingking | i would do it |
| 21:08.19 | mindjuju | Sept 29 or Oct 20 |
| 21:08.27 | theblingking | oct 20 for me |
| 21:08.40 | theblingking | sept 29 i have stuff planned |
| 21:08.42 | mindjuju | mgeary, there could be A LOT of people |
| 21:09.05 | mgeary | but a not-huge bbq |
| 21:09.11 | mindjuju | just as an example, when we did goodwood, if i recall there were 35 total |
| 21:09.20 | mindjuju | geeks, geek spouse and children |
| 21:09.32 | mindjuju | way good time, but lots, and if we do in Orem, could be more attending |
| 21:10.13 | mindjuju | i'm liking Oct 20 more, that give everybody time to plan for it |
| 21:10.50 | mindjuju | course though, mgeary, if we brought out a couple of grills, we could prolly do it at your place |
| 21:11.02 | mindjuju | but would hate to see the carpet afterwards |
| 21:11.06 | mindjuju | assuming yo uhave carpet |
| 21:11.10 | mgeary | *outside* |
| 21:11.26 | mgeary | otoh, parks are nice... ;) |
| 21:11.36 | mindjuju | true that |
| 21:12.00 | mindjuju | i think there is enough critical mass to take this to the mailing list where we can have everybody suggest ideas and do something fun |
| 21:12.00 | theblingking | a park would be great for the kiddies |
| 21:12.05 | theblingking | as long as it was a good day |
| 21:13.05 | mindjuju | yeah, true that -- weather wise |
| 21:13.13 | jnbek | there's Wilderness Park in Provo, on 500N |
| 21:13.31 | jnbek | by the river, nice clean park, with grills if memory serves |
| 21:13.46 | mindjuju | yeah, but that takes us away from tucanos |
| 21:13.48 | mindjuju | :( |
| 21:14.01 | mindjuju | and applewood bacon wrapped turkey |
| 21:14.07 | mindjuju | garlic sirloin |
| 21:14.23 | mindjuju | and all the other fun things |
| 21:14.34 | jnbek | ugh, you just made me hungry again :-P |
| 21:15.08 | mindjuju | and lunch is cheaper, not sure if it is that way on weekends though |
| 21:15.53 | jnbek | probably not, but i don't know for a fact |
| 21:21.56 | theblingking | anyone use a digi device? |
| 21:24.47 | mindjuju | sorry, i don't |
| 21:25.48 | mindjuju | k, email sent |
| 21:25.53 | mindjuju | i think this will be good |
| 21:26.16 | theblingking | i guess no one here uses one |
| 21:26.55 | mindjuju | k, so for those that don't know, what is a digi device, besides something they use in digimon |
| 21:29.19 | theblingking | serial to ethernet device |
| 21:29.56 | mindjuju | oh, never knew what that was called |
| 21:29.56 | theblingking | for example i can hook them up to routers, switches, computers to give me full terminal access |
| 21:30.04 | beandog | mm |
| 21:30.07 | beandog | that would be cool. |
| 21:30.09 | theblingking | digi is the company |
| 21:30.31 | theblingking | rocks with solaris when you have to mess with proms |
| 21:30.44 | theblingking | or you get issues when booting up a box |
| 21:31.19 | theblingking | you ssh into the digi box and then it puts you on the serial connector |
| 21:32.45 | theblingking | they also make another box that you can run all your rj-45 management connections to |
| 21:33.08 | theblingking | and access that box for them all |
| 21:33.11 | theblingking | really nice stuff |
| 21:33.35 | theblingking | ive used it with routers and solaris alot |
| 21:34.15 | theblingking | they have a usb one now |
| 21:34.51 | theblingking | i think xmission uses the power management ones |
| 21:37.23 | theblingking | oh man they dont support gig networks |
| 21:38.05 | *** join/#uphpu cole_joplin (n=cjoplin@gw.helius.com) |
| 21:38.23 | fungus | There are lots of other companies that make Terminal Servers, or Communications Servers. |
| 21:38.59 | fungus | They are great for providing easy access to serial devices (servers, routers, switches, ups, etc) |
| 21:39.08 | fungus | I have one on my desk right now. |
| 21:39.44 | fungus | most don't support ssh, and only telnet though... |
| 21:39.58 | theblingking | eyah or rlogin or radius |
| 21:45.15 | mindjuju | that is a good tune! |
| 21:45.20 | mindjuju | i don't think i have that one here at work |
| 21:45.26 | fungus | Anyone have any tips on negotiating salary with a prospective employer? |
| 21:46.01 | PoeticIntensity | something to remember, fungus, is sometimes when they don't negotiate salary, they will negotiate vacation time... |
| 21:46.15 | mgeary | fungus: always make them name the salary |
| 21:46.25 | wps | the problem is that vacation doesn't pay bills |
| 21:46.30 | mgeary | go ahead and tell them your salary history, but make them name the actual offer |
| 21:46.31 | fungus | They did name it, but it isn't as much as I wanted. |
| 21:46.32 | PoeticIntensity | As far as I'm concerned, I just ask for what I think I'm worth..... what will make (keep) me happy for the next few years. |
| 21:46.50 | mgeary | fungus: does the offer represent a reasonable increase from your last documented salary? |
| 21:47.04 | fungus | No, it's about the same is all. |
| 21:47.18 | mindjuju | will you be doing something you enjoy more? |
| 21:47.19 | mgeary | well, the you tell them, "i'd like to feel like i'm moving forward" |
| 21:47.38 | mindjuju | mgeary, that's awesome, i like that |
| 21:47.45 | fungus | It is more fun, but I would still like more. |
| 21:47.58 | mindjuju | yeah, i like mgeary's line right there |
| 21:48.04 | mindjuju | <PROTECTED> |
| 21:48.04 | fungus | I just need some strategy to know how to ask. |
| 21:48.08 | PoeticIntensity | TBH, working for less than what I'm worth has added to some of the most dreary years of my life. |
| 21:48.13 | fungus | Yeah, I do like that, thanks mgeary |
| 21:48.38 | PoeticIntensity | but, then again.... I'm not a person who is satisfied with the hum-drum.... |
| 21:48.46 | PoeticIntensity | which can be both good and..... bad..... |
| 21:48.51 | mgeary | no employer would expect you to come on at a lower (or really even the same) salary as your last job unless you left under bad circumstances |
| 21:48.58 | mindjuju | you know who has good salary negotiating skills is cole_joplin |
| 21:49.10 | mgeary | assuming you were at your last job for at least a year or so |
| 21:49.10 | cole_joplin | it's a lie |
| 21:49.30 | mindjuju | cole, fungus has an opportunity and they aren't paying what the opportunity should |
| 21:49.32 | fungus | lol. I am too timid sometimes to ask for money. |
| 21:49.37 | cole_joplin | I'm making $4.25 an hour now |
| 21:49.39 | mindjuju | he likes the possiblity, but needs more |
| 21:50.02 | cole_joplin | just my experience, but say no |
| 21:50.07 | mindjuju | one thing cole has said, that i liked is that |
| 21:50.15 | theblingking | just tell them that you expected more from the offer |
| 21:50.16 | cole_joplin | I have turned down more than I have acepted |
| 21:50.19 | fungus | I know there is an opportunity to negotiate though. |
| 21:50.37 | theblingking | all companies are going to low ball first |
| 21:50.38 | mindjuju | they'll make more in the saving by hiring a person of your caliber and they need to compensate appropriately |
| 21:50.41 | cole_joplin | first, you must decide your bottom number BEFORE you do anything |
| 21:50.47 | theblingking | if they want you they will come up |
| 21:50.50 | mindjuju | how is it you say it cole? |
| 21:50.57 | cole_joplin | It's not about them, as much as about you |
| 21:51.06 | cole_joplin | if you are not happy, it doesn't matter |
| 21:51.10 | mindjuju | i'm the guy they hire when they need to fix the code written by the cheaper guy |
| 21:51.12 | mindjuju | something like that |
| 21:51.15 | cole_joplin | unhappy workers don't work well |
| 21:51.22 | fungus | Ok, so it's normal for them to low-ball. Ok. I won't feel so bad. |
| 21:51.22 | theblingking | exactly |
| 21:51.40 | theblingking | i have laughed at people before for the low ball offer |
| 21:51.46 | fungus | It would be a very cool job. Lots of fun, good atmosphere. |
| 21:51.50 | cole_joplin | so, get your number, stick to it, never go below your bottom |
| 21:51.55 | theblingking | but again it is all about you |
| 21:51.59 | theblingking | will you be happy or not |
| 21:52.09 | mindjuju | march in there and say, your puny offer has giving me much opportunity to laugh! The Fungus, will need 10k more to be appeased! |
| 21:52.21 | fungus | LOL |
| 21:52.32 | theblingking | i can negotiate too |
| 21:52.32 | cole_joplin | ok, are you negotiating with your current employer? |
| 21:52.41 | fungus | No , new employer |
| 21:53.04 | theblingking | i think you should barter with them |
| 21:53.07 | theblingking | bartering rocks |
| 21:53.17 | theblingking | i need a car...house....and....uh.... |
| 21:53.20 | cole_joplin | If it is low, thank them, tell them your financial needs are greater than what they can offer. |
| 21:53.43 | cole_joplin | You wish them well, and in the future if their business is more profitable, please call back. |
| 21:53.46 | fungus | I did tell them it was kind of low, but they immediately jumped in and said it was negotiable. |
| 21:53.56 | cole_joplin | That's bad |
| 21:54.02 | cole_joplin | A very bad sign |
| 21:54.02 | theblingking | hehe |
| 21:54.05 | timinator | Look, I'm a bad a** M***** F***er! You add another digit to your offer, then we'll talk! |
| 21:54.17 | timinator | I've found that line works well |
| 21:54.17 | cole_joplin | First, never use the word "low" or "cheap" |
| 21:54.18 | theblingking | that is how i do it |
| 21:54.19 | mindjuju | true that timinator |
| 21:54.21 | timinator | :) |
| 21:54.25 | cole_joplin | Just thank them for their time |
| 21:54.31 | cole_joplin | They'll figure it out |
| 21:54.34 | timinator | and, thank you for your time |
| 21:54.37 | cole_joplin | I would definitely say no |
| 21:54.46 | cole_joplin | But always leave it in their court |
| 21:54.54 | timinator | that's why I don't work for you :) |
| 21:54.54 | theblingking | i tell them i am theblingking and im worth more |
| 21:54.59 | cole_joplin | The fact is they are too low, end of discussion, their turn |
| 21:55.19 | cole_joplin | Of course, I sart with my asking price, and I have room to negotiate |
| 21:55.30 | cole_joplin | Insurance, stock, bonus expectations... |
| 21:55.39 | fungus | Ok, I think I can do it. Just ask for more. |
| 21:55.40 | theblingking | man if they dont start with 90k then im done |
| 21:55.41 | theblingking | :) |
| 21:55.50 | cole_joplin | But if the salary is low from the get-go, it has to be no |
| 21:56.09 | theblingking | and sometimes you have to ask why they are low too |
| 21:56.12 | cole_joplin | Don't "ask for more", you "Name your requirements" |
| 21:56.12 | theblingking | that is a sign as well |
| 21:56.24 | cole_joplin | I don't care WHY they are low |
| 21:56.30 | cole_joplin | That's their problem |
| 21:56.41 | cole_joplin | I don't want to insult anyone |
| 21:56.48 | timinator | yes.... I'm being serious here..... Start w/ the high offer, then as you pull $$ off, put on non-cash compensation |
| 21:56.51 | cole_joplin | Many are good at getting low wages |
| 21:56.58 | theblingking | no but you need to understand their financial situation too |
| 21:57.00 | cole_joplin | and that's more important than skill |
| 21:57.28 | fungus | So I should start high myself then... ok. |
| 21:57.38 | cole_joplin | True, I have found that the hardest, cheap negotiators are often the hardest, least fun, to work for |
| 21:57.39 | PoeticIntensity | I have a pgsql question when someone can squeak in a couple of cycles for it... :) |
| 21:57.49 | theblingking | hehe |
| 21:57.54 | PoeticIntensity | ;-) |
| 21:58.02 | cole_joplin | You should know what you are worth, what the market it, and whot you require |
| 21:58.07 | PoeticIntensity | can pgsql handle functions in the WHERE clause? |
| 21:58.11 | cole_joplin | what you need to live |
| 21:58.24 | cole_joplin | Their budget is immaterial |
| 21:58.25 | timinator | right.... if they're looking for a cheap guy, they will have to deal w/ cheap quality |
| 21:58.30 | timinator | you're not cheap |
| 21:58.34 | fungus | What I *need* and what I am worth are very different. |
| 21:58.36 | timinator | on quality or compensation |
| 21:58.45 | theblingking | timinator, is cheap |
| 21:58.49 | timinator | yes |
| 21:58.51 | cole_joplin | You need what you need. |
| 21:59.09 | cole_joplin | Whichever is higher, that's your number |
| 21:59.17 | fungus | I am a cheep person myself. I am making more now than I really need, but that doesn't mean I don't want more. |
| 21:59.22 | cole_joplin | It's not negotiable if it's your bottom |
| 21:59.25 | theblingking | PoeticIntensity, example plz? |
| 21:59.33 | cole_joplin | What is your number, btw? |
| 21:59.46 | PoeticIntensity | lemme work at it a bit so I can ask an intelligent question... But thanks, theblingking |
| 21:59.53 | theblingking | np |
| 22:00.00 | PoeticIntensity | I'll most likely have a question regarding indexing and functions.... |
| 22:00.04 | theblingking | 90k for the timinator |
| 22:00.04 | PoeticIntensity | but not quite... :) |
| 22:00.06 | fungus | My *need* number is probably only about 30k |
| 22:00.08 | cole_joplin | While he thinks os a number, you guys need to stand up for yourselves and make more money |
| 22:00.23 | cole_joplin | fungus...you make me laugh |
| 22:00.25 | theblingking | dude fungus...you need more money |
| 22:00.30 | theblingking | 50k is a minium for ya |
| 22:00.35 | cole_joplin | I wouldn't sweep their parking lot for 30l |
| 22:00.35 | mindjuju | fungus, don't forget to refer to yourself in the 3rd person when negotiating, and rub your chin while considering |
| 22:00.36 | fungus | My *want* number is probably about 60k |
| 22:00.38 | theblingking | i would even say 60k |
| 22:00.48 | theblingking | yeah minium |
| 22:00.58 | cole_joplin | What was the offer? |
| 22:01.08 | beandog | 15k and all the donuts he can eat |
| 22:01.12 | fungus | Inital offer only 45 |
| 22:01.14 | theblingking | hehe |
| 22:01.27 | cole_joplin | What are you making now? |
| 22:01.35 | fungus | 50 |
| 22:02.07 | cole_joplin | Anything less than 55 for you is a waste of time |
| 22:02.19 | timinator | for what? network admin? PHP? |
| 22:02.42 | cole_joplin | If they want 45, you need a guaranteed 10k bonus just to talk |
| 22:02.56 | timinator | I agree |
| 22:03.02 | cole_joplin | Your number should be 65 |
| 22:03.07 | cole_joplin | you'll take 55 |
| 22:03.11 | theblingking | timinator, agrees with everyone |
| 22:03.13 | timinator | right |
| 22:03.14 | cole_joplin | anything else is a no thanks |
| 22:03.19 | theblingking | timinator = non confrontational |
| 22:03.37 | fungus | For Xmission... that means sysadmin, netadmin, everything really. |
| 22:03.43 | timinator | no sir.... I confront frequently.... but I choose my battles |
| 22:03.46 | cole_joplin | For 10k, I'll confront, and I'll back it up with my work |
| 22:03.54 | timinator | and in here, I'm w/ like minded people |
| 22:04.07 | theblingking | hehe |
| 22:04.29 | theblingking | i told my employeer i wanted a coke machine |
| 22:04.37 | timinator | LOL |
| 22:05.03 | theblingking | timinator, laugh it up...but when i show you my coke machine...no laughing will be heard |
| 22:05.12 | timinator | true that |
| 22:05.14 | cole_joplin | so, fungus, we've talked about this, right? |
| 22:05.29 | PoeticIntensity | :) |
| 22:05.36 | fungus | Yup, thanks to everyone, especially cole_joplin and theblingking |
| 22:05.37 | theblingking | i have 6 flavors |
| 22:05.48 | PoeticIntensity | I believe I have 12. |
| 22:05.59 | PoeticIntensity | behind his SQL. |
| 22:05.59 | timinator | WHAT?!?! My help wasn't benificial?? |
| 22:06.09 | timinator | ~slap fungus |
| 22:06.09 | jbot | ACTION slaps fungus, keep your grubby fingers to yourself! |
| 22:06.13 | theblingking | no...cause you agree too much |
| 22:06.25 | timinator | kiss my butt theblingking |
| 22:06.30 | PoeticIntensity | ROFL |
| 22:06.46 | theblingking | ~pimpslap timinator |
| 22:06.46 | jbot | theblingking pimpslaps timinator. ouch! |
| 22:06.47 | cole_joplin | Just for some inspiration, I had a guy who worked for me who was making 32, he left for a job doing 35, and 2 months later, he just accepted an offer at 50. True story. |
| 22:06.47 | timinator | there we go |
| 22:07.04 | cole_joplin | Just happened 2 weeks ago |
| 22:07.12 | mindjuju | i'm not a big fan though of j umpping that fast |
| 22:07.13 | theblingking | that is crazy |
| 22:07.19 | mindjuju | you gots to have some loyality to somebody |
| 22:07.22 | theblingking | i would skipped the middle one |
| 22:07.30 | PoeticIntensity | mindjuju, I gots loyalty to people who are loyal to me. |
| 22:07.34 | PoeticIntensity | truth be told. |
| 22:07.36 | theblingking | loyality is over rated in IT |
| 22:07.43 | PoeticIntensity | most companies couldn't care less about their IT employees. |
| 22:07.44 | cole_joplin | 18k increase buys a lot of loyalty over a 3k increase |
| 22:08.32 | timinator | I agree, unfortunately.... IT is considered a commodity |
| 22:08.43 | theblingking | depends on that |
| 22:08.44 | timinator | that's why I started my own gig |
| 22:08.55 | theblingking | i know companies that will shell out $$$$ for the right person |
| 22:09.07 | timinator | ya, but that's not the norm |
| 22:09.08 | PoeticIntensity | but I can say this: When you *do* find a company who is loyal to you, grab on to em' as if they were gold. |
| 22:09.15 | timinator | yes |
| 22:09.24 | theblingking | my company is good here |
| 22:09.25 | timinator | :) |
| 22:09.32 | PoeticIntensity | (mine too, finally)... |
| 22:09.38 | PoeticIntensity | after 3 years of bouncing. |
| 22:09.40 | cole_joplin | Mine too |
| 22:09.48 | theblingking | i do find that i tend to work for companies that i have friends already working there |
| 22:10.19 | cole_joplin | Do you do rap videos or something? |
| 22:10.20 | PoeticIntensity | the last couple of jobs I had were from Monster or UPHPU... |
| 22:10.20 | theblingking | my last 4 jobs have been friend referral jobs |
| 22:10.47 | theblingking | cole_joplin, i do have a rap song; mindjuju queue it up bro |
| 22:10.58 | timinator | that's the way to go though.... through a referral |
| 22:11.08 | theblingking | northrop grumman has over 48% referrel employees |
| 22:11.21 | mindjuju | or better yet, My Posse on Broadway so we can spin it old sk00l |
| 22:11.38 | timinator | I was part of that % |
| 22:12.09 | theblingking | the referral bonus was killer |
| 22:12.10 | cole_joplin | Marvin Gaye - I Heard It Through the Grapevine |
| 22:12.26 | theblingking | this is more like it |
| 22:12.36 | fungus | Tina Turner - Better Be Good To Me |
| 22:12.44 | mindjuju | ya'll need to play this -- http://www.youtube.com/watch?v=ceOZrm4IWR0 |
| 22:12.49 | timinator | ummm.... those aren't rap |
| 22:13.01 | theblingking | that is fungus' theme song |
| 22:13.20 | fungus | lol |
| 22:13.43 | timinator | mindjuju: LOL |
| 22:13.52 | mindjuju | aaaaaaaahhhh YEAH! |
| 22:13.53 | theblingking | hehe...has a wow feel |
| 22:14.21 | mindjuju | we should make a geekVideo on this song |
| 22:14.33 | mindjuju | theblingking could be mix-a-lot |
| 22:14.46 | mindjuju | we could use PI 's car |
| 22:14.48 | theblingking | kill -9 mf |
| 22:14.59 | PoeticIntensity | mindjuju, hehe... |
| 22:15.53 | theblingking | anyone heard the kill -9 rap |
| 22:15.59 | theblingking | that is wicked funny |
| 22:15.59 | mindjuju | haven't |
| 22:18.21 | *** join/#uphpu fungus (n=olsonl@2001:5c0:8fff:fffe:0:0:0:1647) |
| 22:18.21 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 22:18.55 | theblingking | www.youtube.com/watch?v=Fow7iUaKrq4 |
| 22:19.04 | theblingking | warning |
| 22:19.47 | beandog | extra bling? |
| 22:21.34 | PoeticIntensity | ya know... sql blows me away sometimes. |
| 22:21.45 | PoeticIntensity | theblingking, I answered my own question... |
| 22:22.09 | theblingking | k |
| 22:22.31 | theblingking | mindjuju, did you watch that |
| 22:22.58 | mindjuju | watching now |
| 22:23.01 | mindjuju | it's hilarious |
| 22:23.02 | timinator | here's a funny/weird one: http://youtube.com/watch?v=CThX9iF97kE |
| 22:23.14 | timinator | they're all friends of mine though |
| 22:23.26 | timinator | the "bald monkey" is my main client |
| 22:23.31 | timinator | :) |
| 22:23.45 | theblingking | timinator that did not read very good |
| 22:23.55 | beandog | wtc |
| 22:23.55 | theblingking | the bald monkey...hehe |
| 22:23.58 | timinator | I know.... LOL |
| 22:24.01 | timinator | watch it |
| 22:24.18 | beandog | another reason not to click on random youtube links :) |
| 22:24.23 | theblingking | i cant watch utube here |
| 22:24.37 | theblingking | i got banned from utube |
| 22:24.37 | beandog | ha ha |
| 22:24.39 | beandog | oh? |
| 22:24.42 | timinator | and you consider your company a "good"company? |
| 22:24.53 | beandog | well maybe hes the only one baninated. |
| 22:25.03 | beandog | or it was part of his coke machine concession |
| 22:25.18 | timinator | perhaps |
| 22:25.44 | beandog | ~proxy theblingking |
| 22:26.09 | PoeticIntensity | okay.... Does anyone here know of a good tutorial on "good indexing techniques" for pgsql? |
| 22:26.23 | mindjuju | that's funny timinator |
| 22:26.23 | PoeticIntensity | It seems like any semi-advanced query I run does "seq scan" on pretty much everything. |
| 22:26.35 | timinator | isn't it? |
| 22:26.37 | beandog | seq scan would be looking at the pkeys |
| 22:26.44 | PoeticIntensity | really? |
| 22:26.44 | timinator | the monkey is my main client |
| 22:26.51 | beandog | PoeticIntensity, yah, sequences == pkeys |
| 22:27.03 | timinator | the plumber is his fiance |
| 22:27.03 | PoeticIntensity | I thought that was "sequential scan"........... OH! |
| 22:27.07 | PoeticIntensity | thanks, beandog . |
| 22:27.08 | PoeticIntensity | :) |
| 22:27.13 | timinator | all the rest are their kids |
| 22:27.16 | PoeticIntensity | so that's .... good... right? |
| 22:27.24 | beandog | well, normal :) |
| 22:27.26 | PoeticIntensity | is that faster than an index? |
| 22:27.39 | PoeticIntensity | well.. the pkey *is* an index... |
| 22:27.40 | PoeticIntensity | so.. |
| 22:27.43 | PoeticIntensity | probably the same. |
| 22:27.52 | beandog | actually, a pkey just creates a sequential index |
| 22:27.55 | beandog | there isn't really a "pkey" |
| 22:28.08 | PoeticIntensity | you're confusing me. |
| 22:28.09 | beandog | its kind of a ... whats the word |
| 22:28.26 | beandog | Ok |
| 22:28.29 | PoeticIntensity | a primary key is nothing more than setting a unique index based on the primary key... |
| 22:28.31 | PoeticIntensity | right? |
| 22:28.32 | beandog | On MySQL a column index is flagged as a pkey |
| 22:28.43 | beandog | on postgres, a pkey is a combination of actual flags, not one in itself. |
| 22:28.56 | beandog | PoeticIntensity, right |
| 22:29.07 | beandog | so, a pkey is really just a sequence plus an index |
| 22:29.10 | PoeticIntensity | that's why MySQL doesn't have "sequences". |
| 22:29.10 | beandog | ok |
| 22:29.14 | beandog | right |
| 22:29.17 | beandog | they have auto increment |
| 22:29.19 | PoeticIntensity | I'm with ya. |
| 22:29.26 | beandog | but, sequences are more than that |
| 22:29.54 | beandog | since youre actually telling a pkey to set the next value of the column to seq.index + 1 |
| 22:30.39 | mindjuju | today's 80's moment brought to you by Lite Brite - http://youtube.com/watch?v=MBlTsHsr5Ig |
| 22:31.07 | beandog | the Last Dragon? |
| 22:31.08 | beandog | wazzat |
| 22:31.40 | mindjuju | http://www.imdb.com/title/tt0089461/ |
| 22:32.23 | beandog | http://youtube.com/watch?v=Huat89z2WrA |
| 22:32.37 | beandog | mindjuju, cmon man, thats not gonna give me the geekified summary |
| 22:32.52 | beandog | oh, horrors |
| 22:32.55 | beandog | http://www.youtube.com/watch?v=HnsHpPNltBw&NR=1 |
| 22:33.40 | beandog | evil 80s ugly brain slam warning |
| 22:34.04 | beandog | the only thing worse than that one would be a new kids music video |
| 22:38.56 | wps | I can't be believe that i just sat through that |
| 22:39.25 | beandog | thats my feeling |
| 22:39.33 | wps | no way… that girl is Fergie? |
| 22:39.39 | wps | http://www.youtube.com/watch?v=Gb5DkLd22Ic&mode=related&search= |
| 22:40.38 | wps | what's up with that clown? |
| 22:40.42 | wps | how freaky |
| 22:40.46 | beandog | hehh |
| 23:06.34 | timinator | *yawn |
| 23:06.54 | timinator | I'm out guys.... later |
| 23:08.13 | *** part/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net) |
| 23:16.07 | macnewbold | that song rocks |
| 23:16.15 | mgeary | totally |
| 23:16.55 | mgeary | as does another song from Robin Hood: "Every town has it's ups and downs, but not in Nottinham...." :) |
| 23:17.03 | mgeary | NottinGham |
| 23:18.46 | PoeticIntensity | I love that song, mgeary |
| 23:18.53 | PoeticIntensity | I have loved it for YEARS. |
| 23:19.00 | *** part/#uphpu cole_joplin (n=cjoplin@gw.helius.com) |
| 23:19.06 | mgeary | yup |
| 23:27.27 | dataw0lf | I'm fond of fondling these tactless tactile cats until they tapped out PUT THAT DOWN cuz I put that down, yea, I do dat there, while you asking, talking bout "who that there?" I knock em out |
| 23:27.31 | dataw0lf | ^^ greatest lyrics ever |
| 23:43.24 | mgeary | well folks |
| 23:43.26 | mgeary | have a weekend |
| 23:43.30 | PoeticIntensity | choa... |
| 23:43.34 | PoeticIntensity | you have a great weekend, bud. |
| 23:43.36 | PoeticIntensity | (chao) |
| 23:43.38 | PoeticIntensity | that is. |
| 23:48.02 | *** part/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 23:53.57 | *** join/#uphpu cycokilr (n=cycokilr@66.114.120.2) |
| 23:57.38 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |