| 00:00.59 | *** join/#uphpu dataw0lf|w (~dataw0lf@66.219.227.114) [NETSPLIT VICTIM] |
| 00:02.12 | mindjuju | any firefox users in the house? |
| 00:16.34 | bigdog_ut | yes |
| 00:21.05 | mindjuju | any reason why this code won't work in firefox? |
| 00:21.28 | mindjuju | <a href="javascript: purchaseG()" >Click |
| 00:21.28 | mindjuju | <PROTECTED> |
| 00:21.55 | bigdog_ut | cause its crappy javascript |
| 00:22.38 | bigdog_ut | what is it doing? |
| 00:22.47 | mindjuju | k, well, i threw in onClick for good measure, but it didn't like it either |
| 00:22.56 | mindjuju | it's just a link that connects to a javascript function |
| 00:23.01 | mindjuju | don't really want it on a button |
| 00:23.03 | bigdog_ut | it should be this <a href="#" onclick="purchaseG()"> Click Here </a> |
| 00:23.42 | mindjuju | i know i tried onClick, but don't remember if i took out the javascript option in the href parameter |
| 00:23.47 | mindjuju | i'll see how that works |
| 01:34.30 | *** part/#uphpu mindjuju (~mindjuju@216.20.238.225) |
| 01:50.22 | *** join/#uphpu bigdog_ut (~bigdog_ut@shylonhunter.dsl.xmission.com) |
| 01:50.23 | *** mode/#uphpu [+o bigdog_ut] by ChanServ |
| 01:52.04 | bigdog_ut | whatz up all |
| 02:05.23 | *** join/#uphpu tierra (~tierra@dsl093-225-126.slc1.dsl.speakeasy.net) |
| 02:15.46 | *** join/#uphpu tierra (~tierra@dsl093-225-126.slc1.dsl.speakeasy.net) |
| 02:28.06 | *** join/#uphpu tierra (~tierra@dsl093-225-126.slc1.dsl.speakeasy.net) |
| 03:07.26 | *** join/#uphpu greygnome (~greynome@c-67-186-198-153.hsd1.ut.comcast.net) |
| 03:45.41 | *** join/#uphpu wps (~wade@65.73.113.199) |
| 03:45.45 | *** mode/#uphpu [+o wps] by ChanServ |
| 04:25.25 | *** join/#uphpu usynic (~synic@c-67-172-247-186.hsd1.ut.comcast.net) |
| 13:52.49 | *** join/#uphpu trl-thomas (~thomas@c-24-2-83-84.hsd1.ut.comcast.net) |
| 14:24.16 | *** part/#uphpu greygnome (~greynome@c-67-186-198-153.hsd1.ut.comcast.net) |
| 14:48.44 | *** join/#uphpu eco (identd@c-24-10-128-63.hsd1.ut.comcast.net) |
| 15:10.17 | *** join/#uphpu mindjuju (~mindjuju@216.20.238.225) |
| 15:12.10 | mindjuju | w00t! |
| 15:12.16 | mindjuju | let's hear it for scientists! |
| 15:12.17 | mindjuju | http://news.yahoo.com/s/washpost/20050609/tc_washpost/many_scientists_admit_to_misconduct |
| 15:13.08 | macnewbold | morning, everyone |
| 15:13.18 | macnewbold | meeting tonight! |
| 15:13.32 | *** topic/#uphpu by macnewbold -> Group project meeting TONIGHT! 7pm | Utah PHP Users Group | uphpu.org |
| 15:14.46 | *** join/#uphpu drip (~scoobmast@67.108.238.129.ptr.us.xo.net) |
| 15:17.16 | *** join/#uphpu fungus (~fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 15:17.18 | macnewbold | ~urapug |
| 15:17.19 | jbot | i heard urapug is Utah Ruby and Python User Group - #urapug |
| 15:17.44 | macnewbold | ~urapug is also <reply> no, YOU'RE a pug! |
| 15:17.45 | jbot | okay, macnewbold |
| 15:17.48 | macnewbold | ~urapug |
| 15:17.49 | jbot | hmm... urapug is Utah Ruby and Python User Group - #urapug, or <reply> no, YOU'RE a pug! |
| 15:18.03 | macnewbold | well, not quite, but I guess it will have to do |
| 15:18.10 | macnewbold | ~urug |
| 15:18.16 | macnewbold | ~utahpython |
| 15:18.30 | macnewbold | ~urug is Utah Ruby Users Group - #urug |
| 15:18.31 | jbot | macnewbold: okay |
| 15:20.41 | *** join/#uphpu jsmith (~jsmith@pip.drs1.omniture.com) |
| 15:39.25 | *** join/#uphpu bobert_ (~bobert@216.20.238.225) |
| 15:39.33 | *** part/#uphpu bobert_ (~bobert@216.20.238.225) |
| 15:40.08 | *** join/#uphpu bigdog_ut (~bigdog@166.70.34.182) |
| 15:40.08 | *** mode/#uphpu [+o bigdog_ut] by ChanServ |
| 16:00.09 | fungus | I went to the plug ruby on rails meeting last night. Stole some good ideas for our project. |
| 16:02.43 | jsmith | fungus: Good! |
| 16:13.45 | macnewbold | excellent |
| 17:04.08 | *** part/#uphpu fungus (~fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 17:10.47 | *** join/#uphpu fungus (~fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 17:11.50 | scott_ | so I asked this question yesterday but took off and couldn't followup with a clarification. If I have index.php but normally just use ?action=foo.bar in my links and I want to link to the current page (?action=foo.bar) plus &whatever=1 is there a way to do that besides writing ?action=foo.bar&whatever=1 |
| 17:14.45 | jsmith | scott_: Use sessions, use POSTs, use AJAX... there are plently of ways to do it -- each one with its own pros and cons. |
| 17:54.07 | macnewbold | scott_: you can also look in $_SERVER at QUERY_STRING I believe, or one of those variables, and get the current query so that you can add to it. |
| 17:54.42 | *** join/#uphpu beandog (~sdibb@64.50.56.200) |
| 17:54.45 | beandog | macnewbold: you around |
| 17:55.14 | macnewbold | yep |
| 17:55.18 | macnewbold | sup? |
| 18:04.08 | scott_ | but all of the alternatives require me to do work than just retyping ?action=foo.bar right? I was just curious if there was an html shortcut |
| 18:05.45 | macnewbold | not an html shortcut, but a php shortcut |
| 18:06.20 | macnewbold | set your url to "$_SERVER[QUERY_STRING]&whatever=1" |
| 18:06.24 | macnewbold | and it will always get the right string |
| 18:28.15 | dataw0lf|w | morning macnewbold |
| 18:29.44 | dataw0lf|w | I'll be at the project meeting tonight. |
| 18:29.46 | dataw0lf|w | I swears. |
| 18:30.51 | bigdog_ut | sure man |
| 18:31.18 | dataw0lf|w | I am, I'm going to be there. |
| 18:31.23 | dataw0lf|w | you going, bigdog? |
| 18:31.36 | bigdog_ut | not sure |
| 18:31.45 | dataw0lf|w | I don't want to hear that, try again. |
| 18:36.35 | *** join/#uphpu john__ (~john@128.187.220.80) |
| 18:36.58 | *** part/#uphpu john__ (~john@128.187.220.80) |
| 18:37.53 | *** join/#uphpu john__ (~john@128.187.220.80) |
| 18:38.21 | bigdog_ut | not sure yet |
| 18:38.40 | *** part/#uphpu john__ (~john@128.187.220.80) |
| 18:39.04 | *** join/#uphpu rooeydaniel (~daniel@67.50.128.10) |
| 18:39.40 | *** join/#uphpu john_uphpu_ (~john@128.187.220.80) |
| 18:40.13 | john_uphpu_ | Is anyone listening right now? |
| 18:40.25 | rooeydaniel | yes |
| 18:40.49 | john_uphpu_ | Awesome - just making sure this works... Its been a long time since I've used IRC... |
| 18:41.02 | rooeydaniel | This is the first time for me...I guess I just figured it out :) |
| 18:41.35 | dataw0lf|w | <PROTECTED> |
| 18:41.40 | dataw0lf|w | .. |
| 18:43.38 | dataw0lf|w | your inept virtual matrix moves are no match for my text fu, sir. |
| 18:47.20 | bigdog_ut | lol |
| 18:47.21 | bigdog_ut | what ever |
| 18:47.26 | dataw0lf|w | jeje |
| 18:47.29 | dataw0lf|w | ergh |
| 18:47.29 | dataw0lf|w | hehe |
| 18:51.05 | bigdog_ut | while Wolf Lift of Ethereal Deceptions rocks dataw0lf|w's world |
| 18:51.58 | dataw0lf|w | Now, sit! |
| 18:53.44 | bigdog_ut | while preparing the Uppercut of the Dogs |
| 18:54.02 | dataw0lf|w | HA! |
| 18:57.34 | *** join/#uphpu optikal` (~optikal@64.50.125.203) |
| 19:00.10 | dataw0lf|w | bigdog_ut: I installed Eclipse on my machine for the third time, last night. |
| 19:00.18 | dataw0lf|w | And for the third time, realized it was terrible. |
| 19:00.19 | bigdog_ut | third time |
| 19:00.24 | bigdog_ut | lol |
| 19:00.29 | bigdog_ut | you just dont know how to use it |
| 19:00.52 | bigdog_ut | dude if i had 10 minutes to show you would be all over eclipse |
| 19:01.24 | dataw0lf|w | if you go to the meeting tonight, I will give you some time to show me what the fuss is all about. |
| 19:01.33 | dataw0lf|w | but right now it just ain't working for me. |
| 19:02.31 | bigdog_ut | i hope i can |
| 19:02.51 | dataw0lf|w | word. |
| 19:03.52 | dataw0lf|w | I dunno, I'm digging spe and komodo |
| 19:04.02 | bigdog_ut | oh |
| 19:05.06 | bigdog_ut | no i wont be able to make it tonight |
| 19:05.47 | macnewbold | c'mon, man |
| 19:05.49 | macnewbold | you gotta come |
| 19:06.14 | bigdog_ut | i have to attend dance recitals for my girls |
| 19:06.33 | dataw0lf|w | ah, cool. |
| 19:06.38 | dataw0lf|w | I won't give you crap then. |
| 19:06.41 | dataw0lf|w | family > * |
| 19:06.49 | macnewbold | yeah, it's cool this time |
| 19:07.06 | macnewbold | but next time, have them reschedule the recitals... |
| 19:07.09 | macnewbold | ;) |
| 19:07.09 | bigdog_ut | yeah i have 3 girls all in dance...and i get three nights of recitals |
| 19:07.29 | dataw0lf|w | hehe. |
| 19:07.34 | bigdog_ut | i asked my wife if i could get out of it...and man that was a stupid thing |
| 19:07.40 | dataw0lf|w | man, do you have any sons? |
| 19:08.00 | macnewbold | hehe, yeah, smooth one bigdog_ut ;) |
| 19:08.09 | macnewbold | did you tell her she looked fat too? |
| 19:08.13 | macnewbold | j/k |
| 19:08.17 | bigdog_ut | yeah i have a 6mth old son |
| 19:08.29 | bigdog_ut | that would have been lighter in terms of anger |
| 19:11.38 | macnewbold | dude |
| 19:13.34 | fungus | Maybe bigdog_ut could do a presentation on using eclipse for PHP dev? :) |
| 19:13.35 | dataw0lf|w | bigdog_ut: well, at least you have another guy. |
| 19:14.01 | dataw0lf|w | or give a presentation at URAPUG on Eclipse for Python dev. |
| 19:14.12 | dataw0lf|w | or at least make it to our presentation week after next. |
| 19:18.34 | xilch | ur freedumb |
| 19:18.47 | xilch | and I am going to work |
| 19:18.48 | xilch | bibi |
| 19:18.48 | macnewbold | ~pimpslap xilch |
| 19:19.01 | macnewbold | ~pimp xilch |
| 19:19.02 | jbot | ACTION pimps xilch for only xilch, while stating: "cheap whores are my speciality..." :P |
| 19:19.02 | xilch | kthx |
| 19:19.36 | macnewbold | ~give xilch freedumb |
| 19:19.41 | dataw0lf|w | 'Brotha, did ya forget your name? Did you lose it on the wall playing tic tac toe? Yo, check the diagonal, three million gone, c'mon, cause they're counting backwards to zero' |
| 19:19.48 | macnewbold | ~tell xilch about freedumb |
| 19:20.02 | dataw0lf|w | '(anger is a gift)' |
| 19:20.32 | dataw0lf|w | macnewbold: don't worry, he's just cynical from so much Perl. |
| 19:20.42 | macnewbold | ~halelujah |
| 19:21.16 | dataw0lf|w | ~hallelujah |
| 19:21.24 | dataw0lf|w | ~halellujah |
| 19:21.27 | dataw0lf|w | hm |
| 19:21.40 | dataw0lf|w | AMEN! |
| 19:23.21 | rooeydaniel | Does Quanta have a PHP Plugin? |
| 19:23.25 | bigdog_ut | y |
| 19:23.50 | rooeydaniel | I am trying to locate it without any success, any idea where I can get it? |
| 19:24.15 | macnewbold | ~quanta |
| 19:24.16 | jbot | i guess quanta is http://quanta.sourceforge.net |
| 19:24.25 | macnewbold | is it an IDE? |
| 19:24.31 | rooeydaniel | Yes |
| 19:24.33 | bigdog_ut | y |
| 19:24.38 | dataw0lf|w | yeah, it isn't very good, imho. |
| 19:24.43 | rooeydaniel | Really? |
| 19:24.45 | macnewbold | who needs it... just use emacs |
| 19:24.46 | bigdog_ut | no not really |
| 19:24.50 | dataw0lf|w | I don't think so, rooeydaniel. |
| 19:24.54 | rooeydaniel | lol...I use vim quite a bit |
| 19:25.00 | dataw0lf|w | ~vim++ |
| 19:25.28 | macnewbold | all you really need for php development is a good text editor that has syntax highlighting and indenting, and one or more browsers |
| 19:25.38 | dataw0lf|w | very much agreed. |
| 19:25.43 | dataw0lf|w | jedit is pretty decent. |
| 19:25.51 | macnewbold | the better you know your editor, the quicker you'll be |
| 19:26.11 | macnewbold | whether it's vim or emacs or jedit doesn't make nearly as much difference as knowing it well |
| 19:26.17 | bigdog_ut | rooeydaniel, quanta should have php in it already |
| 19:26.32 | dataw0lf|w | cept for emacs. |
| 19:26.33 | dataw0lf|w | cause it's so terrible. |
| 19:26.35 | dataw0lf|w | :) |
| 19:26.37 | dataw0lf|w | <3 macnewbold |
| 19:27.19 | bigdog_ut | however, rooeydaniel, i would suggest kdevelop or kate if you are using kde |
| 19:27.48 | dataw0lf|w | KDevelop is really nice, but I haven't used it for PHP. |
| 19:28.09 | bigdog_ut | kate is really good if you are just doing php files and no project |
| 19:28.20 | mindjuju | yo bigdog |
| 19:28.39 | macnewbold | dataw0lf, did you just scroheart me? |
| 19:28.45 | mindjuju | if you had 200,000 records coming in a month |
| 19:28.47 | dataw0lf|w | I don't usually like corrupting my environment with KDE apps, but I gotta say I was impressed with C/C++ with KDevelop. |
| 19:28.53 | dataw0lf|w | macnewbold: yessir. |
| 19:28.53 | mindjuju | and had to keep records for a year |
| 19:29.01 | mindjuju | would you use MySQL to do it |
| 19:29.06 | macnewbold | ~curse dataw0lf |
| 19:29.07 | jbot | May you be reincarnated as a Windows XP administrator, dataw0lf ! |
| 19:29.07 | dataw0lf|w | heh |
| 19:29.10 | macnewbold | ~flea dataw0lf |
| 19:29.16 | macnewbold | ~fleas dataw0lf |
| 19:29.18 | jbot | dataw0lf, may the fleas of a thousand camels infest the hair in your dark sensitive areas forever! |
| 19:29.32 | dataw0lf|w | mindjuju: what's the database design going to be like? |
| 19:29.42 | mindjuju | form 3 normalization |
| 19:29.48 | rooeydaniel | I actually use Gnome most of the time... |
| 19:29.52 | dataw0lf|w | use postgres. |
| 19:29.56 | dataw0lf|w | ~rooeydaniel++ |
| 19:29.58 | bigdog_ut | mindjuju, use pgsql |
| 19:29.59 | rooeydaniel | as a matter of fact, I don't even have KDE installed on my laptop |
| 19:30.08 | beandog | How would you do not == in php? |
| 19:30.10 | bigdog_ut | quanta is a kde app |
| 19:30.12 | beandog | Is it !== or != |
| 19:30.18 | dataw0lf|w | != |
| 19:30.21 | rooeydaniel | Ah, I have that installed on my work machine |
| 19:30.23 | dataw0lf|w | !== is not === |
| 19:30.27 | rooeydaniel | where KDE is installed |
| 19:30.28 | beandog | ok, thats what I thought |
| 19:30.37 | beandog | sudenly it just didnt look right |
| 19:30.45 | dataw0lf|w | hehe |
| 19:30.49 | dataw0lf|w | ooh |
| 19:31.09 | dataw0lf|w | good call mac |
| 19:31.44 | dataw0lf|w | or maybe Paul Simon - Graceland.. |
| 19:32.13 | bigdog_ut | urg |
| 19:32.57 | dataw0lf|w | bigdog_ut: is work better for you lately? |
| 19:33.38 | bigdog_ut | no it still sucks |
| 19:33.46 | bigdog_ut | i am writing a help system again |
| 19:34.01 | dataw0lf|w | windows help format? |
| 19:35.07 | bigdog_ut | no a home grown xml help system |
| 19:35.15 | bigdog_ut | they wanted it home grown |
| 19:35.25 | bigdog_ut | i wanted it done with robohelp |
| 19:35.36 | dataw0lf|w | that sucks |
| 19:36.11 | dataw0lf|w | macnewbold: you think a wiki would be a good idea for the group project? |
| 19:36.19 | dataw0lf|w | for documentation purposes, at least. |
| 19:37.29 | rooeydaniel | Did we decide that someone was going to be here during the meeting tonight? |
| 19:38.17 | dataw0lf|w | I think mac's office has wireless, from what I remember from the discussion, so that won't be a problem, I'm sure. |
| 19:38.49 | rooeydaniel | okay... |
| 19:39.34 | dataw0lf|w | macnewbold: so we're going to set aside some time to discuss the Python porting project, too, then? |
| 19:39.41 | bigdog_ut | did we decide on some leaders and team leads |
| 19:39.53 | dataw0lf|w | I think that's on the agenda for tonight. |
| 19:43.07 | macnewbold | dataw0lf: sure |
| 19:43.10 | macnewbold | probably not too much |
| 19:43.16 | macnewbold | since there's not much to discuss at this point :) |
| 19:43.24 | macnewbold | but it will be good to make everyone aware of it, |
| 19:43.39 | macnewbold | and be somewhat conscious of the considerations as we move forward |
| 19:44.17 | macnewbold | oh, and Paul Simon rocks - graceland is good |
| 19:44.49 | macnewbold | bigdog_ut: we want to decide either before tonight, or at the meeting |
| 19:44.55 | macnewbold | on leaders and such |
| 19:45.14 | macnewbold | dataw0lf; wiki might be good... I've never used them much, but I guess we could do one |
| 19:45.15 | bigdog_ut | i would do it before the meeting or no latter than after |
| 19:45.17 | macnewbold | thoughts? |
| 19:45.39 | macnewbold | anyone opposed to voting at the meeting/ |
| 19:45.40 | macnewbold | ? |
| 19:46.05 | macnewbold | a wiki might be a good way to spread around the thoughts and plans |
| 19:46.43 | dataw0lf|w | macnewbold: yeah, that's what we're using for IronMesh and it seems to be working pretty well. |
| 19:46.49 | macnewbold | cool |
| 19:48.09 | mindjuju | ~frenchtaunt macnewbold |
| 19:48.10 | jbot | ACTION summons the french taunter! macnewbold, I burst my pimples at you... |
| 19:48.21 | mindjuju | thought you may need that, mac |
| 19:49.57 | bigdog_ut | mindjuju, you get an answer on your sql stuff? |
| 19:50.19 | mindjuju | yup, don't use mysql |
| 19:52.18 | bigdog_ut | good man |
| 19:52.22 | macnewbold | ~frenchassault mindjuju |
| 19:52.23 | jbot | ACTION summons the french taunter! mindjuju is an English bedwetting type! mindjuju, I burst my pimples at you... You tiny-brained wipers of other people's bottoms! Now go away or I shall taunt you a second time-a! |
| 19:52.23 | beandog | heh |
| 19:52.29 | macnewbold | ~lart bigdog_ut |
| 19:52.37 | mindjuju | ~newsflash macnewbold |
| 19:52.38 | jbot | ACTION snapped pictures of macnewbold prancing around like pippi longstocking picking posies! Pictures to be posted! |
| 19:52.40 | macnewbold | mindjuju: why not mysql? |
| 19:52.50 | bigdog_ut | cause it sucks |
| 19:53.10 | mindjuju | wasn't sure if it was going to be able to handle the load well |
| 19:53.20 | mindjuju | 200k records a month with storage going for the whole year |
| 19:53.30 | mindjuju | heavy queries |
| 19:53.39 | macnewbold | mysql will do fine with that |
| 19:53.45 | macnewbold | as long as you don't have broken queries |
| 19:54.05 | macnewbold | that's only 2.4M records by the end of the year |
| 19:54.08 | bigdog_ut | as long as you have a decent mysql config file |
| 19:54.51 | macnewbold | you could probably even do that with the default config, |
| 19:54.59 | macnewbold | as long as the records are of reasonable size |
| 19:55.24 | bigdog_ut | mysql sucks though..you want a real db with transactions..innodb would crap out at that rate |
| 19:55.44 | macnewbold | if your records got over 1k each, that would be 2GB+ of raw data, which wouldn't be good for most any database |
| 19:55.54 | macnewbold | why do you want transactions if you don't need them? |
| 19:55.58 | macnewbold | they just slow you down |
| 19:56.09 | macnewbold | and I don't use innodb :) |
| 19:56.37 | bigdog_ut | if you care about your data you use trans |
| 19:56.50 | macnewbold | not necessarily |
| 19:57.01 | macnewbold | single queries are atomic |
| 19:57.24 | macnewbold | mindjuju hasn't mentioned anything about needing txns |
| 19:57.37 | mindjuju | i won't really need transactions as this is an olap function |
| 19:58.01 | mindjuju | or rather the database is built for olap purposes |
| 19:58.33 | mindjuju | so not going to be changing records, but going to analyze the records that are present |
| 19:58.52 | bigdog_ut | how are you analyzing? |
| 19:59.10 | mindjuju | through queries? |
| 19:59.34 | bigdog_ut | obviously...buy what type of analyzing? |
| 20:00.09 | scott_ | how do you check if a server is running mod_rewrite? can you use .htaccess to rewrite index.php?action=admissions.generalinfo&s=tuition to admissions/generalinfo/tuition ? would it be a pain to do for quite a few pages? |
| 20:00.10 | mindjuju | talling certain columns; counting frequencies of events, finding percentages |
| 20:00.12 | bigdog_ut | for example olap is usually done with specific tools |
| 20:00.19 | mindjuju | ah, oh |
| 20:00.30 | bigdog_ut | hence the name |
| 20:00.40 | mindjuju | c# app |
| 20:00.41 | bigdog_ut | online analytical processing |
| 20:01.01 | macnewbold | scott_: if the server config allows it, you can set up rewrites in your .htaccess |
| 20:01.05 | mindjuju | now before anybody says anything |
| 20:01.18 | mindjuju | THIS IS NOT MY APP, it is for a friend in an all windows enviroment |
| 20:01.24 | mindjuju | who was using MySQL |
| 20:01.25 | macnewbold | hehe |
| 20:01.25 | bigdog_ut | mysql is okay...if you are doing really complex queries the pgsql is the best |
| 20:01.35 | macnewbold | I disagree, of course |
| 20:01.45 | macnewbold | mysql being lighter and less complex would probably be faster |
| 20:01.48 | bigdog_ut | yeah but you are locking into the box |
| 20:01.58 | bigdog_ut | depends again on the queries |
| 20:02.07 | bigdog_ut | i can do a stored procedure that is killer fast |
| 20:02.28 | macnewbold | mysql runs queries PDQ too |
| 20:02.43 | mindjuju | see, that was my arguement. stored procedures to make the queries fast |
| 20:02.50 | mindjuju | which is why I was suggesting away from mysql |
| 20:02.56 | mindjuju | and came here to see concensus |
| 20:02.57 | macnewbold | in any case, if its "fast enough", who cares unless you're doing it a bajillion times in a row |
| 20:03.05 | macnewbold | mindjuju: you'll probably find none :) |
| 20:03.32 | mindjuju | true no consensus, but good arguements lead to informed decision |
| 20:03.35 | bigdog_ut | the problem that macnewbold has is that he has not use pgsql to make a valid concensus |
| 20:03.44 | bigdog_ut | :) |
| 20:04.16 | bigdog_ut | ill give sql the benefit if you are doing simple queries the msyql is fast |
| 20:04.36 | scott_ | macnewbold: how do I know if the server supports it? an example for that that address I mentioned? |
| 20:04.46 | bigdog_ut | however if you are doing olap (like stated) you are doing intensive queries (complex) that requrie a nice db |
| 20:04.58 | mindjuju | fungus hasn't said anything lately |
| 20:05.03 | mindjuju | ~nosepick fungus |
| 20:05.05 | jbot | ACTION plucks fungus out of the nose of humanity and wipes him on the couch! |
| 20:05.45 | bigdog_ut | i would love to see the comparisons if you did to mysql and pgsql of the same queries |
| 20:06.02 | fungus | I generally agree with macnewbold, on the my vs pg issue, but I choose to keep my mouth shut for a change. |
| 20:06.03 | jsmith | bigdog_ut: Me too! Me too! |
| 20:06.43 | fungus | That was quite funny though mindjuju, I was actually picking my nose at the same time you did that. |
| 20:07.05 | jsmith | Eeeeww! |
| 20:07.30 | mindjuju | ! |
| 20:07.35 | mindjuju | hilarious! |
| 20:09.22 | macnewbold | scott_: to tell if it supports it, there are a couple of ways |
| 20:09.22 | mindjuju | ~toejam macnewbold |
| 20:09.23 | jbot | ACTION wipes all the crud and macnewbold from out between his toes. Yuck! |
| 20:09.24 | macnewbold | ask the admin |
| 20:09.29 | macnewbold | try it and see |
| 20:09.57 | macnewbold | that's about all I can think of |
| 20:10.03 | macnewbold | unless you have read access to the apache conf file |
| 20:12.13 | macnewbold | in which case you can just look there to see if it's allowed |
| 20:13.11 | fungus | grep rewrite /usr/local/etc/apache*/httpd.conf |
| 20:14.56 | mindjuju | k, so that said. does it make sense if on the quarter, to tally all the computations of that quarter and put the results of te computations into a new table. Then when the end of the year assessment happens, tally the 4 records |
| 20:15.05 | mindjuju | or does that just seem like a lot of work |
| 20:15.43 | macnewbold | caching aggregated results can save time |
| 20:15.48 | bigdog_ut | it all depends on the requirements of what you are doing |
| 20:16.00 | macnewbold | if you can do it all at once, and don't need the quarterlies for anything else, |
| 20:16.03 | macnewbold | then do it at once |
| 20:16.19 | macnewbold | if its too big, or you need the quarters anyway, cache the result and reuse it |
| 20:16.30 | macnewbold | especially if the data isn't changing |
| 20:17.28 | macnewbold | if the data grows a lot more often than you use the cached totals, then don't cache the last total, or you'll spend too much time keeping it up to date |
| 20:17.52 | macnewbold | if you've got latency requirements on your responses, the cache might help there too |
| 20:18.03 | mindjuju | v true |
| 20:18.06 | macnewbold | because you've precomputed part of it (most of it) before they even ask |
| 20:29.10 | scott_ | macnewbold: how would I do a rewrite for index.php?action=admissions.generalinfo&s=tuition to admissions/generalinfo/tuition in .htaccess to test if it works? |
| 20:29.27 | macnewbold | not sure... I haven't ever actually used mod_rewrite :) |
| 20:29.49 | macnewbold | it's probably basically a regular expression, |
| 20:29.54 | macnewbold | but I don't know the syntax |
| 20:30.09 | macnewbold | actually, you probably want to go the other way no? |
| 20:30.16 | macnewbold | they put the simple URL in the browser |
| 20:30.26 | macnewbold | and internally it is converted to the GET? |
| 20:30.26 | bigdog_ut | http://httpd.apache.org/docs/mod/mod_rewrite.html#RewriteCond |
| 20:30.49 | macnewbold | then in your code, you just print out simple URLs |
| 20:31.10 | bigdog_ut | u do a rewrite of the admissions/generalinfo/tuition to index.php?action=admissions.generalinfo&s=tuition |
| 20:31.15 | bigdog_ut | using regex |
| 20:36.15 | bigdog_ut | its nice that openoffice crashes with over 8k fonts loaded |
| 20:37.48 | bigdog_ut | where is wps today? |
| 20:40.25 | *** part/#uphpu rooeydaniel (~daniel@67.50.128.10) |
| 20:44.57 | bigdog_ut | lol that is funny that openoffice crashes |
| 20:50.44 | mindjuju | ~shakespeare bigdog_ut |
| 20:50.46 | jbot | ACTION stands up and quotes Shakespeare: bigdog_ut - Thou impertinent elf-skinned scullian! |
| 20:54.19 | *** part/#uphpu trl-thomas (~thomas@c-24-2-83-84.hsd1.ut.comcast.net) |
| 20:56.09 | macnewbold | ~dataw0lf |
| 20:56.10 | jbot | methinks dataw0lf is sleeping again, or da supahstah, or a dink, or #utah's number one troll |
| 20:56.32 | macnewbold | jbot, dataw0lf is also known by his full title: dataw0lf, Destroyer of Newbies, Troll of the Seas of IRC, God of All that is Technical, etc, etc |
| 20:56.34 | jbot | okay, macnewbold |
| 20:56.36 | macnewbold | ~dataw0lf |
| 20:56.37 | jbot | [dataw0lf] sleeping again, or da supahstah, or a dink, or #utah's number one troll, or known by his full title: dataw0lf, Destroyer of Newbies, Troll of the Seas of IRC, God of All that is Technical, etc, etc |
| 20:56.43 | dataw0lf|w | true dat. |
| 21:47.33 | *** join/#uphpu tierra (~tierra@dsl093-225-126.slc1.dsl.speakeasy.net) |
| 21:59.27 | *** join/#uphpu design5279 (~sfaught@63.75.14.2) |
| 22:05.27 | *** part/#uphpu beandog (~sdibb@64.50.56.200) |
| 22:17.21 | *** join/#uphpu eco|w (~eco@dsl093-225-126.slc1.dsl.speakeasy.net) |
| 22:19.30 | macnewbold | design5279: are you new here, or have I just not been paying attention? |
| 22:19.38 | macnewbold | in either case, welcome! |
| 22:19.55 | dataw0lf|w | woot woot |
| 22:19.55 | *** topic/#uphpu by macnewbold -> Group project meeting in a few hours! 7pm | Utah PHP Users Group | uphpu.org |
| 22:28.51 | jsmith | Why do things always come up on Thursday nights? |
| 22:43.05 | *** join/#uphpu bobert_ (~bobert@216.20.238.225) |
| 22:43.11 | *** part/#uphpu bobert_ (~bobert@216.20.238.225) |
| 22:46.50 | *** join/#uphpu shill (~scotth@204.110.225.254) |
| 22:48.55 | *** join/#uphpu bigdog_ut (~bigdog@166.70.34.182) |
| 22:48.55 | *** mode/#uphpu [+o bigdog_ut] by ChanServ |
| 22:49.39 | design5279 | sorry, a bit slow today + new 2 irc... the first post I see is asking me whether I was paying attention, so I don't know what came before that |
| 23:01.45 | *** part/#uphpu fungus (~fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 23:18.00 | *** join/#uphpu design5279 (~sfaught@63.75.14.2) |
| 23:23.43 | *** join/#uphpu design5279 (~sfaught@63.75.14.2) |
| 23:25.03 | *** join/#uphpu eco (identd@c-24-10-128-63.hsd1.ut.comcast.net) |
| 23:55.50 | macnewbold | design5279: there wasn't anything before that |
| 23:55.55 | macnewbold | I was just telling you welcome |
| 23:56.05 | macnewbold | and asking if _I_ wasn't paying attention |
| 23:56.11 | macnewbold | that I hadn't noticed you before |
| 23:56.32 | design5279 | thank then, and I just joined, so you *are* paying attention |