| --- Log opened Tue May 05 00:00:26 2009 |
| 00:16 | | Rhamphoryncus [~rhamph@Nightstar-7184.ed.shawcable.net] has joined #code |
| 00:31 | | You're now known as TheWatcher[T-2] |
| 00:34 | | You're now known as TheWatcher[zZzZ] |
| 01:11 | | * McMartin rages at Debian |
| 01:23 | <@Derakon> | "Debian" and "Derakon" have a more than passing resemblance at the word level. ¬.¬ |
| 01:33 | <@MyCatVerbs> | Derakon is not named for a husband+wife pair, though. |
| 01:33 | <@MyCatVerbs> | Or was it lady+gentleman, and meh to matrimony? Either way. |
| 01:36 | <@McMartin> | Actually, the issue was not Debian's fault, for once, but rather my documentation. |
| 01:39 | | * Derakon finally wisens up to the fact that all of the available relation types for his tree are valid except for 'none', so he should be enumerating badness instead of goodness. |
| 01:39 | <@Derakon> | No more "relation in ['self', 'parent', 'child', 'connection', 'sibling']"! |
| 01:40 | | Attilla_ [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has quit [Ping Timeout] |
| 01:42 | | Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has joined #code |
| 01:42 | | mode/#code [+o Attilla] by ChanServ |
| 01:44 | | Attilla_ [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has joined #code |
| 01:44 | | Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has quit [Connection reset by peer] |
| 01:49 | | Attilla_ [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has quit [Ping Timeout] |
| 01:56 | | Derakon is now known as Derakon[DDR] |
| 02:09 | | gnolam [lenin@Nightstar-1382.A163.priv.bahnhof.se] has quit [Quit: Z?] |
| 02:09 | | Vornicus-Latens is now known as Vornicus |
| 03:05 | | * Vornicus examines. |
| 03:08 | <@Vornicus> | Okay. 1. I am given a list of things. 2. I must have at least a things from one set, and exactly a + b things from the first set and the second, and nothing else. |
| 03:09 | <@Vornicus> | So far so good. I think I can code that. |
| 03:13 | <@Vornicus> | Now let's see. In /some/ cases I need to be able to add 1 to b; in some other cases, I need one more thing in there /not/ necessarily on the list. |
| 03:15 | | Derakon[DDR] is now known as Derakon |
| 03:21 | | * Vornicus tries to figure out how to do that last bit. |
| 03:58 | <@Vornicus> | Of course, worse still than the other stupid name issues is "class" |
| 04:02 | <@Derakon> | Hmm? |
| 04:02 | <@Derakon> | Don't tell you you tried to make a variable named "class". |
| 04:05 | <@Vornicus> | Well what /else/ will I call it. It's the character's class! |
| 04:05 | <@Derakon> | pcType? |
| 04:05 | <@Derakon> | charClass? |
| 04:05 | <@Derakon> | job? |
| 04:14 | <@Vornicus> | Also apparently from PEP 008: "single_trailing_underscore_: used by convention to avoid conflicts with Python keyword" |
| 04:14 | | * Vornicus will be calling it "role" |
| 04:15 | <@Derakon> | Python Enhancement Protocol? |
| 04:15 | <@Vornicus> | Proposal |
| 04:15 | <@Vornicus> | But 008 is the Style Guide |
| 04:15 | <@Derakon> | Ahh. |
| 04:16 | <@Derakon> | I'll keep that in mind next time I want to name a variable "range". |
| 04:20 | | * Vornicus has hatred for hard namespace collisions |
| 04:49 | < Rhamphoryncus> | That is the use case for class_, IMO. The word is exactly what you want, it just has an existing meaning |
| 04:49 | < Rhamphoryncus> | just like having else_ when parsing python sourcecode ;) |
| 04:50 | < Rhamphoryncus> | The most I might do is stick "# D&D Class, silly" on the initial assignment |
| 04:51 | <@Vornicus> | Heh. Half the problem is the initial assignment is reading from a data file and using setattr() |
| 04:56 | | * McMartin does battle with DLL Purgatory |
| 04:57 | <@Vornicus> | what madness is this? |
| 05:01 | <@McMartin> | I'm trying to make Windows behave like a Mac and load DLLs from a specific location that is not . |
| 05:03 | <@McMartin> | Oho, here we go. |
| 05:08 | | * Vornicus gets Darwine,examines, tries to decide what Wind... oh. Of course, there is only one choice. |
| 05:08 | | * Vornicus hunts up Spelunky. |
| 05:11 | <@Vornicus> | argl. |
| 05:11 | | * Vornicus hunts up an unrar. |
| 06:03 | | Syloqs-AFH [Syloq@ServicesAdmin.Nightstar.Net] has quit [Connection reset by peer] |
| 06:24 | | * Vornicus ponders |
| 06:29 | | Reiv [~82d94c4d@Nightstar-29731.dsl.in-addr.zen.co.uk] has joined #Code |
| 06:30 | | * Reiv hunts for Really Basic SQL advice. |
| 06:30 | < Reiv> | How do you give a column in your SELECT statement a custom name? |
| 06:31 | <@MyCatVerbs> | SELECT foo as bar, baz as uncle FROM biguglytable WHERE bar = 15; |
| 06:31 | < Reiv> | Excelent, danke. |
| 06:31 | <@MyCatVerbs> | Bitte. ^_^ |
| 06:31 | <@Derakon> | select count(*) AS total FROM orders WHERE date > '2008-12-02'; |
| 06:31 | < Reiv> | (I knew it was simple; my brain was fail.) |
| 06:32 | <@MyCatVerbs> | No worries. That's the sort of annoying question that usually isn't explained anywhere other than badly-written tutorials halfway through. ;) |
| 06:33 | < Reiv> | Exactly. |
| 06:33 | < Reiv> | Now, hmn. |
| 06:33 | < Reiv> | *hunts for informations to turn into the query right* |
| 06:33 | | AnnoDomini [AnnoDomini@Nightstar-29573.neoplus.adsl.tpnet.pl] has joined #Code |
| 06:33 | | mode/#code [+o AnnoDomini] by ChanServ |
| 06:35 | < Reiv> | hooray monster queries |
| 06:48 | < Reiv> | hrm. |
| 06:49 | <@AnnoDomini> | Taiko's turn. Doing anything? |
| 06:58 | < Reiv> | Anno: Frentic. |
| 06:59 | < Reiv> | ... can I have voice, plz? |
| 06:59 | | mode/#code [+o Reiv] by Derakon |
| 06:59 | <@Reiv> | http://pastebin.com/d44af2194 - can I have advice on how to munge these three queries together? |
| 06:59 | <@Reiv> | danke :) |
| 07:00 | | * Reiv makes a note to set DiceBot to have a !voiceme command, usable only in Code. |
| 07:01 | <@Derakon> | Hm. So reviewers are special users, the reviewer_has_review table tells you which reviewers have claimed which reviews, and the reviews table is for finished reviews? |
| 07:01 | <@Reiv> | Correct - 'cept reviewers_has_review' tracks which reviewer wrote which review. |
| 07:01 | <@Reiv> | er |
| 07:02 | <@Reiv> | Correct - except 'reviewers_has_review' tracks which reviewer wrote which review. |
| 07:02 | <@Derakon> | ...how is that different from what you said the first time? |
| 07:02 | | * Vornicus wishes for an "enforce" command that tells chanserv "hey see who you can op" or something |
| 07:02 | <@Reiv> | reviewer_has_proposal tracks which proposals a reviewer has volinteered to review. |
| 07:02 | <@Derakon> | Oh, reviewer_has_proposal is for volunteering. |
| 07:02 | <@Reiv> | Yeah |
| 07:02 | <@Derakon> | Vorn: you mean the olist? |
| 07:03 | <@Vornicus> | Indeed |
| 07:04 | <@Reiv> | Whether this uses a subquery or an outer join is a matter of taste; bonus points if it's easiest to use both~ |
| 07:04 | <@Reiv> | I just can't think how to do it. |
| 07:06 | <@Derakon> | Basically you take your Reviews_Done and Reviews_Volunteered queries, make them into subqueries, and have them pull not just count(*) but also reviewer_id out. |
| 07:06 | <@Derakon> | That way you can do a manual join on reviewer_id. |
| 07:06 | <@Derakon> | Something like http://paste.ubuntu.com/164703/ except I didn't bother to match your complete table structure. |
| 07:07 | <@Derakon> | (Disclaimer: may be buggy) |
| 07:08 | <@Reiv> | buggy due to table structures, or syntax in question? |
| 07:10 | <@Derakon> | Buggy due to me not having any appropriate tables to test against. |
| 07:10 | <@Derakon> | I'm not good enough at SQL to write queries that work on the first try if they're doing anything particularly complicated. |
| 07:11 | <@Reiv> | right. |
| 07:53 | | Vornicus is now known as Vornicus-Latens |
| 07:58 | | Derakon is now known as Derakon[AFK] |
| 08:18 | | Reiv [~82d94c4d@Nightstar-29731.dsl.in-addr.zen.co.uk] has quit [Quit: CGI:IRC (EOF)] |
| 08:20 | | Namegduf [namegduf@86.29.157.ns-3965] has quit [Quit: Alas, tis time to leave. I shall return this evening.] |
| 08:34 | | You're now known as TheWatcher |
| 09:15 | | EvilDarkLord [~jjlehto3@Nightstar-9591.cs.hut.fi] has quit [Ping Timeout] |
| 09:18 | | EvilDarkLord [~jjlehto3@Nightstar-9591.cs.hut.fi] has joined #code |
| 09:19 | | EvilDarkLord is now known as NSGuest-306 |
| 10:12 | | gnolam [lenin@Nightstar-1382.A163.priv.bahnhof.se] has joined #Code |
| 10:12 | | mode/#code [+o gnolam] by ChanServ |
| 10:30 | < simontwo> | can anyone suggest a tool for plotting a graph of the time and memory use of a command-line program when it is fed variable input? |
| 10:31 | < simontwo> | `time ./program <input>` does it for the time. |
| 10:33 | | ryan [~haggle@Nightstar-26893.dsl.scrm01.sbcglobal.net] has joined #Code |
| 10:34 | < ryan> | hello? |
| 10:35 | < simontwo> | hello. |
| 10:38 | < ryan> | hi I am actually a regular on another channel on this server but |
| 10:38 | < ryan> | I was just wondering if anyone here knows a good php/mysql tutorial |
| 10:38 | < ryan> | like, ground-level |
| 10:39 | | You're now known as TheWatcher[afk] |
| 10:44 | < simontwo> | not personally. |
| 10:44 | < simontwo> | I learned PHP by looking in the online manual. |
| 10:47 | < ryan> | I'm kind of trying to learn php and mysql at the same time though |
| 10:47 | < ryan> | I mean php itself seems really simple |
| 10:47 | < ryan> | from what I've seen so far |
| 10:47 | < ryan> | but I don't know anything about databases |
| 10:47 | < ryan> | anyway it's fine, I'm sure I can find something |
| 10:47 | < ryan> | just figured I'd see if there was anything particularly enlightening |
| 10:50 | < simontwo> | ryan, perhaps get a good book on relational databases and learn PHP separately by the internet. |
| 10:51 | < ryan> | hmm. well, I was hoping to avoid spending any money. maybe you're right, though. |
| 10:51 | < ryan> | oh actually I forgot to check my school library |
| 10:52 | < simontwo> | ryan, PHP programmers have some really rotten database habits. having learned databases first through hobbyist web programming I can attest that I sucked. |
| 11:14 | < ryan> | ok well thanks for the advice |
| 11:14 | < ryan> | I'll have to see what I can find for books at the library |
| 11:20 | <@gnolam> | Which reminds me that I have a domain and web hosting to cancel. |
| 11:21 | | ryan [~haggle@Nightstar-26893.dsl.scrm01.sbcglobal.net] has left #Code [] |
| 11:41 | | Rhamphoryncus [~rhamph@Nightstar-7184.ed.shawcable.net] has quit [Quit: Rhamphoryncus] |
| 12:10 | < simontwo> | I should've told him about the Manga Guide to Databases, heh. |
| 12:10 | < simontwo> | "And so the relation is normalized. Pika-pika." |
| 12:26 | | Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has joined #code |
| 12:26 | | mode/#code [+o Attilla] by ChanServ |
| 12:47 | | You're now known as TheWatcher |
| 14:16 | | Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has quit [Connection reset by peer] |
| 14:17 | | Attilla [~The.Attil@Nightstar-9147.cdif.cable.ntl.com] has joined #code |
| 14:17 | | mode/#code [+o Attilla] by ChanServ |
| 14:51 | <@Consul> | He says a few hours later: I was lucky and found a pretty good book on database design early on that went over the key concepts. |
| 15:00 | < simontwo> | it seems that `time` can benchmark both time and memory use, but only memory use in kilobytes. anyone got a suggestion as to how I can benchmark smaller uses? |
| 15:11 | <@TheWatcher> | Which language are you using? If it's c++, you could just override new and delete? |
| 15:12 | <@TheWatcher> | then have a 'memused' variable that gets incremented/decremented and printed each time either is called *shrug* |
| 15:13 | < simontwo> | TheWatcher, it's a blackbox program written in C. |
| 15:13 | <@TheWatcher> | Joy. |
| 15:13 | < simontwo> | TheWatcher, it seems that time -f "%M" should do it, but it doesn't. always just prints 0. |
| 15:14 | <@TheWatcher> | %M is in KBytes anyway |
| 15:14 | < simontwo> | exactly. |
| 15:14 | <@TheWatcher> | " %M Maximum resident set size of the process during its lifetime, in Kbytes." |
| 15:14 | < simontwo> | I wrote a program which of its sole purpose is allocating a number of kilobytes of memory, and running time -f %M on that also returns 0 regardless. |
| 15:17 | <@TheWatcher> | Actually, I believe that even /proc/<PID>/stat only records the memory use in KB anyway |
| 15:18 | <@gnolam> | You won't even need to monitor memory use on the byte level. |
| 15:18 | <@gnolam> | *ever |
| 15:19 | <@gnolam> | Paging, etc. |
| 15:19 | <@TheWatcher> | simontwo: Why'd you need to know anyway? |
| 15:24 | < simontwo> | TheWatcher, I need to benchmark a program's CPU and memory use. |
| 15:24 | <@gnolam> | Homework assignment? |
| 15:24 | < simontwo> | yup. not mandatory. |
| 15:25 | <@gnolam> | Anyway. Paging. There's no need to monitor use on the byte level, since it will only be allocated (multi)KiB-sized chunks of memory anyway. |
| 15:25 | <@gnolam> | s/it/your program |
| 15:25 | < simontwo> | right |
| 15:25 | <@gnolam> | My lack of both sleep and food today is beginning to manifest, methinks. |
| 16:04 | | Syloqs_AFH [Syloq@Admin.Nightstar.Net] has joined #code |
| 16:05 | | Syloqs_AFH is now known as Syloqs-AFH |
| 16:35 | | Tarinaky is now known as roll |
| 16:35 | | roll is now known as Tarinaky |
| 16:56 | | crem [~moo@Nightstar-28703.adsl.mgts.by] has quit [Connection reset by peer] |
| 16:56 | | crem_ [~moo@Nightstar-28703.adsl.mgts.by] has joined #code |
| 17:12 | | You're now known as TheWatcher[afk] |
| 17:17 | | Namegduf [namegduf@86.29.157.ns-3965] has joined #code |
| 17:35 | | Derakon[AFK] is now known as Derakon |
| 18:17 | | You're now known as TheWatcher |
| 18:20 | <@gnolam> | Huh. Interesting. |
| 18:21 | <@gnolam> | Sunlight through a birch tree on a somewhat windy day + reflection off glass = perfectly water-like caustics. |
| 18:49 | <@Derakon> | Typo while typing: "topLoc" => "toplop". |
| 19:06 | <@Derakon> | Code I just wrote: "del self.deadSeeds[space].node.spaces[space]" |
| 19:06 | <@TheWatcher> | Ow |
| 19:12 | <@Derakon> | This is all the worse because I'd already defined a function on the class that the node field is an instance of to do that operation. ¬.¬ |
| 19:12 | <@Derakon> | I don't know what's in my own codebase any more! ;.; |
| 19:12 | <@Derakon> | (It's 3678 lines long, mind you) |
| 19:12 | <@Derakon> | 4115 if you count the dynamically-loaded modules. |
| 21:04 | | Rhamphoryncus [~rhamph@Nightstar-7184.ed.shawcable.net] has joined #code |
| 23:36 | | AnnoDomini [AnnoDomini@Nightstar-29573.neoplus.adsl.tpnet.pl] has quit [Quit: "I just want you to know... I faked all the orgasms." "So? Mine were real." "...asshole."] |
| --- Log closed Wed May 06 00:00:40 2009 |