| 00:01.34 | *** join/#uphpu cyco|w (n=cyco@66.114.120.2) |
| 00:02.35 | beandog | hmm |
| 00:03.04 | *** join/#uphpu cyco|w (n=cyco@66.114.120.2) |
| 00:03.14 | beandog | fungus: thanks |
| 00:04.37 | beandog | I was trying to find a way not to use head / tail, since I'm grepping a file with over 3 million lines. |
| 00:04.37 | beandog | meh. |
| 00:06.54 | fungus | There might be a better command, but I can't remember it. |
| 00:12.08 | beandog | ok |
| 00:22.22 | macnewbold | beandog: if you know how many bytes into the file it is, you could write a simple program that opened the file and did an fseek to that point |
| 00:22.29 | macnewbold | but head/tail will be faster than writing that program |
| 00:22.34 | beandog | hmm, ok |
| 00:22.35 | macnewbold | 3million lines isn't that bad |
| 00:22.41 | macnewbold | good luck with it though :) |
| 00:22.58 | beandog | I ended up writing a bash script to loop through it, and run expr and sed |
| 00:23.07 | beandog | to edit it, not grep it out. |
| 00:23.12 | beandog | er, n/m |
| 00:23.16 | beandog | none of that is gonna make sense. |
| 00:37.53 | mindjuju | anybody around? |
| 00:40.39 | bigdog_ut | y |
| 00:41.58 | bigdog_ut | mindjuju, what you need? |
| 00:42.23 | mindjuju | just looking to see if anybody had any experience with online backups |
| 00:42.38 | mindjuju | how you doing bigdog_ut? |
| 00:42.38 | bigdog_ut | give me an example? |
| 00:43.02 | mindjuju | like ibackup.com or backup.com |
| 00:43.45 | mindjuju | the owner is considering doing online backup of his files and he was asking me what I thought. I don't use a service so don't have an opionoin just thought i'd check here |
| 00:45.39 | bigdog_ut | nope...i just do my own backups |
| 00:46.42 | mindjuju | yeah, me too, have 40g tape, but he was looking for something a little more friendly |
| 00:46.48 | mindjuju | thx though! |
| 00:49.27 | bigdog_ut | np |
| 00:50.51 | *** join/#uphpu jakea (n=jakea@12-191-122-219.att-inc.com) |
| 01:04.38 | *** join/#uphpu synic (n=squish@pdpc/supporter/student/synic) |
| 01:04.38 | *** mode/#UPHPU [+v synic] by ChanServ |
| 01:07.26 | mindjuju | where you going to school at synic? |
| 01:13.46 | mindjuju | that's too funny, the channel topic is still what I put on the other day about "manly men" -- a response to the #phpwomen channel |
| 01:14.47 | dataw0lf | sup |
| 01:14.54 | mindjuju | sup yo! |
| 01:15.12 | dataw0lf | awww jea. ya know, just chillin, fool. |
| 01:15.51 | mindjuju | i think we ought to raise the Jolly Roger and jump into the #phpwomen channel and make a raucous |
| 01:16.43 | dataw0lf | dang, everyone wants me to flame with them |
| 01:16.48 | dataw0lf | so many victims, so little time |
| 01:17.06 | mindjuju | :) |
| 01:39.35 | Joffray | I think synic is going to slcc |
| 01:42.10 | dataw0lf | hell too |
| 01:42.18 | dataw0lf | j/k |
| 01:44.16 | mindjuju | hey dataw0lf, if i wanted to see where a port was being blocked, is there a way to do it? i know tracert is a way of seeing the steps an ICMP packet takes to get to its destination, is there something like tracert that you execute on a computer to see where a port is being blocked? |
| 01:44.46 | dataw0lf | sure, what OS? |
| 01:44.52 | dataw0lf | and what proto? |
| 01:45.10 | mindjuju | winXP |
| 01:45.23 | Joffray | what protocol |
| 01:45.29 | dataw0lf | there's actually a GNU implementation of tcptraceroute, I believe. |
| 01:45.49 | mindjuju | tcp, sorry somebody came in my office |
| 01:46.08 | dataw0lf | Windows, dunno, I'd just use Python. |
| 01:46.40 | dataw0lf | just google for tcp traceroute windows, I'm sure there's a bunch of, ahem, quality software out there that can handle it. |
| 01:47.05 | Joffray | wow |
| 01:47.10 | Joffray | the dems might pick up both |
| 01:47.24 | dataw0lf | good stuff. |
| 01:47.38 | dataw0lf | start handing out two week notices to everyone in the White House |
| 01:47.47 | Joffray | yea no shit |
| 01:47.59 | Joffray | if the democrats don't try to impeach that administration |
| 01:48.10 | Joffray | I'll be dissapointed |
| 01:48.21 | dataw0lf | language bro |
| 01:48.32 | dataw0lf | but I agree. |
| 01:48.36 | Joffray | language? |
| 01:48.39 | Joffray | english! |
| 01:48.55 | dataw0lf | watch the cursing in here, some people don't appreciate it. |
| 01:48.58 | Joffray | plus, you're one to talk dw ;) |
| 01:49.16 | dataw0lf | I don't curse in UPHPU. |
| 01:49.45 | Joffray | meh, language noted |
| 01:49.57 | dataw0lf | I might have the worst non sailor mouth evar, but I gotta respect the channel |
| 01:50.09 | dataw0lf | oooh, a gold star |
| 01:50.14 | Joffray | oh wow |
| 01:50.19 | Joffray | we picked up OHIO! |
| 01:50.22 | dataw0lf | this'll match well next to my bronze one. |
| 01:50.27 | dataw0lf | yea, governor and all |
| 01:51.17 | mindjuju | if i remember right though, the dems have to pick up 16 house 7 senate seats to have majority |
| 01:51.35 | dataw0lf | well the house is a given |
| 01:51.46 | dataw0lf | really, the senate was questionable |
| 01:51.46 | Joffray | yea mindjuju |
| 01:51.53 | dataw0lf | but it's looking purty. |
| 01:51.55 | Joffray | they're picking up the ones they need to though |
| 01:52.08 | Joffray | looks like it'll hinge on Virginia for the senate |
| 01:52.34 | dataw0lf | how's Ford Jr doing? |
| 01:53.20 | Joffray | only 3% reporting |
| 01:53.25 | Joffray | 45% for Ford Jr |
| 01:53.33 | Joffray | http://www.dailykos.com/election/Senate_South |
| 01:53.40 | dataw0lf | coolio |
| 01:54.07 | dataw0lf | alright, I'm gonna go eat dinner and get some sleep, I gotta fly to le Frisco in the mornin' |
| 01:54.31 | mindjuju | cya dataw0lf |
| 01:54.31 | dataw0lf | hopefully I'll wake up in a blue nation |
| 01:54.33 | dataw0lf | huzzah! |
| 01:54.43 | mindjuju | ugh, blue |
| 01:55.40 | Joffray | ? |
| 01:56.04 | mindjuju | dataw0lf's comments on the nation going blue |
| 01:56.17 | Joffray | :) |
| 01:56.33 | mindjuju | yeah, not much of a blue fan when it comes to politics |
| 01:56.46 | Joffray | the republicans are such crooks |
| 01:56.52 | Joffray | that's what bugs me |
| 01:57.10 | mindjuju | lol, that's hilarious |
| 01:57.46 | Joffray | well.... they are |
| 01:57.57 | mindjuju | never known a democrat to lie, cheat, etc... |
| 01:58.13 | *** join/#uphpu timinator (n=timinato@c-67-171-118-199.hsd1.ut.comcast.net) |
| 01:58.13 | *** mode/#UPHPU [+v timinator] by ChanServ |
| 01:58.13 | Joffray | I never said that none of them are |
| 01:58.34 | mindjuju | yeah, but your blanket statement - repbus are such crooks, |
| 01:58.38 | mindjuju | implies all are |
| 01:58.38 | Joffray | well |
| 01:58.41 | Joffray | no |
| 01:58.42 | Joffray | most |
| 01:58.52 | mindjuju | that's not what your statement says though |
| 01:58.52 | Joffray | use that thing attached to your neck |
| 01:59.10 | Joffray | well I apologize if you thought I was saying ALL of them are |
| 01:59.11 | mindjuju | so let me see if i'm understanding you |
| 01:59.50 | Joffray | I don't think all of them are, I think most of them are |
| 02:00.05 | mindjuju | your saying that because you can't say anything other than standard rhetoric "all repubs are crooks" i should use my head and take everything you say with a grain of salt |
| 02:00.06 | Joffray | As for the democrats, they're idiots about some issues |
| 02:00.07 | mindjuju | good idea |
| 02:00.28 | Joffray | u r dumb |
| 02:00.40 | Joffray | that better? |
| 02:00.51 | Joffray | and actually I said |
| 02:00.56 | Joffray | the republicans |
| 02:00.58 | Joffray | not all |
| 02:01.04 | mindjuju | way cool! i love it when polical discussion get personal |
| 02:01.14 | mindjuju | if you can't argue the issues, stay out of the arguments |
| 02:01.20 | Joffray | but yes, I apologize if you misunderstood my statement |
| 02:01.29 | mindjuju | k, fair enough |
| 02:02.01 | Joffray | the republicans are bible thumping fear mongers |
| 02:02.07 | Joffray | the democrats, however |
| 02:02.19 | mindjuju | lol, joffray, your simply too much |
| 02:02.31 | Joffray | aren't a ton better |
| 02:02.41 | Joffray | well, I'm speaking very generally |
| 02:03.02 | Joffray | in terms of the general direction of their policies |
| 02:03.09 | Joffray | OMG terrar! |
| 02:03.13 | Joffray | OMG GOD! |
| 02:03.50 | mindjuju | wow, those are very broad sterotypes. k, so in the words of Nacho Libre, let's get down to the nitty gritty |
| 02:03.59 | mindjuju | what specifically do you not agree with (as far as repubs go) |
| 02:04.17 | Joffray | I do not agree with the (virtual) ban on stem cell research |
| 02:04.30 | Joffray | It's basically impossible to do stem cell research in the united states |
| 02:05.08 | Joffray | I do not agree with the ban(s) on same-sex marriage. These are almost always put forward by republicans. |
| 02:06.43 | mindjuju | so, just those 2 points, everything else ok? |
| 02:07.03 | Joffray | no, but I need to take a shower before my gf comes over :) |
| 02:07.31 | mindjuju | ah, well by all means, don't let a small thing like a political conversation keep you from impressing |
| 02:07.46 | mindjuju | we'll catch up on this tomorrow when hopefully the nation is still red |
| 02:07.50 | Joffray | you're an ass |
| 02:07.55 | *** part/#uphpu Joffray (i=olds@antitech.xmission.com) |
| 02:07.57 | mindjuju | lol |
| 02:09.37 | mindjuju | oh there wasn't much |
| 02:09.50 | mindjuju | dataw0lf just said he hopes that when he wakes up the nation voted blue |
| 02:09.53 | mindjuju | i said ugh |
| 02:10.02 | timinator | lol |
| 02:10.04 | mindjuju | Joffray said he thought all repubs were crooks |
| 02:10.25 | mindjuju | i have a prob with people repeating rhetoric they've heard and not researched |
| 02:10.30 | mindjuju | so i called him on it and he got mad |
| 02:10.38 | timinator | yep |
| 02:11.12 | mindjuju | it's a dead give away in a political conversation if things turn personal that they haven't studied, just repeating |
| 02:11.23 | timinator | ya |
| 02:11.25 | mindjuju | he called me an a$$ twice |
| 02:11.30 | mindjuju | no argue on points |
| 02:11.32 | mindjuju | ah well |
| 02:11.42 | timinator | lol |
| 02:13.46 | mindjuju | wow, did you see that Genesis is going to tour again? you a fan timinator? |
| 02:14.14 | timinator | oh ya |
| 02:14.22 | timinator | that's cool |
| 02:14.46 | mindjuju | it says a 2 month world tour, they better get their butts at least within 200 miles of here |
| 02:14.58 | timinator | no doubt |
| 02:19.47 | mindjuju | those bunch of jerks! http://www.genesis-music.com/ |
| 02:32.19 | *** join/#uphpu xilch (n=xilch@c-24-10-182-180.hsd1.ut.comcast.net) |
| 02:56.22 | mindjuju | ~seen Joffray |
| 02:56.36 | jbot | joffray <i=olds@antitech.xmission.com> was last seen on IRC in channel #uphpu, 48m 46s ago, saying: 'you're an ass'. |
| 02:56.57 | timinator | that's a good way to be remembered |
| 02:57.04 | mindjuju | yeah |
| 02:59.21 | mindjuju | the sad thing is that i didn't even get to talk about my political conundrum |
| 03:01.44 | mindjuju | if a person TRULY believes the 2000 and 2004 elections were stolen by illegal acts, then there is no way you can believe the blues will win tonight. The reason is that most who believe the aforementioned believe it was stolen by the Military-Industrial-Complex to start and maintain the war. If dems win congress then war will surely be stopped -- a threat to the MIC, and therefore not allowable |
| 03:32.31 | mindjuju | wow, where fungus at? |
| 03:59.28 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 03:59.28 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 04:08.29 | timinator | hey guys |
| 04:08.53 | timinator | is there any way to force an HTTPS connection on a directory? |
| 04:09.24 | timinator | such as http://site.com/secure will pull up https://site.com/secure |
| 04:09.56 | synic | Probably not the right way to do it, but I have index.php check $ENV['SERVER_PORT'] and if it's not 443, it redirects it to https |
| 04:10.08 | mindjuju | yup, that's what i do |
| 04:10.14 | timinator | really? |
| 04:10.20 | timinator | can I steal one of those files? |
| 04:10.23 | timinator | please? |
| 04:10.30 | timinator | pretty please? |
| 04:10.37 | tierra | I'd actually do a mod_rewrite in a virtual host, but either works |
| 04:10.39 | synic | hah, I'd have to write one up real quick |
| 04:10.55 | mindjuju | mines is in CF |
| 04:11.03 | timinator | oh |
| 04:11.14 | timinator | a mod_rewrite would work too |
| 04:11.26 | timinator | really mindjuju? |
| 04:11.36 | timinator | isn't that winblows only? |
| 04:11.49 | mindjuju | nope, they have a version for linux |
| 04:11.57 | tierra | I write C++ primarily, not PHP ;) |
| 04:12.02 | timinator | tierra: could you copy/paste that mod_rewrite please? |
| 04:12.12 | timinator | nice mindjuju |
| 04:12.15 | beandog | mmmmmmm c++ |
| 04:12.25 | timinator | c++ |
| 04:12.27 | tierra | and I hope to move into a lot more python as well |
| 04:12.36 | timinator | so everything is a .cgi script? |
| 04:12.40 | mindjuju | yeah, but c++ is the language that all programmers revere |
| 04:12.45 | tierra | but you guys will always be my friends ;) |
| 04:13.25 | mindjuju | and a good c++ programmer instantly gets the guru label by virtue of c++ |
| 04:13.32 | timinator | If I weren't a PHP manly man, I'd feel a group hug coming on |
| 04:13.52 | tierra | hehe |
| 04:14.31 | mindjuju | i was thinking that we should raise the jolly roger and make a raucous in the #phpwomen channel |
| 04:14.52 | beandog | lols |
| 04:15.00 | mindjuju | let's raid the channel! |
| 04:15.02 | tierra | mindjuju: there's a lot of C++ techniques that still baffle me to this day, I wouldn't say knowing C++ gives you instant credibility |
| 04:15.16 | timinator | I agree mindjuju |
| 04:15.27 | timinator | go in there and belch and fart |
| 04:15.30 | timinator | and then run out |
| 04:20.09 | mindjuju | here are the stats |
| 04:20.20 | mindjuju | 3 people |
| 04:20.25 | mindjuju | binarykitten |
| 04:20.27 | mindjuju | chairmanmiaow |
| 04:20.29 | mindjuju | lig |
| 04:20.56 | timinator | mindjuju, you and I'll have to change our nicks... tierra, you're fine as you are |
| 04:21.00 | timinator | :) |
| 04:21.07 | mindjuju | lol |
| 04:21.24 | mindjuju | there isn't much conversating going on there though |
| 04:21.37 | *** join/#uphpu el_gaucho (n=bigdog@zeus.thebigdog.biz) |
| 04:21.38 | *** mode/#UPHPU [+o el_gaucho] by ChanServ |
| 04:21.48 | mindjuju | in fact, no statements since i got in here 5 minutes ago |
| 04:21.58 | timinator | hey el_gaucho |
| 04:22.16 | el_gaucho | whatz up |
| 04:22.55 | timinator | nada |
| 04:23.35 | el_gaucho | same here...just starting to get some more work done |
| 04:26.39 | tierra | timinator: are you getting my PMs? |
| 04:26.53 | timinator | getting nothin |
| 04:26.56 | el_gaucho | eyah but you log off after i get them |
| 04:27.03 | tierra | stupid FreeNode... you need to register |
| 04:27.12 | tierra | but in the mean time... |
| 04:27.15 | tierra | one sec |
| 04:27.33 | timinator | did you get my PMs? |
| 04:27.35 | mindjuju | the tierra name isn't registered? |
| 04:27.46 | tierra | timinator: yeah, I got yours |
| 04:27.51 | timinator | ah |
| 04:27.55 | tierra | mine is registered |
| 04:27.58 | tierra | timinator's isn't |
| 04:28.03 | timinator | so is mine |
| 04:28.07 | tierra | you'd probably be better off with a <Location> |
| 04:28.07 | timinator | I registered |
| 04:28.17 | tierra | the way I was thinking was since you need separate virtual host definitions for ssl and non-ssl anyway, you just put in a rule like this in the non-ssl: RewriteRule ^secure/(.*)$ https://mysite.com/secure/$1 [L] |
| 04:28.32 | timinator | lol mindjuju |
| 04:29.12 | tierra | -NickServ(NickServ@services.)- Registered: 1 year 30 weeks 4 days (23h 25m 46s) ago |
| 04:29.16 | tierra | see |
| 04:29.45 | timinator | what did you type for that response tierra? |
| 04:30.50 | tierra | /msg nickserv info |
| 04:30.50 | synic | 21:30 -NickServ(NickServ@services.)- Nickname: synic << ONLINE >> |
| 04:30.50 | synic | 21:30 -NickServ(NickServ@services.)- Registered: 3 years 48 weeks 4 days (1h 52m 29s) ago |
| 04:30.50 | synic | omg i win |
| 04:30.50 | tierra | I've been on FreeNode much longer, just held off registering until I needed to |
| 04:31.05 | tierra | I think it was this channel that prompted me to actualy |
| 04:31.07 | synic | me too.. except I think they changed ircds about then or something |
| 04:31.07 | tierra | +l |
| 04:31.19 | mindjuju | Registered: 1 year 9 weeks 6 days (6h 42m 1s) ago |
| 04:31.32 | timinator | Nickname: timinator << ONLINE >> |
| 04:31.33 | timinator | Registered: 4 weeks 6 days (5h 47m 4s) ago |
| 04:31.35 | synic | when did they change from openprojects.net? |
| 04:32.03 | tierra | stupid FreeNode, did you just identify timinator, or were you before? |
| 04:32.40 | tierra | all I kept getting was this crap when trying to message timinator: |
| 04:32.43 | tierra | [freenode] -!- Private messages from unregistered users are currently blocked due to spam problems... |
| 04:33.13 | tierra | but I'm registered any identified, and so was timinator, which makes FreeNode just stupid |
| 04:33.23 | tierra | s/any/and |
| 04:33.25 | timinator | that's crazy |
| 04:33.37 | synic | it seems to randomly pick when it's going to do that |
| 04:33.42 | synic | I haven't seen it in a while myself |
| 04:34.06 | tierra | well, I don't PM many people on FreeNode often... |
| 04:34.57 | tierra | anyway, timinator that was my mod_rewrite solution if you didn't see it earlier |
| 04:35.07 | timinator | I did, thanks |
| 04:36.11 | tierra | timinator: tierra@phreaker.net on MSN |
| 04:36.50 | *** topic/#UPHPU by el_gaucho -> UPHPU | http://www.uphpu.org |
| 04:38.51 | burnin | Go Ashdown!!! |
| 04:38.54 | burnin | :) |
| 04:39.13 | mindjuju | he was winning, but i'm showing 39 - 55 |
| 04:39.31 | burnin | 15.8% of precincts in and he is winning 48.72% to 45.68% |
| 04:39.53 | burnin | http://www.clerk.slco.org/results/public/ |
| 04:40.05 | burnin | page routines updates with results |
| 04:40.12 | burnin | routinely that is |
| 04:41.01 | mindjuju | that page you posted burnin has a higher reporting percentage than mine |
| 04:41.12 | mindjuju | i'll start using yours |
| 04:41.28 | burnin | what is the url to the site you were watching? |
| 04:41.59 | mindjuju | i was using the AP one http://www.yahoo.com/s/432395 |
| 04:43.39 | mindjuju | yuck! |
| 04:43.59 | mindjuju | the phpwoman lig says "lig coughs a lung up" |
| 04:45.08 | tierra | http://www.electionresults.utah.gov/xmlData/300009.html btw |
| 04:45.51 | mindjuju | wow |
| 04:46.48 | tierra | I like SLCO results... heh |
| 04:46.56 | burnin | lol |
| 04:46.58 | tierra | but they aren't updating often |
| 04:47.00 | burnin | same here |
| 04:47.30 | mindjuju | salt lake county voted for pete ashdown by more than a 1000 votes |
| 04:47.45 | tierra | so far |
| 04:48.14 | mindjuju | true that |
| 04:49.31 | burnin | looks like salt lake and carbon county are the only areas where there was actually a race. |
| 04:49.42 | tierra | for those that use mod_rewrite much, this is a really good resource: http://www.ilovejackdaniels.com/apache/mod_rewrite-cheat-sheet/ |
| 05:13.50 | timinator | I'm out guys. |
| 05:13.53 | timinator | have a good night |
| 05:13.56 | timinator | later |
| 05:13.58 | mindjuju | cya |
| 05:30.20 | mindjuju | anybody around? |
| 05:30.25 | tierra | yeah |
| 05:30.39 | burnin | but about to head off to bed, early day tomorrow |
| 05:30.57 | mindjuju | do ya'll know off hand how to get the name (not the value) of the chosen option in an HTML select using JS ? |
| 05:31.09 | mindjuju | if not offhand that's ok, i'll search google |
| 05:31.42 | tierra | not offhand, been a long time since I've done any of that |
| 05:31.44 | mindjuju | i thought it was document.form1.myselectelement.name but i guess not |
| 05:31.58 | tierra | value maybe? |
| 05:32.03 | tierra | I do remember something similar |
| 05:32.10 | mindjuju | i'll try that |
| 05:32.15 | burnin | hmm, the name of the option, not sure. |
| 05:32.23 | synic | I didn't know the options had names |
| 05:33.09 | mindjuju | <option value="fu">thisIsWhatIWant</option> |
| 05:33.21 | synic | do you mean the name of the select? Like <select name='you_want_this'> |
| 05:33.23 | synic | oh. |
| 05:33.42 | mindjuju | there is a way to snag, just can't think of it, but i'm googling as we speak |
| 05:43.31 | tierra | how about that, WebMonkey is still around |
| 05:43.44 | tierra | I would bet they have info for it |
| 05:44.09 | mindjuju | sorry, i found it on codepunk |
| 05:44.25 | mindjuju | document.form1.box.options[document.form1.box.options.selectedIndex].text |
| 05:44.42 | tierra | heh, nice |
| 15:05.17 | *** join/#uphpu jsmith_ (n=jsmith@h4605004d.area3.spcsdns.net) |
| 15:09.48 | *** mode/#UPHPU [+v jsmith] by ChanServ |
| 15:11.14 | *** join/#uphpu designsimply (i=jlo@xmission.xmission.com) |
| 15:14.52 | *** join/#uphpu wps (n=wps@64.72.210.10) |
| 15:14.52 | *** mode/#UPHPU [+o wps] by ChanServ |
| 15:23.30 | *** join/#uphpu _psychic_ (n=_psychic@71.32.228.156) |
| 15:23.30 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 15:38.55 | *** join/#uphpu herlo (n=herlo@class1-nat.gurulabs.com) |
| 15:46.41 | bigdog_ut | ~mornin |
| 15:52.48 | *** join/#uphpu timinator (n=timinato@c-67-171-118-199.hsd1.ut.comcast.net) |
| 15:52.48 | *** mode/#UPHPU [+v timinator] by ChanServ |
| 16:06.05 | wps | good morning |
| 16:06.45 | timinator | mornin' |
| 16:10.27 | drip | morning on ya'll |
| 16:16.36 | *** join/#uphpu jsmith_ (n=jsmith@h4605004d.area3.spcsdns.net) |
| 16:40.19 | *** join/#uphpu timinator (n=timinato@c-67-171-118-199.hsd1.ut.comcast.net) |
| 16:40.19 | *** mode/#UPHPU [+v timinator] by ChanServ |
| 16:49.22 | *** join/#uphpu watermouse (n=byronw@66.236.72.126.ptr.us.xo.net) |
| 16:51.02 | mindjuju | mornin all |
| 16:51.14 | timinator | morning mindjuju |
| 16:52.21 | mindjuju | T - 3 days on the new site, you ready? |
| 16:52.47 | timinator | no |
| 16:52.49 | timinator | LOL |
| 16:53.18 | timinator | and we release on Friday & Saturday... so wouldn't that be something like T-2? |
| 16:53.57 | timinator | and tomorrow we're flying and setting up the booth |
| 16:54.02 | timinator | so I've got today |
| 16:54.04 | mindjuju | wow! |
| 16:54.08 | timinator | eek |
| 16:54.37 | drip | get back to work!! |
| 16:54.45 | timinator | no doubt |
| 16:54.47 | drip | =) |
| 16:54.51 | mindjuju | well, my presentation is this Tuesday coming, still have about 50 dev hours left |
| 16:55.16 | mindjuju | but i got the weekend and mon so i think i'll swing it ok |
| 16:55.16 | *** mode/#UPHPU [+v jsmith] by ChanServ |
| 16:55.22 | timinator | ya |
| 16:55.26 | *** join/#uphpu macnewbold (n=mac@cg.dsl.xmission.com) |
| 16:55.26 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 16:57.43 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 16:57.43 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 17:17.05 | mindjuju | wow! another doba ad |
| 17:29.26 | *** join/#uphpu cyco|w (n=cyco@66.114.120.2) |
| 17:30.55 | bigdog_ut | where? |
| 17:32.01 | beandog | doba? |
| 17:33.31 | bigdog_ut | where is the ad mindjuju ? |
| 17:33.58 | mindjuju | www.di.fm |
| 17:35.01 | mindjuju | i took a screenshot of it just in case, you want it? |
| 17:36.51 | herlo | mindjuju: di.fm is a cool radio station |
| 17:36.53 | mindjuju | and I HIGHLY recommend di.fm for those of you who appreciate electronic dance music |
| 17:37.03 | mindjuju | yup, i'm on breaks channel |
| 17:37.28 | mindjuju | b.nice - electronic stimulus -- i might have to buy this one |
| 17:39.39 | bigdog_ut | ~upchuck |
| 17:43.16 | *** join/#uphpu designsimply (i=jlo@xmission.xmission.com) |
| 17:43.29 | timinator | TY mindjuju |
| 17:44.00 | mindjuju | timinator, on the di.fm? |
| 17:44.07 | timinator | yes |
| 17:44.59 | mindjuju | yeah, dude, i've got breaks, goa, eurodance and mixes all preset, so as soon as one channel starts to go bad, i can jump to something else |
| 17:45.16 | *** join/#uphpu swb (i=jlo@xmission.xmission.com) |
| 17:47.42 | bigdog_ut | lol |
| 17:47.54 | bigdog_ut | ~flame electronica |
| 17:47.55 | jbot | electronica, YOU SUCK. And you know it. |
| 17:48.07 | bigdog_ut | ~flame mindjuju |
| 17:48.08 | jbot | mindjuju, YOU SUCK. And you know it. |
| 17:48.24 | bigdog_ut | ~love mindjuju |
| 17:48.25 | jbot | If you love mindjuju so much, why don't you marry it? (oooooh) |
| 17:48.36 | bigdog_ut | ~kiss mindjuju |
| 17:48.37 | jbot | ACTION forces mindjuju to give wps a big kiss on the lips |
| 17:48.42 | bigdog_ut | lol |
| 17:48.48 | bigdog_ut | great jbot |
| 17:48.50 | wps | sick |
| 17:49.16 | wps | I am so frustrated |
| 17:49.22 | mindjuju | yeah, that was gross |
| 17:49.26 | wps | there are no good web-based project management solutions |
| 17:50.58 | mindjuju | seems like i heard that mantis was a bug tracker and project manager; but have never used it |
| 17:51.21 | herlo | mindjuju: I enjoy the chill channel, but sometimes they have too many commercials |
| 17:51.26 | herlo | I also enjoy somafm.com |
| 17:51.30 | wps | mantis is junk |
| 17:51.42 | watermouse | anyone have a FLAT PANEL monitor(for sale(cheap)) or a plain CRT to give away?! |
| 17:51.45 | mindjuju | yeah they do, and always the same commercial for the scion and "trippin' it out" |
| 17:52.01 | wps | and it's just a bug tracker |
| 17:52.04 | mindjuju | i'll have to check out somafm |
| 17:52.58 | bigdog_ut | watermouse, drip has a 14" green crt |
| 17:53.04 | herlo | mindjuju: In my opinion, it's better, but it doesn't have as many channels or options when it comes to electronic upbeat stuff (though they are always expanding) |
| 17:53.12 | watermouse | to small |
| 17:53.34 | *** mode/#UPHPU [+v herlo] by ChanServ |
| 17:54.44 | bigdog_ut | ~pimpslap mindjuju |
| 17:54.45 | jbot | bigdog_ut pimpslaps mindjuju. ouch! |
| 17:55.05 | bigdog_ut | ~whaleslap mindjuju |
| 17:55.06 | jbot | ACTION beats mindjuju upside and over the head with a freakishly huge killer whale named Hugh |
| 17:55.22 | bigdog_ut | ~lart mindjuju |
| 17:55.40 | bigdog_ut | +1 jbot |
| 17:56.47 | bigdog_ut | ~flip mindjuju |
| 17:57.06 | mindjuju | dude, don't be so bitter cause you like the tunes better than tool or godsmack |
| 17:57.20 | mindjuju | it's ok, you've been wrong about techno, and what you like it now, so what big deal |
| 17:57.30 | bigdog_ut | lol |
| 17:57.35 | mindjuju | just enjoy the tunes! |
| 17:58.35 | mindjuju | the "state of euphoria" was a good album |
| 17:58.59 | timinator | Kid Rock baby |
| 17:59.00 | bigdog_ut | yeah good one |
| 17:59.08 | bigdog_ut | ~smack timinator |
| 17:59.09 | jbot | ACTION smacks timinator upside the head. |
| 17:59.46 | mindjuju | so wps, did you need that screen cap of the doba ad from di.fm or did you see it |
| 17:59.50 | timinator | LOL |
| 17:59.51 | mindjuju | lol |
| 18:00.03 | mindjuju | they do have that one cool song |
| 18:00.11 | wps | it never came up for me… so that screen cap was nice |
| 18:00.17 | timinator | after school special |
| 18:00.54 | mindjuju | pepper is what that song was called by the BhS |
| 18:08.00 | mindjuju | for all you "in the closet" brittney fans (looking in bigdog_ut's direction), i heard she just filed for divorce |
| 18:08.08 | mindjuju | hey, wps, what email addy should i send this to? |
| 18:08.17 | wps | send what? |
| 18:08.25 | mindjuju | the doba ad screencap |
| 18:08.32 | wps | oh, you found another? |
| 18:08.54 | mindjuju | well, i took one when i saw it on di.fm cause i thought you might want it |
| 18:09.12 | wps | sure |
| 18:09.46 | drip | mindjuju: looks like you need to get one of the spinal tap amps |
| 18:09.49 | drip | they're louder. |
| 18:09.51 | drip | they go to 11 |
| 18:13.07 | mindjuju | ugh, 11a, i'd better start busting out some code! |
| 18:14.09 | wps | thanks for the screencap, mindjuju |
| 18:19.35 | *** join/#uphpu swb (i=jlo@xmission.xmission.com) |
| 18:20.20 | _psychic_ | rumsfeld is stepping down looks like |
| 18:32.42 | cyco|w | apparently minjuju is as well |
| 18:46.27 | *** join/#uphpu mindjuju (n=mindjuju@65-121-75-195.dia.static.qwest.net) |
| 18:46.27 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 18:59.37 | *** join/#uphpu fungus (n=fungus@firebat.aros.net) |
| 18:59.47 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 19:16.55 | *** join/#uphpu _psychic__ (n=_psychic@65.103.232.203) |
| 19:32.58 | *** join/#uphpu jnbek (n=jnbek@c-24-10-178-17.hsd1.ut.comcast.net) |
| 19:52.51 | beandog | man |
| 19:52.53 | beandog | I love postgres. |
| 19:53.17 | beandog | its so easy to select with regexp |
| 19:53.23 | beandog | select * from table where col ~ '^foo' |
| 19:53.36 | beandog | postgres++ |
| 19:54.30 | mindjuju | me loves ms sql 2k5! it's so much fun to have to read and install security patches |
| 19:54.38 | mindjuju | ms sql 2k5++ |
| 19:56.46 | beandog | hehehe |
| 19:56.49 | beandog | poor mindjuju |
| 20:03.41 | *** join/#uphpu brasto (n=brasto@71-32-236-165.slkc.qwest.net) |
| 20:03.41 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 20:05.51 | brasto | wps, i'm crossing my fingers that i don't start a flame war against MS Project - I mentioned it in my response to your inquiry, but made it clear I'm not a proponent of MS Project myself. |
| 20:06.33 | wps | :) |
| 20:06.58 | wps | I'm so frustrated |
| 20:07.06 | mindjuju | "but then I read deeper and discovered that it was developed for IE and only runs on MS servers and requires Active X. What a piece of junk!" |
| 20:07.26 | mindjuju | so i'm pretty sure MS Project out |
| 20:10.03 | mindjuju | wps, have you looked at basecamphq? |
| 20:10.13 | mindjuju | it's a SaaS |
| 20:10.14 | wps | yes, I listed that in my original email |
| 20:10.22 | wps | SaaS? |
| 20:10.54 | mindjuju | Software as a Service |
| 20:11.41 | brasto | yep, mindjuju, i mentioned that in the email |
| 20:12.11 | mindjuju | oh, sure as day |
| 20:12.15 | mindjuju | i must have skipped over it |
| 20:12.40 | brasto | I disagreed with my |
| 20:12.40 | brasto | classmates for the same reason you dislike SimplyPM - of course, MS |
| 20:12.40 | brasto | Project is all proprietary, and probably just as dependent on Active X |
| 20:12.40 | brasto | and IE as SimplyPM." |
| 20:13.36 | mindjuju | curious, that's what i meant to say with my quoting of wps's email comments |
| 20:15.20 | brasto | yea, one thing about taking courses at UoP - they are a Micro$oft prefered partner, so they advocate M$ in every class. |
| 20:15.36 | brasto | I made it a point to advocate just the opposite in each class |
| 20:16.22 | mindjuju | brasto, you take classes at UofP? how you like it over all? |
| 20:16.25 | brasto | sometimes i got my whole team involved, and sometimes i was the sole Open Source advocate |
| 20:16.40 | mindjuju | i'm a few credits short of my bach degree, need to finish it up |
| 20:16.42 | timinator | UofP? |
| 20:16.51 | mindjuju | University of Phoneix likely |
| 20:16.52 | timinator | university of provo? |
| 20:16.56 | timinator | ah |
| 20:17.05 | mindjuju | at least that's what i thought he meant |
| 20:17.27 | brasto | it was University of Phoenix |
| 20:17.31 | brasto | I enjoyed it |
| 20:17.52 | mindjuju | seems a little pricey, is it worth it? |
| 20:17.53 | timinator | it was probably a financial decision to go w/ MS |
| 20:18.19 | mindjuju | MS gives big discounts for schools, students |
| 20:18.25 | timinator | yep |
| 20:18.50 | brasto | yes, it was |
| 20:19.24 | brasto | I enjoyed being able to take my class at home on a computer and minimize the time away from my family |
| 20:19.44 | brasto | i could participate at any time of the day when i was available |
| 20:20.04 | brasto | usually, that ended up being the middle of the night. |
| 20:20.19 | mindjuju | that cool |
| 20:23.35 | timinator | that is cool |
| 20:29.38 | mindjuju | jk |
| 20:29.47 | mindjuju | ugh! got to focus on coding |
| 20:43.44 | brasto | a penguine is a bird |
| 20:44.40 | mindjuju | and is also the general symbol for linux |
| 20:44.43 | mindjuju | but it was a joke |
| 21:04.42 | brasto | yes, i know it's a symbol for linux, i was responding to your joke with a joke |
| 21:05.53 | mindjuju | curious |
| 21:13.43 | mindjuju | what the littledog_ut did to bigdog_ut's laptop http://www.forumspile.com/Owned/Owned-PuppyPeeLaptop.jpg |
| 21:21.41 | beandog | puppypeelaptop? |
| 21:21.45 | beandog | Im definately not clicking on that one. |
| 21:23.02 | swb | what r u guys using for your irc clients? |
| 21:23.15 | wps | Colloquy |
| 21:24.15 | swb | that must make you a mac aficionado |
| 21:24.28 | wps | indeed |
| 21:25.54 | swb | tierra: is irssi better than ircii? |
| 21:26.10 | tierra | yes, imo |
| 21:26.26 | swb | I've only just figured out how to irc from work--must shell into another machine and irc from the command line |
| 21:26.55 | tierra | I don't _have_ to, I just like to do it that way |
| 21:27.13 | tierra | running it inside screen |
| 21:27.32 | timinator | hey guys |
| 21:27.34 | swb | inside screen? |
| 21:27.47 | timinator | is there any way to create a form that posts data to two spots? |
| 21:28.03 | tierra | http://www.gnu.org/software/screen/ |
| 21:28.05 | mindjuju | you could with JS |
| 21:28.17 | timinator | ah, yes |
| 21:28.31 | timinator | :) |
| 21:28.55 | mindjuju | you know what to do timinator? have the submit button on the form call a function that submits two forms to two iframes |
| 21:29.01 | tierra | you could write a script that it posts to that posts all $_POST variables to multiple locations :/ |
| 21:29.24 | swb | tierra: oic, so I'm stuck with ircii on the command line if I have to irc from shell, right? |
| 21:29.28 | tierra | return values would be hard though |
| 21:29.41 | timinator | ya |
| 21:30.21 | tierra | swb: no, you could use irssi (also command line), or BitchX (it's the app's name, calm down), and I'm sure theres others |
| 21:30.47 | mindjuju | brb |
| 21:30.58 | timinator | thanks guys |
| 21:31.03 | tierra | I wouldn't recommend BX (BitchX), it doesn't come with a manual |
| 21:31.32 | bigdog_ut | i love the bx |
| 21:31.36 | brasto | I wouldn't use BX just because of the name |
| 21:31.47 | bigdog_ut | i use it for the name |
| 21:31.51 | brasto | lol |
| 21:31.55 | bigdog_ut | xchat is good too |
| 21:32.06 | tierra | I used to after I finally figured out most of the stuff I needed in it, but then irssi came around with better features |
| 21:32.43 | brasto | kvirc is pretty cool, but i like it more with gaim |
| 21:32.52 | brasto | kopete also works well for me |
| 21:33.56 | brasto | good thing about kvirc - it puts nickserve and other system messages in one window |
| 21:34.08 | bigdog_ut | tierra, i like the eclispe theme for irssi |
| 21:34.24 | tierra | never tried it |
| 21:35.00 | bigdog_ut | ive just seen it..never abused it...but it might be good for me since i use eclipse all the time at work...they might think i actually work |
| 21:35.12 | tierra | heh |
| 21:36.56 | tierra | I've never played with any themes, default with nickcolor and nicklist works for me |
| 21:37.23 | swb | if I want to use irc from my hosting server, I need to install something myself, so I'm going to give it a try |
| 21:37.34 | swb | sounds like irssi is a good option then |
| 21:37.55 | tierra | it took some time coming from using xchat for a while to get used to the nicks not lining up, but looking through the themes that do line up lines, it seems more confusing now |
| 21:38.30 | tierra | swb: if you don't have root, you can still download, build, and run from your home directory if needed |
| 21:39.53 | swb | that's what I was planning, I don't have too much sys admin experience, but when I asked my host if irc was avail. they said I could install it as long as I don't "violate the terms of service" |
| 21:40.00 | swb | whatever that means |
| 21:40.50 | tierra | what your host probably meant was in terms of hosting an IRC server |
| 21:41.21 | swb | yeah, I don't want to host an irc server |
| 21:41.36 | swb | so, I'll try installing irssi tonight :) |
| 21:42.23 | swb | mindjuju: you here? |
| 21:47.14 | tierra | swb: my irssi: http://ibaku.net/dump/irssi.png |
| 21:48.02 | swb | ooo, it's nicer than ircii, with colors and user list |
| 21:48.03 | swb | I like |
| 21:48.18 | tierra | you need to install a few scripts for those btw |
| 21:48.29 | tierra | it doesn't ship like that by default |
| 21:48.35 | swb | oh, I must learn that |
| 21:49.08 | swb | PuTTY rocks |
| 21:49.18 | swb | whoever wrote that should get a prize |
| 21:49.41 | tierra | yeah, it is a pretty amazing feat |
| 21:49.58 | tierra | I love the one executable, settings save in reg |
| 21:50.29 | tierra | no install, run where-ever... I've liked that about Mac OS X bundles too |
| 21:50.56 | tierra | well, a lot of Mac software still requires an install, but yeah |
| 21:54.20 | mindjuju | wps, what's your website |
| 21:54.27 | mindjuju | the avani website |
| 21:55.18 | wps | anavidesign.com |
| 21:55.47 | fungus | tierra: can you post the theme and scripts you use to get that screenshot. I would love the user list like that. |
| 21:57.48 | tierra | anyone mind a ~8 line paste? |
| 21:57.55 | tierra | didn't think so |
| 21:57.58 | wps | nah |
| 21:57.58 | tierra | 14:56 ,--[ScriptAssist] |
| 21:57.58 | tierra | 14:56 | o dccstat Up to date. (1.52) |
| 21:57.58 | tierra | 14:56 | o go Up to date. (1.00) |
| 21:57.58 | tierra | 14:56 | o keepnick Up to date. (1.17) |
| 21:57.58 | tierra | 14:56 | o nickcolor Up to date. (1) |
| 21:58.00 | tierra | 14:56 | o nicklist Up to date. (0.4.6) |
| 21:58.03 | tierra | 14:56 | o scriptassist Up to date. (2003020803) |
| 21:58.05 | tierra | 14:56 | o splitlong Up to date. (0.20) |
| 21:58.08 | tierra | 14:56 | o usercount Up to date. (1.16) |
| 21:58.11 | tierra | 14:56 | o xdccget Up to date. (20040509) |
| 21:58.13 | tierra | 14:56 `--<check>-> |
| 21:58.16 | tierra | ;) |
| 22:00.36 | tierra | those are the scripts btw |
| 22:00.44 | tierra | that I use |
| 22:00.59 | fungus | cool, thx |
| 22:02.00 | *** join/#uphpu fungus_ (n=fungus@shell.aros.net) |
| 22:02.38 | tierra | nicklist can be a pain to setup, and tends to screw up copy & paste in any terminal, the trick is to bind keys to turn on and off the list while doing c&p |
| 22:07.40 | *** join/#uphpu cyco|w (n=cyco@66.114.120.2) |
| 22:22.13 | brasto | wps, your default font size for anavidesign.com on my 1600 X1200 screen is kinda tiny |
| 22:24.35 | brasto | wps, if you don't mind a bit of grammar feedback on anavidesign.com, here are a couple things: |
| 22:25.12 | brasto | "technology and aesthetic" should probably be "technology and aesthetics" |
| 22:26.17 | brasto | "We wake up each morning to make the world more beautiful place" is not a complete sentence. Perhaps you meant to end with "... _a_ more beautiful place" |
| 22:27.10 | mindjuju | bigdog_ut, you around? |
| 22:28.58 | swb | would any of you guys be interested in doing resume workshops and/or mock interviews as a UPHPU event? |
| 22:30.16 | mindjuju | i've done some tech hiring so could do interviews |
| 22:30.16 | swb | thanks mindjuju, that would be awesome! |
| 22:30.16 | mindjuju | where i'm the interviewer that is |
| 22:30.16 | swb | right |
| 22:30.52 | swb | mindjuju: I thought I heard you say you guys have discussed this in the past, true? |
| 22:30.53 | *** join/#uphpu xilch|w (n=xilch@66.236.72.101.ptr.us.xo.net) |
| 22:31.14 | swb | wps: your thoughts? |
| 22:31.58 | mindjuju | something similar. it was to take people like macnewbold and have them talk about the transition from programmer to business owner |
| 22:32.10 | mindjuju | timinator made jump from programmer to COO, right tim? |
| 22:33.23 | swb | I think that would be really cool too |
| 22:33.49 | mindjuju | yup, could talk about cool things like contracts, scope creep, etc |
| 22:34.13 | brasto | ~lart timinator |
| 22:35.13 | bigdog_ut | mindjuju, im here |
| 22:35.42 | mindjuju | hey bigdog_ut, a friend of mine asked this question, if you got a moment can you tell me what you think |
| 22:35.50 | mindjuju | I guess I just need clarification on, if you setup 3 indexes on a table, but you run a query against that table, only one of the indexes can ever by used per query? Is this accurate? |
| 22:36.39 | bigdog_ut | i dont think so |
| 22:36.53 | bigdog_ut | the execute plan would take into account all the indexes it can |
| 22:36.59 | jsmith | mindjuju: With MySQL, I'm pretty sure that's the case. Other databases may be more friendly; |
| 22:37.08 | jsmith | bigdog_ut: I don't think MySQL will handle more than one index per query. |
| 22:37.08 | bigdog_ut | but you would need to double check on the query plan first to make sure |
| 22:37.21 | bigdog_ut | oh really...then mysql sucks |
| 22:37.27 | mindjuju | sorry, i thought i mentioned it. it's a pgsql question |
| 22:37.28 | mindjuju | my bad |
| 22:37.38 | wps | I don't have too much interest personally, but I would support it as a UPHPU event |
| 22:38.20 | jsmith | bigdog_ut: If you look at MySQL's website, they tell you to use self-joins to get around that particular limitation --- yech! |
| 22:38.41 | swb | even if you're not looking for a job, you could use the even to keep your resume updated and help interviewees get interview practice... |
| 22:38.57 | swb | [edit] even = event |
| 22:39.31 | mindjuju | so then it sounds like your answer about the execute plan holds then, right bigdog_ut? |
| 22:40.08 | bigdog_ut | yeah with psql the query planner decides when to use and index |
| 22:40.14 | jsmith | But I don't know nearly as much as bigdog_ut |
| 22:40.15 | bigdog_ut | now it can choose not to use an index |
| 22:41.23 | bigdog_ut | mindjuju, also note that indexes in psql use different algorithums |
| 22:41.35 | bigdog_ut | like btree, rtree, hash and my fav gist |
| 22:41.50 | bigdog_ut | i think btree is the defalt |
| 22:42.29 | mindjuju | coolio, thx bigdog_ut |
| 22:43.16 | bigdog_ut | also tell him that you can have indexes over multicolumns which is better than having 1 index over 2 different columns |
| 22:44.06 | bigdog_ut | btree and gist indexes only support that and you can have only 32 columns max |
| 22:44.35 | beandog | bigdog_ut: what? |
| 22:44.49 | beandog | indexes over multicolumns but not over 2 columns? |
| 22:44.52 | beandog | did I read that wrong |
| 22:45.19 | bigdog_ut | no i typed that wrong |
| 22:45.53 | bigdog_ut | indexes need to be fined tuned just like anything else in the db |
| 22:46.09 | bigdog_ut | sometimes multicolumn indexes are good and sometimes they are not |
| 22:46.48 | beandog | yah |
| 22:46.50 | beandog | definately |
| 22:47.18 | beandog | The l33t hackers just use "Index Tuning Wizard" in mssql |
| 22:47.56 | bigdog_ut | lol |
| 22:48.28 | brasto | mysql can handle more than one index per query |
| 22:48.32 | brasto | i do it all the time |
| 22:49.38 | beandog | can handle more than one index per query? |
| 22:49.45 | beandog | what do you mean |
| 22:50.11 | beandog | like creating them? |
| 22:51.19 | brasto | i should add documentation on where my indexes are, but here's one database structure: |
| 22:51.58 | brasto | http://mscis.org/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=71 |
| 22:52.28 | *** join/#uphpu watermouse (n=byronw@66.236.72.126.ptr.us.xo.net) |
| 22:52.44 | brasto | on the first table i index these fields: |
| 22:54.48 | brasto | PrimaryKey -> LocationID, UniqueAddress -> Home, StreetOrPObox, ApptOrSuite, City, State, Zip, Country |
| 22:55.04 | beandog | does mysql have a boolan field type? |
| 22:55.07 | beandog | boolean |
| 22:55.12 | synic | no |
| 22:55.21 | beandog | hmm, poopy. |
| 22:55.29 | synic | i usually just use the tinyint and 0 or 1 |
| 22:55.37 | beandog | yah, okay |
| 22:55.39 | beandog | that'd work |
| 22:55.40 | synic | you could use enum |
| 22:55.51 | brasto | you can also use enum ('0','1') |
| 22:55.54 | beandog | integers are easier |
| 22:55.57 | bigdog_ut | mindjuju, also with pgsql you can do index on expressions which are really nice |
| 22:56.13 | bigdog_ut | and portable |
| 22:56.20 | beandog | brasto: thats gonna slow you down having the pkey on both |
| 22:56.21 | brasto | i like enum because it forces only 0 and 1 |
| 22:56.29 | beandog | Id make a separate unique key for address |
| 22:56.35 | brasto | hmmm, that makes sense |
| 22:57.09 | brasto | so you can do a tinyint in a innodb with referential integrity to a table with only 1 and 0 |
| 22:57.16 | bigdog_ut | mindjuju, and partial indexes are really killer too if you use them right |
| 22:57.16 | beandog | I would change the 'created' columns to default to getdate() |
| 22:57.19 | beandog | or whatever mysql's function is |
| 22:57.41 | bigdog_ut | i think it is now() |
| 22:57.44 | bigdog_ut | :) |
| 22:58.10 | brasto | this query works on the indexes i mentioned for the above table: |
| 22:58.22 | brasto | SELECT c.ContactID, FirstName, LastName |
| 22:58.22 | brasto | FROM MyABcontact c |
| 22:58.22 | brasto | LEFT JOIN MyABaddress2contact a |
| 22:58.22 | brasto | <PROTECTED> |
| 22:58.22 | brasto | LEFT JOIN MyABgroup2contact g2c |
| 22:58.22 | brasto | <PROTECTED> |
| 22:58.24 | brasto | LEFT JOIN MyABgroup g |
| 22:58.26 | brasto | <PROTECTED> |
| 22:58.28 | brasto | WHERE LocationID IS NULL |
| 22:58.30 | brasto | <PROTECTED> |
| 22:58.32 | brasto | <PROTECTED> |
| 22:58.54 | beandog | setup a view |
| 22:58.57 | beandog | that'll speed it up too |
| 22:59.16 | bigdog_ut | only new versions of mysql support them :( |
| 22:59.30 | brasto | i'm referencing the primary key in that select statement, plus the unique key |
| 22:59.40 | beandog | does 4.0 have foreign keys? |
| 22:59.43 | brasto | beandog, are your suggestions for me? |
| 22:59.48 | beandog | brasto: yah |
| 22:59.55 | bigdog_ut | not sure |
| 23:00.06 | brasto | foreign keys are supported way back in 3.0 for innodb tables |
| 23:00.17 | beandog | ah |
| 23:00.21 | beandog | InnoDB is good. |
| 23:00.24 | beandog | transactions are good. |
| 23:00.42 | beandog | anyway. |
| 23:00.46 | brasto | foreign keys will be supported on myisam tables in 5.1 |
| 23:00.54 | brasto | http://mscis.org/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=72 |
| 23:01.00 | brasto | beandog, those are my views |
| 23:01.25 | beandog | you use drop table on a view? |
| 23:01.37 | beandog | weerd. |
| 23:02.10 | brasto | beandog, modified defaults to the "date()" function because every time the record get's updated, it takes effect. |
| 23:02.31 | brasto | beandog, which table has drop table? |
| 23:02.49 | beandog | <PROTECTED> |
| 23:03.08 | brasto | ah, no, that's a statement for people that don't have MySQL 4.1 |
| 23:03.11 | brasto | or up |
| 23:03.22 | brasto | actually, 5.0 or up |
| 23:03.46 | brasto | To quote myself: |
| 23:03.51 | brasto | "MySQL 5.0 supports views. For previous versions, replace this line:" |
| 23:04.01 | brasto | "CREATE VIEW viewName AS" |
| 23:04.11 | beandog | ah |
| 23:04.14 | brasto | with one of these: |
| 23:04.15 | beandog | as usual, I skimmed. |
| 23:04.16 | beandog | -_- |
| 23:04.18 | brasto | np |
| 23:04.19 | brasto | lol |
| 23:05.21 | brasto | i'm not sure how to make a column default to a now() for the first write, i'll have to look into doing that... |
| 23:05.58 | brasto | perhaps it's just in the column type 'datetime' vs 'timestamp'... |
| 23:06.54 | brasto | anyway, unless im missing something, many of my views reference several indexed fields, and they work. |
| 23:07.22 | beandog | well, just set the default to now() or whatever |
| 23:07.28 | beandog | and it will use that as the default value |
| 23:07.37 | beandog | It wont *update* to that unless you used a trigger |
| 23:08.57 | brasto | ah, that makes sense |
| 23:09.04 | brasto | i'll test that out.. |
| 23:09.27 | brasto | btw, viewGroupTree doesn't work: http://forums.mysql.com/read.php?100,122988,122988#msg-122988 |
| 23:09.36 | brasto | i posted in the above forum on it |
| 23:09.48 | brasto | nobody can help so far |
| 23:32.41 | beandog | pgsql vs mssql thread on plug? |
| 23:32.44 | beandog | How did I miss that one |
| 23:32.53 | beandog | Like it should even be a *question* |
| 23:32.59 | bigdog_ut | exactly |
| 23:33.10 | beandog | O_o |
| 23:33.31 | beandog | its like asking if you want an ice cream cone or get your bladder slammed in the doorway |
| 23:33.45 | bigdog_ut | roflol |
| 23:34.01 | bigdog_ut | man we have been migrating data from mssql to mssql 2005 and it sucks |
| 23:34.09 | beandog | really? |
| 23:34.16 | beandog | Its not backwards compatible? |
| 23:34.28 | bigdog_ut | sorry 2007 or whatever is the newest |
| 23:34.31 | bigdog_ut | 2006 |
| 23:34.36 | bigdog_ut | it is all crap |
| 23:34.44 | beandog | whats it doing |
| 23:34.54 | bigdog_ut | just doesnt like to move |
| 23:35.10 | bigdog_ut | i think it has its bladder slammed in the doorway |
| 23:35.20 | beandog | lols |
| 23:35.32 | beandog | Doesnt sql server come with some kind of an upgrade wizard? |
| 23:35.41 | beandog | I swear I remmeber seeing one in 2k for migrating from v7 or something.. |
| 23:36.02 | bigdog_ut | we are moving data from one server to the next |
| 23:36.11 | beandog | Ah |
| 23:36.14 | beandog | gotcha. |
| 23:41.50 | beandog | odbc wont work? |
| 23:41.53 | beandog | or adodb |
| 23:44.25 | brasto | beandog - i remember now why i don't have now() for default on created: |
| 23:44.40 | brasto | MySQL said: |
| 23:44.51 | brasto | #1067 - Invalid default value for 'Created' |
| 23:45.20 | beandog | now() must not return that datatype then |
| 23:46.03 | brasto | it does, but i think MySQL wants a string, and it's thinking I'm assigning 'now()' as a string... |
| 23:47.52 | macnewbold | is created a timestamp? |
| 23:48.03 | macnewbold | or a datetime? |
| 23:48.09 | brasto | macnewbold it's a datetime |
| 23:48.21 | brasto | i use timestamp for modified |
| 23:48.26 | brasto | i use datetime for created |
| 23:48.29 | macnewbold | hm |
| 23:48.33 | macnewbold | that might be the difference |
| 23:48.46 | macnewbold | if you make another timestamp for created, |
| 23:48.52 | macnewbold | _after_ the modified one, |
| 23:48.57 | brasto | doesn't timestamp update to now() with every update, and not just on creation? |
| 23:48.59 | macnewbold | and set it as NOT NULL, |
| 23:49.02 | macnewbold | it will default to now |
| 23:49.06 | macnewbold | only the _first_ timestamp |
| 23:49.17 | macnewbold | so a modified/updated timestamp should be first, |
| 23:49.20 | macnewbold | then a created timestamp |
| 23:49.40 | macnewbold | otherwise, you'll have to explicitly set a datetime to NOW() on creation to get it work the way you want |
| 23:49.57 | brasto | cool, i'll try that |
| 23:50.00 | macnewbold | a datetime defaults to 0000-00-00 00:00:00 etc. when you have it set not null |
| 23:50.06 | macnewbold | and don't set it explicitly |
| 23:50.10 | macnewbold | and since now() is a function, |
| 23:50.15 | macnewbold | you can't use it as a default value |
| 23:51.18 | brasto | btw, why must created be after updated? |
| 23:53.18 | brasto | btw for beandog and maybe macnewbold - timestamp uses a constant - CURRENT_TIMESTAMP for it's default value when non-null - not the now() function |
| 23:53.37 | macnewbold | brasto: the _First_ timestamp gets auto updated every time the row is updated |
| 23:53.47 | macnewbold | so if you put created there, it will always get chnaged |
| 23:53.50 | brasto | ah, ok |
| 23:53.56 | macnewbold | you want modified there, then created can stay the same |
| 23:54.02 | macnewbold | after the initial setting |
| 23:54.13 | brasto | i wonder if the CURRENT_TIMESTAMP might work in datetime? testing both now... |
| 23:54.16 | macnewbold | now() returns CURRENT_TIMESTAMP |
| 23:54.29 | macnewbold | let me know how it goes |
| 23:55.03 | brasto | hmmm error number one: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause |
| 23:55.09 | wps | so, Brittney Spears got divorced from Kevin Federline |
| 23:55.13 | wps | …also know as K-Fed |
| 23:55.22 | wps | so, now he is FedEx |
| 23:55.39 | brasto | wps, did you get my suggestions above? |
| 23:56.03 | wps | suggestions? |
| 23:57.46 | brasto | for anavidesign.com |
| 23:58.00 | brasto | your default font size for anavidesign.com on my 1600 X1200 screen is kinda tiny |
| 23:58.09 | brasto | if you don't mind a bit of grammar feedback on anavidesign.com, here are a couple things: |
| 23:58.16 | brasto | "technology and aesthetic" should probably be "technology and aesthetics" |
| 23:58.24 | brasto | "We wake up each morning to make the world more beautiful place" is not a complete sentence. Perhaps you meant to end with "... _a_ more beautiful place" |
| 23:58.54 | brasto | macnewbold, error number 2: |
| 23:58.59 | brasto | ALTER TABLE `MyABphone` CHANGE `Created` `Created` DATETIME NOT NULL DEFAULT 'CURRENT_TIMESTAMP' |
| 23:59.07 | brasto | #1067 - Invalid default value for 'Created' |
| 23:59.09 | macnewbold | doh |
| 23:59.41 | macnewbold | okay |
