jemfinch (~jfincher@ts32-16.homenet.ohio-state.edu) joined #gnuenterprise. is there any way to declare a table that's unique on two columns? i.e., a table that wouldn't allow you to insert a new row with columns x='foo' and y='bar' if there already existed a row with x='foo' and y='bar'? yeah what database? in postgres, it'd look something like create table test ( field1 integer not null, field2 varchar not null, field3 datetime not null, unique (field1, field2) ); (if field1 and field2 are what you wanted to be unique) most other SQL92-like databases support the UNIQUE constraint too ah, cool. (oracle, et al) Action: jemfinch goes to see if SQLite supports it. ah, great, it does. awesome. Action: jemfinch loves SQLite. should I put an index on field1 and field2 if I want that uniqueness test to be fast? actually unique() implies an index so one should be created automatically hmm, I wonder if SQLite does that too. Action: jcater is pretty sure it does usually unique (field1, field2) is the same as create unique index xxxx on test (field1, field2); a VIEW will change if the underlying table changes, right? ok, yes, I tried it out :) reinhard (~reinhard@M1249P020.adsl.highway.telekom.at) joined #gnuenterprise. thanks for the help, jcater. jemfinch (~jfincher@ts32-16.homenet.ohio-state.edu) left #gnuenterprise ("Client Exiting"). Nick change: SachaS_away -> SachaS jemfinch (~jfincher@ts32-16.homenet.ohio-state.edu) joined #gnuenterprise. jemfinch (~jfincher@ts32-16.homenet.ohio-state.edu) left #gnuenterprise ("Client Exiting"). chillywilly (~danielb@CPE-24-167-199-51.wi.rr.com) left irc: "brb" btami (~tamas@ip102-205.ktv.tiszanet.hu) joined #gnuenterprise. btami (~tamas@ip102-205.ktv.tiszanet.hu) left irc: Remote closed the connection lekma (~lekma@node1142c.a2000.nl) joined #gnuenterprise. lekma (~lekma@node1142c.a2000.nl) left #gnuenterprise ("Client exiting"). Nick change: SachaS -> SachaS_away reinhard (~reinhard@M1249P020.adsl.highway.telekom.at) left irc: "This sentence no verb" lekma (~lekma@node1142c.a2000.nl) joined #gnuenterprise. lekma (~lekma@node1142c.a2000.nl) left #gnuenterprise ("Client exiting"). Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) left irc: Remote closed the connection reinhard (~reinhard@M1249P020.adsl.highway.telekom.at) joined #gnuenterprise. Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) joined #gnuenterprise. reinhard (~reinhard@M1249P020.adsl.highway.telekom.at) left irc: "Even if you're on the right track, you'll get run over if you just sit there" amen to that steveb_ (~steveb@202.0.63.153) joined #gnuenterprise. steveb__ (~steveb@202.0.63.153) left irc: Read error: 110 (Connection timed out) dsmith (dsmith@oh-strongsvillecadent1-1d-224.clvhoh.adelphia.net) left irc: "later.." dsmith (dsmith@oh-strongsvillecadent1-1d-224.clvhoh.adelphia.net) joined #gnuenterprise. dsmith (dsmith@oh-strongsvillecadent1-1d-224.clvhoh.adelphia.net) left irc: Client Quit dsmith (dsmith@oh-strongsvillecadent1-1d-224.clvhoh.adelphia.net) joined #gnuenterprise. SachaS_away (~Sacha@dialup-196-116.wasp.net.au) got netsplit. SachaS_away (~Sacha@dialup-196-116.wasp.net.au) got lost in the net-split. SachaS_away (~Sacha@dialup-196-116.wasp.net.au) joined #gnuenterprise. SachaS_away (~Sacha@dialup-196-116.wasp.net.au) left irc: Network is unreachable dsmith (dsmith@oh-strongsvillecadent1-1d-224.clvhoh.adelphia.net) left irc: "later.." SachaS_away (~Sacha@dialup-196-183.wasp.net.au) joined #gnuenterprise. Nick change: SachaS_away -> SachaS jamest (~jamest@gw.math.ksu.edu) joined #gnuenterprise. kyeran (kye@ip68-97-43-25.ok.ok.cox.net) joined #gnuenterprise. Action: kyeran is confused are GNUe Modules and Classes C++ things, or are they something else??? something else gnue is a few different things Does it get parsed by GEIS and generate stub structs/SQL??? and all of our tools are designed to work independent of the others so you can what you want So what 'glues' them together?? CORBA??? if you want a simple client/server setup say a graphical front end to a database you can grab forms and write the xml files by hand if you want a middle tier w/ business objects you grab appserver and define your objects in there forms has a appserver interface so it'll not really know the difference - it's still just a datasource appserver/forms communicate over gnue common's rpc abstraction library but I know little about it Ok seisel showed me a demo the other day with appserver tied to a javascript based forms like setup running over the web it was pretty slick Cool so really you can just grab the pieces you want So A browser connected to an Appserver addy, and then appserver returned appropriate javascript??? the only thing all current tools depend upon is GNUe Common i don't know the internal implementation details Ok he just said "go here and test it out" LOL :) Where do I find out what is in GNUe Common??? Sorry, Just found it Action: kyeran is away: I'm busy deprogram (~deprogram@dsc05-cld-oh-1-163.rasserver.net) left irc: Read error: 110 (Connection timed out) the common docs are not complete and the ones I'm working on are targeted more toward using common outside of gnue but it's the same as how we use it :) dsmith (~dsmith@borg.altus.cc) joined #gnuenterprise. Action: kyeran is back (gone 00:31:43) jcater (~jason@cpe-066-061-083-220.midsouth.rr.com) left irc: "Client Exiting" chillywilly (~danielb@CPE-24-167-199-51.wi.rr.com) joined #gnuenterprise. chillywilly (~danielb@CPE-24-167-199-51.wi.rr.com) left irc: "leaving" ah, cfengine enabling me too push buggy configuration info to all my systems w/ a single command LOL :) jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise. kyeran (kye@ip68-97-43-25.ok.ok.cox.net) left irc: "Bedtime" chillywilly (~danielb@CPE-24-167-199-51.wi.rr.com) joined #gnuenterprise. esands (~nic@mdr1-port21.jetstart.maxnet.co.nz) left irc: Read error: 60 (Operation timed out) steveb__ (~steveb@202.0.63.174) joined #gnuenterprise. steveb_ (~steveb@202.0.63.153) left irc: Read error: 104 (Connection reset by peer) esands (~nic@mdr1-port5.jetstart.maxnet.co.nz) joined #gnuenterprise. steveb_ (~steveb@202.0.63.253) joined #gnuenterprise. chillywilly (~danielb@CPE-24-167-199-51.wi.rr.com) left irc: "leaving" chillywilly (~danielb@CPE-24-167-199-51.wi.rr.com) joined #gnuenterprise. steveb__ (~steveb@202.0.63.174) left irc: Read error: 110 (Connection timed out) dsmith (~dsmith@borg.altus.cc) left irc: "later.." dsmith (~dsmith@borg.altus.cc) joined #gnuenterprise. lupo (lupo@pD9542475.dip.t-dialin.net) joined #gnuenterprise. chillywilly (~danielb@CPE-24-167-199-51.wi.rr.com) left irc: "leaving" away chillywilly (~danielb@CPE-65-31-171-97.wi.rr.com) joined #gnuenterprise. lupo (lupo@pD9542475.dip.t-dialin.net) left irc: Read error: 104 (Connection reset by peer) Stoke (~stoker@dpvc-141-149-254-50.buff.east.verizon.net) got netsplit. Stoke (~stoker@dpvc-141-149-254-50.buff.east.verizon.net) returned to #gnuenterprise. dyfet (~dyfet@pool-138-89-34-217.mad.east.verizon.net) joined #gnuenterprise. man.. somehow someone's gotten ahold of my company debit card# and has been going to town yesterday and today.. =/ Action: Vee2d2 goes to da bank.. vee, so how is your new g4 powermac with the 27" monitor? :( that sucks /msg jcater I didn't think he'd notice until after we got the new 50" plasma monitor were delivered lol /msg jamest your's wasn't delivered yet? I told you to do it overnight /msg jcater well, the card was near it's limit and that is an oversized package, i had to adapt harobed (~harobed@harobed.net1.nerim.net) left irc: Connection timed out fixe (~fixe@dsl093-081-253.chi2.dsl.speakeasy.net) left irc: "Client exiting" jemfinch (~fincher@delta.cis.ohio-state.edu) joined #gnuenterprise. ok, I've got another SQL question :) is there a way to change my ON CONFLICT resolution behavior based on certain criteria? I have never played with ON CONFLICT resolution, so don't know (I don't even know what that is) well, I'm doing a Markov's chain database. sorry :( so I have two tables: "create table pairs (id integer primary key, first text, second text, unique (first, second) on conflict ignore)" and "create table follows (id integer primary key, pair_id integer, word text)" I'm sure you can see how that works, right? (assuming you know markov's chains) i've never used it well, basically, you take two words and maintain a list of the words that follow those two words. and so you can build random but somewhat intelligible text by taking a random pair of words from the pairs table and following them with a word from the follows table, and then iterating. I can show you some output if you come to #sourcereview anyway, for it to be *really* good, rather than start off the markov phrase with a random pair, you should start off the phrase only with a pair that actually started a phrase in your corpus. so I'd like to change my pairs table to include an "is_first" boolean to determine if the pair was used first in a message. but then my on conflict ignore thing doesn't work perfectly fine. I have no idea how you'd program any of that kind of logic using SQL constructs... that seems like purely application-level logic to me ok, I was just curious. oh, and ON CONFLICT appears to be non-standard. so it's not a bad thing that you don't really use it :) hmm. I can add an ON CONFLICT to INSERTs. so when I'm inserting my first pair, I can use ON CONFLICT UPDATE, and the rest of the pairs, ON CONFLICT IGNORE. so I IGNORE adds with an is_first of 0, and REPLACE adds with an is_first of 1. dyfet (~dyfet@pool-138-89-34-217.mad.east.verizon.net) left irc: "Client exiting" chillywilly (~danielb@CPE-65-31-171-97.wi.rr.com) left irc: "leaving" chillywilly (~danielb@CPE-65-31-171-97.wi.rr.com) joined #gnuenterprise. chillywilly (~danielb@CPE-65-31-171-97.wi.rr.com) got netsplit. jemfinch (~fincher@delta.cis.ohio-state.edu) got netsplit. Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) got netsplit. aaron_ (coyote@CPE-24-163-193-174.mn.rr.com) got netsplit. InsanitY (insanity@co58147-a.olden1.ov.home.nl) got netsplit. havoc (~havoc@CPE-65-31-171-97.wi.rr.com) got netsplit. derek (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) got netsplit. ToyMan (~stuq@smtp.dstoys.com) got netsplit. esands (~nic@mdr1-port5.jetstart.maxnet.co.nz) got netsplit. Remosi (dahoose@port-219-88-246-74.jet.net.nz) got netsplit. esands (~nic@mdr1-port5.jetstart.maxnet.co.nz) returned to #gnuenterprise. Remosi (dahoose@port-219-88-246-74.jet.net.nz) returned to #gnuenterprise. chillywilly (~danielb@CPE-65-31-171-97.wi.rr.com) returned to #gnuenterprise. jemfinch (~fincher@delta.cis.ohio-state.edu) returned to #gnuenterprise. Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) returned to #gnuenterprise. havoc (~havoc@CPE-65-31-171-97.wi.rr.com) returned to #gnuenterprise. ToyMan (~stuq@smtp.dstoys.com) returned to #gnuenterprise. InsanitY (insanity@co58147-a.olden1.ov.home.nl) returned to #gnuenterprise. aaron_ (coyote@CPE-24-163-193-174.mn.rr.com) returned to #gnuenterprise. derek (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) returned to #gnuenterprise. ToyMan (~stuq@smtp.dstoys.com) left irc: "Client Exiting" Remosi (dahoose@port-219-88-246-74.jet.net.nz) got netsplit. esands (~nic@mdr1-port5.jetstart.maxnet.co.nz) got netsplit. aaron_ (coyote@CPE-24-163-193-174.mn.rr.com) got netsplit. InsanitY (insanity@co58147-a.olden1.ov.home.nl) 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. derek (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) got netsplit. jemfinch (~fincher@delta.cis.ohio-state.edu) got netsplit. chillywilly (~danielb@CPE-65-31-171-97.wi.rr.com) got netsplit. chillywilly (~danielb@CPE-65-31-171-97.wi.rr.com) returned to #gnuenterprise. jemfinch (~fincher@delta.cis.ohio-state.edu) returned to #gnuenterprise. Vee2d2 (~vin@c66.169.136.41.ts46v-07.otn-c1.ftwrth.tx.charter.com) returned to #gnuenterprise. havoc (~havoc@CPE-65-31-171-97.wi.rr.com) returned to #gnuenterprise. InsanitY (insanity@co58147-a.olden1.ov.home.nl) returned to #gnuenterprise. aaron_ (coyote@CPE-24-163-193-174.mn.rr.com) returned to #gnuenterprise. derek (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) returned to #gnuenterprise. esands (~nic@mdr1-port5.jetstart.maxnet.co.nz) returned to #gnuenterprise. Remosi (dahoose@port-219-88-246-74.jet.net.nz) returned to #gnuenterprise. ToyMan (~stuq@170-215-196-92.bras01.glv.ny.frontiernet.net) joined #gnuenterprise. jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) left irc: "Client Exiting" harobed (~harobed@harobed.net1.nerim.net) joined #gnuenterprise. jamest (~jamest@gw.math.ksu.edu) left #gnuenterprise. jemfinch (~fincher@delta.cis.ohio-state.edu) left #gnuenterprise ("Client Exiting"). jamest (~jamest@gw.math.ksu.edu) joined #gnuenterprise. Action: chillywilly smacks everyone with a trout dsmith (~dsmith@borg.altus.cc) left irc: "later.." jamest (~jamest@gw.math.ksu.edu) left irc: "[x]chat" jamest (~jamest@adsl-65-64-190-216.dsl.tpkaks.swbell.net) joined #gnuenterprise. jcater (~jason@cpe-066-061-083-220.midsouth.rr.com) joined #gnuenterprise. chillywilly (~danielb@CPE-65-31-171-97.wi.rr.com) left irc: "leaving" chillywilly (~danielb@CPE-24-167-199-51.wi.rr.com) joined #gnuenterprise. SachaS (~Sacha@dialup-196-183.wasp.net.au) left #gnuenterprise ("Client Exiting"). SachaS (~Sacha@dialup-196-82.wasp.net.au) joined #gnuenterprise. steveb_ (~steveb@202.0.63.253) left irc: Read error: 104 (Connection reset by peer) ToyMan (~stuq@170-215-196-92.bras01.glv.ny.frontiernet.net) left irc: "Client Exiting" steveb_ (~steveb@202.0.63.242) joined #gnuenterprise. ToyMan (~stuq@170-215-196-92.bras01.glv.ny.frontiernet.net) joined #gnuenterprise. ToyMan (~stuq@170-215-196-92.bras01.glv.ny.frontiernet.net) left irc: Client Quit jamest_ (~jamest@adsl-65-71-168-103.dsl.tpkaks.swbell.net) joined #gnuenterprise. jamest (~jamest@adsl-65-64-190-216.dsl.tpkaks.swbell.net) left irc: Read error: 104 (Connection reset by peer) jamest (~jamest@adsl-64-216-106-200.dsl.tpkaks.swbell.net) joined #gnuenterprise. jamest_ (~jamest@adsl-65-71-168-103.dsl.tpkaks.swbell.net) left irc: Read error: 104 (Connection reset by peer) W00t! w0000000tttttt!!!!!!!!!! I'm wire free coool Action: chillywilly was sire free for a while today wire even havoc has 2 access points in his house...he's such a nerd ;) yeah, i'm feeling nerdy myself setting here watching my son play Zelda while I irc cool I let my son irc once no way dude anyone remeber that little incident? ;) yes he was in this channel IIRC but people like jcater and derek hang out in here! he was like typing his name over and over again HEH I know I should be locked up for child abuse now I can do what I set out to do work even when I'm taking a break from the office take over the world? you can eat you dinner with your laptop while hacking some python or somehting don't eat the laptop though bad jamest :) jamest (~jamest@adsl-64-216-106-200.dsl.tpkaks.swbell.net) left irc: "Client Exiting" wtf jamest (~jamest@adsl-64-216-106-200.dsl.tpkaks.swbell.net) joined #gnuenterprise. fucking with my theme has made my konsole background gray yuck what the hell I'm using the zmachine jpeg as my background wassat? it's a pleasant reminder that no matter how bad a day I'm having the tiny piece of matter at the center of that shitstorm is having a worse one i'll find a url damnit this sucks I can't change it back blah brb chillywilly (~danielb@CPE-24-167-199-51.wi.rr.com) left irc: "leaving" chillywilly (~danielb@CPE-24-167-199-51.wi.rr.com) joined #gnuenterprise. http://www.sandia.gov/news-center/news-releases/2003/images/jpg/zmachine.jpg playing with the themes changed my backgroud that what it was wtf is that? the zmachine an experimal fusion reactor it takes about 3 fuckloads of energy and focuses it into an area about the size of a pencil eraser it's humbling to look at are those like big huge sparks? like jacob 'sladder type thingies? i think it's just leaking energy from the machine it's been a while since I've read about the power of that thing thing is on my laptop here it's hard to see the whole picure at once I am fixed at 1024x768 ah i have it and a few other pics scaled and in rotation as my background it'll scale to your res nicely yea, I was thinking of downloading IIRC that machine uses in a brief moment enough energy to power a small city I know this pic here was from a recent article on /. i didn't read the text though as I've been bust busy derek: you here? jamest (~jamest@adsl-64-216-106-200.dsl.tpkaks.swbell.net) left irc: "Client Exiting" --- Sat Apr 12 2003