IRC log for #uphpu on 20080730

00:01.24swbhehe
00:01.29*** join/#uphpu Jacob_Kerr (n=Jacob_Ke@69-71-163-172.mammothnetworks.com)
00:01.36Jacob_KerrGood afternoon!
00:31.34*** part/#uphpu mgeary (n=mgeary@166.70.44.49)
02:05.22*** part/#uphpu Utah_Dave (n=David_Bo@72-166-51-162.dia.static.qwest.net)
02:05.29*** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com)
02:05.29*** mode/#UPHPU [+v burnin] by ChanServ
02:18.56*** join/#uphpu swb (n=designsi@box324.bluehost.com)
02:18.56*** mode/#UPHPU [+v swb] by ChanServ
02:56.15*** join/#uphpu mgeary (n=mgeary@72.8.120.115)
02:56.20*** mode/#UPHPU [+v mgeary] by ChanServ
03:14.47*** join/#uphpu Midorikawa (n=insanemo@75-169-221-132.slkc.qwest.net)
03:27.45*** join/#uphpu wps (n=wps@208.53.47.251)
03:27.45*** mode/#UPHPU [+o wps] by ChanServ
04:01.16*** join/#uphpu Utah_Dave (n=David_Bo@75-169-163-113.slkc.qwest.net)
04:01.16*** mode/#UPHPU [+o Utah_Dave] by ChanServ
04:43.35*** part/#uphpu Utah_Dave (n=David_Bo@75-169-163-113.slkc.qwest.net)
05:00.37*** join/#uphpu thebigdog (n=bigdog@zeus.thebigdog.biz)
05:00.37*** mode/#UPHPU [+o thebigdog] by ChanServ
05:08.52thebigdogwhat a beautiful day in the neighborhood....
05:31.57herlothebigdog: really??
05:32.15thebigdogyes it is storming out side and i love it
05:40.10herlowow, its hot here
05:40.12herloDallas
05:40.37thebigdogoh yeah
05:47.24herloyeah, I'm not happy about it, but its pretty nice being inside mostly
06:07.54thebigdogyeah
12:22.42*** join/#uphpu Utah_Dave (n=David_Bo@72-166-51-162.dia.static.qwest.net)
12:22.42*** mode/#UPHPU [+o Utah_Dave] by ChanServ
13:07.46*** join/#uphpu mindjuju (n=mindjuju@76.8.222.130)
13:07.46*** mode/#UPHPU [+o mindjuju] by ChanServ
13:22.33*** join/#uphpu bwelker (n=benjam@166.70.178.114)
13:23.47Utah_Davefor beandog:  http://xkcd.com/456/
13:24.26bwelkerlol
13:24.32bwelkersee.... linux is evil
13:32.34mindjuju~yow
13:32.49mindjuju~chuckfact
13:32.49jbotChuck Norris hand is the only hand that can beat a Royal Flush
14:20.19*** join/#uphpu _psychic_ (n=_psychic@75.148.101.137)
14:20.19*** mode/#UPHPU [+v _psychic_] by ChanServ
14:49.39*** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog)
14:49.39*** mode/#UPHPU [+v beandog] by ChanServ
14:53.00*** join/#uphpu fungus (n=olsonl@bromine.sosstaffing.com)
14:53.00*** mode/#UPHPU [+o fungus] by ChanServ
15:12.16*** join/#uphpu wps (n=wps@64.0.192.154)
15:12.16*** mode/#UPHPU [+o wps] by ChanServ
15:15.39unumI still think we need to teach jbot bruce facts
15:20.25*** join/#uphpu mgeary (n=mgeary@166.70.44.49)
15:20.25*** mode/#UPHPU [+v mgeary] by ChanServ
15:33.37*** join/#uphpu josephscott (n=josephsc@75-169-251-65.slkc.qwest.net)
15:33.37*** mode/#UPHPU [+v josephscott] by ChanServ
15:36.44*** join/#uphpu redroy_ (n=redroy@72.8.106.83)
15:55.57*** join/#uphpu thebigdog (n=thebigdo@0006yE-Yn.dsl.xmission.com)
15:55.57*** mode/#UPHPU [+o thebigdog] by ChanServ
15:58.12_psychic_anyone know regex for if I want to match a line that *doesn't* start with a certain strin?
15:59.38wpsput a bang in front of it
16:00.01wpsif you want to match lines that do not start with "money", then you would use
16:00.13wps!^money
16:00.31wps! = not, ^ = starts with
16:00.56mgearyi don't think that's correct
16:01.04wpsi use it all the time
16:01.52wpsat least with apache rewrites
16:01.58wpswhere/how are you using your regex?
16:02.15_psychic_textmate
16:02.18_psychic_that doesn't seem to do it
16:02.32wpsthat must just be an Apache thing then
16:02.36unumyou can use ^ inside of []
16:02.36mgearymust be, i think
16:02.42mgearyright, unum is correct
16:02.44_psychic_[^ ]
16:02.45_psychic_yeah
16:02.46_psychic_nice
16:02.46mgearythat's the usual way
16:02.58_psychic_^[^stuff]  == doesn't start with stuff
16:03.06mgearywell
16:03.08mgearyno
16:03.13jsmith_psychic_: No!
16:03.16mgearythat would mean: "doesn't start with s, t, u, f
16:03.18mgeary"
16:03.26jsmith_psychic_: That says "Doesn't start with a carat or s or t or u or f"
16:03.44jsmithunum: A carat inside square brackets is a literal carat
16:03.54mgearyi don't think so
16:03.57mgearyi think it means NOT
16:03.58_psychic_nor do i
16:04.02_psychic_It does mean NOT
16:04.30_psychic_http://www.regular-expressions.info/reference.html
16:04.36_psychic_[^a-d] matches x (any character except a, b, c or d)
16:04.54*** join/#uphpu timinator (n=timothy@c-98-202-102-189.hsd1.ut.comcast.net)
16:04.54*** mode/#UPHPU [+v timinator] by ChanServ
16:05.18wpsright, but things within brackets are ORs… you can't match a word within brackets
16:05.32_psychic_so how would I do that? :/
16:05.33mgearythat is correct
16:05.36wps[^money] won't match "money"
16:05.47wpsit matches m, o, n, e, or y
16:05.55wpswell, anything BUT those ;)
16:06.41mgearyi wonder if you could do:
16:06.56mgeary^(somestring){0}
16:07.16mgeary_psychic_: give us a more concrete example of what you need
16:07.19mgearywhat is the string in question
16:07.20mgeary?
16:07.33_psychic_I want to figure out how many CREATE TABLE statements are in a huge file
16:07.34wpsfrom what I have read, using ^ as a NOT only works within brackets
16:07.37wpsthere has to be a way though
16:07.46_psychic_so I was thinking to nix everything that doesn't start with CREATE TABLE
16:08.01mgearyhow huge?
16:08.06_psychic_15K lines
16:08.44mgearywell, do you simply want to know how many CREATE TABLE lines there are?
16:08.47_psychic_thought at this point figuring out the regex is just as important as getting my original answer :)
16:08.52mgearyheh
16:10.19*** join/#uphpu beandog (n=steve@gentoo/developer/beandog)
16:10.19*** mode/#UPHPU [+v beandog] by ChanServ
16:10.29*** join/#uphpu swb (n=designsi@box324.bluehost.com)
16:10.29*** mode/#UPHPU [+v swb] by ChanServ
16:11.12_psychic_I'll just grep it for ^CREATE and pipe it to wc
16:11.16mgeary_psychic_: here's a messy way to do it:
16:11.34mgeary"find lines not beginning with 'foo'":
16:11.40mgeary^([^f]|f[^o]|fo[^o])*.{0,2}
16:11.43wpsha ha ha
16:11.51_psychic_ouch
16:11.55mgearyyes
16:12.05timinatoryou could also explode it..... that doesn't use regex, and is supposed to be faster
16:12.13timinatorI've never used in that large of a string
16:12.19_psychic_grep ^CREATE foo.sql | wc -l
16:12.21timinatorbut explode it, then count the array
16:12.28_psychic_omg
16:12.32_psychic_have you guys seen magento?
16:13.23timinatorthen unset the array  :)
16:13.26timinatorto save space
16:14.00_psychic_http://www.magentocommerce.com/
16:14.09_psychic_dear goodness the sucker needs 195 tables.
16:14.17mgearyjeeze
16:14.34mgearywe've gotten so disgusted with available E-store solutions, we're building our own
16:14.57mgearyi hate how no e-store out there is designed to integrate with an existing users/logins table
16:16.44mgearyhey _psychic_
16:16.45mgearyhttp://wiki.hypexr.org/wikka.php?wakka=/RegexFAQ
16:16.58mgeary<PROTECTED>
16:17.37_psychic_interesting
16:18.15mgearyyeah, this works for me
16:18.23_psychic_yeah wfm too
16:18.27_psychic_nice
16:18.28_psychic_thanks
16:18.29timinatorI'm curious about what everyone thinks about my redneck solution.....
16:18.33timinatorwould it work?
16:18.37_psychic_moral of the story - stay far away from Magento
16:18.57_psychic_timinator: explode on 'CREATE TABLE' ?
16:19.04timinatoryes
16:19.26_psychic_splitting a MB of string probably would be slow but it'd work I bet
16:19.27mgearytiminator: he's in TextMate, not PHP
16:19.32timinatoroh.....
16:19.44timinatorthat's what I get for going online late in the AM, eh?
16:19.46timinatorLOL
16:19.52mgearynah, it's still a decent solution
16:19.59mgearyhowever
16:20.03mgearyyou could just do this:
16:20.54mgearygrep -v foo | wc
16:21.00mgeary-v inverts a grep
16:27.59*** join/#uphpu SunSparc (n=sparky@75.148.101.137)
16:27.59*** mode/#UPHPU [+v SunSparc] by ChanServ
16:28.25mgearyshh. here he comes
16:31.57SunSparc:)
16:32.48timinatorand a deafening silence falls over the room
16:33.09SunSparc~wake the room
16:33.09jbotACTION throws a barrel-full of ice water on the room and shouts "GOOD MORNING!!!!"
16:33.25beandogI need some Chips Ahoy
16:40.23*** join/#uphpu brasto (n=brasto@97-117-58-144.slkc.qwest.net)
16:40.25*** mode/#UPHPU [+v brasto] by ChanServ
16:44.51SunSparc~cookie beandog
16:47.05mgeary~prarie SunSparc
16:47.06jbotACTION takes SunSparc out to the prarie and shows him land so flat he can see the back of his head on the horizon
16:47.23mgearyjbot: prarie is spelled prairie
16:47.23jbotACTION takes is spelled prairie out to the prarie and shows him land so flat he can see the back of his head on the horizon
16:47.37mgearyjbot forget prarie
16:47.38jbotmgeary: i didn't have anything called 'prarie' to forget
16:47.47mgearyjbot, you're a bonehead
16:47.48jbotI know you are but what am I?
16:47.57SunSparcLOL
16:48.58SunSparcjbot, you're a super intelligent pan-dimensional being
16:48.58jbotI know you are but what am I?
16:49.02SunSparc:)
16:49.52beandogwhat's pan-dimensional?
16:50.04mgearypan == all
16:50.14SunSparc~wiki pan-dimensional
16:51.40SunSparc"Deep Thought is a computer that was created by the pan-dimensional, hyper-intelligent race of beings of planet Magrathea to come up with the ultimate answer to Life, the Universe, and Everything."
16:51.52unumbeandog: and in our dimension I'm represented as a super intelligent shade of blue
16:52.47unumI thought hitch hikers guide to the galaxy was required reading to join this channel
16:53.48SunSparcI thought so too
16:54.00SunSparcbeandog: you have some reading to do
16:54.15beandogif its anything like the movie, im not interested
16:54.23mgearynothing, nothing like the movie
16:54.27SunSparcIs any movie like the book?
16:54.30bwelkerhey cake bakers....   anyb ody know how to set up a dynamically generated file to download?
16:54.41unumwhich movie?
16:54.54bwelkerI have a client that wants vcards avail for download on the site, and I can make the vcard, but how do I force a download?
16:55.18jsmithbwelker: Set the appropriate Content-type header
16:55.27bwelkerin the layout file?
16:55.31SunSparcbwelker: set a header... yeah, what jsmith said
16:55.51bwelkerright, i know how to do it in normal PHP, but how do I set that up in Cake?
16:55.53SunSparcbwelker: yes, that is an appropriate place for the header
16:56.09SunSparcSince the layout encapsulates the page
16:56.12bwelkerok, i'll give that a whirl
17:16.19SunSparchttp://www.youtube.com/watch?v=E9VzZ4gUgVo
17:16.38mgearyyeah, that's classic
17:17.10SunSparc:)
17:17.43mgearyreally mean
17:17.54wpsI could barely understand him talking
17:17.58wpswhat was he getting revenge for?
17:18.02SunSparcIt looks staged
17:18.03wpswhy was she playing with the gun?
17:18.43mgearyit does look staged, but the wife does pull off a freaked out expression pretty durn well
17:18.50SunSparcEveryone loves to play with guns
17:20.24wpsif I want to index a column (mysql) that is not the primary key, is this the correct way?
17:20.24wpshttp://rafb.net/p/cEwjwR81.html
17:21.26mgearydon't think so
17:21.31mgearybut i always use PMA for that ;)
17:21.45wpsPMA is for girls
17:21.59wpsoops, sorry swb
17:22.16wpss/girls/jedi knights/
17:22.44wpsI think PMA is confusing… the interface is awful
17:23.25beandogI love PMA
17:23.41beandogwhats confusing about it?
17:24.49wpsit's fine… I just like things that are prettier to look at and I am used to the command line so it's weird for me to use
17:28.12SunSparcactually, PMS is for girls, PMA is for web dev geeks that don't know CLI.
17:31.54beandogthe CLI is awful
17:32.22mgearyit's not bad
17:32.25SunSparcIf by awful you actually mean awesome
17:32.26mgearybut pma is useful
17:32.34beandogIt's awful compared to psql
17:32.53SunSparcbeandog: Isn't everything?
17:32.55SunSparc:)
17:33.02beandogtab-completion sucks, error messages are unhelpful
17:33.18beandoganyway
17:33.25beandogno me gusta
17:33.26_psychic_psql?
17:33.31beandogSunSparc, pretty much
17:33.33SunSparcI agree, it could be better
17:33.58SunSparc~psql
17:33.58jbotrumour has it, psql is postgresql
17:34.13beandogits not that bad, I guess
17:34.16beandogjust has some annoying bugs.
17:34.43SunSparcbugs, or as the MySQL developers like to call them, features
17:35.05beandogInnoDB support is lacking, across the board
17:35.15beandogI wish PMA would support adding foreign keys
17:35.19beandogthat'd make my life much happier.
17:35.46mgearybrasto tells me that if you install the PMA aux database, it does support foreign keys
17:36.03_psychic_you guys heard of Drizzle?
17:36.08mgearyfer shizzle
17:36.23SunSparcVerio recently announced that they are removing the Innodb engine from all of their default MySQL installations because it has proved to be much more resource intensive.
17:36.28beandogmgeary, really?
17:36.31beandogI didnt know that
17:36.43mgeary^^ what brasto tells me. i haven't used that feature
17:36.43SunSparcI drizzle icing on my cupcakes
17:42.12beandogmgeary, thanks, Ill have to check that out
17:43.07beandogthats the major CLI problem I have with it.  If your syntax is wrong when creating an fkey, it'll give you an error completely irrelevant, and so you have to really hunt down where the problem is.
17:43.21beandogand the requirements are really obstinate
17:43.37beandogsame field type and length and unsigned status
17:43.44beandogplus it has to be indexed first
17:47.40beandogevil.
17:47.52_psychic_agreed.
17:48.01_psychic_wait
17:48.05_psychic_define "handle"
17:48.25mgearyif you've got a table with 4 auxiliary tables, related via foreign keys
17:48.31mgearyand you delete the primary table record...
17:48.45mgearyi have a delete() function in my Active Record class where i can go in and clean out the orphans
17:49.15mgearymakes more sense to me because often you need to do more than just delete orphans. You need to apply some logic and modify other data as well
17:49.37mgearydo while i have indexed foreign keys all over the place, i don't rely on any database feature to enforce/regulate them
17:49.44mgearys/do/so/
17:50.17_psychic_I'm for that.
17:50.35_psychic_I'm a keep-logic-in-the-app-not-in-the-db guy
17:50.47beandogI guess I'm all alone then
17:50.48mgearyyeah, me too, generally
17:50.50_psychic_That's why I'm looking at drizzle
17:50.54beandogI prefer letting the DB force integrity, where possible.
17:51.10mgearyi generally like the DB to enforce unique keys
17:51.12mgearybut that's about it
17:51.29_psychic_no views, triggers, prepared statements, stored procs, etc.
17:51.46beandogeek
17:51.46mgearythey all can be very handy
17:51.47beandogevil.
17:51.57beandogthey are all soooooo nice
17:52.13mgearyviews provide functionality that it's difficult to emulate in code
17:52.25mgearythe other items can be handled in code fairly easily, if desired
17:52.36beandogit'll still be faster though if its in the database
17:53.26mgearythe speed difference would be small enough to be irrelevant, i'd think
17:53.50beandogI'd disagree heartily, based on past experience
17:54.09_psychic_views, maybe, but triggers/statements/procs are evil
17:54.28_psychic_if logic is bad in the view layer, how is it not bad in the storage layer?
17:55.15mgearywell...
17:55.27mgeary*view* logic is okay in the view layer
17:55.36mgearyso presumably *storage* logic is okay in the storage layer
17:56.08mgearyfor example, if you had a single DB that was accessed by several different applications, in different languages, it might well make sense to push more logic into the storage layer
18:10.54thebigdogi think a good mixture of db logic is good and valuable at the same time
18:14.20thebigdogmy ideas of db logic are a little different though
18:14.33unumI put logic in both places.  that way the db catches me if mess up on the coding level
18:14.40unumof course it's not always pratical
18:14.57jsmithThere are certain things that are best handled at the database level, including things of a transactional nature.
18:15.04jsmithOther logic is best handled at the application layer
18:15.14thebigdogyes trans are extremly important
18:15.44_psychic_I wasn't talking about transactions.
18:16.08unumI use unique and foreign keys a lot
18:16.51_psychic_if your keys auto increment, do you ever run into collisions?
18:17.26thebigdognot if they are primary keys
18:18.15unumif you set the field as unique you're not allowed to
18:18.30*** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com)
18:18.30*** mode/#UPHPU [+v burnin] by ChanServ
18:28.18*** join/#uphpu bradym (n=bradym@63-197-255-78.ded.pacbell.net)
18:28.18*** mode/#UPHPU [+v bradym] by ChanServ
18:46.01thebigdogwps for your file upload question
18:46.10thebigdogi moved them and rename the file for security
18:46.28thebigdogi tend not to trust the uploaded file name that was given
18:46.53wpsI don't want to keep the file
18:46.59wpsI just want to read it's contents
18:47.39wpsis it possible to read without moving it to a location? or do I have to move it, read it, and then delete it?
18:47.59thebigdogyou can test it out...however, i am not sure...i think you have to move it but i could be wrong
18:48.13thebigdogi would think move it read it and then delete it
18:48.35wpsthat's what I am thinking because you don't know the path to the temp file, only the temp filename
18:48.59wpstemp file location is not part of the _FILE array
18:49.11wpsthat's what leads me to wonder if the file even exists as a file
18:49.13bradymlook at the output of phpinfo() it should tell you
18:49.15wps… if it's just in memory
18:49.21thebigdogit would be under the tmp dir you have setup
18:49.21mgearyif you don't move it, it seems to me like it gets deleted at the end of your script
18:49.22bradymnormally it's /tmp
18:49.30mgearybut i could be wrong
18:49.40wpsit does get deleted if you don't move it… another reason to wonder if it even exists
18:49.42beandogmgeary, thats right
18:49.55mgeary~mgeary++
18:51.08timinatormgeary: isn't blatant self promotion not allowed  :)
18:51.15mgearyit is not, indeed
18:51.29mgeary'bout tore my shoulder off, patting myself on the back
18:51.35wpsha ha
18:51.44timinatorhehe
18:51.53*** topic/#UPHPU by wps -> dataw0lf fan club with mgeary Wednesdays
18:52.14beandogtoday's wednesday?
18:52.27timinatorholy crap... I better get to work
18:52.28timinator:)
18:52.28wpsSURPRISE!
18:52.42wpstell me about it
18:52.51wpsI started a quick project monday morning and am still trying to get it done
18:52.57thebigdogwps what type of file is it?
18:53.03wpsmy boss has come by twice a day with feature-creap
18:53.08wpstext file
18:53.11wpsCSV
18:53.25thebigdogis it big? can they just form post it?
18:53.35wps50,000 rows
18:53.37wps(lines)
18:54.02wpscould be 100,000 lines
18:54.08thebigdogoh
18:54.20wpsgoing to be lots of looping in this script :)
18:54.32mgearyhave them zip it before form-posting, that'll give you a 40x reduction
18:54.41mgearythen just unzip serverside
18:54.49thebigdogi would suggest moving it too cause then you get the php check that it is an uploaded file
18:54.52wpsI don't care if it takes them a long time to upload it :)
18:55.09wpsyeah, that's what I'm going to do
18:55.58mgearynot very significant
18:56.10mgearyseconds, not minutes, would be my guess
18:56.18bradymvery quick if you use load data infile
18:56.28wpsload data infile?
18:56.54timinatorPMA does it
18:56.54bradymwps: http://dev.mysql.com/doc/refman/5.0/en/load-data.html
18:57.19wpscan that read in a CSV?
18:57.19mgearyyeah, but PMA poops out if the file is too big, in my experience
18:57.24mgearyyes
18:57.33bradymyeah, that's pretty much what it's for :)
18:57.50thebigdogyou have to make sure that your csv is proper though
18:58.02bradymyeah
18:58.07mindjujuthat's SUPER cool, and v good to know
18:58.07thebigdogif the user messes something up then you might get corrupt data
18:58.26wpsand I'd have to lop the header row off the top first
18:58.31bradymnope,
18:58.35bradymtell it to ignore the first line
18:58.35wps(they insisted that the CSV come with headers)
18:58.39wpsah
18:58.55mindjujuyup, IGNORE number LINES
18:59.37thebigdogjsmith, you there
18:59.45jsmiththebigdog: Yup...
18:59.50jsmiththebigdog: (back in the USA again!)
18:59.53bradymwe load new data each week from CSV files to MySQL and use load data infile.. works like a charm
18:59.54thebigdogncie
18:59.57thebigdogwelcome
19:00.05thebigdogare you familiar with mysql load file
19:00.18wpshave you use CSV with 100,000 rows bradym ?
19:00.31jsmiththebigdog: I haven't touched it in say three years... why?
19:00.34bradymum.. lemme check
19:00.45wpswould be good to know if it can hack that
19:00.45thebigdogcurious on how it does the commit
19:00.48thebigdogor when it does
19:00.49DexterTheDragonI used to use load data infile to push several hundred thousand rows into mysql
19:00.58wpscool
19:01.03wpsI'll use that then
19:01.10wpsbetter than looping 100,000 times in a foreach
19:01.14mindjujuoh that's true with your work at Top Ten
19:01.22mindjujuright?
19:01.26DexterTheDragonyep
19:01.54mindjujuman would have been cool to work there, if nothing more than to get the experience of coding some of the projects that cole was telling me about
19:02.10bradymwps: i'm sure it can, but largest I've done myself is probably around 30-40k
19:03.03DexterTheDragonI think the only thing to really watch out for is if your doing it to a remote server, mysql has limits on packet sizes
19:03.21wpshmm
19:03.29wpsthis will be to a DB on a different box
19:03.39bradymyeah, i always upload the csv files to the server where i have a script with the load data infile statements
19:04.08jsmiththebigdog: As far as I know, it's not transactional.  It just holds off updating the indices until all the records have been inserted
19:04.17wpshmm… I won't be able to put the CSV on the server where the DB is
19:04.20jsmiththebigdog: As always, though, I"m probably wrong
19:04.25wpsthe CSV and the script will be on a web server
19:04.35thebigdogjsmith, im checking now
19:04.37wpsyou think I should not do it then?
19:04.57wpsperformance isn't too important as it isn't a production server
19:04.58thebigdogjsmith, you are close
19:05.01thebigdogvery close
19:05.05jsmiththebigdog: w00t!
19:05.09jsmiththebigdog: Details?
19:05.11thebigdogso it removes the indexes from the tables
19:05.14timinatorwps: do you have one of these files? how large is it (in KB/MB)
19:05.17DexterTheDragonwps: give it a try
19:05.20thebigdogflushes it and then inserts and then reindexes
19:05.52jsmiththebigdog: Right... which can make a *huge* difference depending on the tables and indices
19:06.04thebigdogyeah
19:06.12thebigdogthey say you get 20x faster with load file
19:06.15thebigdogthen inserts
19:06.21DexterTheDragonwps: http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html wou could also try that
19:06.27thebigdogwhich would come from removing the indexes
19:06.28DexterTheDragonit has a --compress option
19:06.58thebigdogjsmith, you can push that more if you do it manually though
19:07.53thebigdogcause you can specify the temp space allocation
19:07.53jsmithRight
19:07.54bradymi can attest to the load file being way faster.. running inserts for my data took ~ 2 mins.. load data infile takes about 3 seconds
19:07.54thebigdogand you can manually disable keys too
19:08.02wpsk… I'll try it
19:08.03wpsthanks everyone
19:10.45thebigdogjsmith, oops i made a big mistake
19:11.00thebigdogit does not do that on tables that have data in them
19:11.05thebigdogonly on ones that are empty
19:11.51thebigdogso wps increase your key_buffer_size and it might even be faster
19:19.09timinatorwps: if your file is <=2MB, you could use PMA to run a speed test.......
19:26.14bradymwell...i *wasn't* gonna say anything but now i feel almost obligated ;)
19:27.12bradymyou should try SQLYog, it's for windows, but i'm running it via wine on my mac and it works great
19:27.53bradymwish they had a native port, but i like it better than the os x native apps i've tried for mysql interaction
19:30.54mgearyyeah, there's def. a need there
19:31.03mgearythe MySQL-supplied tools aren't bad, but they tend to crash
19:38.47mgearymeh
19:39.09mgearyCup-o-Soup is waaay better than Top Ramen. I wish CostCo still carried it
19:39.17mgearyinstead of their crappy Kirkland brand
19:39.44DexterTheDragonTop Ramen > *
19:52.16Utah_DaveI'm running dhcpd3 on an Ubuntu server. Is there a way to kill all the dhcp leases? Can I just delete or rename the dhcpd.leases file?
19:53.39beandogdhcpcd -k ethX
19:53.45beandogoh
19:53.47beandogdhcp server
19:53.48beandogn/m
19:53.53beandogfail.
19:55.36Utah_DaveI guess I was wondering if I can rename the dhcpd.leases file and reboot the server
20:00.59fungusYes, you can
20:01.03fungusstop dhcpd
20:01.07fungusdelete or move the file
20:01.12fungusand restart dhcpd
20:01.23beandog/var/lib/dhcpd.leases or something
20:01.47fungusHowever a client will ask for the same address again, and unless there is reason not to, dhcpd will grant it again.
20:02.59fungusthe dhcpd.leases file is not "live".  It only gets written periodically.  Which is why you need to stop the server before deleting it.
20:04.37Utah_Davefungus: awesome. That's exactly what I needed to know
20:04.45Utah_DaveThis is on a small testbed network.
20:05.11Utah_DaveWhen I boot up 10 new machines at a time, I wanted to be able to go into the leases file and get all the MAC addresses.
20:05.47fungusIIRC, dhcpd3 logs all the DHCP requests to syslog as normal.  That might be easier.
20:05.51Utah_DaveThen for the next batch of machines I wanted a clean leases file
20:05.53fungusthat is "live"
20:06.16Utah_DaveHmm. OK, I'll look at the syslog
20:06.19fungusahh, to clean it out, you gotta stop, delete, start
20:06.35Utah_Daveok.  Thanks, fungus
20:06.40Utah_Dave~fungus++
20:06.43fungussure, good luck
20:07.29funguswoot!  congrats
20:07.35mindjuju:)
20:07.42mindjujuemail server
20:08.02mindjujuhopefully everything will go well and it'll be up friday ~ monday
20:08.28fungusWhat email server did you run in winders
20:09.27mindjujuwas running hmailserver, not bad, but this email server is becoming more important, needs to be much more reliable and better able
20:09.41fungusas long as it isn't exchange...
20:09.46mindjujunope
20:16.41timinatorI've got the AIM, Facebook, eBay, Flashlight and Remote apps on my iPod Touch.... any others you'd all recommend?
20:17.11fungusMonkey Ball, Enigmo, Aurora Feint
20:17.28timinatorcool
20:17.31fungusBubbleWrap, and WordPress
20:18.20wpslabyrinth
20:18.27fungusOh yeah, that one too
20:18.41fungusTap Tap Revenge is pretty fun too
20:19.40mindjujuwps, what's the word on your iphone, did you get one?
20:19.52wpsfunny you should ask :)
20:19.57wpsjust arrived 5 minutes ago
20:20.00wpsthey are porting my number right now
20:20.04mindjujuawesome!
20:20.07mindjujucongrats!
20:20.22*** topic/#UPHPU by wps -> Utah PHP Users Group | uphpu.org
20:20.31timinatorNICE
20:26.30*** part/#uphpu Utah_Dave (n=David_Bo@72-166-51-162.dia.static.qwest.net)
20:58.31*** join/#uphpu orsonj (n=orson@node140.252.100.208.1dial.com)
20:58.31*** mode/#UPHPU [+v orsonj] by ChanServ
20:59.01orsonjlooks like someone turned my work computer off
20:59.11*** join/#uphpu bradym_ (n=bradym@63-197-255-78.ded.pacbell.net)
21:17.46*** join/#uphpu bigdog_ut (n=thebigdo@0006yE-Yn.dsl.xmission.com)
21:17.46*** mode/#UPHPU [+o bigdog_ut] by ChanServ
21:19.56wpstiminator: another must have is NetNewsWire
21:20.14timinatorI'll check it.... these are good
21:20.22timinatorwasting too much time on ITMS
21:20.23timinatorLOL
21:33.26fungusNah, Google Reader is where it's at
21:34.33orsonj~lart fungus
21:34.33jbotdecapitates fungus conan the destroyer style
21:34.48fungus~whip orsonj
21:34.48jbotACTION takes orsonj outside to be thoroughly whipped by fungus
21:47.28timinatorNNW has some really bad reviews
21:47.38wpsreally?
21:47.47wpsI just tried it out and it worked perfectly
21:47.50timinatorfungus: are you using the Google Mobile App for Reader??
21:48.03timinatordo either offer offline use?
21:48.17wpswere the reviews for the initial version or the update that NNW just released
21:48.37timinatordunno
21:48.40wpsthe initial version didn't show non-read counts for categories which would make it less-useful
21:48.47timinatorya
21:48.54wpswhat do you mean off-line use?
21:49.02wpsit's not a web app
21:49.10timinatordoes it store content?
21:49.13wpsyes
21:49.17timinatorand sync when online
21:49.18timinatorcool
21:49.44wpsand it syncs with their server so that your the desktop version of NNW and the iPHone version are in sync
21:49.47fungusnope, google reader doesn't work offline
21:49.57wps(if you read it on your laptop then is hows as read on your iPhone)
21:50.57fungusoh cool.  If NNW can sync desktop and iPhone versions, it might pull me away from google reader.
21:51.12wpsdesktop apps are always better than web apps
21:51.33wpsthings should be web-enabled, not web-based
21:51.48timinatorthere's a place for both
21:51.50timinator:)
21:51.58fungusYes, a place for both.
21:52.05wpstrue… web apps are great for emergencies and airport kiosks
21:52.11wpsbut not for heavy use
21:52.29wpss/heavy/heavy or regular/
21:52.40wps:)
21:52.41timinatoror if old data is irrelevant
21:53.07wpsI hate the idea of a web browser as a platform
21:53.11fungusFor services that need to be up-to-date and in sync everywhere, webapps work best.
21:53.17wpspeople that are trying to build operating systems within a web browser
21:53.19fungusEg. mail, rss, etc
21:53.49timinator*cough *cough Facebook *cough
21:53.52wpsI disagree… I would much rather have web enabled applications for that. IMAP
21:53.59orsonjwhat's the one, "Lively" I think
21:54.27fungusThere is no IMAP equivalent for RSS feeds
21:54.43wpsNNW offers it, fungus
21:55.11fungusThat still isn't equivalent.  that is just proprietary syncing.
21:55.25fungusIt's close though.
21:58.56timinatorwps: is *your* software web-based or web-enabled??
22:02.04bigdog_utfirefox is my os
22:02.25bigdog_utgfirefox for the i686
22:06.52timinatorI'm thinking of learning ObjectiveC, so that my stuff can all be web-enabled rather than web-based, as it is now
22:07.07timinatorpush everything as iPhone/iPod apps
22:07.17timinatorwith web-based counterparts
22:07.28timinatorwhat's everyone's opinion of that??
22:08.27mgearyputting a lot of stock into the iPhone there
22:08.59mgearyif you want that, you could try just using Adobe Air
22:09.10mgearythat'd give you multi-platform support
22:11.57mgearyhey, to put a single quote into mysql, when the value is being wrapped in single quotes...
22:11.57mgearyit seems like i can do \' or ''', does that sound familiar?
22:12.19orsonjmysql_real_escape_string
22:12.23mgearynot using php
22:12.26mgearyraw mysql
22:12.29wpsyes, you can escape with a backslash
22:12.35wpsI do that all the time
22:12.46mgearyare you familiar with the ''' approach?
22:12.53mgearyi may be remembering that from someting else
22:12.55wpsno
22:12.56orsonjI thought it was two quotes
22:12.59mgearymight be
22:13.12wpssong='wade\'s wonderful ditty'
22:13.34funguseek, I read that as "dirty"
22:14.05mgearyyou would
22:14.05funguslol
22:24.42orsonjsql standard says quotes are done double style 'a ''quoted'' string', an extension of sql accepts slashed quotes 'a \'quoted\' string' some db engines suport one or the other, others support both. ms probably uses a forward slash.
22:41.50beandogjust do what I do -- remove any quotes
22:41.57wpsexactly
22:42.11wpschange "that's" to "that is"
22:42.15beandogpeople cant spell anyway
22:42.33wpsI've actually done that many times
22:42.35wps:)
22:42.39beandogheh
22:43.22orsonjWhat if your name is O'Neill or the like
22:43.32beandogblame your parents
22:45.27orsonjor better: Robert'); DROP TABLE Students;--
22:45.54beandogheh
22:46.56unumxkcd was the last thing referenced in two of the irc channels I'm in....
22:47.20wpsalright, those that use load data infile…
22:47.24wpshere's what I have
22:47.30wps(it's throwing an error)
22:47.38unumorsonj: I forgot to escape my strings and had someone named O'neil....
22:47.47wpshttp://rafb.net/p/lLTq3J49.html
22:47.58unumhis performance was not getting loaded into the database for a month....
22:48.45orsonj~give wps some newlines
22:48.45jbotACTION gives some newlines to wps
22:48.51wpssorry about that
22:49.38wpsah-hah!
22:49.43wpsI want lines terminated by
22:49.47wpsnot fields terminated by
22:50.10wpsat least that one thing that's wrong
22:50.13wps(there's surely more)
22:52.05wpshere you go, orsonj: http://rafb.net/p/0E1QHK59.html
22:53.10wpslines 5-13
22:56.30orsonjyou might need to move the ignore line down a couple rows
22:57.01wpsawesome
22:57.07wpsthat eliminated the error
22:57.14wpsI didn't get my values in though
22:57.26wpsam I doing the @var1 bit right?
22:57.32orsonjnot sure
22:58.05orsonjbeginners luck
22:58.07jsmith-awaywps: Have you tried placing the INGORE 1 LINES stuff *after* the "LINES TERMINATED" and "FIELDS TERMINATED" stuff?
22:58.18wpsjust did that and it resolved the error
22:58.27jsmith-awayw00t!
22:58.31jsmith-awayGreat minds think alike!
22:58.44jsmith-away(Oh, and ours do too)
22:58.45wpsnow I am just trying to get the vars assigned to the right columns
22:58.57wpsis @var1 the right way?
22:59.05wpsthe MySQL doc is very hard to understand
22:59.45wpsdo I need to list the columns in parans before I get to set?
23:00.50orsonjlooks like that may be the case
23:01.33wpsawesome
23:01.34wpsgetting warmer
23:01.38wpsI got one variable in
23:02.32orsonjwant to update your current paste?
23:03.06wpshttp://rafb.net/p/5AgvPz95.html
23:03.28wpsed_email made it in but ed_url didn't
23:03.55wpsah-hah
23:03.57wpsi see it
23:04.37wpsawesome
23:04.39wpsI see how it works now
23:04.46wpsMySQL docs suck
23:04.54wpswhy don't they write it for humans to read
23:05.31wpshere's what worked if you're interested
23:05.31wpshttp://rafb.net/p/pnqQsi41.html
23:06.32orsonjyeah, that was a tough read
23:07.06wpsthey could solve most of the problems with some good examples
23:07.13orsonjyour final code does makes sense now
23:07.27wpsyou define the variables in the parans and then use them in the set
23:07.54wpsand what is in the parans has to match the order of items on the line in the file
23:08.37orsonjuse of <h#> tags would help it a lot
23:08.37wpsyeah
23:09.45orsonjI guess it isn't too bad if you read it straight through, but looking for only the stuff you want is difficult.
23:15.08*** join/#uphpu bradym (n=bradym@63-197-255-78.ded.pacbell.net)
23:15.08*** mode/#UPHPU [+v bradym] by ChanServ
23:26.21timinatorI'm out.... later guys
23:34.13orsonjwps: http://rafb.net/p/igQOfB52.html <-- this looks like a more compact version of the last few lines
23:35.10wpsI'll try it
23:35.47wpsdidn't work
23:35.55wpsoh wait
23:36.19wpsniiiiiiiice
23:36.21wpsit did work
23:36.22wpsthanks
23:36.59wpsso you don't need to create a variable of it unless you are going to do something to it (such as run a function on it or perform math on it or something)
23:37.55beandogyahp
23:42.55beandogor use it in a stored proc
23:42.56beandogor a view
23:43.02beandogor all those other useless things everyone hates.
23:43.06macnewbold~rlart
23:43.06jbotwhips out his power stapler and staples eco's foot to the floor
23:43.09wps:)
23:43.15beandogfor some reason
23:44.06wpsit's sunny
23:44.09wpsbroken sprinkler?
23:44.10orsonjwell, over watering
23:44.28wpshttp://slowtheflow.org/
23:44.45orsonjlandlord has like 20x the water shares he needs
23:47.44beandogwps, thats a cool site

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