| --- Log opened Thu Apr 09 00:00:44 2009 |
| 00:38 | | * C_tiger needs SQL help. |
| 00:38 | <@C_tiger> | any volunteers? |
| 00:42 | <@C_tiger> | I have two tables with an overlapping column. I can easily find the number of distinct rows in tblA that are also in tblB, but I'm looking for the number of rows of tblA that AREN'T in tblB. So the syntax: select count(distinct(tblA.A)) from tblA where tblA.A NOT IN (SELECT tblB.B FROM tblB) would work. |
| 00:42 | <@C_tiger> | except that tblB is massive at almost 500K rows. |
| 00:42 | <@C_tiger> | and tblA is small. |
| 00:42 | <@C_tiger> | but significant. |
| 00:43 | <@C_tiger> | any way to make this faster. I'm assuming that some kind of left join is necessary but I don't really understand those. |
| 00:47 | <@C_tiger> | hmm... nevermind, 25 minutes later the query finished. |
| 00:48 | <@C_tiger> | I'd appreciate thoughts on how to make this more efficient in the future but for now, having the answer is more important. |
| 01:01 | | McMartin [~mcmartin@Nightstar-3361.dsl.pltn13.sbcglobal.net] has quit [Operation timed out] |
| 01:02 | | C_tiger [~cheng@Nightstar-5625.hsd1.ca.comcast.net] has quit [Ping Timeout] |
| 01:14 | | C_tiger [~cheng@Nightstar-5625.hsd1.ca.comcast.net] has joined #code |
| 01:14 | | mode/#code [+o C_tiger] by ChanServ |
| 01:16 | | thalass [~thalass@Nightstar-23217.dyn.iinet.net.au] has joined #code |
| 01:16 | < thalass> | arg |
| 01:40 | < thalass> | I'm wondering if this is possible: Have a usb mouse connected to a computer, with the computer ignoring the xy commands for the cursor, and interpreting the scroll wheel/middle button as volume up/down and mute. Perhaps the other two mouse buttons as other funcitons. Is this possible? |
| 01:41 | < thalass> | and is is possible with another usb pointing device doing the regular xy and clicky functions? |
| 01:44 | | somnolence [~somnolenc@Nightstar-3790.hsd1.ca.comcast.net] has joined #code |
| 01:53 | | somnolence [~somnolenc@Nightstar-3790.hsd1.ca.comcast.net] has quit [Client exited] |
| 02:16 | | Vornicus [Vornicus@Admin.Nightstar.Net] has joined #code |
| 02:17 | | mode/#code [+o Vornicus] by ChanServ |
| 02:21 | <@ToxicFrog> | Is it possible as in "can it be done": most certainly. |
| 02:21 | <@ToxicFrog> | "does software exist to do it": no clue |
| 02:21 | <@Vornicus> | what are we doing? |
| 02:22 | <@GeekSoldier> | I just have an Xbox360 controller plugged in, and ControlMK, with the shoulder buttons mapped to the master volume, and the others mapped for various clicks etc. |
| 02:23 | < thalass> | I have a wii remote as mouse and it's fairly easy to change the button mapping like that. |
| 02:24 | <@ToxicFrog> | I know that X11 supports multiple mice, but I don't know if it distinguishes between, for example, "mouse 0 button 0" and "mouse 1 button 0" |
| 02:25 | < thalass> | I want to build a carpc out of a 7 inch eee pc, with a touch screen as the primary control. But I also want hardware controls for volume and next track/previous track so it occured to me last night that I might be able to dismantle a mouse and use that. That would be more intuitive to control than a vol up and vol down button pair. |
| 02:25 | < thalass> | ah |
| 02:25 | < thalass> | I'll have to look into it, then. |
| 02:25 | < thalass> | and, y'know, learn more linux-fu |
| 02:27 | <@GeekSoldier> | I was thinking of just getting a Griffon Powermate knob. it's about $40, but it will integrate nicely with my Impala. |
| 02:35 | < thalass> | hey that's cool |
| 02:37 | < thalass> | that shark thing looks good, too. I'll need a usb fm receiver |
| 02:38 | | thalass [~thalass@Nightstar-23217.dyn.iinet.net.au] has quit [Quit: reboot] |
| 02:43 | | gnolam [lenin@Nightstar-1382.A163.priv.bahnhof.se] has quit [Quit: Z?] |
| 04:38 | | McMartin [~mcmartin@Nightstar-19418.dsl.pltn13.sbcglobal.net] has joined #code |
| 04:38 | | mode/#code [+o McMartin] by ChanServ |
| 06:02 | | Syloqs-AFH [Syloq@Admin.Nightstar.Net] has quit [Connection reset by peer] |
| 06:52 | <@McMartin> | Fuck. I'm going to actually have to learn CoreFoundation and soon. |
| 06:52 | | AnnoDomini [~farkoff@Nightstar-29494.neoplus.adsl.tpnet.pl] has joined #Code |
| 06:52 | | mode/#code [+o AnnoDomini] by ChanServ |
| 08:00 | | Vornicus [Vornicus@Admin.Nightstar.Net] has quit [Quit: ] |
| 10:02 | | ryan64 [ryan@Nightstar-17687.181.78.68.cable.wynd.cablerocket.net] has joined #Code |
| 10:02 | | ryan64 [ryan@Nightstar-17687.181.78.68.cable.wynd.cablerocket.net] has quit [Client exited] |
| 10:35 | | Rhamphoryncus [~rhamph@Nightstar-7184.ed.shawcable.net] has quit [Quit: Rhamphoryncus] |
| 12:35 | | gnolam [lenin@Nightstar-1382.A163.priv.bahnhof.se] has joined #Code |
| 12:35 | | mode/#code [+o gnolam] by ChanServ |
| 13:16 | | McMartin [~mcmartin@Nightstar-19418.dsl.pltn13.sbcglobal.net] has quit [Operation timed out] |
| 13:31 | | McMartin [~mcmartin@Nightstar-19418.dsl.pltn13.sbcglobal.net] has joined #code |
| 13:31 | | mode/#code [+o McMartin] by ChanServ |
| 13:41 | | MobileAnno [~vladimir.@62.108.180.ns-22717] has joined #Code |
| 13:42 | < MobileAnno> | Yo. Anyone know how to make Prolog read numbers? |
| 13:42 | < MobileAnno> | I mean, I want it to read something like '10' not '1' then '0' as it does. |
| 13:47 | < MobileAnno> | Nevermind! |
| 13:47 | < MobileAnno> | I wanted read but used get. |
| 13:47 | < TarinakyKai> | Anyone here any good with Linux and Bluetooth? |
| 13:50 | | MobileAnno [~vladimir.@62.108.180.ns-22717] has quit [Quit: ] |
| 14:32 | | SmithKurosaki [~Smith@Nightstar-26868.acanac.net] has quit [Quit: Leaving] |
| 14:34 | | SmithKurosaki [~jess@Nightstar-26868.acanac.net] has joined #code |
| 14:37 | <@ToxicFrog> | McMartin: CoreFoundation? |
| 14:38 | <@ToxicFrog> | ..assume that was a question mark, windows-NX is kind of delusional about my keyboard layout |
| 16:04 | | Syloqs_AFH [Syloq@Admin.Nightstar.Net] has joined #code |
| 16:05 | | Syloqs_AFH is now known as Syloqs-AFH |
| 17:41 | | GeekSoldier [~Rob@Nightstar-8573.midstate.ip.cablemo.net] has quit [Ping Timeout] |
| 18:02 | | ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has quit [Operation timed out] |
| 18:04 | | SmithKurosaki [~jess@Nightstar-26868.acanac.net] has quit [Ping Timeout] |
| 18:04 | | Vornicus [Vornicus@Admin.Nightstar.Net] has joined #code |
| 18:04 | | mode/#code [+o Vornicus] by ChanServ |
| 18:10 | | SmithKurosaki [~jess@Nightstar-26868.acanac.net] has joined #code |
| 18:11 | | ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has joined #code |
| 18:11 | | mode/#code [+o ToxicFrog] by ChanServ |
| 18:27 | | * AnnoDomini tests his Guess The Number game written in Prolog. |
| 18:39 | | Rhamphoryncus [~rhamph@Nightstar-7184.ed.shawcable.net] has joined #code |
| 19:05 | | TarinakyKai [~Tarinaky@Nightstar-16638.plus.com] has quit [Client exited] |
| 19:15 | <@AnnoDomini> | Seems to work okay. |
| 19:34 | | Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has joined #code |
| 19:34 | | mode/#code [+o Attilla] by ChanServ |
| 19:53 | <@McMartin> | TF: CoreFoundation is the C API to the OS X core API. |
| 19:53 | <@McMartin> | Which is in ObjC |
| 21:34 | | Vornicus [Vornicus@Admin.Nightstar.Net] has quit [Ping Timeout] |
| 21:40 | | Vornicus [Vornicus@Admin.Nightstar.Net] has joined #code |
| 22:09 | | * McMartin wins! VERBOSITY. |
| 22:10 | <@McMartin> | CFStringRef def = CFStringCreateWithCString(NULL, "default", kCFStringEncodingUTF8); |
| 22:10 | <@McMartin> | CFPropertyListRef v = CFDictionaryGetValue(d, def); |
| 22:10 | <@McMartin> | if (v != NULL && CFGetTypeID(v) == CFStringGetTypeID() && |
| 22:10 | <@McMartin> | CFStringCompare((CFString)v, yes, kCFCompareCaseInsensitive) == kCFCompareEqualTo) { |
| 22:10 | <@McMartin> | At this rate, Win32 coding will feel terse. |
| 22:14 | | somnolence [~somnolenc@Nightstar-3790.hsd1.ca.comcast.net] has joined #code |
| 22:15 | <@AnnoDomini> | "* McMartin wins!" <- Did you? Look at yourself. Look at what you've become. |
| 22:26 | < MyCatVerbs> | AnnoDomini: I'm curious about something. Is that quote from Penny-Arcade, or were Penny-Arcade quoting something else famous there? |
| 22:30 | <@AnnoDomini> | MyCatVerbs: I saw it first on Penny Arcade. |
| 22:32 | <@McMartin> | AD: I've become someone with passing knowledge of all three of the low-level OS calls that anybody ever uses. |
| 22:34 | | SmithKurosaki [~jess@Nightstar-26868.acanac.net] has quit [Operation timed out] |
| 22:34 | | ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has quit [Operation timed out] |
| 22:50 | | SmithKurosaki [~jess@Nightstar-26868.acanac.net] has joined #code |
| 22:50 | | ToxicFrog [~ToxicFrog@Admin.Nightstar.Net] has joined #code |
| 22:50 | | mode/#code [+o ToxicFrog] by ChanServ |
| 23:43 | | Tarinaky [~Tarinaky@Nightstar-16638.plus.com] has joined #code |
| 23:47 | | Tarinaky [~Tarinaky@Nightstar-16638.plus.com] has quit [Ping Timeout] |
| 23:51 | | Tarinaky [~Tarinaky@Nightstar-16638.plus.com] has joined #code |
| 23:55 | | KBot [~karma.bot@Nightstar-29553.neoplus.adsl.tpnet.pl] has joined #Code |
| 23:55 | | AnnoDomini [~farkoff@Nightstar-29494.neoplus.adsl.tpnet.pl] has quit [Ping Timeout] |
| 23:56 | | KarmaBot [AnnoDomini@Nightstar-29494.neoplus.adsl.tpnet.pl] has quit [Ping Timeout] |
| 23:58 | | KBot is now known as KarmaBot |
| --- Log closed Fri Apr 10 00:00:56 2009 |