IRC log for #uphpu on 20070410

00:00.46PoeticIntensityI'm in a racin' mood...
00:00.53PoeticIntensityI think I'm gonna take State Street home.
00:00.58PoeticIntensityfrom AF to Springville. :)
00:01.03beandogwont it be packed?
00:01.06PoeticIntensityhow's them apples, beandog
00:01.09PoeticIntensityyup.
00:01.20PoeticIntensitynever underestimate finding another racer and making your way to the next red light, though. :)
00:01.45PoeticIntensitymaybe I'll take the freeway...
00:01.46PoeticIntensity:-|
00:01.48PoeticIntensitymaybe not.
00:01.57beandognow really
00:02.04beandogwhat are the chances of finding someone that can even beat you?
00:02.15PoeticIntensityoh dude...
00:02.17PoeticIntensitylots.
00:02.38PoeticIntensitywell... okay... maybe not.
00:02.41PoeticIntensity:)
00:02.47beandogheh
00:05.21PoeticIntensitythanks, man... that's beautiful.
00:05.25beandoggood shtuff
00:05.26PoeticIntensityI'm outta here.
00:05.30beandoglaters.
00:05.34PoeticIntensitytalk to ya'll tomorroa.
00:09.28*** join/#uphpu burnin (n=burnin@hongkong.machinage.com)
00:45.52*** join/#uphpu mindjuju (n=mindjuju@65-121-75-195.dia.static.qwest.net)
00:45.52*** mode/#UPHPU [+o mindjuju] by ChanServ
00:47.05mindjuju~rlart
00:47.18jbotblasts com4 to oblivion with a kamehameha wave
01:00.22*** join/#uphpu seant23___ (n=chatzill@70.103.87.163)
01:01.23*** join/#uphpu wps (n=wps@208.53.47.251)
01:01.23*** mode/#UPHPU [+o wps] by ChanServ
01:11.59mindjujuhey wps
01:12.13mindjujuhave you seen the new photoshop CS3 ?
02:27.43wpsI have
02:28.11mindjujudid you like it?  is it any good?
02:28.21mindjujui have CS2, was wondering if it was worth the upgrade?
02:28.28wpsI think it will be, yes
02:28.58wpsdepends on what you do… if you'll need the features… there are some nice interface improvements too though
02:30.09mindjujuas far as functionality, I prolly use about 20% of what PS has to offer.  Just enough to clean up pics, change the background, touch ups, change file formats, rez, etc
02:30.12mindjujuv simple stuff
02:30.31wpsthen it may not be worth the few hundred
02:30.37*** part/#uphpu wps (n=wps@208.53.47.251)
02:30.40*** join/#uphpu wps (n=wps@208.53.47.251)
02:30.40*** mode/#UPHPU [+o wps] by ChanServ
02:30.48wpssorry about that
02:30.53wpsclosed the wrong window
02:30.53mindjujuno worries
02:32.15*** join/#uphpu Utah_Dave (n=boucha@c-67-182-239-240.hsd1.ut.comcast.net)
02:32.15*** mode/#UPHPU [+o Utah_Dave] by ChanServ
03:40.26*** join/#uphpu Utah_Dav1 (n=boucha@c-67-182-239-240.hsd1.ut.comcast.net)
03:56.50*** part/#uphpu Utah_Dav1 (n=boucha@c-67-182-239-240.hsd1.ut.comcast.net)
05:03.53licyeusi remember someone from uphpu had a blog post about the berkeley challenge last year, about the final challenge, does anybody remember the blog?
05:13.38mindjujudoesn't ring a bell, for some reason, when I scan my IRC logs, it isn't coming up
05:14.35mindjujulicyeus , are you sure it was this channel?
05:14.41mindjujugoogling this should have brought it up
05:14.42mindjujuuphpu riker "berkeley challenge"
05:15.06mindjujusince uphpu riker brings up all the logs
05:15.49licyeusi don't know if it was this channel...
05:15.54licyeusactually, it was on the list. http://jenseng.com/archives/000052.html
05:16.14licyeusfound it, hurray.
05:16.47mindjujucool
06:10.46*** join/#uphpu mgeary (n=mgeary@72.8.89.50)
06:10.46*** mode/#UPHPU [+v mgeary] by ChanServ
06:40.33*** part/#uphpu mgeary (n=mgeary@72.8.89.50)
07:02.09*** join/#uphpu xilch|w_ (n=xilch@66.236.72.101.ptr.us.xo.net)
07:08.03*** join/#uphpu seant23___ (n=chatzill@70.103.87.163)
12:02.57*** join/#uphpu seant23____ (n=chatzill@70.103.87.163)
12:34.19*** join/#uphpu timinator (n=timinato@c-67-171-118-199.hsd1.ut.comcast.net)
12:34.19*** mode/#UPHPU [+v timinator] by ChanServ
13:41.40*** join/#uphpu gibba[w] (n=gibbawho@209-253-35-18.ip.mcleodusa.net)
13:53.30*** join/#uphpu jsmith (n=jsmith@70.5.236.251)
13:53.30*** mode/#UPHPU [+v jsmith] by ChanServ
14:01.38*** join/#uphpu timinator (n=timinato@c-67-171-118-199.hsd1.ut.comcast.net)
14:01.38*** mode/#UPHPU [+v timinator] by ChanServ
14:19.15*** join/#uphpu Utah_Dave (n=boucha@c-67-182-239-240.hsd1.ut.comcast.net)
14:19.15*** mode/#UPHPU [+o Utah_Dave] by ChanServ
14:21.02*** join/#uphpu fungus (n=fungus@mailhub.sosstaffing.com)
14:21.12*** mode/#UPHPU [+o fungus] by ChanServ
14:22.08*** join/#uphpu Utah_Dav1 (n=boucha@c-67-182-239-240.hsd1.ut.comcast.net)
14:22.20*** part/#uphpu Utah_Dav1 (n=boucha@c-67-182-239-240.hsd1.ut.comcast.net)
14:26.06*** join/#uphpu wps (n=wps@67.108.236.230.ptr.us.xo.net)
14:26.06*** mode/#UPHPU [+o wps] by ChanServ
14:30.16*** join/#uphpu thebigdog (n=bigdog@208.177.146.102.ptr.us.xo.net)
14:30.16*** mode/#UPHPU [+o thebigdog] by ChanServ
15:16.03*** join/#uphpu mgeary (n=mgeary@166.70.44.49)
15:16.03*** mode/#UPHPU [+v mgeary] by ChanServ
15:44.41*** join/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net)
15:44.41*** mode/#UPHPU [+o Utah_Dave] by ChanServ
15:45.55*** join/#uphpu Lone_Wanderer (n=chatzill@cg.dsl.xmission.com)
15:45.55*** mode/#UPHPU [+v Lone_Wanderer] by ChanServ
15:58.51*** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog)
15:58.51*** mode/#UPHPU [+v beandog] by ChanServ
16:02.11Lone_WandererGood morning to ye good sirs.
16:03.44beandoghey Lone_Wanderer
16:03.52beandoghows it going
16:03.57Lone_WandererIt's going.
16:04.00Lone_WandererCan't complain.
16:04.02beandogmindjuju: where were you yesterday
16:04.14Lone_WandererExcept about the weather.  One can always find cause to complain about the weather.
16:04.15beandogLone_Wanderer: when do you move
16:04.19Lone_Wanderer22nd
16:04.24Lone_Wandereror thereabouts
16:04.25beandognice
16:05.59Lone_WandererYeah, the place is pretty decent.
16:06.09Lone_WandererI actually found out that most of my family members have lived there in the past.
16:06.21Lone_WandererLike, all of my older siblings.
16:06.45*** join/#uphpu brasto (n=brasto@71-219-154-236.slkc.qwest.net)
16:06.45*** mode/#UPHPU [+v brasto] by ChanServ
16:06.54brastoany of you tried phplist?
16:07.25*** join/#uphpu PoeticIntensity (n=jason@70.96.176.8)
16:07.25*** mode/#UPHPU [+v PoeticIntensity] by ChanServ
16:07.29brastoIt has the most downloads out of the mail list apps in sf.net, so I thought I'd give it a try...
16:08.00brastothe code is horrible on some pages - they use short tags on several of them for example.
16:08.18mgearywhat does it do?
16:08.51brastoits a mail list manager, like the mail list uphpu uses
16:08.53beandogman
16:08.55mgearyah, right
16:08.58mgearyi use mailman
16:08.59beandogI cannot get php + TLS working
16:09.00beandogbuh.
16:09.03brastowps, what mail list software do you use?
16:10.14brastophp list has had a bug report on their short tag pages for about 2 years, and still haven't gotten 'round to fixing it.
16:10.25brastophplist, that is - one word.
16:11.26mgearybrasto: have you tried mailman? it's pretty easy to use
16:12.45PoeticIntensityTLS?
16:12.49PoeticIntensitywhat's that, beandog ?
16:13.04beandogGNU's Transport Layer Security
16:13.05beandoglike SSL
16:13.50PoeticIntensityah.
16:14.24PoeticIntensityman.... I've got the postgres bug now, beandog.  I was up late converting one of my projects.
16:14.33beandogheh
16:14.34PoeticIntensityI have no idea if I'll like it or not, but..... so far, so good.
16:15.01brastomgeary, i have not tried mailman yet
16:15.02PoeticIntensitywhat's up with the sequence (auto_increment) not automatically updating itself?
16:15.06Lone_Wandererheh, you've been infected?
16:15.09wpsbrasto, I use Mailman
16:15.28brastoi may, but i thought i'd try phplist first since I'm a php guy, and not familiar with python
16:15.34wpsit's a beast to configure, but once you get it setup, it runs and runs
16:15.37beandogPoeticIntensity: use serial data type
16:15.37mgearybrasto: you don't have to be
16:15.39wpsexcellent work horse
16:15.41PoeticIntensitylike.... I manually insert an ID in the id field which is a SERIAL type. and the sequence doesn't figure it out.  So upon next insert it tells me there's duplicate keys.
16:15.49PoeticIntensityit is serial type.
16:15.54beandoghmm.
16:16.37PoeticIntensityI ran a batch insert of 2500 rows, and the sequence for that table still has a next_value of 1
16:16.46PoeticIntensity???????
16:16.57jsmithPoeticIntensity: You're not supposed to insert the ID column manually
16:17.19jsmithPoeticIntensity: You do the INSERT with the ID column set to "DEFAULT", and the sequence will automagically insert the next value
16:17.36jsmithPoeticIntensity: Or, you can use "ALTER SEQUENCE" to reset the next value
16:17.50PoeticIntensityjsmith, yeah...  However, I'm transferring IDs from a MySQL table to the Postgres one.  I want the IDs to match.
16:17.51Lone_WandererWhat do you call the quotes in a newspaper column that are larger than the rest of the text and usually floated?
16:17.58Lone_Wandererdropquotes?  block quotes?
16:18.20beandogPoeticIntensity: just make it an integer first then, and change it to serial afterwards.
16:18.30jsmithPoeticIntensity: Then do the inserts, and then use "ALTER SEQUENCE blah blah blah RESET foo" to set the next sequence ID
16:18.33beandogwell, its always an integer.
16:18.38beandogbut just with a sequence on it.
16:18.43PoeticIntensitybeandog, yup.
16:19.01PoeticIntensityjsmith, .... yeah...  hrmmm.....
16:19.10PoeticIntensitythought postgres would be smart enough to handle crud like that.
16:19.16PoeticIntensityare there a lot of little gotchas like that?
16:19.26PoeticIntensityMySQL didn't have trouble.....
16:19.43Lone_WandererWhat's the purpose of having a separate sequence that's not a part of the table, btw?
16:20.04PoeticIntensityLone_Wanderer, I have no idea.  I suppose that's the way Postgres does it.
16:20.13PoeticIntensityI'm not sure there's a way to have it included in the table.
16:20.20jsmithLone_Wanderer: So you can have different tables share a sequence
16:20.37Lone_WandererWhen would you want to do that?
16:21.04jsmithLet's say you had a bunch of people... some were merchants, and some were consumers
16:21.08Lone_Wandererok
16:21.50jsmithAnd you wanted to give them unique IDs (but not resort to have merchant_ids and consumer_ids)
16:22.08Lone_WandererSo you have a merchants table and a consumers table and you want an ID that's unique across tables?
16:22.15jsmithExactly
16:22.26Lone_WandererOkay, but why is that helpful, if you've got two separate tables?
16:22.38jsmithI'm not saying that's necessarily the best way to do it, I'm just saying that's *one* reason to have the sequences seperate
16:22.45Lone_WandererDoes it require an understanding of Postgres being object oriented?
16:22.57jsmithNo.
16:22.59Lone_Wanderer'cause I don't completely understand that part either.
16:23.00Lone_Wandererok
16:33.33beandogpostgres is great
16:33.51beandogtheres a few things that are different from everything else, but the more you use it, the more psql's methods make sense.
16:35.00mgearytell us more
16:35.05mgearyconvince me :)
16:35.16Lone_WandererWhat characters are invalid in a URL?
16:36.00fungusIt's probably easier to define what characters are *valid* in a URL.
16:36.26Lone_WandererI'm creating a vanity URL thing
16:36.44Lone_Wandererso an admin user can enter a string, and then an ID, and they get dropped into the DB
16:37.25Lone_Wandererand a custom 404 page will look up the URL that was requested, match it to the strings entered by the admin, and if it finds a match, forward the user to the profile with the ID
16:37.28Lone_Wandererthat the admin entered
16:37.57Lone_Wandererso I just need a way to validate the string to make sure the admin doesn't enter something that will break in a URL.
16:38.29beandogcant you just use http_url_encode or whatever it is.
16:39.02Lone_WandererWell yeah but the end user won't necessarily type www.islandbeats.com/some%20thing
16:39.32Lone_WandererI could urlencode and then compare with the original string and if they match then we're good
16:41.00PoeticIntensityso mgeary, you like Postgres?
16:41.45PoeticIntensityThis might be flamebait, but it's not intended as such:, but... how many people in here use / like Postgres - and why did you end up choosing it?
16:42.02mgearyi've installed it, but never really *used* it. with the new MySQL features, i can't find a compelling reason
16:42.05PoeticIntensityI'm in the process of seeing if we should switch our main business db over to postgres or not.
16:42.28PoeticIntensitymgeary, thanks.  Anyone else (besides beandog.  I know your reasons... :) )
16:42.33beandognot that anyone cares, but I'll post my response ... I cut my teeth on Postgres as the first DB I ever used, and using mysql in comparison is a pita.
16:43.27PoeticIntensityhowever, it's a pita for the same reason that Postgres for me now, is a pita.  Not necessarily because it's better or worse, but just because it's new.
16:43.33Lone_WandererI asked on #postgresql.  Sequences are also useful if you want to get the ID of the next insert before you do the insert.
16:43.52thebigdogPoeticIntensity, i started with mysql and postgres...but moved to pgsql for the advanced features i needed
16:43.54beandogWell, for me its a pain because postgres has so many features that mysql does not.  So its like using Linux for a good while then going to DOS.
16:44.31thebigdogmysql and pgsql both have their place
16:44.36PoeticIntensitythebigdog, I'm assuming you mean triggers, stored procedures, etc....
16:44.46thebigdogyes
16:44.46PoeticIntensitythe stuff that My 5.0 now has.
16:44.55thebigdogyes
16:45.07thebigdoghowever, one thing to remember is that it is new in mysql...so it will be buggy
16:45.22jsmithPoeticIntensity: I used to manage several hundreds of terabytes of MySQL data, so that's why I prefer PostgreSQL
16:45.22thebigdogpsql has had them for years and has had time to improve/stabilize it
16:45.36beandogbesides, nothing beat's psql's tab-completion.
16:45.37PoeticIntensityjsmith, now THAT is interested to me.
16:45.40jsmithMVCC is another good feature
16:45.46PoeticIntensityinterested = interesting.
16:45.49Lone_WandererWow.  Postgres is awesome.
16:45.51thebigdogi got my new 11tb raid today
16:46.09thebigdogyeah i have pgsql dbs with millions and millions of records
16:46.11Lone_WandererThey just named three things (I think it was three...) that I've had problems with in MySQL that Postgres's sequences solve.
16:46.13mindjuju11 tb?
16:46.16mindjujui'm jealous
16:46.24thebigdogyeah with my 6.3 and 3.1
16:46.32thebigdogi need to take some pics of it
16:46.33mgearybeandog: what about this tab-complete?
16:46.38PoeticIntensityLone_Wanderer, mind expouding?
16:46.41PoeticIntensityman.....
16:46.48thebigdogmysql should have tab completion too
16:46.48beandogmgeary: basically it works on everything, all indexes, sequences, tables, columns, etc.
16:46.52beandogmysql does
16:46.54mgearywhere
16:46.54mgeary?
16:46.56beandogbut psql's is more extensive.
16:47.01thebigdogtrue
16:47.08Lone_WandererWell there's the one I just said above (getting the next insert ID before you perform the insert)
16:47.15PoeticIntensityyeah...
16:47.15mgearywhat are you doing when you utilize the tab-completion? command-line queries?
16:47.21beandogYah.
16:47.22thebigdogmy thing is that if you need a lightweight db then mysql is great
16:47.24beandogI use psql all the time.
16:47.38thebigdogbut if you need a heavy hitter and advanced features then psql is great for that too
16:47.38Lone_WandererThen there's the issue of assigning a user ID early on in the signup process and knowing that it's unique, without knowing whether the user will finish their signup
16:48.07PoeticIntensitythat's pretty nice.
16:48.13thebigdogthat what a transaction is for
16:48.15beandogwhy would you assign a user id early?
16:48.22Lone_WandererYou can use a sequence to get a unique number and stick it onto a user-supplied string and say "This is your username"
16:48.34PoeticIntensityjsmith, so in your opinion, PG handles large dbs better than Mysql?
16:48.37Lone_Wandererthen let them do the rest of the signup, and you know it'll still  be unique by the time they finish the signup
16:48.51beandogokay, thats a good reason.
16:48.53jsmithPoeticIntensity: Definitely... ever had a table take 12 days to run "myisamchk" on it?
16:48.59PoeticIntensityROFL
16:49.01thebigdogjsmith we need to write that pgsql book we have been talking about
16:49.08Lone_WandererPI: Postgres handles large DB's much better.  It's actually faster than MySQL for large tables.
16:49.15thebigdogpgsql for everyone
16:49.22jsmiththebigdog: Whenever you're ready, my friend... just let me finish up the 2nd Edition of Asterisk: The Future of Telephony
16:49.25PoeticIntensityusing MyISAM, I can understand.... but it's also better than innodb?
16:49.37thebigdog2nd edition....ouch
16:49.39thebigdogalready
16:49.40jsmithPoeticIntensity: InnoDB has some nice features, but it's slower
16:49.44Lone_WandererYeah.  It offers lots of optimization tricks that MySQL doesn't offer.
16:49.52jsmiththebigdog: Yup... tech moves quickly
16:49.55thebigdoginnodb cracks when you get alot of data in it
16:50.02Lone_WandererFor small tables MySQL is faster, but the speed doesn't scale.
16:50.05jsmiththebigdog: (Especially when you're writing about "the future" of anything)
16:50.11thebigdoglol
16:50.29thebigdogbut the future is that...a big ?
16:50.49PoeticIntensitywell...  Thanks for all your responses...  I'm amazed I didn't start a flame-war, but then again, this is UPHPU.  I love this place.
16:50.53jsmithSure, MySQL now supports things like enforced referential integrity and views, but PostgreSQL has then *AND* has the experience to do them well.
16:50.56mindjujuugh, i feel like kicking my padawan in the jimmies
16:51.06PoeticIntensityI think I'm gonna go full-guns-blazing toward PGSQL.
16:51.24jsmithPoeticIntensity: w00t!  We knew you'd see it our way ;-)
16:51.34PoeticIntensityheh.... I'm honestly curious to see what will happen.
16:51.51jsmithTo be 100% honest though, it's the non-obvious things about MySQL that drove me nuts
16:51.54PoeticIntensitynot sure if our company will ever switch, but.... I'm gonna learn it regardless.
16:52.18jsmithLike the "MySQL won't use more than one index on a query" thing... (which *hopefully* got fixed in 5.0, but I'm not sure)
16:52.38beandogjsmith: it doesnt?  lols
16:52.43jsmithHow in tarnation are you supposed to do anything useful with a database if you don't use a bunch of indices?
16:52.49jsmithbeandog: Nope.
16:53.00jsmithbeandog: I think 5.0 finally does, but only for certain database types.
16:53.09jsmithbeandog: Certainly not for MyISAM tables
16:53.27Lone_WandererIs there a way to just get the difference between two strings?
16:53.29jsmithYou guys want to hear my favorite MySQL-related annoyance?
16:53.38PoeticIntensitygo for it.
16:53.57Lone_WandererLike foo("abcd", "abce") will return 3, because the 3rd char in the two strings are different?
16:54.20thebigdogLone_Wanderer, in php?
16:54.23jsmithLet's say you have a table where you're counting events... every time you see an event, you increment the value of one column, right?
16:54.24Lone_WandererYeah.
16:54.32PoeticIntensityright.
16:55.54jsmithAnd then you want to pull a report, but you want to pull the events with the highest count, so you end up doing something like:
16:56.19jsmithSELECT event_id, event_count FROM events ORDER BY event_count DESC LIMIT 5;
16:56.23jsmithEverybody with me?
16:56.26PoeticIntensityyup
16:56.46Lone_Wandereryeah
16:56.57thebigdogLone_Wanderer, i dont think there is a function to do that but you can create one
16:57.03jsmithWell, to make a long story short, you'll get some performance gain by actually decrementing the counters instead of incrementing them, and then doing your ORDER BY ascending instead of descending
16:57.07thebigdogusing strpos and the other strcmp functions
16:57.13Lone_Wandererthebigdog: Yeah I'm not finding one, looks like I get to write my own.
16:57.30thebigdogLone_Wanderer, you can write one for php and then submit it
16:57.31thebigdog:)
16:57.33Lone_WandererI think I'm going to have to just recurse over the string as an array, comparing each character as I go.
16:57.39Lone_WandererMaybe I will :p
16:57.42jsmithbeandog: Even better:  BEGIN; DELETE FROM *; -- Oops!; ROLLBACK
16:58.17beandogheh
16:58.31beandogtransactions, views and foreign keys are enough to make me switch.
16:58.37jsmithI've saved myself *numerous* times with careful use of transactions and savepoints
16:59.03PoeticIntensityvery, very interesting.
16:59.19jsmithI still think MVCC is the best feature though... no more stupid locking problems
16:59.37jsmith"Gee, I gotta lock the whole table just so I can backup my database"
16:59.46beandoglame.
17:01.14beandogah well.
17:01.23beandogwe all know mssql is the one true option.
17:01.31beandogyou closet freaks just wont admit it.
17:03.15thebigdogsybase...with geo spacial containers rocks
17:03.41thebigdogdb2 rocks as well
17:05.28mindjujutoo bad this stuff didn't exist when i was in high school
17:05.29mindjujuhttp://www.gizmowatch.com/entry/top-technologies-that-cracked-the-holy-grail-of-invisibility/
17:07.42beandoghttp://www.faqs.org/docs/ppbook/book1.htm
17:08.36jsmithdBase III+ is where it's at
17:08.59jsmithbeandog: After the week I've had fighting SQL Server, I don't think it qualifies as a *real* database any more.
17:09.05beandogheh
17:09.14beandogI dont think it ever did.
17:10.20Lone_WandererI think he means that he doesn't think it any more.
17:10.29Lone_WandererNot that it became a fake server over the weekend.
17:10.39beandogmssql is a truly horrible database.
17:10.47beandogI cannot warn you enough to stay away.
17:18.51mindjujusuch hate for ms sql!
17:19.33Lone_WandererYay, got my URL fixing thing done.
17:19.38Lone_WandererIt's actually not that complex.
17:19.56Utah_Davebrasto: try looking at this php mailing list project: http://pommo.org
17:25.22Lone_Wandererhttp://dpaste.com/hold/8248/ if anyone wants it
17:27.38beandogIf youre checking for spaces you could just do if(preg_match('/\s/', $foo))
17:27.56Lone_WandererI had it just checking for spaces before
17:28.11beandogbut you could just use a regexp for the whole thing, but I dont know what the set of accepted chars is. :T
17:28.36Lone_WandererI don't either.
17:28.36Lone_WandererWhich is why I used urlencode :p
17:28.36beandoglet them do all the work. :)
17:28.40Lone_WandererExactly.
17:28.52Lone_WandererWell, she'll learn pretty quick which characters are allowed and which aren't.
17:29.11beandogLooks like A-Za-z0-9-_
17:29.12beandogand that's it.
17:29.32beandogReturns a string in which all non-alphanumeric characters except -_. have been replaced with a percent (%) sign followed by two hex digits and spaces encoded as plus (+) signs.
17:29.34beandogmaybe.
17:29.44beandogmeh.
17:29.47beandoglet the function do it.
17:29.51Lone_WandererI have already written my code and have no intention of changing it to accommodate your regexp fetish! :-{
17:31.31mindjujulmao
17:31.53Lone_WandererNow fetch me my swyrd and ready mine finest stallion, for I've a duel to attend in Knotsburry.
17:32.01Lone_WandererHmm.
17:32.55beandogwtc.
17:33.01beandogwhy does SquirrelMail need 52 megs of ram.
17:33.05Lone_Wandererrofl
17:33.11wpsSM sucks
17:33.19beandogFatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 524402 bytes)
17:33.31beandogwps: got a good alternative?  Im open to suggestions.
17:33.40wpsno, unfortunately
17:33.50beandogI didnt like horde last time I tried it.
17:34.19beandog52 megs though ... what in the world is it doing.
17:34.43wpsshelling walnuts
17:35.08Lone_Wandererand burying them in my front yard so that when Spring comes I've got a ton of oak trees trying to spring up.
17:35.25mgearyumm
17:35.32mgearywalnuts -> oak trees?
17:35.36mgearythat's a good trick
17:35.43Lone_WandererFor some reason I read that as acorns.
17:35.58wpsthe internet is a crazy place
17:36.09jsmithbeandog: It's trying to load all your messages into memory
17:36.19beandoghmm, could be.
17:43.06herlo~seen emcnabb
17:43.31jbotemcnabb is currently on #utah, last said: '~lart elg '.
17:43.31herlowoops
17:43.56fungus~lart emacnabb
17:43.56jbotjudo chops emacnabb
17:47.10Lone_WandererIs it possible to put a "unique" constraint on a column in MySQL?
17:47.16Lone_WandererOther than a primary key column
17:47.17mgearysure
17:47.33mgearydo you use phpMyAdmin?
17:47.44Lone_WandererAhh, there it is.  Yeah.
17:47.47Lone_WandererJust found it =)
17:59.00*** join/#uphpu burnin (n=burnin@204.228.142.194)
18:11.42thebigdogdoes anyone know off hand if a disabled select will still post the value?
18:12.08thebigdogim thinking it does...but cant remember if im confusing it with a checkbox
18:19.01beandogthebigdog: no, it wont.
18:19.12beandogoh, select?
18:19.16beandogdisabled?
18:19.20beandogdunno.
18:19.21thebigdogy
18:19.25beandogI thought you said checkbox.
18:20.20mgearyno
18:20.21mgearythe diff between disabled and read-only is that disabled will NOT send the value
18:20.21mgearywhile readonly will
18:20.27mgearydisabled will prevent any form element from sending it's name/value
18:24.16*** part/#uphpu brasto (n=brasto@71-219-154-236.slkc.qwest.net)
18:27.28Lone_WandererDo all browsers respect disabled and readonly?  I thought some of them ignored them.
18:29.59thebigdogyep disabled will not send...so i just need to add hidden fields
18:30.53mindjujujust remember hidden fields are quiet so hidden
18:30.53thebigdogi was just looking in the form view for firefox and it showed the values
18:30.53thebigdogyeah
18:31.16mgeary"just remember hidden fields are quiet so hidden" mindjuju what does that mean?
18:31.32mgearyan, "aren't quite so hidden", perhaps?
18:31.45mindjujuyeah
18:31.48mgearyyeah
18:31.49mindjujuthx for the correct
18:32.18mgearyaww
18:32.21mindjujuheh
18:32.34mgeary~fishslap mindjuju
18:32.45jbotACTION slaps mindjuju up side the head with a wet fish.
18:33.00thebigdog~tunafart room
18:33.02jbotACTION eats a week-old tuna sandwich with relish and walks over to room, leg raised, to let 'em rip.
18:33.24mindjujutunafart is by far, my best jbot creation
18:33.38thebigdogyes, one of my favs
18:33.44thebigdog~melvin mgeary
18:33.46jbotACTION pulls mgeary underwear up to the ceiling...and smiles
18:33.50thebigdogthat is my next fav
18:34.03mgearyis there a way to get a list of all the defined actions from jbot?
18:34.51thebigdogyeah you have to ask jbot for them
18:34.52mindjujulike all commands baked in, or the ones we wrote
18:34.58thebigdogor mindjuju
18:35.03mgearythe custom ones
18:35.10mgearyyou can "help" to get a bunch of built-ins
18:35.27mindjujuyeah, it seems like list will do it
18:35.38mindjujubut list uses RegEx
18:35.46mindjujuso you have to kinda piece them all together
18:35.57mindjujui've got a decent list going
18:35.57mgeary"one warez list being sent"
18:36.00mgeary?
18:36.04mindjujuthough others have added recently and I don't have them
18:36.10mgeary~list
18:36.12jbotone warez list being sent
18:36.16mgearysee?
18:37.11thebigdogmgeary you could grep the logs too
18:37.17mgearywell yeah
18:37.37mgearystands to reason that there's some interface to jbot to get them directly
18:37.45mgearyeeh
18:38.44jsmith~literal list
18:38.46jbot"list" is "<REPLY> one warez list being sent"
18:45.13thebigdogmgeary you can always ping riker
18:45.22thebigdogtim riker
18:46.06mgearywho's that?
18:47.26mgearyah
19:04.44*** join/#uphpu _psychic_ (n=_psychic@66.7.114.126)
19:04.44*** mode/#UPHPU [+v _psychic_] by ChanServ
19:37.02*** join/#uphpu _psychic_ (n=_psychic@66.7.114.126)
19:37.02*** mode/#UPHPU [+v _psychic_] by ChanServ
20:13.02*** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog)
20:13.02*** mode/#UPHPU [+v beandog] by ChanServ
20:29.33beandogbah.
20:29.38beandogI cant remeber how to rename a column in mysql4
20:31.23mgearyi just use phpMyAdmin to do it
20:32.15beandogslacker!
20:32.15jsmithbeandog: ALTER TABLE my_table RENAME column old_name new_name, I think...
20:32.18beandogyah I tried variations of that, no me workie
20:32.21beandogcan't find it in the docs.
20:32.21beandogmeh.
20:32.22beandogoh well.
20:35.29thebigdogalter table <table> change <oldcol> <newcol> olddefinition;
20:35.34beandogwell, it's throwing an error too
20:35.37beandogI guess I'm not changing it.
20:36.13thebigdogor without olddefinition then you need to add the column def again
20:36.30thebigdogalter table orgs change o_name org_name varchar(64);
20:36.35beandogright
20:36.38beandogthat threw a nasty error.
20:36.47thebigdogwhat version of mysql?
20:36.53beandogwhich isn't documented either.
20:36.53beandog4.0.x
20:37.10thebigdognot sure if you can rename
20:37.11beandogERROR 1025: Error on rename of './formsurf/#sql-262_228' to './formsurf/product_options' (errno: 150)
20:37.26beandogoh well.
20:37.30thebigdogpsql +100
20:37.49beandogheh
20:39.58thebigdogrenaming is so important in design
20:42.29PoeticIntensityyup.
20:43.39PoeticIntensityyeah... I Don't think you can rename in MySQL.
20:43.42PoeticIntensityjust create a new row.
20:43.48PoeticIntensityer.... field.
20:43.57PoeticIntensitythen update newfield = oldfield
20:44.01PoeticIntensitydelete oldfield.
20:44.39beandogmeh
20:44.43beandogtoo much work, with the fkeys.
20:44.52PoeticIntensitydarn.
20:44.53beandogI just found out audacious has the coolest feature evah.
20:45.02PoeticIntensityamarok++
20:45.06beandogIf you mouse over ther icon in the tray list and scroll up and down, it changes the volume
20:45.07beandog:D
20:45.21beandogamarok can die in a puddle of its own ignorance and audacity for all I care.
20:45.22PoeticIntensitywow... amarok has been doing that since like.... 1876.
20:45.31beandog1876?
20:45.35PoeticIntensity1876.
20:45.51beandog~mint PoeticIntensity
20:46.13PoeticIntensityaudacious is nothing more than an amarok wannabe.
20:46.18beandogLOL
20:46.20PoeticIntensityamarok rulez th3 pl@n37.
20:46.21beandogyouve never even used it.
20:46.22PoeticIntensityso there.
20:46.22beandogjerk.
20:46.32PoeticIntensityI used it once.
20:46.37PoeticIntensityfelt like xmms.
20:46.38PoeticIntensityso I hated it.
20:46.40beandogI will not hear these lies.
20:46.42PoeticIntensitybecause I loved XMMS.
20:46.52PoeticIntensityand now XMMS has died.
20:46.59PoeticIntensitytherefore audacious must die.
20:47.04PoeticIntensitytwice.
20:47.04beandogpoor XMMS
20:47.24PoeticIntensityleave Charlie out of this, you insensitive clode.
20:47.34PoeticIntensityCharlie is NOT dead.
20:47.42beandogI'm a clode?
20:47.42PoeticIntensityhe's.... just..... asleep.
20:47.47PoeticIntensitysomewhere.
20:47.54PoeticIntensityasleep.
20:47.57PoeticIntensitynot sweep.
20:48.03PoeticIntensitygood night, man....
20:48.14PoeticIntensityI don't think I've been this bored at work.... ever.
20:48.21PoeticIntensityI've gotta go compile something.
20:48.26beandogaudacious
20:48.29beandogif you can pull it off.
20:48.39PoeticIntensityI will no compile audacious.
20:48.43PoeticIntensityno no no!
20:49.00PoeticIntensityaudacious deserves ....... something bad.
20:49.12thebigdogaudacious rocks
20:49.12PoeticIntensityI think I need 3 more monsters.
20:49.22PoeticIntensityaudacious needs an enema.
20:49.25mgeary~buy PoeticIntensity monster
20:49.28jbotACTION goes to S-Mart and gets a dozen monsters for PoeticIntensity
20:49.33PoeticIntensitywoot!
20:49.40PoeticIntensitythanks, mgeary!  You're a pal.
20:49.47mgearyyep
20:50.51PoeticIntensityI need Friday.
20:50.52PoeticIntensitynow.
20:50.57PoeticIntensityanyone got one?
20:51.11PoeticIntensity~kick mindjuju
20:51.13jbotACTION kicks mindjuju
20:51.24PoeticIntensity~lart beandog
20:51.24jbotpulls out a ClueBat (tm) and thwaps beandog
20:51.32PoeticIntensitybah....
20:51.39PoeticIntensity~rlart
20:51.41jbotgives com4 a good seeing to
20:52.08beandogLOL
20:52.12beandogwhat a nerd.
20:52.18beandogwho uses firefox?!
20:52.31PoeticIntensitywho uses audacious.
20:52.33PoeticIntensitybah.
20:52.36PoeticIntensityinfidels.
20:52.38beandogyour mom.
20:52.51PoeticIntensityI just called your mom.
20:52.52beandogI just called her.
20:52.54beandogLOL
20:52.54PoeticIntensityhold on
20:58.29PoeticIntensityhttp://store.cottonfactory.com/cf-478.html
20:58.36PoeticIntensitythat's what I want for my B-Day... :)
20:59.46PoeticIntensity:-(
21:01.57beandogLMAO
21:02.02beandogwho is that?
21:02.34PoeticIntensityAmerican Idol guy...
21:02.39PoeticIntensitySan-poo-poo.
21:03.04beandogboy you can tell they spend about 2 seconds designing each one of these
21:03.13PoeticIntensitythey're FREAKING HILARIOUS!
21:03.20beandoghttp://store.cottonfactory.com/cf-024.html
21:03.22beandogooh momma
21:03.23beandogIm im love.
21:03.38beandogI dont want yellow though
21:03.39beandog:C
21:03.57_psychic_dunno why there's a ladies version of that one :)
21:03.59mgeary;)
21:04.01mgearyhahah
21:04.02mgearyhahahahaha
21:04.04_psychic_jinx!
21:04.09mgeary12345568901-
21:04.10_psychic_12345678910
21:04.11mgearywhatever
21:04.13_psychic_haha
21:04.16_psychic_you owe me a coke
21:04.23_psychic_rofl
21:04.45mgeary~buy _psychic_ coke
21:04.55jbotACTION goes to S-Mart and gets a dozen cokes for _psychic_
21:05.28_psychic_wee
21:07.11PoeticIntensityhttp://www.computergear.com/humstuptshir.html
21:07.28PoeticIntensityhttp://store.cottonfactory.com/cf-306.html
21:08.10beandogTHAT one is classic
21:09.40PoeticIntensityI want any of those, or.... this one:
21:09.49beandoghttp://unicorns.com/store/customer/product.php?productid=688&cat=1&page=1
21:09.55PoeticIntensityhttp://store.cottonfactory.com/cf-256.html
21:10.23beandogPoeticIntensity has the weirdest taste.
21:10.29mgearyOMG PONIES!
21:10.31PoeticIntensityshut it.
21:10.34beandoghttp://www.pbfcomics.com/things.php?link=shirts
21:10.37beandogI so want that pink one
21:11.00mgearythat's a *nice* unicorn
21:11.20mgearywonder which 6-year-old they had draw it
21:12.24PoeticIntensityhttp://store.cottonfactory.com/cf-421.html
21:12.25PoeticIntensityLOL
21:12.37beandogLMFO
21:12.39beandogas;dlkfj
21:12.44beandogLOL
21:12.52beandogOh man
21:12.54beandogIm getting that one.
21:12.55beandogright now.
21:13.43mgeary~buy beandog t-shirts indicating that he believes that unicorns do indeed fall on their face
21:13.58jbotACTION goes to S-Mart and gets a dozen t-shirts indicating that he believes that unicorns do indeed fall on their faces for beandog
21:13.58PoeticIntensityhttp://store.cottonfactory.com/cf-414.html
21:14.10beandog:D
21:14.54beandogunicorns!
21:16.17PoeticIntensityhttp://store.cottonfactory.com/cf-323.html
21:16.57beandogoh man
21:16.59beandogwtc?
21:17.20beandog~lart PoeticIntensity's poor taste
21:17.20jbotpours gasoline all over PoeticIntensity's poor taste, ignites the fire, and then enjoys some toasty marshmallows with the glorious blaze
21:17.20beandog:)
21:17.22PoeticIntensity:-C
21:20.56beandogman
21:20.58beandogtalk about spring fever
21:25.27PoeticIntensityno doubt.
21:30.02beandogooh look
21:30.05beandogI bought myself some M&Ms
21:30.06beandogI'm so nice.
21:30.09mgearyyou guys all aware of this? http://mozy.com/contest
21:30.59herlomgeary: yes
21:31.09mgearyanyone gonna enter?
21:31.52beandogIm thinking about it.
21:32.04beandogI havent publically made a fool of myself in a while
21:32.12beandogunless you count coming in here every day
21:32.29beandog~melvin PoeticIntensity
21:32.37jbotACTION pulls PoeticIntensity underwear up to the ceiling...and smiles
21:34.18PoeticIntensityLOL
21:34.29PoeticIntensitydude.... I'd get eaten *alive* in that contest.
21:34.31PoeticIntensityI'm a PHP junkie.
21:34.36PoeticIntensityI don't know how to program.
21:34.39mgearyheh
21:36.37optikalAnyone in here played with ajax and state checking in opera?
21:37.39PoeticIntensityI can try to sing it, if you like.
21:37.50PoeticIntensity~lart beandog
21:37.50jbotpulls out his louisville slugger and uses beandog's head to break the homerun record
21:37.55beandogooh
21:37.57beandogI like that one.
21:38.07beandogoh geez, that was a bad joke.
21:38.08PoeticIntensityI like that one because it has beandog's name in it.
21:38.18beandoglouisville?
21:38.51PoeticIntensityI've gotta go driving.
21:38.52PoeticIntensityI'm going insane.
21:42.27beandoghmm.
21:42.33beandogpobrecito
21:42.40mgearyhey, i just found a good reason to use __destruct
21:43.08beandogoh yah?
21:43.09mgearyi'm building a parser object that will process a CSV file. The constructor creates a file pointer, and the destructor closes the pointer. whee
21:43.20mgearydon't have to worry about manually closing the file
21:43.33beandogyah there you go
21:43.34beandog:)
21:43.41beandogmgeary: Ive got a CSV class if you wanna see it
21:43.48mgearysure
21:43.52mgearywhat kind of methods does it have?
21:43.57beandoguh
21:44.03beandogI dont remember.
21:44.05mgearylemme see, lemme see
21:44.08beandoglemme see if I can even find it.
21:44.09beandoghold on
21:44.44unumI have a one(project) to many(date) relationship and I want a list of projects in order by the first date
21:45.00unumcan anyone help me with the sql syntax
21:45.11unumI tried distinct on (project_index)
21:45.32mgearyno, that wouldn't do it
21:45.32beandoghere, I dont feel like uploading it
21:45.32unumthis is psql
21:45.32beandoghttp://rafb.net/p/AbmOHH94.html
21:45.32beandogmgeary: ^^
21:45.48mgearycool. thanks
21:46.33beandogits a bit messy ... but it works
21:46.34beandog:T
21:46.41mgearyunum: that's a good question... *thinks*
21:46.42beandogyou'll probably just be able to get some ideas, and that's it.  if that.
21:47.15beandogunum: oh, ive done that before... that is tricky.
21:47.17beandoglemme think.
21:47.35beandogI think you can do a subselect
21:48.11beandogSELECT project, (SELECT date FROM foobar WHERE id = project LIMIT 1) as date ..
21:48.15beandogI *think* that might work.
21:48.16beandogmaybe.
21:48.23mgearyput an order by before your limit
21:48.25beandogthat doesnt seem right.
21:48.37mgearyno, do it in the join
21:49.15beandogAnyway
21:49.31beandogI know you can do something funky like having the JOIN work even though your'e selectin them both.
21:49.42beandogif that made any sense..
21:59.36unumSelect studies.study_index, MIN(studies_dates.date) from studies, studies_dates WHERE studies.study_index=studies_dates.study_index GROUP BY studies.study_index
22:00.42wpswow, the wind is sure howling
22:05.25*** join/#uphpu wps (n=wps@67.108.236.230.ptr.us.xo.net)
22:05.25*** mode/#UPHPU [+o wps] by ChanServ
22:13.11*** part/#uphpu mgeary (n=mgeary@166.70.44.49)
22:13.56Lone_WandererWhere are you Wade?
22:14.16Lone_Wandererwps rather
22:14.27wpsducking for cover
22:14.39wpsBYUMUG just experienced a PLUG moment
22:15.06Lone_WandererMUG?
22:15.20Lone_WandererI'm wondering where the wind is howling.  Worried about my dog being okay.
22:15.22herloLone_Wanderer: mac
22:15.25Lone_Wandererahhhh
22:15.32Lone_Wandererwell, mac users deserve to be flamed
22:15.34wpsMUG = macintosh users group
22:15.40wpshowling in Orem
22:15.43wpsbad
22:15.51Lone_WandererYou don't see Windows users forming groups, do you?
22:16.07Lone_WandererOr having parades, or wearing rainbows.
22:16.12wpsthere are a lot of windows user groups
22:16.17mindjujuGet these Frickin' Idiots off my admin site!!!
22:16.24herloLone_Wanderer: http://www.utwaa.org/
22:16.29beandoggah.
22:16.33beandogthat one is dead.
22:16.38herlobeandog: no, its not
22:16.42beandoguh, yes it is.
22:16.45Lone_WandererI don't know why Mac users feel the need to be so vocal just because they use Macs.
22:16.47herlobeandog: no, its not
22:16.54beandogyou want the domain?
22:16.54Lone_WandererYou don't hear me going on and on about how great my PC is.
22:17.04beandogLone_Wanderer: speak up boy
22:17.11herlobeandog: yes, i do
22:17.20Lone_WandererBesides, it clearly states in the Bible that God hates Mac users.
22:17.22beandogherlo: okay, get a godaddy acct and Ill transfer it to you
22:17.41herlobeandog: I'd rather not have a godaddy account, I already have one at tosdomains.net
22:18.21beandogherlo: meh.
22:18.26beandogherlo: I dunno how else to transfer it
22:18.28herlobeandog: you can transfer it there...
22:18.33herloI'll request it...
22:18.36beandogok
22:18.37herloyou'll get an email...
22:18.46herloand then they'll have you transfer it...
22:18.58Utah_Davetosdomains.net isn't coming up for me
22:19.10herloUtah_Dave: http://www.tosdomains.net/
22:19.13herloI'm there now
22:19.31Lone_WandererI need to get my ears cleaned out.
22:19.49beandogyou gotta love it when a technology website doesn't have foobar.com resolve, but www does
22:19.58Lone_WandererOh yeah baby.
22:20.09beandogthat always inspires confidence.
22:20.20Lone_WandererI like it even better when www.foobar.com goes one place and foobar.com goes someplace completely different.
22:20.49Utah_Davethere we go
22:20.58beandogheh
22:21.06Utah_Davemy credit union's website won't resolve without the www
22:21.16_psy-awaywhich is it?
22:21.33Utah_DaveI sent them an email about it.   got an email back which led me to believe they had no idea what I was talking about
22:22.15Lone_Wandererheh, what did it say?
22:22.20Utah_Daveoh, I guess they fixed it.  although the certificate doesn't match
22:22.21_psychic_Utah_Dave: which credit union?
22:22.25Utah_DaveUCCU
22:22.30Lone_WandererAhhhh.
22:22.33Lone_WandererI used to have an account with them.
22:22.37Utah_Daveuccu.com used to not resolve. but now it does.
22:22.48Lone_WandererBut yeah, technological ineptness there was irritating to me.
22:22.49Lone_Wanderer<3 macu
22:23.03Lone_WandererDo us proud, _psychic_.
22:23.06Utah_Davereally?
22:23.08Utah_Davecool
22:23.09_psychic_yeah
22:23.10_psychic_they're a client
22:23.14Lone_WandererNice.
22:23.24Lone_WandererAlso, re-open my account and give me two million dollars.
22:23.27_psychic_any wishes?
22:23.28_psychic_done.
22:23.31Utah_Davewhat part are you working on?
22:23.37_psychic_Utah_Dave: yes.
22:23.39_psychic_:)
22:23.53Lone_WandererMy primary pet peeve was that my actual account balance never matched up with what the web site said it was.
22:23.54Utah_Daveare you writing it with Cake?
22:24.00Lone_WandererIt was always several days behind.
22:24.15_psychic_Lone_Wanderer: we can't touch their online banking gateway
22:24.29_psychic_Utah_Dave: most likely
22:24.35Utah_DaveI hated that for the longest time we had to use our 4 digit pin to log in
22:25.35_psychic_The biggest complaints we heard was that the site is a little too complex
22:27.02_psychic_Utah_Dave: who replied to your email?
22:31.14Utah_DaveUm, lemme see
22:33.05Utah_DaveI can't find the email
22:36.28Utah_Daveit was quite a while ago. probably a couple years at least
22:57.09*** part/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net)
23:25.56beandoghow could Ben not tell Luke that Vader was his father?
23:25.56beandogtsk tsk.
23:31.29Lone_WandererNo kidding.
23:31.43Lone_WandererYou'd think they'd want to tell him the truth.
23:31.54Lone_WandererMaybe they figured they were sparing him an identity crisis or something.
23:32.08Lone_WandererOr maybe they were just waiting until he was "older".
23:33.22beandogwho knows.
23:33.39beandoghttp://youtube.com/watch?v=I2ZIozw2Ipo
23:33.39timinator<PROTECTED>
23:33.43beandogLone_Wanderer: you gotta watch that btw
23:33.51beandogI think that's it.
23:34.27Lone_WandererWatch what?
23:34.43beandogisland beast?
23:34.47beandogsounds fun.
23:34.47Lone_Wandereryeah :D
23:45.05*** join/#uphpu burnin (n=burnin@hongkong.machinage.com)

Generated by irclog2html.pl Modified by Tim Riker to work with infobot.