| 00:01.50 | *** part/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net) |
| 00:03.37 | *** part/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 00:05.33 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 00:05.33 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 00:07.16 | beandog | anyone know how to rename a postgres sequence |
| 00:07.25 | beandog | I cant figure out the exact syntax. |
| 00:32.46 | jsmith | I'm not sure you can. |
| 00:32.52 | jsmith | You may have to drop it and recreate it. |
| 00:33.51 | mindjuju | drop it like its hawt || raise the roof |
| 00:35.56 | mindjuju | eh, nobody like 'me jokes |
| 00:36.58 | jsmith | What, the snicker didn't come across on IRC? |
| 00:42.52 | mindjuju | jsmith |
| 00:42.54 | mindjuju | you still around? |
| 00:43.07 | jsmith | Yup |
| 00:43.09 | jsmith | What's up? |
| 00:43.33 | mindjuju | what was the name of that company that you recommended for residential VoIP? Alltel or something, i think |
| 00:50.31 | jsmith | ArrivalTel |
| 00:50.43 | jsmith | www.arrivaltel.com |
| 00:50.52 | mindjuju | yup, that's it. i knew it started with an A and ended in tel |
| 00:51.06 | jsmith | Tell them that Jared Smith sent you, and they'll take care of you |
| 00:52.00 | mindjuju | that's cool. $10 for local no long distance |
| 00:52.12 | mindjuju | i usually call long distance through my cell, so don't really need the service |
| 00:52.23 | mindjuju | right now, were paying like $60 for just a goofy landline |
| 02:41.28 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 05:21.49 | *** join/#uphpu bradym (i=bradym@c-24-23-166-86.hsd1.mn.comcast.net) |
| 08:13.09 | *** join/#uphpu beandog__ (n=sdibb@c-24-10-220-25.hsd1.ut.comcast.net) |
| 09:33.21 | *** join/#uphpu licyeus (n=aps@69.60.121.206) [NETSPLIT VICTIM] |
| 09:33.21 | *** join/#uphpu optikal (i=optikal@optikal.org) [NETSPLIT VICTIM] |
| 09:33.21 | *** mode/#UPHPU [+v optikal] by irc.freenode.net |
| 14:00.37 | *** join/#uphpu fungus (n=olsonl@mailhub.sosstaffing.com) |
| 14:00.37 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 14:17.25 | *** join/#uphpu eco (n=eco@gnuk.net) |
| 14:17.25 | *** mode/#UPHPU [+v eco] by ChanServ |
| 14:21.35 | *** join/#uphpu fungus (n=olsonl@mailhub.sosstaffing.com) |
| 14:21.35 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 14:44.20 | *** join/#uphpu thebigdog (n=bigdog@208.177.146.102.ptr.us.xo.net) |
| 14:44.20 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 14:46.20 | *** join/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net) |
| 14:46.20 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 14:47.06 | *** join/#uphpu wps (n=wps@67.108.236.230.ptr.us.xo.net) |
| 14:47.06 | *** mode/#UPHPU [+o wps] by ChanServ |
| 15:03.41 | *** join/#uphpu _psychic_ (n=_psychic@66.7.114.126) |
| 15:03.41 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 15:08.43 | *** join/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 15:08.43 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 15:53.52 | *** join/#uphpu unum_ (n=unum@70.89.247.221) |
| 15:53.54 | *** join/#uphpu Black_Chaos (n=admin@67.41.179.45) [NETSPLIT VICTIM] |
| 16:00.00 | *** join/#uphpu Black_Ch1os (n=admin@67-41-179-45.slkc.qwest.net) |
| 16:12.47 | thebigdog | wps what is the irc client you use again? |
| 16:12.59 | wps | colloquy |
| 16:13.02 | wps | colloquy.info |
| 16:13.23 | mgeary | colloquy is good, but i wish it's transcript archiver/browser didn't suck so badly |
| 16:14.05 | thebigdog | ty |
| 16:14.08 | *** join/#uphpu datencio (n=sywoz@ip66-104-85-3.z85-104-66.customer.algx.net) |
| 16:14.19 | thebigdog | friend wants to jump in the channel and ask some mysql questions |
| 16:14.42 | thebigdog | welcome dataw0lf |
| 16:14.47 | thebigdog | welcome datencio |
| 16:14.52 | mgeary | heh |
| 16:14.55 | mgeary | ~welcome datencio |
| 16:15.09 | jbot | Good to see you, datencio! |
| 16:15.09 | thebigdog | tab completion sucks |
| 16:15.18 | thebigdog | datencio, jsmith is not in here now...but you can ask away your questions |
| 16:15.31 | thebigdog | mgeary is pretty knowledgable and might have some good insight for ya |
| 16:15.39 | mgeary | aww shucks |
| 16:15.52 | thebigdog | macnewbold and dataw0lf have some really good experience too as well |
| 16:16.06 | thebigdog | and Utah_Dave might have some commments |
| 16:16.16 | mgeary | the pressure mounts |
| 16:16.30 | thebigdog | dont ask mindjuju though he runs sqlserver |
| 16:16.30 | mgeary | how can we not comment, with that kind of lead-in? :) |
| 16:16.37 | thebigdog | yeah |
| 16:17.13 | mgeary | oh great |
| 16:17.26 | mgeary | hey, mindjuju, you run MS SQL? |
| 16:17.26 | thebigdog | i think he might be switchign his irc client |
| 16:18.31 | thebigdog | mgeary and wps is that irc client free? |
| 16:18.36 | mgeary | yep |
| 16:18.38 | wps | yes |
| 16:18.57 | *** join/#uphpu datencio (n=sywoz@ip66-104-85-3.z85-104-66.customer.algx.net) |
| 16:18.57 | mgeary | wps sent the url: www.colloquy.info |
| 16:20.05 | *** join/#uphpu devin (n=devin@ip66-104-85-3.z85-104-66.customer.algx.net) |
| 16:20.33 | *** join/#uphpu PoeticIntensity (n=jason@70.96.176.8) |
| 16:20.33 | *** mode/#UPHPU [+v PoeticIntensity] by ChanServ |
| 16:21.05 | devin | hello, I am trying to get work to look at using MySQL 5.0 series for this new project we are doing. I guess there may be up to 30 million rows in a table, and he was wanting me to find out how MySQL performs and thoughts from people who use it. |
| 16:21.35 | PoeticIntensity | I've been using it for years... |
| 16:21.43 | PoeticIntensity | it works quite wel. |
| 16:21.44 | PoeticIntensity | well. |
| 16:21.47 | PoeticIntensity | we use 5.0 at work. |
| 16:21.58 | devin | We currently use Sybase 12.5 for most of our stuff, but we don't want to pay 20k for another server. As i have my MySQL Core 4 Certification and i'm more comfortable with MySQL versus Sybase or Postgres. |
| 16:21.59 | PoeticIntensity | haven't had any crashes or any major issues like that at all. |
| 16:22.15 | mgeary | my biggest tables have around 2 million rows, so i can't comment on 30 mil, but we love MySQL |
| 16:22.29 | PoeticIntensity | we've got a table that has 120 mil. |
| 16:22.38 | PoeticIntensity | it's anything but fast, but it doesn't crash. |
| 16:22.55 | PoeticIntensity | and if properly indexed and optimized, it runs along quite nicely. |
| 16:23.28 | PoeticIntensity | I'm gettin' to love Postgres, but I still love MySQL. |
| 16:23.40 | PoeticIntensity | If you do end up using MySQL, please don't use anything prior to 5.0. |
| 16:23.47 | PoeticIntensity | you'll end up regretting it. |
| 16:24.08 | devin | No we will use 5.0 or 5.1 |
| 16:24.09 | devin | at least. |
| 16:24.09 | mgeary | though at the *very* least, stay above version 4.2 |
| 16:24.23 | thebigdog | or use pgsql |
| 16:24.24 | thebigdog | :) |
| 16:24.47 | devin | I used Postgres back in the 7.2 days but it has been some time now. and I think work would be concerned finding help if we needed help with Postgres, I think MySQL would be easier to get support and help. |
| 16:25.01 | thebigdog | ive got about 8 tables with 5+mill records with postgis and it rocks |
| 16:25.18 | devin | Yeah. i don't doubt postgres at all. |
| 16:26.08 | thebigdog | where is Lone Wanderer these days |
| 16:26.36 | thebigdog | devin, i would agree with you there to stick with something you are comfortable with and you can find help if you need it |
| 16:26.57 | devin | Yes, plus i will probably work towards my MySQL 5 DBA if we do this. |
| 16:27.19 | devin | I just wouldn't want some major issue and not be familiar with it to help out. |
| 16:28.22 | devin | our company seems to like more mainstream things as we are 100% dell shop, 100% RedHat Enterprise Shop, so i think MySQL would fit the bill more if they don't want to pay for Oracle or Sybase. |
| 16:28.33 | *** join/#uphpu wps (n=wps@67.108.236.230.ptr.us.xo.net) |
| 16:28.33 | *** mode/#UPHPU [+o wps] by ChanServ |
| 16:29.27 | thebigdog | devin, if you are a redhat shop why not use redhat db? |
| 16:29.29 | *** join/#uphpu wps (n=wps@67.108.236.230.ptr.us.xo.net) |
| 16:29.29 | *** mode/#UPHPU [+o wps] by ChanServ |
| 16:29.43 | devin | redhat db? |
| 16:30.03 | thebigdog | yeah redhat does an enterprise version of pgsql |
| 16:31.01 | thebigdog | is that out now |
| 16:31.12 | tierra | it's on the main page |
| 16:31.14 | devin | Yes Thunderbird 2.0 has been out for a few days. |
| 16:31.41 | tierra | I can't really see it being any worse than 1.5 |
| 16:32.43 | thebigdog | devin that db might be part of your enterprise solution |
| 16:32.49 | tierra | wow... my personal Thunderbird settings/mail folder is 130MB big |
| 16:33.00 | thebigdog | congrats tierra |
| 16:33.20 | tierra | it's just that's a lot bigger than I was thinking it would be |
| 16:33.42 | thebigdog | i need to check mine...i have mail from like 7-8 years ago |
| 16:33.56 | tierra | I don't store more than maybe a couple thousand messages in there, and I know for a fact that Thunderbird only has the headers for more than half of those |
| 16:34.32 | tierra | my Gmail account is over 700MB big, and I expect it would be, but I don't use my other accounts for mailing lists |
| 16:34.42 | thebigdog | devin might be worth looking into if you are already using redhat |
| 16:35.54 | devin | An interesting Article i just found on the topic, Google releases improved MySQL Code. |
| 16:35.54 | devin | http://www.informationweek.com/news/showArticle.jhtml?articleID=199201237 |
| 16:46.33 | tierra | interesting |
| 16:49.30 | devin | ok thanks for your time =) i have to head to do some work |
| 16:49.39 | thebigdog | np |
| 17:01.50 | *** join/#uphpu bradym (n=bradym@63.197.255.70) |
| 17:11.23 | *** join/#uphpu wps (n=wps@67.108.236.230.ptr.us.xo.net) |
| 17:11.23 | *** mode/#UPHPU [+o wps] by ChanServ |
| 17:18.54 | mgeary | anyone know if there's any way to check/validate/verify an SPF record? |
| 17:19.42 | PoeticIntensity | heh.... what is an "SPF" record? |
| 17:20.37 | mgeary | as i understand it, it's something you add to your DNS to make it more difficult for spammers to forge your server when sending emails |
| 17:20.47 | mgeary | http://www.openspf.org/Introduction |
| 17:24.24 | *** join/#uphpu thebigdog (n=bigdog@208.177.146.102.ptr.us.xo.net) |
| 17:24.24 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 17:26.06 | thebigdog | new tb looks good |
| 17:31.33 | PoeticIntensity | oh? |
| 17:40.40 | *** join/#uphpu Lone_Wanderer (n=Lone_Wan@cg.dsl.xmission.com) |
| 17:40.40 | *** mode/#UPHPU [+v Lone_Wanderer] by ChanServ |
| 17:41.38 | *** join/#uphpu jsmith (n=jsmith@70.5.231.20) |
| 17:41.38 | *** mode/#UPHPU [+v jsmith] by ChanServ |
| 17:41.43 | Lone_Wanderer | wps: Great recommendation on Colloquy, I like it already. |
| 17:42.01 | thebigdog | well speak of the devil |
| 17:42.22 | thebigdog | PoeticIntensity, yeah i like the stock look n feel and it seems to run good for me |
| 17:42.35 | jsmith | thebigdog: Oh, I'm the devil now, eh? |
| 17:42.38 | Lone_Wanderer | ohhh, styles. I like! |
| 17:42.49 | Lone_Wanderer | What were you saying about me? Something about how I hate Macs? |
| 17:43.02 | Lone_Wanderer | Because I do. Seriously. I don't like them at all. |
| 17:43.04 | Lone_Wanderer | >.> |
| 17:43.07 | thebigdog | jsmith, i was refer'n to Lone_Wanderer |
| 17:43.30 | jsmith | thebigdog: OK |
| 17:43.31 | thebigdog | jsmith, i had a buddy that i pointed him here to ask you some questions on mysql |
| 17:43.49 | jsmith | Sorry, haven't been online all morning |
| 17:43.52 | thebigdog | but in that reference i was shootin at Lone_Wanderer |
| 17:43.56 | jsmith | But now I'm here |
| 17:44.12 | jsmith | (walkthrough on the new house, and shopping for lights and flooring) |
| 17:44.22 | thebigdog | man can i just say that its great having a wife that can cook |
| 17:44.31 | thebigdog | +1B to thebigdog's wife |
| 17:44.56 | jsmith | Amen, brother! Praise the wife and pass the potatoes! |
| 17:45.08 | jsmith | Sure, I make good money. |
| 17:45.12 | jsmith | Not great money, but good money. |
| 17:45.17 | thebigdog | lo |
| 17:45.25 | jsmith | I'm comfortable, let me put it that way. |
| 17:45.31 | thebigdog | Lone_Wanderer pvp with hunter rocks a** |
| 17:45.34 | jsmith | I'm not *quite* living paycheck to paycheck. |
| 17:45.44 | thebigdog | i would be comfortable if i did not have 3 daughters |
| 17:46.00 | mgeary | thebigdog: just wait till they're teenagers |
| 17:46.04 | Lone_Wanderer | What spec thebigdog? |
| 17:46.11 | Lone_Wanderer | And what level? And what kind of pvp? |
| 17:46.21 | thebigdog | mgeary i have a 16yr that is slowly killing me |
| 17:46.32 | mgeary | ahh |
| 17:46.46 | thebigdog | and an 8yr and 6yr girls |
| 17:46.54 | thebigdog | im not that old though |
| 17:47.21 | thebigdog | Lone_Wanderer, lvl 24 |
| 17:47.21 | Lone_Wanderer | cool |
| 17:47.24 | thebigdog | i have both in mastery and marks |
| 17:47.34 | thebigdog | what spec are you |
| 17:47.55 | Lone_Wanderer | right now my 65 hunter is in BM up to intimidation and marks the rest of the way |
| 17:47.59 | wps | I love Colloquy |
| 17:48.01 | thebigdog | mgeary biologically she is not mine...but i have raised her from a littl eon |
| 17:48.08 | mgeary | aah |
| 17:48.13 | wps | I like it set to have the tabs across the bottom for each channel |
| 17:48.21 | wps | and white on black text |
| 17:48.24 | Lone_Wanderer | so I've got TSA and intimidation, which gives me more stuns |
| 17:48.28 | thebigdog | wps that is how i have mine |
| 17:48.37 | Lone_Wanderer | wps: I hope you don't mind my anti-mac stuff. |
| 17:48.41 | thebigdog | nice...that is what i was thinking |
| 17:48.52 | wps | to each his own :) |
| 17:48.52 | thebigdog | Lone_Wanderer, so i was in stm |
| 17:49.03 | Lone_Wanderer | wps: I'm not serious about it, most of the time. |
| 17:49.55 | thebigdog | i saw in the horde area that is up over the mountains |
| 17:50.04 | thebigdog | i was |
| 17:50.25 | Lone_Wanderer | k |
| 17:50.35 | Lone_Wanderer | sun rock retreat, right? |
| 17:50.37 | thebigdog | then i saw this 28 druid alli just sitting there...so i started ganking him...almost had him but he healed on me |
| 17:50.41 | thebigdog | before that one |
| 17:50.58 | thebigdog | i so almost had him |
| 17:51.18 | Lone_Wanderer | d'oh |
| 17:51.19 | thebigdog | but i was surprised that i could hold my own on a 28 druid that was kinda geared |
| 17:51.21 | Lone_Wanderer | druids suck |
| 17:51.34 | Lone_Wanderer | and they do serious damage vs. hunters |
| 17:51.46 | Lone_Wanderer | you know you can cast scare beast on them when they're in animal forms right? |
| 17:51.56 | thebigdog | you can? |
| 17:52.00 | Lone_Wanderer | yep |
| 17:52.05 | thebigdog | nope i did not know that |
| 17:52.09 | thebigdog | next time i will do that |
| 17:52.11 | Lone_Wanderer | It's super useful. |
| 17:52.27 | thebigdog | i cant believe how fast you can lvl a hunter |
| 17:52.33 | Lone_Wanderer | I usually war stomp then cast scare beast, then use my trinket to un-root myself if they rooted me |
| 17:52.38 | Lone_Wanderer | yeah it's great :D |
| 17:52.43 | Lone_Wanderer | tank, DPS and healer all in one class |
| 17:53.15 | Lone_Wanderer | With virtually no downtime, especially if you have good mana regen. |
| 17:53.29 | thebigdog | yeah |
| 17:53.46 | thebigdog | i got some good weapons for my hunter from my warrior |
| 17:53.54 | thebigdog | i just need some gear |
| 17:54.04 | thebigdog | lvlin is fast with a hunter too |
| 17:54.11 | Lone_Wanderer | "of the monkey" is good gear |
| 17:54.24 | Lone_Wanderer | esp. now that your pet gets part of your stamina |
| 17:54.25 | thebigdog | ill have to watch for them |
| 17:54.31 | thebigdog | yeah i saw that |
| 17:54.47 | Lone_Wanderer | what kind of pet do you have? |
| 17:54.50 | thebigdog | you know your spec numbers? |
| 17:54.52 | Lone_Wanderer | you know about "caster" pets? |
| 17:54.55 | Lone_Wanderer | I don't, no. |
| 17:55.02 | thebigdog | i have a cat...nope |
| 17:55.41 | Lone_Wanderer | There are some pets that have "caster" stats. Higher int and spirit, lower other stuff. |
| 17:56.04 | thebigdog | is a cat good for lvl 26? or is there another one i should get |
| 17:56.07 | Lone_Wanderer | I forget what they are, but they make really bad pets. They don't even necessarily have to be pets that cast spells. |
| 17:56.16 | Lone_Wanderer | Like a wind serpent casts lightning breath, that's something different. |
| 17:56.36 | Lone_Wanderer | I have Humar and I've had him since I was at XR and I love him and would never trade him for anything else. |
| 17:57.09 | Lone_Wanderer | He generates a huge amount of aggro, regardless of my spec, he's fast, he hits hard and he's tough. |
| 17:57.19 | Lone_Wanderer | Keep your cat. Only drawback is their diet. |
| 17:57.28 | thebigdog | yeah |
| 17:57.33 | thebigdog | ive noticed that |
| 17:57.35 | Lone_Wanderer | Just pick up fishing and cooking. |
| 17:58.26 | thebigdog | how about gorillas? i heard some peps pimping their skills |
| 17:58.35 | Lone_Wanderer | If you fish in the Barrens pools, you can get deviate fish, which sell pretty decently. |
| 17:58.45 | thebigdog | yeah i do those all theime |
| 17:59.02 | Lone_Wanderer | Gorillas are tough and have an AoE attack, so they can generate AoE aggro. |
| 17:59.09 | thebigdog | and deviate fish are used with jewelcrafting |
| 17:59.12 | Lone_Wanderer | Which is sometimes good. And they'll eat anything, or almost anything. |
| 17:59.16 | Lone_Wanderer | Seriously? That's awesome. |
| 17:59.29 | Lone_Wanderer | Look up petopia |
| 17:59.35 | Lone_Wanderer | they've got a ton of pet resources. |
| 18:00.45 | thebigdog | oh nice |
| 18:00.45 | thebigdog | 161 damn |
| 18:00.45 | Lone_Wanderer | 161? |
| 18:00.45 | thebigdog | types of pets |
| 18:00.45 | Lone_Wanderer | ahh |
| 18:01.30 | thebigdog | so you have just used the cats mainly? |
| 18:01.36 | Lone_Wanderer | yeah |
| 18:01.47 | Lone_Wanderer | I've used other things from time to time, because you have to train them to learn skills. |
| 18:01.53 | thebigdog | i like the look of the cats |
| 18:02.01 | thebigdog | makes sense |
| 18:02.04 | Lone_Wanderer | So I've played around with a lot of things. But I always go back to good old Razorfang. |
| 18:02.28 | thebigdog | i was thinking of getting a ghostpaw |
| 18:02.29 | Lone_Wanderer | Partially 'cause I'm impatient, and cats get dash. |
| 18:02.41 | Lone_Wanderer | Those are wolves, right? |
| 18:02.49 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 18:02.53 | thebigdog | yep |
| 18:03.19 | Lone_Wanderer | Cats are also good in pvp 'cause they have a high damage output, so Razorfang can do double duty. |
| 18:03.35 | Lone_Wanderer | If I see an Alliance that's just asking to be ganked I just turn off growl, turn on prowl, and send him in. |
| 18:03.41 | thebigdog | http://petopia.brashendeavors.net/html/mobs/mob_ghostpawalpha.shtml |
| 18:03.46 | Lone_Wanderer | Then I can stand there and act all friendly until he hits. |
| 18:03.53 | thebigdog | haha |
| 18:04.48 | thebigdog | this is the gorilla http://petopia.brashendeavors.net/html/skins/skin_gorillaskingrey.shtml |
| 18:05.22 | thebigdog | so how many pets you have total? |
| 18:05.37 | Lone_Wanderer | I think I've got three. |
| 18:06.06 | Lone_Wanderer | Humar (Razorfang), a wolf for raiding (haven't used him since BC came out), and a warp stalker, which sucks because I got one with caster stats. |
| 18:06.09 | thebigdog | that humar is nice |
| 18:06.19 | Lone_Wanderer | But it is kind of cool that they can blink behind their target. |
| 18:06.27 | thebigdog | nice |
| 18:07.06 | Lone_Wanderer | Yeah, I'm thinking I might actually start using a warp stalker for general purpose grinding and/or pvp. |
| 18:07.10 | thebigdog | how many pets can you have? |
| 18:07.17 | Lone_Wanderer | three. Two in the stable, one with you. |
| 18:07.42 | Lone_Wanderer | The blink they do is nice because if something's running away, they just blink right to it. Or if you send them to a second target after the first one, they can blink to it. |
| 18:07.52 | Lone_Wanderer | Nice combo with Rapid Killing. |
| 18:07.55 | thebigdog | oh that sucks |
| 18:08.21 | Lone_Wanderer | Yeah, one of the perpetual threads on the hunter forum is "give us more stable slots!" |
| 18:08.27 | thebigdog | ok so when you coming and playing on bloodscalp |
| 18:08.54 | thebigdog | yeah that would be nice to have like 10 slots |
| 18:08.55 | Lone_Wanderer | As soon as I get my computer working. |
| 18:08.55 | Lone_Wanderer | I need more parts. |
| 18:08.58 | Lone_Wanderer | And a net connection. |
| 18:09.30 | Lone_Wanderer | http://petopia.brashendeavors.net/html/articles/skills_list.shtml#warp |
| 18:10.09 | thebigdog | man 70 seems so far away again |
| 18:10.18 | Lone_Wanderer | yeah |
| 18:10.18 | thebigdog | i figure in a month i should be 60 |
| 18:10.35 | thebigdog | then i will lvl my hunter and warrior to 70 |
| 18:11.25 | thebigdog | i guess if i have 3 pets, one from each section ill be covered |
| 18:11.35 | thebigdog | one def, one off, one well rounded |
| 18:11.37 | Lone_Wanderer | offensive, defensive and balanced? |
| 18:11.42 | thebigdog | y |
| 18:11.45 | Lone_Wanderer | I thought about doing that too |
| 18:11.58 | Lone_Wanderer | but in the end it wasn't worth it to me to keep switching |
| 18:12.04 | thebigdog | i like my cat, i want to try out a gorilla |
| 18:12.09 | Lone_Wanderer | and Humar almost never dies anyway |
| 18:12.44 | Lone_Wanderer | even before the patch that gave him bonuses from my own stats he was fine |
| 18:13.08 | Lone_Wanderer | of course having more than 1k RAP before buffs probably helps with that ;) |
| 18:13.35 | thebigdog | http://armory.worldofwarcraft.com/#character-sheet.xml?r=Bloodscalp&n=Raimundus |
| 18:13.57 | thebigdog | that sword is nice |
| 18:14.07 | thebigdog | i got a new bow waiting for me too for the next lvl |
| 18:14.31 | Lone_Wanderer | hmm, something I did lowered my RAP |
| 18:14.38 | Lone_Wanderer | http://armory.worldofwarcraft.com/#character-sheet.xml?r=Deathwing&n=Bodkin |
| 18:15.16 | thebigdog | i hate the ajax on those pages |
| 18:15.16 | Lone_Wanderer | Check out my necklace :D |
| 18:15.55 | thebigdog | k |
| 18:16.08 | thebigdog | that killed firefox |
| 18:16.20 | thebigdog | wow that ajax sucked |
| 18:16.28 | Lone_Wanderer | :( |
| 18:16.51 | Lone_Wanderer | It's the Amulet of the Darkmoon. 10 str, 19 agility, 10 stamina |
| 18:16.58 | thebigdog | oh nice |
| 18:17.07 | Lone_Wanderer | yeah, I got it a long time ago |
| 18:17.12 | Lone_Wanderer | and haven't found anything better yet |
| 18:17.20 | Lone_Wanderer | which is good because I worked my arse off for it |
| 18:18.21 | thebigdog | haha |
| 18:18.49 | Lone_Wanderer | seriously, I had to make something like 3,000 rugged leather kits |
| 18:18.56 | Lone_Wanderer | or more, I don't remember. it was insane. |
| 18:18.58 | thebigdog | oh |
| 18:19.41 | thebigdog | there is your talent tree |
| 18:19.42 | tierra | mgeary: this works decent enough for SPF testing: http://www.kitterman.com/spf/validate.html |
| 18:19.44 | Lone_Wanderer | then turn them into the Darkmoon Faire for tickets. It's nice though if you can do it. |
| 18:20.09 | thebigdog | i got a mage as my leatherworker |
| 18:20.30 | mgeary | Thanks, yeah, i found that too. though it gives me some strangeness. still waiting for the DNS cache to update with my tweaks. |
| 18:20.59 | wps | if these are my choices: Northeast, Northwest, Midwest, Great Plains, Southeast, South, Southwest, Alaska/Hawaii |
| 18:21.17 | wps | and I live in Utah… which am I? |
| 18:21.53 | wps | it frustrates me to no end that they call Ohio the Midwest… sheesh, it's right of the middle! |
| 18:22.14 | mgeary | i'd guess southwest |
| 18:22.22 | thebigdog | Lone_Wanderer, when do hunters get mail? |
| 18:22.25 | wps | Utah should be midwest, but I don't think that is what they are considering since most people consider midwest to be kansas and ohio |
| 18:22.31 | thebigdog | Lone_Wanderer, armor |
| 18:22.47 | mgeary | heck, even Michigan is considered "midwest" |
| 18:23.24 | wps | isn't that Northeast? |
| 18:23.51 | mgeary | Vermont is Northeast :) |
| 18:23.58 | wps | no, that's east coast |
| 18:24.00 | wps | :) |
| 18:24.28 | mgeary | ah, well, i'm not sure how much "coast" Vermont has, but yeah |
| 18:25.08 | *** join/#uphpu bradym (n=bradym@63.197.255.70) |
| 18:25.43 | mgeary | i guess Vermont has a coast on the shore of Lake Champlain |
| 18:26.39 | Lone_Wanderer | Ohio would either be the midwest or the great plains. A lot of the great plains states are in the midwest. |
| 18:26.53 | Lone_Wanderer | thebigdog: level 40 |
| 18:27.21 | thebigdog | oh nice |
| 18:27.21 | Lone_Wanderer | Minnesota is midwest, I don't think Utah counts. But I guess it's as close as they'll let you get. |
| 18:27.21 | thebigdog | mail armor on a hunter rocks |
| 18:27.24 | thebigdog | same with shammy |
| 18:27.33 | Lone_Wanderer | yeah |
| 18:27.45 | Lone_Wanderer | I can usually offtank for a decent amount of time in instances, if I have to. |
| 18:27.58 | Lone_Wanderer | Well, s/offtank/kite |
| 18:28.08 | thebigdog | yeah |
| 18:28.11 | Lone_Wanderer | I'm kind of ticked that the hunter's bow quest isn't important any more. |
| 18:28.19 | Lone_Wanderer | You're not a Real Hunter if you haven't done that quest. |
| 18:28.53 | thebigdog | isnt not available? |
| 18:29.00 | thebigdog | which quest is that one? |
| 18:29.02 | Lone_Wanderer | It is, but why bother with it? |
| 18:29.13 | Lone_Wanderer | The Striker's Mark that I've got is a bit nicer, and it's way easier to get. |
| 18:29.20 | Lone_Wanderer | The one where you have to kill four demons |
| 18:29.24 | Lone_Wanderer | with no help |
| 18:29.26 | Lone_Wanderer | from anyone |
| 18:29.28 | thebigdog | what is the name? |
| 18:29.28 | Lone_Wanderer | even your pet |
| 18:29.42 | Lone_Wanderer | I don't know. It's just The Hunter's Epic Quest. |
| 18:30.06 | thebigdog | oh |
| 18:30.07 | Lone_Wanderer | There are four demons, in Winterspring, Burning Steppes, Un'Goro, and Silithus. |
| 18:30.34 | Lone_Wanderer | Normally they just look like normal mobs that you can't attack, but if you have the quest and you talk to them you can make them turn into level 60 elite demons. |
| 18:31.09 | Lone_Wanderer | If anyone other than a hunter aggros them, they do an AoE that does like 10k damage. |
| 18:31.26 | Lone_Wanderer | If, after the hunter tags them, anyone else gets on their aggro list, they despawn immediately for an hour. |
| 18:31.26 | thebigdog | oh |
| 18:32.05 | Lone_Wanderer | So if anyone else heals you, buffs you, anything, you get to wait an hour. Which is the source of much frustration when someone comes along and decides to "help". |
| 18:32.25 | thebigdog | yeah |
| 18:33.05 | Lone_Wanderer | But yeah. They're incredibly tough demons, each one has a "trick" that you have to use to kill them, and you have to perform flawlessly in order to win. |
| 18:33.33 | thebigdog | anyone use thunderbird with active directory? |
| 18:34.16 | Lone_Wanderer | http://www.wowwiki.com/Hunter_quests |
| 18:35.03 | thebigdog | so no one does it now? |
| 18:35.23 | Lone_Wanderer | Anyway. It used to be that if you had your Rhok'Delar, it meant you were qualified to be considered a "good" hunter, because you couldn't get it without mastering the hunter tricks (jump shot, kiting, off-tanking, etc.) but now there's no point in doing it. |
| 18:35.28 | Lone_Wanderer | Which makes me sad :( |
| 18:36.30 | Lone_Wanderer | Well, I guess you could do it for the quiver. Ancient Sinew Wrapped Lamina, it's an 18 slow quiver that gives a 15% boost in attack speed. But you don't have to kill the demons for that one. |
| 18:42.20 | thebigdog | i might check it out |
| 18:42.24 | thebigdog | im always up for a challenge |
| 18:42.43 | Lone_Wanderer | It's more than a challenge. |
| 18:42.52 | Lone_Wanderer | I guarantee you will want to kill someone more than once. |
| 18:43.05 | Lone_Wanderer | But if you can do it you will have my e-respect forever. |
| 18:48.51 | Lone_Wanderer | ;) |
| 19:38.59 | *** join/#uphpu _psychic__ (n=_psychic@66.7.114.126) |
| 20:13.46 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 20:13.46 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 21:04.21 | mgeary | ~ping mindjuju |
| 21:04.24 | jbot | pong mindjuju |
| 21:04.32 | mgeary | ~seen mindjuju |
| 21:04.58 | jbot | mindjuju is currently on #uphpu (1d 22h 45m 59s). Has said a total of 100 messages. Is idling for 20h 12m 36s, last said: 'right now, were paying like $60 for just a goofy landline'. |
| 21:06.57 | mgeary | grr. I find it frustrating that MS SQL seems to equate an empty string with NULL |
| 21:07.53 | mgeary | and that if you pass an empty string to a field that does NOT allow nulls, it replaces it with a space |
| 21:08.06 | mgeary | ~lart MSSQL |
| 21:08.06 | jbot | cuts off MSSQL's head with a halberd that could have been a little bit sharper |
| 21:13.51 | beandog | mgeary: heh |
| 21:14.03 | jsmith | mgeary: I hate to break this to you, but there's a big difference between an empty string and a NULL |
| 21:14.14 | mgeary | well, EXACTLY |
| 21:14.17 | mgeary | see my reference |
| 21:14.18 | beandog | mssql gets confused that way. |
| 21:14.21 | mgeary | grr. I find it frustrating that MS SQL seems to equate an empty string with NULL |
| 21:14.21 | beandog | It is REALLY jacked up. |
| 21:14.40 | jsmith | Oh, sorry -- I misread |
| 21:37.35 | unum | so I have a web app where I have to refresh the screen frequently, I want to only refresh the parts that have changed |
| 21:37.50 | unum | so I want to keep track of which fields have been modified in the database |
| 21:38.00 | unum | what's the best way to do this |
| 21:38.28 | jsmith | AJAX |
| 21:38.46 | unum | I worded that wrong |
| 21:39.05 | unum | what's the best way to handle keeping track of which fields have been modified in the databse |
| 21:39.20 | unum | should I log all changes to a seperate table |
| 21:39.51 | unum | should I break up the table into smaller tables and keep track on a row by row basis |
| 21:40.07 | unum | is their a good way to keep track on a field to field basis |
| 21:40.35 | unum | or should I leave it in one large table and update whole rows at a time(which would probably work) |
| 21:43.36 | PoeticIntensity | okay, guys..... |
| 21:44.06 | PoeticIntensity | I've got a couple of questions for those of you who have worked with both MySQL versions 5.0+ and also have worked with PGSQL. |
| 21:44.24 | PoeticIntensity | Our company is at the point of needing to seriously consider using transactions. |
| 21:44.32 | PoeticIntensity | we're currently using MySQL 5.0 |
| 21:44.49 | PoeticIntensity | I am under the impression that 5.0 has bugs with using transactions. |
| 21:45.08 | PoeticIntensity | We can't have any bugs causing our main accounting system to crash, or not do what it is meant to do. |
| 21:45.34 | PoeticIntensity | The reasons we are not using transactions from the get-go are better left unsaid. :) |
| 21:45.38 | PoeticIntensity | so..... |
| 21:45.46 | PoeticIntensity | for those MySQL 5.0 gurus out there.... |
| 21:45.55 | PoeticIntensity | Are we safe using transactions with 5.0? |
| 21:46.17 | PoeticIntensity | If not, is 5.1 stable enough for use with a production server? |
| 21:46.29 | PoeticIntensity | (assuming 5.1's transactions aren't buggy) |
| 21:47.02 | PoeticIntensity | if worse comes to worse (or best), we are considering moving to PGSQL, but that'd take *much* more time to do considering the integration with MySQL is pretty hefty at this point within our systems. |
| 21:47.26 | PoeticIntensity | anyone out there got any info that can help out? |
| 21:48.56 | PoeticIntensity | ~lart tierra |
| 21:48.56 | jbot | installs PocketPC on tierra's PDA |
| 21:51.29 | tierra | I've not heard of transaction bugs with 5.0, but I haven't actually worked much with transactions just yet either, though I have been planning on jumping into them in the near future here |
| 21:51.43 | mgeary | ditto |
| 21:52.02 | PoeticIntensity | hmmmm..... |
| 21:52.05 | PoeticIntensity | I've gotta find out. |
| 21:52.13 | bradym | yeah, i've used mysql 5, but not transactions.. |
| 21:52.14 | PoeticIntensity | My job might be on the line if I mess this sucker up. :) |
| 21:52.46 | unum | I've only used transactions on pgsql |
| 21:52.58 | unum | and I doubt anyone would notice if they weren't working.... |
| 21:53.34 | tierra | yeah, if you're writing decent code in the first place, they aren't supposed to even be used ;) |
| 21:53.43 | tierra | hehe |
| 21:53.49 | PoeticIntensity | hehe....... yeah...\ |
| 21:54.06 | PoeticIntensity | so here's the question: |
| 21:54.17 | PoeticIntensity | I do an insert on a page into a table. |
| 21:54.28 | PoeticIntensity | I do mysql_insert_id() |
| 21:54.31 | PoeticIntensity | and get the id. |
| 21:54.36 | tierra | I was planning on doing some research on PHP PDO soon here, but you caught me too early :/ |
| 21:54.39 | PoeticIntensity | is that *guaranteed* to be the id of the last insert? |
| 21:54.51 | PoeticIntensity | yes.... yes it is. |
| 21:54.54 | mgeary | PoeticIntensity: use mysqli and you can avoid that altogether |
| 21:55.03 | mgeary | 'cause everything's attached to the object |
| 21:55.11 | PoeticIntensity | hmm..... |
| 21:55.13 | PoeticIntensity | mysqli. |
| 21:55.19 | PoeticIntensity | I've heard of it, but not much more. |
| 21:55.20 | mgeary | mysqli++ |
| 21:55.25 | mgeary | it's great |
| 21:55.31 | PoeticIntensity | is it still mysql? |
| 21:55.34 | mgeary | yep |
| 21:55.37 | PoeticIntensity | gotta link? |
| 21:55.38 | mgeary | just a more modern driver |
| 21:55.45 | PoeticIntensity | ah.... |
| 21:55.47 | PoeticIntensity | so it's inside PHP. |
| 21:55.48 | mgeary | it's there by default, just gotta add it to the config |
| 21:55.49 | unum | my issue is that I need to find the next availiable row and lock it before any one else finds it |
| 21:55.50 | mgeary | yep |
| 21:56.03 | PoeticIntensity | huh. |
| 21:56.09 | PoeticIntensity | I'll do some research. |
| 21:57.01 | unum | I've been using mdb2 from pear |
| 21:57.05 | unum | I really like it |
| 21:57.29 | mgeary | i've rolled my own OOP-centric db abstraction |
| 21:57.36 | mgeary | which i love :) |
| 21:58.20 | PoeticIntensity | well..... |
| 21:58.26 | PoeticIntensity | I don't have a problem with db abstraction... |
| 21:58.27 | unum | I wish there was a newer ldap abstraction |
| 21:58.52 | PoeticIntensity | there's just no way to *ensure* that the same script isn't being used by two different people at the exact same time. |
| 21:59.14 | mgeary | you mean the same data row, no? |
| 21:59.26 | PoeticIntensity | inserting different rows within milliseconds, grabbing the wrong insert_id, and borking the db. |
| 21:59.34 | mgeary | no |
| 21:59.44 | PoeticIntensity | I'm talking two rows inserted within milliseconds of each other. |
| 21:59.49 | PoeticIntensity | and borking the IDs associating the tables. |
| 21:59.56 | mgeary | mysql_insert_id operates off the db connection for the *current* script |
| 21:59.59 | PoeticIntensity | I'm relatively new to the idea of transactions. |
| 22:00.13 | mgeary | it does NOT get the last record in the DB |
| 22:00.20 | unum | you shouldn't need transactions for that |
| 22:00.24 | mgeary | it gets the last inserted primary key *for the current connection* |
| 22:00.35 | mgeary | otherwise it'd be completely useless |
| 22:00.45 | PoeticIntensity | right. |
| 22:00.49 | mgeary | so, PoeticIntensity, you should be in good shape |
| 22:01.05 | PoeticIntensity | we've written so much code in so little time and done so little testing / QA / etc.... |
| 22:01.27 | PoeticIntensity | I'm just waiting for something to blow up into a million pieces. |
| 22:01.54 | PoeticIntensity | so... if what you're saying is true.... 99% of my worries are unfounded. |
| 22:02.41 | mgeary | it wouldn't be hard to verify. get two different processes each inserting 1000 rows and start them at approximately the same time. then output the IDs from each insert |
| 22:02.45 | PoeticIntensity | hrmmm........ |
| 22:03.00 | PoeticIntensity | true. |
| 22:03.51 | mgeary | even if you have two mysql connections on the same script, you can pass the resource variable to mysql_insert_id to ensure accuracy |
| 22:04.06 | PoeticIntensity | none of my scripts do that. |
| 22:04.17 | PoeticIntensity | they assume it's the previous connection. |
| 22:04.29 | PoeticIntensity | ergh.... |
| 22:04.42 | PoeticIntensity | and even if I did, I use a db connection class which handles all that. |
| 22:04.56 | PoeticIntensity | two scripts would use the same db connector. |
| 22:05.06 | PoeticIntensity | I wish the php docs were a bit more specfic on this. |
| 22:05.10 | PoeticIntensity | http://us.php.net/manual/en/function.mysql-insert-id.php |
| 22:06.20 | PoeticIntensity | Note: Because mysql_insert_id() acts on the last performed query, be sure to call mysql_insert_id() immediately after the query that generates the value. |
| 22:06.25 | PoeticIntensity | that's straight from the php docs. |
| 22:06.31 | PoeticIntensity | that causes me to worry a bit...... :-T |
| 22:07.14 | PoeticIntensity | I follow that advice to the Tee, but that leads me to believe that two scripts running on the same table inserting rows...... the IDs returned could get borked. |
| 22:07.18 | PoeticIntensity | I'm gonna have to test this. |
| 22:08.45 | beandog | What the database *should* do is return the last inserted ID based on the current connection |
| 22:08.52 | beandog | Just use SELECT @@IDENTITY; |
| 22:09.09 | PoeticIntensity | you sure that works in MySQL? |
| 22:09.11 | beandog | No. |
| 22:09.14 | beandog | I know it does on MSSQL though. |
| 22:09.17 | PoeticIntensity | yup. |
| 22:09.22 | PoeticIntensity | my DBA told me the same thing. |
| 22:09.25 | PoeticIntensity | I don't think it works in MySQL. |
| 22:10.01 | beandog | This is where you use functions. |
| 22:10.11 | beandog | to do an insert |
| 22:10.25 | beandog | Thats one way to guarantee getting it back. |
| 22:10.26 | mgeary | beandog means *objects/classes*, surely |
| 22:10.34 | beandog | stored procs. |
| 22:10.39 | mgeary | oh |
| 22:10.40 | PoeticIntensity | beandog, I appreciate your trying to help, but re-writing our whole application isn't an option. |
| 22:10.41 | mgeary | yeah |
| 22:10.50 | mgeary | PoeticIntensity: are you familiar with the ActiveRecord pattern? |
| 22:10.51 | beandog | a function goes inside the DB |
| 22:10.54 | mgeary | it changed my life |
| 22:11.00 | PoeticIntensity | I am not... |
| 22:11.01 | mgeary | (design pattern) |
| 22:11.06 | beandog | anyway, others know much more about mysql, so, Ill just hush up anyway. |
| 22:11.39 | mgeary | the concept behind the ActiveRecord pattern is that you have a Class for (nearly) every table in your DB. an instance of that class equals a given row in that table |
| 22:11.57 | mgeary | so you only ever interface with the DB *through* the object |
| 22:12.08 | PoeticIntensity | interesting. |
| 22:12.17 | mgeary | the object would have, for example, a save() method, which intelligently inserts or updates the appropriate row |
| 22:12.30 | mgeary | in my AR system, i grab the insert_id immediately after the insert(0 |
| 22:12.33 | mgeary | insert |
| 22:12.39 | PoeticIntensity | so basically just re-create the whole db schema with objects. |
| 22:12.40 | mgeary | it's soooo nice |
| 22:12.46 | mgeary | yep |
| 22:12.47 | beandog | mysqli lets you pass two queries at once right? |
| 22:12.51 | mgeary | it does |
| 22:12.52 | beandog | That should work (in theory) |
| 22:13.02 | beandog | $sql = "INSERT FOO; SELECT @@IDENTITY;"; |
| 22:13.02 | mgeary | but with mysqli it's not necessary |
| 22:13.05 | beandog | Oh. |
| 22:13.09 | beandog | Well, there you go. |
| 22:13.09 | mgeary | because you can call the insert_id property |
| 22:13.12 | mgeary | of the mysqli object |
| 22:13.26 | PoeticIntensity | mgeary, I do the same thing. I *always* grab the insert_id immediately after it is inserted.... but nothing I'm finding in the docs is assuring me that the id grabbed is based on the connection. |
| 22:13.28 | mgeary | (if you're using the OOP way of mysqli) |
| 22:13.29 | beandog | Can you call what the next sequence id is gonna be? |
| 22:13.41 | beandog | PoeticIntensity: Just try it |
| 22:13.44 | beandog | Shoudlnt be hard at all |
| 22:13.54 | beandog | Write two php pages making a db connection, run sleep to keep them open |
| 22:14.02 | beandog | have open open / insert / close before the other |
| 22:14.06 | mgeary | PoeticIntensity: if it were not so, the entire internet would be broken within minutes :) |
| 22:14.16 | PoeticIntensity | heh... |
| 22:14.25 | PoeticIntensity | I've just gotta keep my bases covered.... |
| 22:14.44 | PoeticIntensity | maybe its an assumption so elementary, I'm making myself look like an idiot by even mentioning it, but.... |
| 22:14.53 | mgeary | you misspelled "*ss" ;) |
| 22:15.15 | PoeticIntensity | I sure did...... |
| 22:15.16 | PoeticIntensity | LOL |
| 22:15.29 | PoeticIntensity | why would they not document that? |
| 22:15.35 | mgeary | they do |
| 22:15.46 | PoeticIntensity | the PHP docs are littered with "this just gets the last inserted id" |
| 22:15.46 | mgeary | they refer it to the *connection* |
| 22:15.48 | thebigdog | PoeticIntensity, pgsql |
| 22:15.58 | PoeticIntensity | thebigdog, don't I know it.... |
| 22:16.15 | thebigdog | i made that change long ago |
| 22:16.22 | PoeticIntensity | I'd much rather go to pgsql, but...... in all honesty - I'm stretched to the limit with crap I've gotta deal with without converting our entire system over to pg. |
| 22:16.34 | mgeary | okay, so the docs are a *bit* vague, but again, by simply passing your resource variable, you can be assured |
| 22:17.10 | PoeticIntensity | thebigdog, do you know of any transaction bugs in MySQL 5.0? |
| 22:17.13 | PoeticIntensity | or heard of any? |
| 22:17.15 | PoeticIntensity | or...... anything? |
| 22:17.24 | thebigdog | not really |
| 22:17.47 | PoeticIntensity | so you'd trust your accounting system with mysql 5.0 using transactions? |
| 22:18.12 | PoeticIntensity | my main concern is two-fold: |
| 22:18.22 | PoeticIntensity | 1. Nobody seems to use transactions with mysql 5.0 - yet. |
| 22:18.54 | PoeticIntensity | 2. Transaction support was released in MySQL 5.0... Doesn't lend itself to much trusting with it seemingly still so infant. |
| 22:19.06 | thebigdog | no i would not |
| 22:19.15 | PoeticIntensity | I'm gonna die. |
| 22:19.15 | beandog | Well you could just use InnoDB |
| 22:19.18 | PoeticIntensity | right here, right now. |
| 22:19.23 | mgeary | dude |
| 22:19.26 | PoeticIntensity | I'm already using it. |
| 22:19.26 | thebigdog | innodb has issues when you get to big |
| 22:19.28 | mgeary | whip up a test, |
| 22:19.38 | beandog | PoeticIntensity: looks like either way youre going to have to wander into unfamiliar territory. :T pick yer poison. |
| 22:19.40 | PoeticIntensity | our entire db is using innodb. |
| 22:19.50 | beandog | well innodb already uses transactions |
| 22:19.55 | beandog | So why do you need 5.0? |
| 22:19.55 | thebigdog | i hate innodb |
| 22:20.01 | PoeticIntensity | I could handle unfamiliar, beandog, I just need to research the bug-factor. |
| 22:20.08 | beandog | gotcha |
| 22:20.26 | thebigdog | transactions in psql are stable as hell |
| 22:20.36 | PoeticIntensity | if I go into the *wrong* unfamiliar territory, and our accounting system (doing about a million dollars a week) fails.... |
| 22:20.36 | beandog | COPY is super fast too, holy cats. |
| 22:20.39 | PoeticIntensity | guess who just lost his job. |
| 22:21.05 | thebigdog | that is why im suprised you are using mysql for financial data |
| 22:21.14 | PoeticIntensity | thebigdog, I *know* pgsql is stable. Right now I've gotta evaluate the possibility of our whole system crashing when I implement transactions in MySQL. |
| 22:21.17 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 22:21.27 | beandog | PoeticIntensity: what version are you guys on |
| 22:21.30 | PoeticIntensity | 5.0 |
| 22:21.39 | beandog | And everything is InnoDB? |
| 22:21.43 | PoeticIntensity | we're scared to go to 5.1 because we don't know if it's stable yet. |
| 22:21.54 | PoeticIntensity | we're scared to use transactions in 5.0 for the same reason. |
| 22:21.56 | beandog | InnoDB had transactions before 5.0 |
| 22:21.59 | beandog | So its not "new" |
| 22:22.05 | beandog | MyISAM + 5.0 + transactions is new. |
| 22:22.22 | PoeticIntensity | uhhh.... MySQL's implementation of innodb didn't support transactions, AFAIK, until MySQL 5.0 |
| 22:22.28 | beandog | wrong. :) |
| 22:22.31 | beandog | 4.0 has it. |
| 22:22.33 | PoeticIntensity | MyISAM still doesn't support transactions. |
| 22:22.44 | PoeticIntensity | mind if I ask for a link with that? |
| 22:22.46 | mgeary | au contraire |
| 22:22.52 | PoeticIntensity | I'm under the impression that 5.0 was the first. |
| 22:23.08 | mgeary | 5.x brought transactions and stored procs to MyISAM |
| 22:23.14 | PoeticIntensity | ah... |
| 22:23.16 | mgeary | and views |
| 22:23.46 | beandog | http://dev.mysql.com/doc/refman/4.1/en/ansi-diff-transactions.html |
| 22:23.47 | PoeticIntensity | so.... did MySQL 4.0 have transactions with inndob? |
| 22:23.49 | beandog | Yes |
| 22:23.50 | beandog | ^^ |
| 22:23.58 | beandog | MySQL Server (version 3.23-max and all versions 4.0 and above) supports transactions with the InnoDB and BDB transactional storage engines. |
| 22:24.32 | _psychic_ | Anyone here used Zend_Search (Lucene) before? |
| 22:24.33 | PoeticIntensity | thankee, beandog |
| 22:24.44 | beandog | ACID transactions are *very good thing* |
| 22:24.57 | PoeticIntensity | yup. |
| 22:24.57 | beandog | er, compliance. |
| 22:25.06 | beandog | anyway. you knew that. |
| 22:25.43 | _psychic_ | You can make a search engine for your site in like 100 lines, and that includes the crawler. |
| 22:27.45 | wps | I've having hot flashes |
| 22:28.00 | wps | I have eaten 10 oz of hot tamales again today |
| 22:29.01 | wps | it's a good thing that my addictions are not of controlled substances because I don't have a lot of will power |
| 22:29.02 | jsmith | Mmmmn.... |
| 22:29.44 | wps | they have you in scouts there, jsmith? |
| 22:29.54 | wps | I've done a lot of that |
| 22:29.58 | jsmith | Yup... 11-year-old scouts |
| 22:30.01 | mgeary | hey |
| 22:30.02 | mgeary | me too |
| 22:30.05 | wps | been scout master twice and assistance SM once |
| 22:30.11 | jsmith | Where you can still teach them :-) |
| 22:30.16 | synic | um... I was like... a scout once. |
| 22:30.37 | synic | I totally got my Eagle when I was 13. |
| 22:30.39 | jsmith | Well, it's about that time. Gotta have time to pick up some bribery^H^H^H^Hincentives at the store. |
| 22:30.48 | jsmith | ~zap synic |
| 22:31.02 | jbot | ACTION takes out a cattle prod and gives synic a good jolt. |
| 22:31.04 | jsmith | It's no fun when jbot is being so slow |
| 22:31.10 | synic | ouch. |
| 22:31.18 | wps | no kidding |
| 22:31.26 | wps | he has really been slow a lot lately |
| 22:31.37 | wps | must be getting arthritic in his old age |
| 22:31.57 | jsmith-away | He? I thought it was a she |
| 22:31.57 | wps | jbot, go to the doctor |
| 22:32.07 | wps | I hope not… he has a girlfriend |
| 22:32.10 | jsmith-away | ~doctor jbot |
| 22:32.13 | jsmith-away | She does? |
| 22:32.25 | wps | jbot, do you have a girlfriend? |
| 22:32.27 | jbot | yes, I have a girlfriend. |
| 22:32.28 | jsmith-away | ~gender ibot |
| 22:32.30 | jbot | I heard ibot is sexless. |
| 22:32.38 | beandog | classic nerd. |
| 22:32.42 | jsmith-away | jbot: Are you female? |
| 22:32.53 | mgeary | i like how jbot has to rely on hearsay |
| 22:32.57 | thebigdog | wow found a bug in tb2 |
| 22:33.10 | jsmith-away | Later all... |
| 22:33.13 | wps | he's not willing to commit to anything |
| 22:33.16 | wps | goodnight, jsmith-away |
| 22:33.18 | beandog | tb2? |
| 22:33.34 | thebigdog | thunderbird2 |
| 22:33.37 | mgeary | my back hurts |
| 22:33.40 | beandog | oh |
| 22:33.44 | wps | stop slouching |
| 22:33.47 | mgeary | seriously |
| 22:34.16 | wps | I could barely walk last night |
| 22:34.40 | wps | I have a herniated disc and I think that I aggravated it by slouching at work |
| 22:38.51 | thebigdog | wps i thought you said hemroids |
| 22:39.00 | wps | eek |
| 22:39.01 | wps | heavens no |
| 22:43.44 | mgeary | ~buy wps Preparation H tube |
| 22:43.57 | jbot | ACTION goes to S-Mart and gets a dozen Preparation H tubes for wps |
| 22:43.58 | wps | no no no |
| 22:44.43 | _psychic_ | ~buy mgeary-and-wps bengay |
| 22:44.49 | jbot | ACTION goes to S-Mart and gets a dozen bengays for mgeary-and-wps |
| 22:48.10 | _psychic_ | Isn't the plural of bengay, bengai ? |
| 22:48.12 | _psychic_ | :/ |
| 22:48.17 | mgeary | bengal |
| 22:48.46 | _psychic_ | bengais |
| 22:48.53 | mgeary | benelux |
| 22:48.59 | _psychic_ | haha |
| 22:49.46 | beandog | thebigdog: thats what I read too :) |
| 23:10.19 | Lone_Wanderer | ~lart people whose job it is to interface with customers on my behalf. |
| 23:10.19 | jbot | takes out people whose job it is to interface with customers on my behalf. with the trash |
| 23:11.15 | *** join/#uphpu jsmith-away (n=jsmith@70.5.231.20) |
| 23:11.15 | *** mode/#UPHPU [+v jsmith-away] by ChanServ |
| 23:12.27 | Utah_Dave | ~lart mindjuju |
| 23:12.27 | jbot | beats mindjuju into protomatter with the andromeda galaxy |
| 23:15.12 | beandog | Lone_Wanderer: heh |
| 23:15.54 | beandog | why do I get stuck with all the weird CSS errors |
| 23:17.19 | Lone_Wanderer | Why do I get stuck with the idiot clients who have problems that Abish doesn't understand, resulting in communications going to the client that make it sound like we're clueless? |
| 23:17.26 | beandog | oh, dangit. that one was easy to fix. |
| 23:18.20 | beandog | Lone_Wanderer wins |
| 23:18.38 | Lone_Wanderer | What did I win? Oh, the "who has the worse problem" contest? |
| 23:18.41 | beandog | yah |
| 23:18.47 | Lone_Wanderer | cool |
| 23:18.49 | beandog | congratulations |
| 23:19.05 | Lone_Wanderer | I really hope I can boost my wireless signal with my satellite dish. |
| 23:19.55 | thebigdog | ~wow Lone_Wanderer |
| 23:20.22 | jbot | from memory, lone_wanderer is goes through sunflower seeds way too fast, or an acolyte of mindjuju's musical tastes, or not heckariffic (whatever that is) |
| 23:23.34 | beandog | ~wow ? |
| 23:24.05 | jbot | methinks wow is the best game EVAR! |
| 23:40.17 | mindjuju | thx a heap Utah_DAve |
| 23:41.44 | mindjuju | that's got to be some sort of records, 6 hours of various meets today |
| 23:43.30 | Utah_Dave | any time, mindjuju |
| 23:43.39 | Utah_Dave | a good lart can ward off the meeting blues |
| 23:47.39 | *** part/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 23:52.47 | mgeary | later folks |
| 23:52.53 | *** part/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 23:54.34 | mindjuju | that' s funny, they have the worst tech mascots on this page |
| 23:54.49 | mindjuju | http://www.wired.com/culture/design/multimedia/2007/04/gallery_mascots?slide=11&slideView=3 |
| 23:54.49 | mindjuju | the funny thing though, they left out the worst one of all |
| 23:55.01 | mindjuju | MSN was this guy in a blue butterfly suit, how did that miss this list? |