| --- Log opened Thu Oct 24 00:00:16 2013 |
| 00:03 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 00:03 | | mode/#code [+o himi] by ChanServ |
| 00:05 | <@gnolam> | Outlook's logo + Windows 8's taskbar/quicklaunch is a bad combo. |
| 00:05 | <@gnolam> | I keep reading it as "0 new messages" instead of a stylized O. |
| 00:10 | | You're now known as TheWatcher[T-2] |
| 00:14 | <@Reiv> | Tarinaky: Are you assuming a setting where low energy missions will be a thing? |
| 00:16 | < RichyB> | Tarinaky, am I right in understanding here that what you're essentially trying to do is make a videogame about space flight that is better than Kerbal Space Program? :D |
| 00:16 | | You're now known as TheWatcher[zZzZ] |
| 00:16 | < RichyB> | Tarinaky, in which case, fuck yeah, best of luck to you! The world needs more awesome videogames about fukkin' rockets. =D |
| 00:19 | <@Reiv> | RichyB: Nnot quite. |
| 00:20 | <@Reiv> | He's trying to rewrite Aurora, which is Dwarf Fortress: Galactic Empire Edition. |
| 00:38 | | Harlow [Harlow@Nightstar-2dbe3d64.il.comcast.net] has joined #code |
| 00:43 | < RichyB> | Reiv, *reads up on Aurora* |
| 00:44 | < RichyB> | That is also COOL AS SHIT |
| 00:44 | < RichyB> | Tarinaky, godspeed! :D |
| 00:44 | <@Reiv> | RichyB: It's also an unplayable mess whose core engine is an Access database of terrifying vintage. |
| 00:44 | <@Reiv> | Tarinaky is having a crack at Doing It Properly. |
| 00:47 | <&McMartin> | Huh. There's still some progress being made in really simple PRNGs |
| 00:47 | <&McMartin> | http://b2d-f9r.blogspot.com/2010/08/16-bit-xorshift-rng-now-with-more.html |
| 00:55 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Operation timed out] |
| 01:05 | | Turaiel[Offline] is now known as Turaiel |
| 01:09 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 01:09 | | mode/#code [+o himi] by ChanServ |
| 01:13 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 01:25 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 01:25 | | mode/#code [+o himi] by ChanServ |
| 01:38 | <&ToxicFrog> | btsync >3 |
| 01:38 | <&ToxicFrog> | <3 even |
| 02:06 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 02:07 | | Turaiel is now known as Turaiel[Offline] |
| 03:21 | | VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has quit [[NS] Quit: Program Shutting down] |
| 04:17 | | VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has joined #code |
| 04:21 | | Kindamoody[zZz] is now known as Kindamoody |
| 04:21 | | VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has quit [[NS] Quit: Program Shutting down] |
| 04:49 | | LurtzCZ [Lurtz@Nightstar-0604e0ca.cust.termsnet.cz] has joined #code |
| 04:51 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 04:51 | | mode/#code [+o himi] by ChanServ |
| 05:03 | | Derakon is now known as Derakon[AFK] |
| 05:10 | | ktemkin is now known as ktemkin[wol] |
| 05:11 | | ktemkin[wol] is now known as ktemkin[away] |
| 05:35 | | RichyB [RichyB@D553D1.68E9F7.02BB7C.3AF784] has quit [[NS] Quit: Gone.] |
| 05:38 | | RichyB [RichyB@D553D1.68E9F7.02BB7C.3AF784] has joined #code |
| 05:46 | | Turaiel[Offline] is now known as Turaiel |
| 06:25 | | Vornicus [vorn@ServerAdministrator.Nightstar.Net] has joined #code |
| 06:25 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 06:26 | | ErikMesoy|sleep is now known as ErikMesoy |
| 06:54 | | celticminstrel [celticminst@Nightstar-90d86201.dsl.bell.ca] has quit [[NS] Quit: And lo! The computer falls into a deep sleep, to awake again some other day!] |
| 06:55 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 07:00 | | Turaiel is now known as Turaiel[Offline] |
| 07:09 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 07:09 | | mode/#code [+o himi] by ChanServ |
| 07:10 | | LurtzCZ [Lurtz@Nightstar-0604e0ca.cust.termsnet.cz] has quit [Ping timeout: 121 seconds] |
| 07:12 | | Harlow [Harlow@Nightstar-2dbe3d64.il.comcast.net] has quit [[NS] Quit: BED] |
| 07:19 | | LurtzCZ [Lurtz@Nightstar-0604e0ca.cust.termsnet.cz] has joined #code |
| 07:24 | <~Vornicus> | The irony is thick like axe body spray in a high school boys' locker room: chrome lists php.net as having malware. |
| 07:33 | < Syka> | haha |
| 07:46 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 07:59 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 07:59 | | mode/#code [+o himi] by ChanServ |
| 08:13 | | Vash [Vash@Nightstar-221158c7.sd.cox.net] has joined #code |
| 08:13 | | mode/#code [+o Vash] by ChanServ |
| 08:36 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 08:48 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 08:48 | | mode/#code [+o himi] by ChanServ |
| 09:01 | | You're now known as TheWatcher |
| 09:20 | | Vash [Vash@Nightstar-221158c7.sd.cox.net] has quit [Ping timeout: 121 seconds] |
| 09:37 | < Attilla> | that's quite the simile |
| 09:46 | | AverageJoe [evil1@Nightstar-9da8df73.ph.cox.net] has joined #code |
| 10:12 | | thalass [thalass@Nightstar-141785b5.bigpond.net.au] has joined #code |
| 10:49 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 11:02 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 11:03 | | mode/#code [+o himi] by ChanServ |
| 11:23 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 11:37 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 11:37 | | mode/#code [+o himi] by ChanServ |
| 11:44 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 11:55 | | Kindamoody is now known as Kindamoody|out |
| 11:57 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 11:57 | | mode/#code [+o himi] by ChanServ |
| 12:06 | | AverageJoe [evil1@Nightstar-9da8df73.ph.cox.net] has quit [[NS] Quit: Leaving] |
| 12:19 | | VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has joined #code |
| 12:39 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 12:48 | | Vash [Vash@Nightstar-221158c7.sd.cox.net] has joined #code |
| 12:48 | | mode/#code [+o Vash] by ChanServ |
| 12:51 | <@Tarinaky> | Hmm... Imaging I have a massless particle controlled by an ai in an n-body simulation. |
| 12:51 | <@Tarinaky> | The AI wants to get from one body to another. |
| 12:52 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 12:52 | | mode/#code [+o himi] by ChanServ |
| 12:52 | <@Tarinaky> | So it tries to find a solution using a conic trajectory, a-la KSP, and if it finds one verifies it's correct by running its own n-body simulation. |
| 12:53 | <@Tarinaky> | If it doesn't have enough deltaV to complete such a solution, what would be a good heuristic to guide a search. |
| 12:54 | <@Tarinaky> | Cartesian position would be an obvious one, but I am unsure whether it is a sensible one. |
| 12:58 | <@Tarinaky> | Need some way to reduce the search to some list of sensible maneuvers to try. |
| 12:58 | <@Tarinaky> | *search space |
| 13:00 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Operation timed out] |
| 13:00 | | * TheWatcher eyes this, wtfs |
| 13:01 | <@TheWatcher> | git clone https://blablalbla/foo.git produces a directory I'd expect. |
| 13:02 | <@TheWatcher> | Using Git::Repository -> run(clone => $repository => $target, { ... opts ...}) produces a directory that contains files that were deleted |
| 13:12 | | Vash [Vash@Nightstar-221158c7.sd.cox.net] has quit [[NS] Quit: I <3Lovecraft<3 Vorn!] |
| 13:14 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 13:14 | | mode/#code [+o himi] by ChanServ |
| 13:14 | <@TheWatcher> | wait |
| 13:14 | | * TheWatcher facepalms |
| 13:17 | | celticminstrel [celticminst@Nightstar-90d86201.dsl.bell.ca] has joined #code |
| 13:17 | | mode/#code [+o celticminstrel] by ChanServ |
| 13:18 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 13:31 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 13:31 | | mode/#code [+o himi] by ChanServ |
| 13:41 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 13:55 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 13:55 | | mode/#code [+o himi] by ChanServ |
| 14:03 | <@Azash> | http://www.gironsec.com/blog/2013/10/bypassing-fireeye-toorcon-vid-slides/ |
| 14:04 | <@Tarinaky> | Argh. Can't seem to figure out how to use my universities e-journal system. |
| 14:04 | <@Tarinaky> | Tuition fees are the most useless fucking library card in my life. |
| 14:09 | <@froztbyte> | teehee |
| 14:10 | <@Azash> | For what it's worth, AverageJoe presented at Toorcon ^ |
| 14:10 | <@TheWatcher> | Go ask the library staff; it's their job to know how to do what you need. |
| 14:14 | <@TheWatcher> | Also, writing documentation: good gods, how I hateses it. |
| 14:59 | < ErikMesoy> | Errors you don't want to see at an IT workplace: "Sys" is undefined in global.js |
| 15:04 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 15:08 | | Reiv [NSwebIRC@Nightstar-95746c1f.kinect.net.nz] has quit [Ping timeout: 121 seconds] |
| 15:15 | | Vornicus [vorn@ServerAdministrator.Nightstar.Net] has quit [[NS] Quit: Leaving] |
| 15:18 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 15:18 | | mode/#code [+o himi] by ChanServ |
| 16:14 | <&ToxicFrog> | TheWatcher: cloned the wrong thing? |
| 16:14 | <&ToxicFrog> | Tarinaky: er - if it's massless, conics don't apply, its trajectory is a straight* line |
| 16:16 | <@Tarinaky> | ToxicFrog: Negligible mass sorry. |
| 16:16 | <@Tarinaky> | ToxicFrog: I don't speak well when I'm thinking at the same time. |
| 16:17 | <@TheWatcher> | TF: no, even more dumb. The code that invoked Git::Repository was also doing a bunch of post-clone work, part of which involves modifying a given file if it exists or /creating it if it doesn't/... |
| 16:17 | <@TheWatcher> | Yeah >.> |
| 16:20 | | Derakon[AFK] is now known as Derakon |
| 16:26 | <@Tarinaky> | I went to the library and asked. I've been told to email a different desk. |
| 17:10 | <@Tarinaky> | Lame. Apparently they don't have access to the journal for the year the article I want was published. :/ |
| 17:10 | <@Tarinaky> | Boo. Hiss. |
| 17:14 | < Syka> | time to do an aaron swartz |
| 17:17 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 17:20 | | thalass is now known as Thalasleep |
| 17:21 | | celticminstrel [celticminst@Nightstar-90d86201.dsl.bell.ca] has quit [[NS] Quit: And lo! The computer falls into a deep sleep, to awake again some other day!] |
| 17:30 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 17:30 | | mode/#code [+o himi] by ChanServ |
| 17:35 | | Turaiel[Offline] is now known as Turaiel |
| 17:51 | | abudhabi [abudhabi@2B12AA.CA225B.06AE83.B2A635] has quit [Ping timeout: 121 seconds] |
| 17:56 | | abudhabi [abudhabi@2B12AA.CA225B.06AE83.B2A635] has joined #code |
| 18:02 | | abudhabi is now known as Wires |
| 18:15 | <@TheWatcher> | Tarinaky: what is it you're after? I might be able to get it for you |
| 18:15 | | Kindamoody|out is now known as Kindamoody |
| 18:15 | <@Tarinaky> | TheWatcher: Trying to come up with a 'list' of maneuvers a space ship can perform, to use that as the elements from which to define a search space. |
| 18:16 | <@Tarinaky> | SPecifically, those relating to Libration points. |
| 18:16 | <@Tarinaky> | KSP has taught me enough to do simple transfers... |
| 18:17 | <@TheWatcher> | Okay, but which article are you after? |
| 18:17 | <@Tarinaky> | Oh, let me check. |
| 18:18 | <@Tarinaky> | 'Targeting in Hamiltonian systems that have mixed regular/chaotic phase spaces' |
| 18:18 | <@TheWatcher> | pmid 12779678? |
| 18:19 | <@Tarinaky> | I have no idea what that means. |
| 18:20 | <@gnolam> | Wait, why would it have a PubMed ID? |
| 18:21 | <@gnolam> | Tarinaky: https://en.wikipedia.org/wiki/PMID#PubMed_identifier |
| 18:22 | <@gnolam> | I mean, a DOI, sure, but PMID? Weird. |
| 18:24 | <@Tarinaky> | I have no idea what the pmid is. |
| 18:24 | <@Tarinaky> | There isn't one listed in this database. |
| 18:26 | | * TheWatcher eyes this |
| 18:27 | <@TheWatcher> | Well, I've found it, I think. http://scitation.aip.org/content/aip/journal/chaos/7/4/10.1063/1.166277 for example. However, even going through my uni's journal system, it won't let me at it for free |
| 18:29 | <@TheWatcher> | ... yep, nothing, all end up going back to that page and no free options it seems. |
| 18:30 | <@Tarinaky> | Fair winds. It's not the end of the world. |
| 18:40 | | Turaiel is now known as Turaiel[Offline] |
| 18:59 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 19:05 | < ErikMesoy> | SQL: what's the syntax for counting how many subthings each of a type of thing has? I think I'm trying to write something that will give me "Science 3; Math 2" from a courses-and-study-groups table that contains the five entries (Science, group1), (Science, group2), (Science, group3), (Math, group1), (Math, group2). |
| 19:05 | < ErikMesoy> | Looking at something similar to "SELECT course, COUNT(group) FROM CourseGroupTable" but that's wrong. I have a longer table and it's only giving me the last entry. |
| 19:06 | | Kindamoody is now known as Kindamoody|afk |
| 19:13 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 19:13 | | mode/#code [+o himi] by ChanServ |
| 19:13 | < ErikMesoy> | SELECT course, COUNT(distinct group) FROM CourseGroupTable WHERE course="Science" gives me the "Science 3" result I want, but this only gives me one thing at a time. Saying WHERE course LIKE '%' doesn't give me a list either. |
| 19:19 | | LurtzCZ [Lurtz@Nightstar-0604e0ca.cust.termsnet.cz] has quit [Ping timeout: 121 seconds] |
| 19:22 | | Wires is now known as AnnoDomini |
| 19:25 | < RichyB> | SELECT course, COUNT(distinct group) FROM CourseGroupTable GROUP BY course; -- ? |
| 19:25 | < RichyB> | ErikMesoy, â ? |
| 19:27 | < ErikMesoy> | Yes. |
| 19:28 | < ErikMesoy> | This works. |
| 19:30 | <@Tarinaky> | TheWatcher: Dumb question, any idea how to progress my research in light of this obstacle? I'm new to this whole independent learning thing >.> |
| 19:30 | < RichyB> | How old is the paper? |
| 19:31 | <@Tarinaky> | Published 1997 |
| 19:31 | < RichyB> | Supposedly, if you can track down one of the authors, most academics will happily email a PDF, usually stamped with "DRAFT" or "PREPRINT", in response to a polite email. |
| 19:32 | < Syka> | they might even find it amusing if you mention it's for KSP manevours |
| 19:32 | < ErikMesoy> | Urgh. This next SQL exercise says I'm supposed to retrieve group information from the table of students; the group information isn't in the table of students, only the table of courses. |
| 19:33 | < ErikMesoy> | The exercise says "only the table Students shall be present in the FROM clause of the statement" which sounds like an exercise in accessing table Groups outside of the FROM clause. >_> |
| 19:38 | | Kindamoody|afk is now known as Kindamoody |
| 19:48 | <@Tarinaky> | Syka: It's not for KSP. It's for something nelse. |
| 19:49 | <@Tarinaky> | KSP doesn't have any kind of provision for AI/Flight Computer unfortunately. |
| 19:49 | < Syka> | oh |
| 19:49 | < Syka> | Tarinaky: mechjeb? |
| 19:49 | <@Tarinaky> | Oh yeah But Mechjeb already does everything in KSP's model. |
| 19:49 | < Syka> | that's a flight computer, i think |
| 19:49 | < Syka> | oh |
| 19:49 | <@Tarinaky> | This is for something else either way. |
| 19:50 | <@Tarinaky> | Since KSP /only/ has conics. |
| 19:50 | < Syka> | ...still, saying it's for KSP might help :D |
| 19:50 | | * Syka awaits the day for a paper to have figures of KSP-based models |
| 19:50 | < Syka> | i guess ksp ignores the 3 body problem |
| 19:51 | <@Tarinaky> | I'm need to figure out an understanding of how libration-point transfers work so I can define a language encompassing them. |
| 19:51 | <@Tarinaky> | Well, need is too strong a word. |
| 19:51 | < Syka> | you may have been nerdsniped |
| 19:51 | <@Tarinaky> | Nerdsniped? |
| 19:52 | < Syka> | introduced to a problem where everything else shuts down until you've solved it |
| 19:52 | < Syka> | (or an 'interesting avenue of interllectual persuit') |
| 19:52 | <@Tarinaky> | Ah. Yes. |
| 19:53 | < Syka> | it's why i know lots of useless facts about things |
| 19:55 | <@Tarinaky> | Last time I got nerdsniped this badly was when I saw a problem about an infinite plane of resistors. |
| 19:55 | < Syka> | i think thats actually the example in the xkcd |
| 19:56 | < Syka> | since There Is Always A Relevant XKCD Comic |
| 19:57 | <@Tarinaky> | Quite likely. |
| 19:57 | < AnnoDomini> | Can't the infinite resistor plane be solved by extrapolating from increaningly large but finite resistor planes? |
| 19:58 | < Syka> | see, my solution for that is |
| 19:58 | < Syka> | 'by observing the resistance, you change it' |
| 19:58 | < ErikMesoy> | Stop solving it. You don't have an infinite resistor plane. |
| 19:58 | <@Tarinaky> | iirc I built a geometric series that modelled the problem and was able to solve it using that. |
| 19:58 | < Syka> | i call it the 'quantum screw you' |
| 19:58 | <@Tarinaky> | 19:57 < AnnoDomini> Can't the infinite resistor plane be solved by extrapolating from increaningly large but finite resistor planes? |
| 19:58 | <@Tarinaky> | Isn't that basically the definition of convergence? |
| 19:59 | < AnnoDomini> | ErikMesoy: Good idea. |
| 20:00 | < Syka> | what if you did have an infinite resistor plane |
| 20:00 | < Syka> | like, just sitting round |
| 20:01 | < AnnoDomini> | Then you could test it. |
| 20:01 | < AnnoDomini> | With a multimeter. |
| 20:01 | < Syka> | an even better question |
| 20:01 | < Syka> | how many radioshacks would you have to ransack to get that many 1 ohm resistors?? |
| 20:01 | <@Tarinaky> | AnnoDomini: What's the resistance of the universe? :p |
| 20:02 | < AnnoDomini> | Tarinaky: Have a solution. http://www.mathpages.com/home/kmath668/kmath668.htm |
| 20:02 | <@Tarinaky> | Presumably there's enough ions floating around the interstellar medium that a sufficiently silly voltage could get a current :p |
| 20:02 | <@Tarinaky> | AnnoDomini: One nerd snipe at a time. |
| 20:03 | < AnnoDomini> | Measuring the impedance of the universe is beyond the ability of a multimeter. Therefore, it is not my problem. |
| 20:03 | < Syka> | pfft |
| 20:03 | < ErikMesoy> | :D |
| 20:03 | < Syka> | get some extension leads |
| 20:03 | < Syka> | she'll be right |
| 20:03 | < ErikMesoy> | Yeah, I like Anno's solution too. |
| 20:05 | < ErikMesoy> | I have a theoretical "this is never gonna happen" principled objection to very large things, and Anno has a more practical "outside my scope" objection to very large things. :p |
| 20:05 | < ErikMesoy> | Oh god here I go with the long statements of longness. |
| 20:05 | < ErikMesoy> | Write a SELECT statement to print out: |
| 20:06 | < Syka> | you want to see long statements of longness? |
| 20:06 | < Syka> | i was dealing with a database written by some medical systems |
| 20:06 | < Syka> | the INSERT statement in python took up 2.5 IRC buffers |
| 20:07 | < ErikMesoy> | ow. |
| 20:07 | < ErikMesoy> | my present exercise: "the course code, group number, and number of students for every group appearing in the CourseStudy table for the present semester (2013-2) using one line per group and course. Lines to be ordered alphabetically by course code and descending by group size. Do not include course INF1100." |
| 20:07 | < Syka> | it was um |
| 20:07 | < Syka> | let me find the statment |
| 20:07 | < Syka> | here is one section: " VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" |
| 20:09 | < Syka> | it is dailywtf material, but i may leave it for a few years, just in case |
| 20:09 | < ErikMesoy> | heh |
| 20:09 | < Syka> | the guy i was working with |
| 20:10 | < Syka> | he means well, but holy shit is he a bad programmer :( |
| 20:10 | < Syka> | I just have to silently fix everything behind his back |
| 20:10 | < Syka> | but that project got cancelled (phew) |
| 20:13 | < ErikMesoy> | "WHERE code is not null AND code is not 'INF1100'" or "WHERE code is not null or 'INF1100'" or some other syntax, for a field that must be neither of two things? |
| 20:13 | < ErikMesoy> | "WHERE code not in (null, 'INF1100')" ? Is there a right way to do this? |
| 20:14 | <@Tarinaky> | I dunno whether I should try to find a good correspondence course in Maths if/when I can find a job to pay for it... |
| 20:14 | <@Tarinaky> | Does such a thing even exist? :/ |
| 20:20 | <&Derakon> | Uh, there's billions of free online courses these days. |
| 20:21 | <&Derakon> | Just hit up Khan Academy or something. |
| 20:21 | <@Tarinaky> | Khan kindof stops at first year maths. |
| 20:22 | | * ErikMesoy is very confused about how he's supposed to do something like "for each" in SQL. It seems to involve GROUP BY somehow. |
| 20:23 | <@Tarinaky> | Eugh. Great. Another article that's probably relevant to what I want to look up and it's in the same journal I can't access :/ |
| 20:23 | <@Tarinaky> | -.- |
| 20:28 | | Kindamoody is now known as Kindamoody[zZz] |
| 20:37 | <@Azash> | ErikMesoy: How do you mean for each? |
| 20:38 | <@Azash> | ErikMesoy: Also, make a Coursera account and look up Jennifer Widom's Introduction to Databases |
| 20:38 | <@Azash> | It's very good for getting you up to speed |
| 20:39 | < ErikMesoy> | Azash: For each course, I'm supposed to calculate the average number of students-per-group that course has. |
| 20:40 | <@Azash> | Mm, I can't remember it off-hand, admittedly |
| 20:40 | <@Azash> | My piece of advice still stands |
| 20:41 | | * ErikMesoy does so. Aaagh, video lectures, unsearchable. |
| 20:42 | < AnnoDomini> | I think there's a function that calculates an average out of rows. |
| 20:42 | < AnnoDomini> | Also a keyword thingy that lets you break things down by a criterion. |
| 20:43 | < AnnoDomini> | Something like avg(something) group by field='smth'. It's been quite some time since I've used SQL. |
| 20:43 | < ErikMesoy> | AnnoDomini: My problem is that I don't have numeric rows. I have a set of student:course:group relationships, and I have a GROUP BY statement to print out "course X group 1 has N students. course X group 2 has M students". |
| 20:44 | <@Alek> | oh evil |
| 20:44 | <@Alek> | http://steike.com/code/useless/zip-file-quine/ |
| 20:44 | < ErikMesoy> | I have to average M and N, and those don't exist in any table, so it seems I have to nest somehow. |
| 20:44 | < Syka> | you can do that using psuedotable things |
| 20:44 | < Syka> | i forget what theyre called |
| 20:44 | < Syka> | but you join in a fictional table (say, x) |
| 20:44 | < Syka> | and then query on x |
| 20:45 | < Syka> | but that may be a bit complicated for what theyre asking |
| 20:45 | < AnnoDomini> | Subselect? |
| 20:47 | <@Pandemic> | does any one know what the parseing conditions are for iOS and phone numbers |
| 20:47 | <@Pandemic> | specificly I'm trying to figure out formating limitations. |
| 20:47 | <@Pandemic> | does the parser support spaces for example? |
| 20:52 | < AnnoDomini> | ErikMesoy: Have you tried creating a table, feeding results of group membership calculations there, doing aggregation and grouping, and then deleting the table? |
| 20:52 | < ErikMesoy> | AnnoDomini: This is supposed to be done inside a select statement. |
| 20:52 | < AnnoDomini> | Have you tried a subselect? |
| 20:52 | < ErikMesoy> | I haven't figured out the right syntax for that. |
| 20:53 | <@Pandemic> | would an inner or outer join be useful in this situation? |
| 20:53 | < ErikMesoy> | All the examples I'm finding are for subselects in the WHERE clause. |
| 20:53 | < AnnoDomini> | http://en.wikipedia.org/wiki/Correlated_subquery |
| 20:55 | < ErikMesoy> | If you copypaste "SELECT distinct Country, COUNT(CustomerID) as 'people here' FROM Customers GROUP BY Country;" into the form at http://www.w3schools.com/sql/trysql.asp?filename=trysql_func_avg you will get an idea of what I'm working with. |
| 20:56 | < ErikMesoy> | Argentina 3, Austria 2 etc - now where do I put the brackets for saying AVG about this? |
| 20:57 | < AnnoDomini> | Rub it on everything. |
| 20:57 | < AnnoDomini> | Do what adventure games taught you! |
| 20:57 | < ErikMesoy> | Pfffft. |
| 20:58 | < AnnoDomini> | Likely suspects: AVG(COUNT(customerID)), AVG(people here). |
| 20:59 | < ErikMesoy> | Aha, worked it out with square brackets. SELECT AVG([people here]) FROM (SELECT distinct Country, COUNT(CustomerID) as 'people here' FROM Customers GROUP BY Country); |
| 20:59 | < AnnoDomini> | What do square brackets do? |
| 21:00 | < ErikMesoy> | Progress the adventure game. :V |
| 21:04 | | * AnnoDomini checks. They just dekeywordize the contents. |
| 21:08 | < ErikMesoy> | That doesn't make me understand why I needed them here or why they work. |
| 21:09 | < AnnoDomini> | You needed them there because you used a space in the name of the virtual table you were making. |
| 21:09 | < AnnoDomini> | Normally 'people here' would be parsed as two separate words. |
| 21:09 | < AnnoDomini> | Since you meant this as one name, you needed [] to dekeywordize the space bar. |
| 21:16 | | Vornicus [vorn@ServerAdministrator.Nightstar.Net] has joined #code |
| 21:16 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 21:20 | | celticminstrel [celticminst@Nightstar-90d86201.dsl.bell.ca] has joined #code |
| 21:20 | | mode/#code [+o celticminstrel] by ChanServ |
| 21:21 | | Harlow [Harlow@Nightstar-2dbe3d64.il.comcast.net] has joined #code |
| 21:47 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 21:52 | | Reiv [NSwebIRC@Nightstar-95746c1f.kinect.net.nz] has joined #code |
| 21:52 | | mode/#code [+o Reiv] by ChanServ |
| 22:00 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 22:00 | | mode/#code [+o himi] by ChanServ |
| 22:02 | | Turaiel[Offline] is now known as Turaiel |
| 22:18 | | NeoGeo64 [trizzo@Nightstar-a940610b.client.mchsi.com] has joined #code |
| 22:20 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 22:23 | | NeoGeo64 [trizzo@Nightstar-a940610b.client.mchsi.com] has left #code [] |
| 22:32 | | Turaiel is now known as Turaiel[Offline] |
| 22:33 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 22:33 | | mode/#code [+o himi] by ChanServ |
| 22:34 | | Harlow [Harlow@Nightstar-2dbe3d64.il.comcast.net] has quit [Ping timeout: 121 seconds] |
| 22:34 | | Harlow [Harlow@Nightstar-2dbe3d64.il.comcast.net] has joined #code |
| 22:39 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 22:42 | | Harlow [Harlow@Nightstar-2dbe3d64.il.comcast.net] has quit [[NS] Quit: This computer has gone to sleep] |
| 22:52 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 22:52 | | mode/#code [+o himi] by ChanServ |
| 23:15 | | ErikMesoy is now known as ErikMesoy|sleep |
| 23:16 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 23:21 | | * McMartin finds the quote he was looking for yesterday. |
| 23:21 | <&McMartin> | "The existence and use of design patterns in a language are indicative of a weakness in the language itself, rather than a consequence of solving the problem at hand" |
| 23:22 | <&McMartin> | Also, heh. "It is a truth universally acknowledged that when you rant about the evils of a specific programming practice, you will find it mandatory within two days." |
| --- Log closed Fri Oct 25 00:00:31 2013 |