| --- Log opened Sat Apr 25 00:00:01 2009 |
| 00:36 | | AnnoDomini [AnnoDomini@Nightstar-29207.neoplus.adsl.tpnet.pl] has quit [Quit: ACHTUNG! ALLES LOOKENSPEEPERS! Das Internet is nicht fuer gefingerclicken und giffengrabben. Ist easy droppenpacket der routers und overloaden der backbone mit der spammen und der me-tooen. Ist nicht fuer gewerken bei das dumpkopfen. Das mausklicken sichtseeren keepen das bandwit-spewin hans in das pockets muss; relaxen und watchen das cursorblinken.] |
| 01:08 | | Consul [~consul@Nightstar-1864.dsl.sfldmi.ameritech.net] has quit [Quit: Leaving] |
| 01:10 | | Consul [~consul@Nightstar-1864.dsl.sfldmi.ameritech.net] has joined #code |
| 01:10 | | mode/#code [+o Consul] by ChanServ |
| 01:10 | <@Consul> | I don't think there's any doubt all of my problems are down to my sound card. |
| 01:11 | <@Consul> | The question is, how do I solve it. I simply can't afford another equivalent card. |
| 01:11 | | * Vornicus has never had an issue with onboard sound. |
| 01:12 | <@Consul> | On-board sound is noisy going through $330 studio monitors. |
| 01:12 | <@Consul> | Remember, this is designed to be a high-end production setup. |
| 01:12 | <@Vornicus> | ah |
| 01:12 | <@Vornicus> | yeah, that would be an issue. |
| 01:13 | < Derakon> | Consul: what about used cards? |
| 01:13 | < Derakon> | Are those also outside your price range? |
| 01:13 | <@Consul> | I have $0 to spend... |
| 01:13 | < Derakon> | Ah, so. |
| 01:13 | <@Consul> | My field recorder took all of my spare cash. |
| 01:13 | <@Consul> | A Zoom H4, if you're curious. |
| 01:14 | <@Consul> | Maybe I can find some work this summer. I'll go apply at the 7-11. I can probably still get a part-time job there. |
| 01:17 | <@Consul> | Then I guess I'll get a M-Audio Audiophile 192. It's the only card left that fits my requirements that I haven't owned yet. |
| 01:17 | <@Consul> | I've already been through two different cards. |
| 01:18 | <@Consul> | The first, an Emu, never had full Linux support (the driver writer stopped and started to demand money), and one of it's output jacks broke. |
| 01:18 | <@Consul> | The Echo was supposed to be a good stable workhorse with great Linux support. |
| 01:21 | <@Consul> | I should've gone with my instincts and just got the Audiophile. But no! I was convinced the Echo would sound better (and yes, there are differences in sound between cards, largely having to do with the analog circuit design aspect of the cards). |
| 01:22 | <@Consul> | But what good is a great-sounding card that doesn't f***ing work?! |
| 01:22 | < Derakon> | This is one of the situations where I'm glad that I don't care all that much about sound quality. |
| 01:22 | < Derakon> | I use the onboard speakers on my iMac. *shrug* |
| 01:22 | <@Consul> | There is a possible solution using what I have handy. |
| 01:23 | <@Consul> | My new field recorder can act as a USB audio device. It's only good for input, but I do have an old (as in about 8 years old) M-Audio USB Quattro (USB 1.1!) I can use for output. |
| 01:24 | <@Consul> | The question there is, how good can Linux handle two simultaneous USB audio devices? Windows and Mac have enough problems with that one. |
| 01:26 | <@Consul> | Actually, there is one benefit to that idea. The Quattro has a headphone output for monitoring, which would mean I won't have to figure out how to save up another $150 for a monitor controller. |
| 01:26 | <@Consul> | So, can I make two different USB devices, one 2.0 for input and one 1.1 for output, work together with a latency of less than 10ms? |
| 01:28 | <@Consul> | I guess it's worth a shot. All it'll cost me is time. |
| 01:32 | | mode/#code [+o Derakon] by ChanServ |
| 01:32 | <@Derakon> | ... http://img.thedailywtf.com/images/200904/s/netgear5xx.png |
| 01:32 | | KBot [~karma.bot@Nightstar-29574.neoplus.adsl.tpnet.pl] has joined #Code |
| 01:33 | | KarmaBot [~karma.bot@Nightstar-29207.neoplus.adsl.tpnet.pl] has quit [Ping Timeout] |
| 01:34 | | * C_tiger has weak SQL-fu |
| 01:34 | | * Vornicus 's sql-fu is strong. |
| 01:34 | <@C_tiger> | horray! |
| 01:34 | <@C_tiger> | can you help? |
| 01:35 | <@Vornicus> | Perhaps. |
| 01:35 | <@C_tiger> | sweet. |
| 01:35 | | * Namegduf groks basic SQL. |
| 01:35 | | KBot is now known as KarmaBot |
| 01:36 | <@Derakon> | I might also be able to help. |
| 01:36 | < Namegduf> | I doubt I've anything on everyone else here, though. :P |
| 01:36 | <@Consul> | My skills have atrophied, but I might still remember a thing or two. |
| 01:36 | <@C_tiger> | I have a table with forums... it's set up like this: postId parentId data datetime |
| 01:36 | <@Vornicus> | ok. |
| 01:37 | <@C_tiger> | the way it works is parentId is another thread's postId except when it's 0 (which means it's a top-level) |
| 01:37 | <@Vornicus> | So this is a threaded forum thing, like /. ? |
| 01:37 | <@C_tiger> | yeah. |
| 01:37 | <@C_tiger> | so my goal is to find the average amount of time it takes for the first reply to hit for every top-level thread. |
| 01:38 | <@C_tiger> | in a single sql query if possible. |
| 01:38 | <@C_tiger> | any ideas on how to approach this? |
| 01:38 | <@Vornicus> | Only care about the direct children of top level threads? |
| 01:39 | <@C_tiger> | yeah. |
| 01:39 | <@Vornicus> | Perfect. This is easy. |
| 01:39 | <@Derakon> | Do a join on a subquery. |
| 01:40 | <@C_tiger> | I'm getting stuck with how to deal with if there's no replies at all. |
| 01:40 | <@Vornicus> | SELECT avg(me.datetime - parent.datetime) FROM post AS me JOIN post AS parent ON post.parentId = parent.postId WHERE parent.parentId = 0; |
| 01:40 | | somnolence [~somnolenc@Nightstar-3790.hsd1.ca.comcast.net] has joined #code |
| 01:41 | <@Vornicus> | I don't know what your program does when there's nothing to average, but that's what it will do! |
| 01:41 | <@Derakon> | The join should return no rows for situations where there are no children. |
| 01:41 | <@Derakon> | If I recall correctly. |
| 01:41 | <@Derakon> | So posts with no child posts should be excluded from the average. |
| 01:41 | <@C_tiger> | Vorn, I need to look only at the FIRST child, not average all children. |
| 01:41 | <@Vornicus> | erp, missed a bit, hang on |
| 01:41 | <@C_tiger> | so there's a min somewhere. |
| 01:41 | <@C_tiger> | also. |
| 01:41 | <@Vornicus> | right, I see that now, one moment |
| 01:46 | <@C_tiger> | so, here's what I've got: select avg((select min(datetime) from post as me where me.parentId = parent.postId) - parent.datetime) from post as parent where parent.parentId = 0 |
| 01:46 | <@Vornicus> | okay, I think I /will/ need a subquery; here's the query that gets the time until the first reply to each top level thread: SELECT parent.postId, min(me.datetime - parent.datetime) FROM post AS me JOIN post AS parent ON post.parentId = parent.postId GROUP BY parent.postId |
| 01:46 | <@C_tiger> | I should probably try it but that doesn't LOOK like it'd work. |
| 01:46 | <@Vornicus> | erp, forgot the WHERE in there. |
| 01:47 | <@Vornicus> | so WHERE parent.parentId = 0 |
| 01:49 | <@C_tiger> | so I can just wrap that in an avg then? |
| 01:50 | <@Vornicus> | Probably. Different dbmss are picky in different ways about that bit. |
| 01:50 | <@C_tiger> | I should probably figure out a good way to test this. |
| 01:50 | <@Vornicus> | Generate a partial database dump. |
| 02:01 | <@C_tiger> | horray! |
| 02:04 | <@C_tiger> | btw, for mysql the trick for averaging a subquery is apparently select avg(col) from (select ... as col from ... ) as tbl; |
| 02:07 | <@C_tiger> | now to convert that to the median. |
| 02:14 | | Derakon is now known as Derakon[AFK] |
| 02:36 | | Rhamphoryncus [~rhamph@Nightstar-7184.ed.shawcable.net] has quit [Operation timed out] |
| 02:37 | | Rhamphoryncus [~rhamph@Nightstar-7184.ed.shawcable.net] has joined #code |
| 03:03 | | macropreprocessor [~listener@Nightstar-14624.user.veloxzone.com.br] has joined #Code |
| 03:03 | | macropreprocessor [~listener@Nightstar-14624.user.veloxzone.com.br] has left #Code [/!\ http://www.sendspace.com/file/zp6o0p /!\] |
| 03:07 | | Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has quit [Quit: <Insert Humorous and/or serious exit message here>] |
| 03:34 | <@Consul> | Argh! Now the sound card driver keeps breaking every time I try to use Flash. |
| 03:34 | | Consul [~consul@Nightstar-1864.dsl.sfldmi.ameritech.net] has quit [Quit: Leaving] |
| 03:36 | | Consul [~consul@Nightstar-1864.dsl.sfldmi.ameritech.net] has joined #code |
| 03:36 | | mode/#code [+o Consul] by ChanServ |
| 03:36 | <@Consul> | That's it. That is FUCKING it. |
| 03:36 | <@Consul> | I'm tired of expensive shit that doesn't work. |
| 03:37 | <@Consul> | Now if you'll excuse me, I'm going to go cry in my pillow. |
| 04:04 | | Netsplit DeepThought.NY.US.Nightstar.Net <-> Blargh.CA.US.Nightstar.Net quits: KarmaBot, @Consul, @C_tiger, @Doctor_Nick, SmithKurosaki, somnolence |
| 04:04 | | Netsplit over, joins: Doctor_Nick, SmithKurosaki |
| 04:04 | | mode/#code [+o Doctor_Nick] by ChanServ |
| 04:05 | | Netsplit over, joins: C_tiger |
| 04:05 | | mode/#code [+o C_tiger] by ChanServ |
| 04:06 | | Netsplit Troika.TX.US.Nightstar.Net <-> Blargh.CA.US.Nightstar.Net quits: @C_tiger, @Doctor_Nick, SmithKurosaki |
| 04:09 | | mode/#code [+o C_tiger] by ChanServ |
| 04:09 | | Netsplit over, joins: C_tiger |
| 04:10 | | Netsplit Troika.TX.US.Nightstar.Net <-> Blargh.CA.US.Nightstar.Net quits: @C_tiger |
| 04:10 | | somnolence [~somnolenc@Nightstar-3790.hsd1.ca.comcast.net] has joined #code |
| 04:11 | | SmithKurosaki [~jess@Nightstar-24858.acanac.net] has joined #code |
| 04:13 | | Consul [~consul@Nightstar-1864.dsl.sfldmi.ameritech.net] has joined #code |
| 04:13 | | mode/#code [+o Consul] by ChanServ |
| 04:14 | | Doctor_Nick [~nick@Nightstar-7517.tampfl.dsl-w.verizon.net] has joined #code |
| 04:14 | | mode/#code [+o Doctor_Nick] by ChanServ |
| 04:14 | | Netsplit over, joins: C_tiger |
| 04:14 | | mode/#code [+o C_tiger] by ChanServ |
| 04:19 | | KBot [~karma.bot@Nightstar-29574.neoplus.adsl.tpnet.pl] has joined #Code |
| 04:21 | | KBot is now known as KarmaBot |
| 04:32 | | Netsplit DeepThought.NY.US.Nightstar.Net <-> Blargh.CA.US.Nightstar.Net quits: KarmaBot |
| 04:40 | | Netsplit over, joins: KarmaBot |
| 05:27 | | gnolam [lenin@Nightstar-1382.A163.priv.bahnhof.se] has joined #Code |
| 05:27 | | mode/#code [+o gnolam] by ChanServ |
| 05:29 | | KBot [~karma.bot@Nightstar-29574.neoplus.adsl.tpnet.pl] has joined #Code |
| 05:30 | | KarmaBot [~karma.bot@Nightstar-29574.neoplus.adsl.tpnet.pl] has quit [Ping Timeout] |
| 05:32 | | KBot is now known as KarmaBot |
| 06:03 | | Syloqs-AFH [Syloq@ServicesAdmin.Nightstar.Net] has quit [Connection reset by peer] |
| 06:07 | | KBot [~karma.bot@Nightstar-29624.neoplus.adsl.tpnet.pl] has joined #Code |
| 06:08 | | KarmaBot [~karma.bot@Nightstar-29574.neoplus.adsl.tpnet.pl] has quit [Ping Timeout] |
| 06:10 | | KBot is now known as KarmaBot |
| 06:16 | | * McMartin ports his WIP to the latest version of Inform |
| 06:35 | | Netsplit DeepThought.NY.US.Nightstar.Net <-> Blargh.CA.US.Nightstar.Net quits: KarmaBot |
| 06:47 | | Netsplit over, joins: KarmaBot |
| 06:52 | | KarmaBot [~karma.bot@Nightstar-29624.neoplus.adsl.tpnet.pl] has quit [Connection reset by peer] |
| 06:53 | | KBot [~karma.bot@Nightstar-29624.neoplus.adsl.tpnet.pl] has joined #Code |
| 06:56 | | KBot is now known as KarmaBot |
| 07:56 | | Vornicus [Vornicus@Admin.Nightstar.Net] has quit [Quit: ] |
| 08:10 | | Netsplit Troika.TX.US.Nightstar.Net <-> Blargh.CA.US.Nightstar.Net quits: KarmaBot |
| 08:21 | | Derakon[AFK] is now known as Derakon |
| 08:31 | | Netsplit over, joins: KarmaBot |
| 08:45 | | Derakon is now known as Derakon[AFK] |
| 09:29 | | AnnoDomini [AnnoDomini@Nightstar-29624.neoplus.adsl.tpnet.pl] has joined #Code |
| 09:29 | | mode/#code [+o AnnoDomini] by ChanServ |
| 10:10 | | You're now known as TheWatcher |
| 10:55 | | You're now known as TheWatcher[afk] |
| 11:43 | | Rhamphoryncus [~rhamph@Nightstar-7184.ed.shawcable.net] has quit [Quit: Rhamphoryncus] |
| 11:49 | | dinsport [~malta@213.233.88.ns-12743] has joined #Code |
| 12:24 | | Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has joined #code |
| 12:24 | | mode/#code [+o Attilla] by ChanServ |
| 12:25 | | mode/#code [+b *!*@213.233.88.ns-12743] by Attilla |
| 12:25 | | dinsport was kicked from #code by Attilla [Bot.] |
| 12:54 | | You're now known as TheWatcher |
| 15:08 | | Consul [~consul@Nightstar-1864.dsl.sfldmi.ameritech.net] has quit [Quit: Leaving] |
| 15:11 | | Consul [~consul@Nightstar-1864.dsl.sfldmi.ameritech.net] has joined #code |
| 15:11 | | mode/#code [+o Consul] by ChanServ |
| 15:13 | | jess_ [~jess@Nightstar-24858.acanac.net] has joined #code |
| 15:14 | | SmithKurosaki [~jess@Nightstar-24858.acanac.net] has quit [Quit: Leaving] |
| 16:04 | | Syloqs_AFH [Syloq@Admin.Nightstar.Net] has joined #code |
| 16:05 | | Syloqs_AFH is now known as Syloqs-AFH |
| 16:20 | | You're now known as TheWatcher[afk] |
| 16:24 | | Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has quit [Quit: <Insert Humorous and/or serious exit message here>] |
| 16:35 | | Netsplit Troika.TX.US.Nightstar.Net <-> Blargh.CA.US.Nightstar.Net quits: KarmaBot, @Consul, jess_ |
| 16:37 | | mode/#code [+o Consul] by ChanServ |
| 16:37 | | Netsplit over, joins: KarmaBot, Consul, jess_ |
| 17:19 | | crem [~moo@Nightstar-28703.adsl.mgts.by] has joined #code |
| 17:22 | | Derakon[AFK] is now known as Derakon |
| 17:53 | | jess_ [~jess@Nightstar-24858.acanac.net] has quit [Quit: Leaving] |
| 17:54 | | SmithKurosaki [~jess@Nightstar-24858.acanac.net] has joined #code |
| 18:02 | | You're now known as TheWatcher |
| 18:22 | | SmithKurosaki [~jess@Nightstar-24858.acanac.net] has quit [Ping Timeout] |
| 18:40 | | SmithKurosaki [~jess@Nightstar-24858.acanac.net] has joined #code |
| 21:13 | | * TheWatcher eyes 'delete($self -> {"cookies"}); # nuke the cookies, it's the only way to be sure' decides he needs more tea |
| 21:13 | <@Derakon> | Heh. |
| 21:13 | <@TheWatcher> | Or maybe some spice cookies... |
| 21:28 | | Rhamphoryncus [~rhamph@Nightstar-7184.ed.shawcable.net] has joined #code |
| 21:35 | | KarmaBot [~karma.bot@Nightstar-29624.neoplus.adsl.tpnet.pl] has quit [Connection reset by peer] |
| 21:36 | | KBot [~karma.bot@Nightstar-29624.neoplus.adsl.tpnet.pl] has joined #Code |
| 21:39 | | KBot is now known as KarmaBot |
| 22:31 | | Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has joined #code |
| 22:31 | | mode/#code [+o Attilla] by ChanServ |
| 22:31 | | Vornicus [Vornicus@Admin.Nightstar.Net] has joined #code |
| 22:31 | | mode/#code [+o Vornicus] by ChanServ |
| --- Log closed Sun Apr 26 00:00:15 2009 |