btami (~tamas@ip102-205.ktv.tiszanet.hu) joined #gnuenterprise.
johannes (~johannes@M1253P027.adsl.highway.telekom.at) left irc: Read error: 110 (Connection timed out)
havoc (~havoc@CPE-65-31-171-97.wi.rr.com) got netsplit.
havoc (~havoc@CPE-65-31-171-97.wi.rr.com) returned to #gnuenterprise.
btami (~tamas@ip102-205.ktv.tiszanet.hu) got netsplit.
IsoosI (dahoose@port-210-54-58-156.jet.net.nz) got netsplit.
Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) got netsplit.
havoc (~havoc@CPE-65-31-171-97.wi.rr.com) got netsplit.
havoc (~havoc@CPE-65-31-171-97.wi.rr.com) returned to #gnuenterprise.
btami (~tamas@ip102-205.ktv.tiszanet.hu) returned to #gnuenterprise.
IsoosI (dahoose@port-210-54-58-156.jet.net.nz) returned to #gnuenterprise.
Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) returned to #gnuenterprise.
reinhard (~reinhard@M1259P014.adsl.highway.telekom.at) joined #gnuenterprise.
dimas (~Administr@ics.elcom.ru) joined #gnuenterprise.
dimas (~Administr@ics.elcom.ru) left #gnuenterprise ("Client Exiting").
<Vee2d2> my office looks like it was hit by a toronado.. 
Action: Vee2d2 warms up the coffee and gets to cleaning up
Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) left irc: Remote closed the connection
Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) joined #gnuenterprise.
Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) left irc: Remote closed the connection
Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) joined #gnuenterprise.
Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) left irc: Remote closed the connection
Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) joined #gnuenterprise.
btami (~tamas@ip102-205.ktv.tiszanet.hu) left irc: 
ToyMan (~stuq@smtp.dstoys.com) joined #gnuenterprise.
kyeran (kye@ip68-97-43-25.ok.ok.cox.net) joined #gnuenterprise.
chillywilly (~danielb@CPE-24-167-199-51.wi.rr.com) left irc: Read error: 104 (Connection reset by peer)
Action: kyeran has just found the documentation for how to use forms and is proceeding to try and implement Hello Forms!
chillywilly (~danielb@CPE-24-167-199-51.wi.rr.com) joined #gnuenterprise.
jamest (~jamest@gw.math.ksu.edu) joined #gnuenterprise.
jemfinch (~jfincher@ts3-2.homenet.ohio-state.edu) joined #gnuenterprise.
<jemfinch> I'm having some real trouble thinking of the Best Way to do some SQL.
<jemfinch> before I type a lot, is someone here who can try to help me?
<reinhard> i'm not sure if i can help you
<reinhard> but you can try :)
<jemfinch> ok, I've got a table with an id and some other information.
<jemfinch> and I've got another table depends that has a .port_id and a .depends_id, and those ids are foreign keys into the first table (ports)
<jemfinch> a port can be said to "depend" on another port if in the depends table, there is a row where that port's id is in port_id and another port's id is in depends_id.
<jemfinch> with me so far?
<reinhard> just a sec
<reinhard> on the phone :(
<jemfinch>     cursor.execute("""CREATE TABLE ports (
<jemfinch>                       id INTEGER PRIMARY KEY,
<jemfinch>                       name TEXT UNIQUE ON CONFLICT IGNORE,
<jemfinch>                       path TEXT,
<jemfinch>                       info TEXT,
<jemfinch>                       maintainer TEXT,
<jemfinch>                       website TEXT
<jemfinch>                       )""")
<jemfinch>     cursor.execute("""CREATE TABLE depends (
<jemfinch>                       port_id INTEGER,
<jemfinch>                       depends_id INTEGER
<jemfinch>                       )""")
<jemfinch> that's the relevant schema (I figured I'd paste it just to make things clearer, since no one else was chatting that I could see)
<jamest> ok
<jemfinch> ok, I think I got it.
<jemfinch> sqlite> SELECT * FROM ports, depends WHERE
<jemfinch>    ...> ports.id = depends.port_id AND
<jemfinch>    ...> depends.depends_id IN (SELECT id FROM ports WHERE name LIKE 'python%');
<jemfinch> but man, that's a slow query.
<jamest> I'm not sure I'm following
<jemfinch> that query finds all the ports that depend on a port whose name is LIKE 'python%'.
<reinhard> back from the phone
<reinhard> jemfinch: you sorted it out yourself, or still need help
<jemfinch> reinhard: I think I sorted it out myself.
<reinhard> sorry i'm at work and have to pick up the phone when it rings ..
<reinhard> ok
<jemfinch> but do you see any reason that SELECT statement should be slow?
<reinhard> it was a pleasure to help you ;)
<jemfinch> thanks :)
<jemfinch> ah, ok.
<jemfinch> putting an index on ports_id and depends_id of the depends table made it fast.
<reinhard> i think an index on ports_id should do it
<jemfinch> the index on depends_id isn't necessary?
<reinhard> i'm not sure if the db can make use of the index on depends_id in this qhery
<reinhard> query
<reinhard> but the ways of db optimizers are sometimes very hard to understand
<reinhard> i would at least try it :)
jemfinch` (~jfincher@ts3-9.homenet.ohio-state.edu) joined #gnuenterprise.
jemfinch (~jfincher@ts3-2.homenet.ohio-state.edu) left irc: "Client Exiting"
Nick change: jemfinch` -> jemfinch
<jemfinch> sorry, I'm on a 30-minute internet line.
<jemfinch> did I miss anything from "the index on depends_id" isn't necessary?"
<jemfinch> (and no, it's not, I just dropped the index and it's still fast)
<reinhard> <reinhard> i'm not sure if the db can make use of the index on depends_id in this qhery
<reinhard> <reinhard> query
<reinhard> <reinhard> but the ways of db optimizers are sometimes very hard to understand
<reinhard> <reinhard> i would at least try it :)
<jemfinch> I did, you were right :)
<reinhard> :)
<jamest> what db?
<jemfinch> jamest: I'm using SQLite.
<jemfinch> ok, I have another question, but this one is more style-related.
<jemfinch> I have a command that has various arguments that basically added constraints, and I want to find all records that match those given constraints.
<jemfinch> is it inelegant to iterate through the constraints, making a new VIEW of the database under each new constraint, and then just selecting * from the last view when I'm done?
<reinhard> yes
<reinhard> i think this is unelegant
<jemfinch> what would be a better solution?
<reinhard> because i think creating a view is very expensive (performance wise)
<jemfinch> oh, hmm.
<reinhard> i would dynamically add all constraints to the WHERE clause
<reinhard> that i
<reinhard> that is
<reinhard> i would create the SQL statement on the fly
<jemfinch> hmm.
<reinhard> and build the where clause dynamically
<jemfinch> I guess I can do that, since I figured out how to put the depends stuff in one WHERE clause.
jbailey (~jbailey@atlas.fundserv.com) joined #gnuenterprise.
jemfinch (~jfincher@ts3-9.homenet.ohio-state.edu) left irc: "Client Exiting"
jemfinch (~jfincher@ts8-9.homenet.ohio-state.edu) joined #gnuenterprise.
<reinhard> :
<jemfinch> ::
<reinhard> :)
<jemfinch> hmm.
<jemfinch> this query is unexpectedly taking a long time.
<jemfinch> SELECT ports.name FROM depends, in_category, ports, categories WHERE ports.id=depends.port_id AND depends.depends_id IN (SELECT id FROM ports WHERE name LIKE 'python%') and categories.name LIKE 'science' AND in_category.category_id=categories.id AND in_category.port_id=ports.id;
<reinhard> i would try an index over
<reinhard> in_category.category_id
<reinhard> and in_category.port_id
<jemfinch> I've got indexes on those already, and it's still taking a long time.
<reinhard> do you also have an index ouver categories.id
<reinhard> ?
<jemfinch> no, I don't have that.
<reinhard> ok try that
<jemfinch> oh, wait, I do.
<jemfinch> it's a PRIMARY KEY
<jemfinch> it just seems odd that the query would take so long.
<reinhard> do all primary keys have an index automatically?
<jemfinch> yeah, in SQLite they do.
<jemfinch> hmm.
<reinhard> maybe
<jemfinch> maybe I should reorder my SQL statement and put the category stuff at the beginning?
<reinhard> i would do it the other way around
<reinhard> like
<jemfinch> hmm, reordering the SQL statement doesn't seem to fix it.
<reinhard> ... AND in_category.port_id=ports.id AND categories.id=in_category.category_id AND categories.name LIKE 'science'
<jemfinch> it's odd, because a query on "categories.name='science' AND in_category.port_id=ports.id AND in_category.category_id=categories.id" returns almost immediately.
<reinhard> you might also try to replace LIKE 'science' with ='science' and see if that makes much difference
<jemfinch> that doesn't, I've tried that.
<reinhard> hmm
Action: reinhard is clueless
<jemfinch> m etoo.
<jemfinch> reordering as per your suggestion doesn't seem to be doing it.
jemfinch` (~jfincher@ts20-15.homenet.ohio-state.edu) joined #gnuenterprise.
jemfinch (~jfincher@ts8-9.homenet.ohio-state.edu) left irc: "Client Exiting"
Nick change: jemfinch` -> jemfinch
jemfinch (~jfincher@ts20-15.homenet.ohio-state.edu) left irc: "Client Exiting"
jemfinch (~jfincher@ts21-11.homenet.ohio-state.edu) joined #gnuenterprise.
lupo (~lupo@pD9542F2E.dip.t-dialin.net) joined #gnuenterprise.
jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise.
<lupo> jcater!
<jcater> word
<lupo> excel
Action: jemfinch found the problem with the slow query.
<lupo> slow query ... hm, you used informix? *fg*
<jemfinch> hehe.
fixe (~fixe@dsl093-081-253.chi2.dsl.speakeasy.net) joined #gnuenterprise.
<reinhard> anybody know how i can make an eps out of a ps?
<jcater> ps2epsi
<jcater> part of the ghostscript package, iirc
<reinhard> epsi == eps?
<reinhard> ugh
<reinhard> ps2epsi chokes on my ps file
<jcater> yes
jemfinch (~jfincher@ts21-11.homenet.ohio-state.edu) left #gnuenterprise ("Client Exiting").
<jcater> yuck
<jcater> that is just a wrapper around gs
<jcater> so I guess that means gs doesn't like it either?
<reinhard> i can view it with ghostview
<reinhard> which is also a wrapper around gs IIRC?
<jcater> hmmm
<reinhard> yeah and gs shows it, too
<jcater> I don't know what else to use :(
<jcater> unless you want to try ps2ps
<jcater> then ps2epsi
<reinhard> GMTA
<reinhard> i already tried
<reinhard> but no help :(
<reinhard> i looked at ps2epsi
<reinhard> it does some funny things
<jcater> if it's a one-time thing, I can do it for you w/our in-house stuff
<reinhard> it runs the ps through an awk script before processing
<jcater> but if it's a script kind of job, that won't help
<jamest> i thought gimp could save .ps as .eps
<jamest> actually I know it can as I had to do one this week
<jcater> but it would rasterize it, I imagine
<jcater> as gimp doesn't do native vector art
<jamest> picky picky 
<jamest> :)
<jcater> sigh
<jcater> I want to go home
<jcater> and I want my xchat 1.x back too
<reinhard> jcater: it works perfectly now
<reinhard> thanks a lot!!
<jcater> no problem
<jbailey> I like xchat2. =)
<jbailey> I can read the fonts.
Action: jcater thwaps jbailey
<jcater> don't interrupt one of my tyraids
<jcater> (sp?)
jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) left irc: "Client exiting"
jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise.
<jamest>  /msg jbailey you have to take it easy on jcater, he doesn't like change, unless of course it's change that he commited
Action: jcater thwaps jamest
kyeran (kye@ip68-97-43-25.ok.ok.cox.net) left irc: "Bed Time"
<jbailey>  /msg jamest Don't like change is right!  I didn't get any change from the $50 dollars I gave him.  And the evening was only worth $30 IMnsHO.
<jamest> lol
reinhard (~reinhard@M1259P014.adsl.highway.telekom.at) left irc: "Real programmers don't comment their code. If it was hard to write, it should be hard to understand"
reinhard (~reinhard@M1259P014.adsl.highway.telekom.at) joined #gnuenterprise.
neilt (~neilt@66.95.70.186) joined #gnuenterprise.
reinhard_ (~reinhard@M1259P014.adsl.highway.telekom.at) joined #gnuenterprise.
<neilt> reinhard_:  hello
<reinhard_> hi neilt
<reinhard_> long time no see
<reinhard_> how are you?
<chillywilly> hi neilt 
reinhard (~reinhard@M1259P014.adsl.highway.telekom.at) left irc: Read error: 111 (Connection refused)
<neilt> ok, i guess
<neilt> too much work
<neilt> but thats probably a good thing all else considered
Nick change: reinhard_ -> reinhard
<reinhard> well
<reinhard> very much the same for me
<neilt> chillywilly: hello
<neilt> anyone know a good to chat with derek?
<neilt> s/good/good time/
<chillywilly> hmmm
<chillywilly> probably after office hours
<chillywilly> if he's not busy
<chillywilly> ;)
<chillywilly> like coaching soccer or what not
<neilt> is he still on regularily, I've waiting a couple of nights until 10 pm eastern time and he's not been around
<reinhard> bbl
reinhard (~reinhard@M1259P014.adsl.highway.telekom.at) left irc: "The more often you run over a dead cat, the flatter it gets"
<chillywilly> neilt: well lately I think his attendence has been spotty
Action: chillywilly is ALWAYS here though ;)
<chillywilly> muwahahaha
<jcater> neilt: usually best to announce you want to talk w/him
<jcater> and he'll see it and come in
<jcater> his office has new restrictions, so he doesn't stay connected all day
<chillywilly> booo
<chillywilly> stinkin' gov't
reinhard (~reinhard@M1259P014.adsl.highway.telekom.at) joined #gnuenterprise.
ToyMan (~stuq@smtp.dstoys.com) left irc: "Client Exiting"
<neilt> jcater: thanks
<neilt> jcater: and how do I announce that I want to talk with derek?
<jcater> I think you have
<jcater> now where is the bugger
<neilt> :)
<jbailey> buggering derek?  The goat got tired of the computer?
ToyMan (~stuq@170-215-194-210.bras01.glv.ny.frontiernet.net) joined #gnuenterprise.
<neilt> jbailey: hard for me to believe, more likely broke it
neilt (~neilt@66.95.70.186) left irc: "Be back later"
steveb_ (~steveb@202-0-63-186.paradise.net.nz) left irc: Read error: 110 (Connection timed out)
neilt (~neilt@ip68-105-182-97.nv.nv.cox.net) joined #gnuenterprise.
<jamest> http://www.devx.com/devx/editorial/11839
Action: jcater thwaps jamest
<jcater> so what are you trying to say, punk?
<reinhard> night all
reinhard (~reinhard@M1259P014.adsl.highway.telekom.at) left irc: "Never wrestle with a pig. You both get dirty and the pig likes it"
<jbailey> jcater: Don't trust that article.
<jbailey> The guy looks vaguely like he's been squished against the back wall.
<jcater> end users are highly overrated anyway
<jcater> just more work
<jamest> jcater: I'm trying to say "so how are input masks coming along?"
<jbailey> I just called...
Action: jcater thwaps jamest
<jbailey> to say..
<jbailey> I thwaped you!
jamest (~jamest@gw.math.ksu.edu) left irc: "[x]chat"
jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) left irc: "Client exiting"
jbailey (~jbailey@atlas.fundserv.com) left #gnuenterprise ("Client exiting").
havoc (~havoc@CPE-65-31-171-97.wi.rr.com) left irc: "Client exiting"
havoc (~havoc@CPE-65-31-171-97.wi.rr.com) joined #gnuenterprise.
dsmith (~dsmith@borg.altus.cc) joined #gnuenterprise.
dsmith (~dsmith@borg.altus.cc) left irc: Read error: 104 (Connection reset by peer)
jbailey (~jbailey@CPE0060082df811-CM014260028338.cpe.net.cable.rogers.com) joined #gnuenterprise.
jcater (~jcater@cpe-066-061-083-220.midsouth.rr.com) joined #gnuenterprise.
dsmith (~dsmith@borg.altus.cc) joined #gnuenterprise.
jbailey (~jbailey@CPE0060082df811-CM014260028338.cpe.net.cable.rogers.com) left irc: "Client exiting"
jbailey (~jbailey@CPE0060082df811-CM014260028338.cpe.net.cable.rogers.com) joined #gnuenterprise.
neilt (~neilt@ip68-105-182-97.nv.nv.cox.net) left irc: Read error: 110 (Connection timed out)
jamest (~jamest@adsl-64-216-106-61.dsl.tpkaks.swbell.net) joined #gnuenterprise.
neilt (~neilt@ip68-105-182-97.nv.nv.cox.net) joined #gnuenterprise.
dsmith (~dsmith@borg.altus.cc) left irc: Read error: 54 (Connection reset by peer)
<jamest> yo cater.....about those input masks......
Action: jamest ducks
dsmith (~dsmith@borg.altus.cc) joined #gnuenterprise.
Action: jcater thwaps jamest
fixe (~fixe@dsl093-081-253.chi2.dsl.speakeasy.net) left irc: "because I feel like it"
dsmith (~dsmith@borg.altus.cc) left irc: "later.."
neilt (~neilt@ip68-105-182-97.nv.nv.cox.net) left irc: "Later all"
dsmith (dsmith@oh-strongsvillecadent1-1d-224.clvhoh.adelphia.net) joined #gnuenterprise.
ToyMan (~stuq@170-215-194-210.bras01.glv.ny.frontiernet.net) left irc: "Client Exiting"
lupo (~lupo@pD9542F2E.dip.t-dialin.net) left irc: Read error: 110 (Connection timed out)
<Vee2d2> derek?
Action: Vee2d2 wonders if he ever got a working browser+java setup.. I cant seem to get anything working with application/x-java-vm support right now
<chillywilly> the newst JDK doesn't work w/ moz or any moz based broweser
<chillywilly> for me anyway
<Vee2d2> well, I assumed that too, so I purged it and went back to j2re1.3 but still dont work.. =/
<chillywilly> hmmm
jbailey (~jbailey@CPE0060082df811-CM014260028338.cpe.net.cable.rogers.com) left #gnuenterprise ("Client exiting").
<Vee2d2> there we go.. konq didnt seem to like 1.3 but did ok with 1.4
<Vee2d2> hada check out how the 'virtual tour' looked on our house, http://www.buyowner.com/buyers/property.asp?Code=DAL13510
<jcater> hmmm
<jcater> well
<jcater> I'm spinning around
<jcater> but I don't see the hippie dude sitting at the computer
<jcater> holding a beer and a baby
<jamest> jason: that's cause they're not in TN IIRC
<jamest> or from TN
<jcater> jamest: but he's from TX
<jcater> they are like TN
<jcater> only bigger
<jamest> ah, double wide folks
<jcater> right
<Vee2d2> hehe
<Vee2d2> I'm right behind that window in the front of the house, peeking through the blinds
<chillywilly> JDK 1.4 is out?
<jamest> 1.4.1
<jamest> 1.4.2 is beta IIRC
Action: chillywilly looks to see what he has
<chillywilly> hmm, I have 1.4.1
<chillywilly> but it don't work
<jamest> you turn java on in konq?
<jamest> it's off by default
<chillywilly> I use galeon a lot lately
<chillywilly> had better CSS support
<chillywilly> has*
<jamest> ah, the the UI still look horrible ?
<jamest> last I tried it it reminded me of a gnome 1 app
<jamest> :)
<chillywilly> I dunno I use the snapshot
<Vee2d2> I think straight 'galeon' is newer than '-snapshot' now.. 
<Vee2d2> geeg:~# apt-cache show galeon | grep Version;apt-cache show galeon-snapshot|grep Version
<Vee2d2> Version: 1.3.3.20030414-1
<Vee2d2> Version: 1.3.3.20030407-1
<chillywilly> HEH
<chillywilly> I didn't know they got rid of the old galeon finally
<Vee2d2> think it happened a day or two ago
<chillywilly> ok
<chillywilly> and they have new xchat too eh?
<Vee2d2> yea, but I find myself yearning for the old one
Remosi (dahoose@port-219-88-246-157.jet.net.nz) joined #gnuenterprise.
<Vee2d2> I dont think this thing was quite ready
<chillywilly> all gnome stuff is going through growing pains as all backwards compatibility was broken
<Vee2d2> yea.. 
<chillywilly> galeon just finally got some of its old features back
<chillywilly> but it pissed me off to the point that I started running KDe
<chillywilly> I think Gnome 2 is retarded
<chillywilly> KDE is not the power users desktop
<chillywilly> ;)
<chillywilly> now*
Action: jamest thwaps chillywilly
Action: chillywilly thinks jamest should read his typo correction
<chillywilly> fewl
IsoosI (dahoose@port-210-54-58-156.jet.net.nz) left irc: Read error: 60 (Operation timed out)
<jamest> ahhhhhhh
<chillywilly> for the record, KDE is *now* the power users desktop
<chillywilly> NOW
<chillywilly> !!!
<jamest> i read that as it would be in the future
Action: chillywilly does the flying trout o' death assualt on jamest 
Action: jcater thwaps chillywilly
Action: chillywilly does the flying trout o' death assault on jcater too
Action: chillywilly just slings trout madly at anyone in the immediate irc vicinity
Action: jcater grabs his umbrella
<jcater> while thwapping jamest
Action: jamest grabs his now trout stained thwap resistant boxers
<jamest> ah dammit chillywilly, you ruined them
Action: dsmith snags some flying trout wiht a a hot fy=rying pan
<chillywilly> heheh
<chillywilly> hey dale
<jamest> carefull
<chillywilly> huh?
<jamest> we don't know where chillywilly keeps his trout
Action: chillywilly whistles innocently
<jamest> they may be unfit for human consuption
<jamest> consumption even
Action: chillywilly puts the typo hex on jamest 
<jamest> too late
Action: dsmith slings hot smmelly trout at chillywilly
<dsmith> Someone rooted our box yesterday.
<chillywilly> jamest: at least he was cooking the trout
<dsmith> :(
<chillywilly> how?
<dsmith> samba I think.
<jamest> i've learned to hide my high rate of typos behind my inability to spell most words properly in the first place
<chillywilly> ack
<jamest> so you'll never know
<chillywilly> jamest: cool ;)
Action: havoc can spel
<chillywilly> jamest: are you still taking calculus courses?
<jamest> not right now
<jcater> he had to quit
<jamest> i had to take a break to get caught up on other stuff
<jcater> he kept misspelling dx
<havoc> http://www.newholland.com/na/Products/gardentrac.html
<havoc> MINE!
<chillywilly> jamest: HEHE
<chillywilly> erm, jcater 
<jamest> however they had approved financial aide already
Action: jcater drools over havoc's tractor
<jamest> so as punishment I loose it for 1 year
<havoc> jcater: I don't have it, yet .... :)
<havoc> someday....
<jamest> that little silver thing by the seat
<chillywilly> havoc: is your yard big enough for that thing?
<jamest> that's the donut holder right?
<havoc> chillywilly: sure :)
<chillywilly> HEH
<chillywilly> jamest: lol
jcater (~jcater@cpe-066-061-083-220.midsouth.rr.com) left irc: "Client exiting"
--- Thu Apr 17 2003