| --- Log opened Tue Nov 13 00:00:20 2012 |
| 00:02 | < VirusJTG> | does any one know when Pandemic timed out? |
| 00:02 | < VirusJTG> | I'm trying to issolate when that machine shutdown |
| 00:03 | < gnolam> | About 1 1/2 hours ago. |
| 00:04 | < gnolam> | (23:31:48 for me. It's now 01:04, local time.) |
| 00:04 | < VirusJTG> | thanks gnolam |
| 00:04 | < VirusJTG> | lets see if it turns back on... |
| 00:06 | < VirusJTG> | looks like it is comming back |
| 00:06 | < VirusJTG> | slowly |
| 00:09 | | VirusJTG is now known as Pandemic |
| 00:09 | | VirusHome [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has joined #code |
| 00:09 | < Pandemic> | yay back! |
| 00:09 | < Pandemic> | ggrr |
| 00:09 | | Pandemic is now known as VirusJTG |
| 00:10 | | VirusHome is now known as PAndemic |
| 00:11 | | PAndemic is now known as Pandemic |
| 00:11 | | VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has quit [[NS] Quit: Program Shutting down] |
| 00:11 | | VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has joined #code |
| 00:23 | <&ToxicFrog> | AnnoDomini: how do you figure it's a feature? |
| 00:24 | <@AnnoDomini> | The devs said so. |
| 00:28 | | Attilla_ [Obsolete@Nightstar-0060b348.as43234.net] has quit [[NS] Quit: ] |
| 00:35 | <&ToxicFrog> | Oh. Weirdass. |
| 00:36 | | celticminstrel [celticminst@Nightstar-05d23b97.cable.rogers.com] has joined #code |
| 00:52 | | * AnnoDomini gets EU3 on Linux to run! |
| 00:52 | <@AnnoDomini> | Unplayably slowly. |
| 00:53 | <@AnnoDomini> | Oh, well. It's better than a kick in the head. |
| 01:20 | | Netsplit *.net <-> *.split quits: @iospace, Pandemic, @froztbyte, Vornicus, @Reiv, @AnnoDomini, @PinkFreud, simon_, cpux, @Tarinaky, (+10 more, use /NETSPLIT to show all of them) |
| 01:20 | | Netsplit over, joins: @PinkFreud, &jerith, &McMartin, @froztbyte, ~Vornicus, @Reiv, simon_, EvilDarkLord, @Namegduf, @Azash |
| 01:21 | | Netsplit over, joins: Pandemic, @Tamber, @franny, @iospace, shawn-p1, gnolam, @Tarinaky, cpux, @AnnoDomini, @rms |
| 01:21 | | Reiv [NSwebIRC@D4E70A.D52DB0.820B13.98C775] has quit [Ping timeout: 121 seconds] |
| 02:54 | | Kindamoody[zZz] is now known as Kindamoody |
| 02:55 | | Moltare [Moltare@583787.FF2A18.190FE2.4D81A1] has quit [Ping timeout: 121 seconds] |
| 02:58 | | Moltare [Moltare@583787.FF2A18.190FE2.4D81A1] has joined #code |
| 03:38 | | VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has quit [[NS] Quit: night all] |
| 04:03 | | McMartin [mcmartin@Nightstar-3895ee8e.pltn13.sbcglobal.net] has quit [[NS] Quit: reboot] |
| 04:12 | | McMartin [mcmartin@Nightstar-3895ee8e.pltn13.sbcglobal.net] has joined #code |
| 04:12 | | mode/#code [+ao McMartin McMartin] by ChanServ |
| 04:48 | | Reiv [NSwebIRC@D4E70A.D52DB0.820B13.98C775] has joined #code |
| 05:25 | | Vash [Vash@Nightstar-b43e074a.wlfrct.sbcglobal.net] has joined #code |
| 05:25 | | mode/#code [+o Vash] by ChanServ |
| 05:31 | | celticminstrel [celticminst@Nightstar-05d23b97.cable.rogers.com] has quit [[NS] Quit: And lo! The computer falls into a deep sleep, to awake again some other day!] |
| 05:41 | | himi [fow035@D741F1.243F35.CADC30.81D435] has quit [Operation timed out] |
| 06:00 | | Syloq_Home [Syloq@NetworkAdministrator.Nightstar.Net] has quit [[NS] Quit: ] |
| 06:02 | | ErikMesoy|sleep is now known as ErikMesoy |
| 06:20 | < Reiv> | Fucking VLOOKUP, how do they work |
| 06:21 | < Reiv> | Or rather: I have one column, A. I have one table, B. I want to return every row of B where the value of the first column of B matches any of the numbers in column A. |
| 06:21 | <~Vornicus> | This in excel? |
| 06:21 | < Reiv> | Yah. |
| 06:21 | < Reiv> | The thing I don't get |
| 06:21 | < Reiv> | After struggling with this for a bit, I simplified down to two columns of values: A and B. |
| 06:21 | <~Vornicus> | Okay, values in B's first column: do they follow the UNIQUE constraint? |
| 06:22 | < Reiv> | Why does the count of found records change if you go VLOOKUP(A,B,1,FALSE) vs VLOOKUP(B,A,1,FALSE)? |
| 06:22 | < Reiv> | ...hm. Neither do. |
| 06:23 | <~Vornicus> | This is Problematic with vlookup. |
| 06:23 | <~Vornicus> | It assumes that the constraint exists. |
| 06:24 | < Reiv> | Ah-/hah/. |
| 06:24 | < Reiv> | OK. |
| 06:25 | < Reiv> | I can, if needed, force Column A to be unique |
| 06:25 | < Reiv> | I cannot force column B to do the same, because it has unique row data. |
| 06:25 | | * Reiv is filtering on installations, but actually trying to return power meters. Installations can often have several. |
| 06:25 | < Reiv> | Is this able to be made workable? |
| 06:26 | <~Vornicus> | I don't, uh... |
| 06:26 | <~Vornicus> | you might be able to do summary work. |
| 06:26 | <~Vornicus> | This is Not a job for Excel though |
| 06:27 | < Reiv> | Well, fuck. |
| 06:27 | <~Vornicus> | Access or whatever SQL system you have can pull it off. |
| 06:27 | < Reiv> | Because it's not a job for the databases I have either, unless you know a way to... hn |
| 06:27 | <~Vornicus> | Make Your Own, it's not that hard |
| 06:27 | < Reiv> | The thing is, I have an Oracle SQL database on one side |
| 06:27 | < Reiv> | And a Microsoft SQL on the other. |
| 06:27 | <~Vornicus> | you're a database guy, you can probably -- oh god the hurting. |
| 06:28 | < Reiv> | We have a large number of connections between various iterations thereof in here |
| 06:28 | < Reiv> | But not between /these/ two systems |
| 06:28 | < Reiv> | Because it's usually assumed there's a daisy chain of intermediaries |
| 06:29 | < Reiv> | And, uh, the whole point of this was to compare Database A to Database E while skipping the steps in between to check that the stuff in between wasn't fucking up. |
| 06:29 | <~Vornicus> | Aha. |
| 06:29 | <~Vornicus> | Okay. Dump your tables into Access. |
| 06:30 | < Reiv> | Oh god an access database~ |
| 06:30 | <~Vornicus> | You can then use Group By in there to summarize data if you need. |
| 06:30 | < Reiv> | Not really sure what benefit that would do |
| 06:30 | <~Vornicus> | Reiv: well you have to get them all in one STEEL CA^W^W database together if you're going to get it done. |
| 06:31 | < Reiv> | But why the group by? |
| 06:31 | < Reiv> | This would've been an inner join, if Excel allowed such a thing. |
| 06:31 | < Reiv> | (Followed by a couple of other diagnostics with left and rights, but hell, inner first at all kthx?) |
| 06:33 | <~Vornicus> | okay I don't quite understand the problem here. |
| 06:34 | <~Vornicus> | Could I get you to mock up some data (I don't want real data, I'm not an employee) and throw that at me and I'll see what I can come up with? |
| 06:35 | | Derakon is now known as Derakon[AFK] |
| 06:35 | | Kindamoody is now known as Kindamoody|out |
| 06:36 | < Reiv> | uh |
| 06:36 | < Reiv> | I can /try/ |
| 06:36 | < Reiv> | hm |
| 06:37 | < Reiv> | What sort of mock data do you want |
| 06:38 | < Reiv> | Beyond, y'know, two columns of numbers that have duplicates, some of which match but most don't? |
| 06:39 | <~Vornicus> | I get the impression that you're looking at the following data, from this end. |
| 06:39 | <~Vornicus> | Account, meter, payload. |
| 06:39 | <~Vornicus> | There are multiple meters per account. |
| 06:39 | < Reiv> | Hm. Yes. |
| 06:39 | <~Vornicus> | That's one side of your data. |
| 06:39 | <~Vornicus> | What's the other side? |
| 06:39 | < Reiv> | A list of account numbers. |
| 06:40 | <~Vornicus> | Okay. And what information do you want, given an account number from that list. |
| 06:40 | < Reiv> | That's it (And is the side I could run a DISTINCT on if it helped) |
| 06:40 | < Reiv> | The data from the first side. |
| 06:40 | <~Vornicus> | The payload? |
| 06:40 | < Reiv> | I've got all 9 columns in the Excel file already. |
| 06:41 | <~Vornicus> | You'll need a summary function for it, and that means a different tack. |
| 06:41 | < Reiv> | I need Account, Meter, Payload in their columns. |
| 06:41 | < Reiv> | The thing being I have Account data to filter the list by |
| 06:42 | < Reiv> | But the row-by-row working will be at the Meter level, using the payload. |
| 06:42 | <~Vornicus> | So in SQL this would be SELECT * FROM filtered_accounts NATURAL JOIN account_meters NATURAL JOIN meters; |
| 06:42 | <~Vornicus> | where filtered_accounts is the account list and the other stuff is as you see. |
| 06:42 | < Reiv> | (This is, in fact, so two temp data-entry staff can be put to use in favour of an automated process, because there's quite a bit of Confounding Rules applied) |
| 06:43 | <~Vornicus> | Okay let me see what I can throw together. |
| 06:44 | < Reiv> | In SQL this would be SELECT * FROM filtered_accounts fa INNER JOIN meter m ON fa.account = m.account; |
| 06:45 | <~Vornicus> | Okay so almost. |
| 06:45 | < Reiv> | As the table I'm pulling data from has the account key on it as a foreign key from a 1:M relationship. |
| 06:45 | <~Vornicus> | that's a natural join anyway. |
| 06:45 | < Reiv> | Fair enough :) |
| 06:46 | | * Vornicus hunts around in the formulas and pokety poke pokes |
| 06:46 | <~Vornicus> | Oh there we are. |
| 06:46 | <~Vornicus> | If you need a one-time thing, you can use the advanced filter task in the Data tab |
| 06:47 | | * Vornicus tries to remember how this is done. |
| 06:48 | <~Vornicus> | Oh, glorious. |
| 06:48 | <~Vornicus> | Okay. |
| 06:48 | <~Vornicus> | So I've got, for my filter trick. |
| 06:49 | <~Vornicus> | You give it two ranges: the one has the meter table; the other has the filtered accounts table. both have headers. |
| 06:49 | < Reiv> | OK |
| 06:50 | | * Reiv has used Filter before. |
| 06:50 | < Reiv> | ... hm, actually. Give it two ranges? |
| 06:51 | | * Reiv muses. |
| 06:51 | <~Vornicus> | You're using Advanced Filter |
| 06:51 | <~Vornicus> | The first range, the Data range, is the meter table. The second range, the Criteria range, is the filtered accounts table. |
| 06:54 | <~Vornicus> | The advanced filter is actually quite awesome; it appears to be approximately as powerful as the criteria boxes in Access, which are how it generates its WHERE clause |
| 06:54 | < Reiv> | ... Oh/ho/ |
| 06:54 | <~Vornicus> | Read the help file on that it's covered in examples. |
| 06:56 | <~Vornicus> | http://office.microsoft.com/en-us/excel-help/filter-by-using-advanced-criteria-H P005200178.aspx check it out. |
| 06:56 | < Reiv> | You, good sir, are my Tiny Elder God of Math. |
| 06:56 | < Reiv> | Why did I not think to ask you this shit before 8pm~ |
| 06:57 | <~Vornicus> | Because you are a silly person who has forgotten that my resume lists "20+ years experience with Microsoft Excel" |
| 06:58 | < Reiv> | And also before like 6pm I don't really get to think seriously about asking shit on IRC rather than the occasional quick bit of chatter in between queries, I guess~ |
| 06:58 | < Reiv> | hm so uh |
| 06:59 | | * Reiv scratches his head, the examples seem a bit odd. Which one are you referring to? |
| 06:59 | <~Vornicus> | Well the one you should probably look at is Multiple Criteria In One Column |
| 07:00 | <~Vornicus> | If you only really care about one column, your criteria range can have just one column |
| 07:00 | <~Vornicus> | But it still needs to have headers! |
| 07:01 | < Reiv> | It has a header |
| 07:01 | < Reiv> | A convinience of copying SQL query output, oddly enough |
| 07:02 | <~Vornicus> | well good then~ |
| 07:02 | < Reiv> | Just trying to figure how you tel the Criteria to compare Column A with the rows of data from column K |
| 07:03 | <~Vornicus> | Okay here's what I've got |
| 07:03 | <~Vornicus> | in column E I have my list of filtered accounts, and the header on that column says "account" |
| 07:03 | <~Vornicus> | In columns A-C I have my table of accounts, meters, and payload. You can have more columns of course but I didn't want to make up more than one thing of payload |
| 07:04 | <~Vornicus> | The A-C table also has headers, and in particular column A is headed "account" |
| 07:04 | | Vash [Vash@Nightstar-b43e074a.wlfrct.sbcglobal.net] has quit [[NS] Quit: I lovecraft Vorn!] |
| 07:05 | < Reiv> | Right |
| 07:05 | <~Vornicus> | I open up Advanced Filter, select "copy to another location", select my stuff in columns A-C as my "list range", select my stuff in column E as my "criteria range", and select a 3-column-wide area somewhere for the "copy to" |
| 07:05 | <~Vornicus> | I hit okay. |
| 07:06 | < Reiv> | ...oh, the columns have to match in headers. |
| 07:06 | < Reiv> | That'll do it. |
| 07:06 | <~Vornicus> | I spin my giant sword around in front of me and then heft it over my shoulder and pick up a mid-potion, 325 XP, and 100 gil. |
| 07:07 | | * Reiv renames the sucker, makes note of origional name for later elsewhere~ |
| 07:07 | < Reiv> | Speaking of giant swords |
| 07:07 | < Reiv> | You want numenera rules? :) |
| 07:07 | | * McMartin gouges for staples during a famine |
| 07:07 | <&McMartin> | I AM THE BEEF LORD |
| 07:08 | <~Vornicus> | what |
| 07:08 | | * McMartin mischanned |
| 07:08 | | * McMartin is performing highly unethical but highly profitable operations in Recettear. |
| 07:12 | <~Vornicus> | Reiv: Yes please. |
| 08:37 | | Moltare [Moltare@583787.FF2A18.190FE2.4D81A1] has quit [Ping timeout: 121 seconds] |
| 08:37 | | Courage [Moltare@583787.FF2A18.190FE2.4D81A1] has joined #code |
| 09:05 | | sykwerk is now known as Syk |
| 09:06 | | * McMartin notes in-channel for future self-reference elsewhere: (with-open [rdr (clojure.java.io/reader fname)] (let [lines (line-seq rdr)] #_(...))) |
| 09:16 | | You're now known as TheWatcher |
| 09:20 | <@Reiver> | wut |
| 09:20 | < Syk> | welp |
| 09:20 | < Syk> | it's going to be a risk, but |
| 09:21 | | * Syk is seriously contemplating starting her own business |
| 09:23 | <&McMartin> | Syk: Good luck! Do you have a product or are you thinking more freelance contracting? |
| 09:23 | < Syk> | I don't 'have' a product right now |
| 09:23 | < Syk> | I know what my product /is/ |
| 09:23 | <&McMartin> | Reiver: The Clojure equivalent of Python's "for x in file(fname):" but with better control over inteation. |
| 09:23 | < Syk> | I just haven't written it yet :P |
| 09:23 | <&McMartin> | Well, good luck! |
| 09:24 | < Syk> | danke :3 |
| 09:24 | < Syk> | but yes... this is the reason why I'm going to learn Python+Twisted |
| 09:24 | < Syk> | because this is gonna be a web service |
| 09:24 | < Syk> | it's a duplication of software I wrote about 3 years ago at work, but that was a native app |
| 09:25 | < Syk> | so essentially I have all the algorithms down, all the design decisions have been made |
| 09:27 | < Syk> | McMartin: also, did you hear? |
| 09:27 | < Syk> | MS' Windows chief (Sinfosky) has left MS |
| 09:27 | <&McMartin> | Someone mentioned it but I haven't really looked into it much |
| 09:35 | < Syk> | I find it /hilarious/ |
| 09:35 | <&McMartin> | Speaking of Windows |
| 09:36 | <&McMartin> | I've been playing a little bit with the experimental Light Table IDE |
| 09:36 | <&McMartin> | (lighttable.com) |
| 09:36 | <&McMartin> | It is in all seriousness a better Metro-style app than any of the real Metro apps |
| 09:36 | <&McMartin> | And I'm running it on Win7. |
| 09:36 | <&McMartin> | So screw you, Sinfosky. |
| 09:42 | <&McMartin> | ... |
| 09:42 | <&McMartin> | So, we can't call the Metro anymore because of silliness with the name. |
| 09:42 | <&McMartin> | But it's like Metro. |
| 09:43 | <&McMartin> | Clearly, then, these are Metroid apps. |
| 09:43 | <&McMartin> | That'll be perfect! Nobody can complain about that name. |
| 09:43 | | * TheWatcher facepalm |
| 09:44 | < Syk> | McMartin: i think it's "Modern" now |
| 09:44 | < Syk> | or some shit |
| 09:45 | <&McMartin> | Modern like the chess openings |
| 09:46 | < Syk> | heh |
| 09:46 | < Syk> | Intel just released a $1000 enthusiast CPU |
| 09:47 | < Syk> | "The six-core, 12-thread i7-3960X has a base clock speed of 3.3GHz that's turbo-boostable to 3.9GHz, and includes 15MB of cache. It supports 64GB of RAM in four DDR3-1066/1333/1600 memory channels with a maximum bandwidth of 51.2GB/s, is baked in a 32-nanometer process, and has a thermal design point (TDP) of 130 watts." |
| 10:10 | | * AnnoDomini tries more upgrades. Maybe it won't break anything. (Haha!) |
| 10:16 | < Syk> | AnnoDomini: maybe the bugfixes might *fix some bugs* :O |
| 10:17 | <@AnnoDomini> | Hmm. Still stymied by the package manager being unable to autoconfigure "python-pyatspi2" and failing the whole procedure. |
| 10:21 | | RichyB [richardb@Nightstar-3b2c2db2.bethere.co.uk] has joined #code |
| 10:40 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 10:40 | | mode/#code [+o himi] by ChanServ |
| 14:13 | | celticminstrel [celticminst@Nightstar-05d23b97.cable.rogers.com] has joined #code |
| 15:07 | | Syloq_Home [Syloq@NetworkAdministrator.Nightstar.Net] has joined #code |
| 15:16 | | Attilla [Obsolete@Nightstar-0060b348.as43234.net] has joined #code |
| 15:19 | | celticminstrel [celticminst@Nightstar-05d23b97.cable.rogers.com] has quit [[NS] Quit: KABOOM! It seems that I have exploded. Please wait while I reinstall the universe.] |
| 15:19 | | celticminstrel [celticminst@Nightstar-05d23b97.cable.rogers.com] has joined #code |
| 15:31 | | rms [rstamer@genoce.org] has quit [Ping timeout: 121 seconds] |
| 15:55 | | celticminstrel [celticminst@Nightstar-05d23b97.cable.rogers.com] has quit [[NS] Quit: And lo! The computer falls into a deep sleep, to awake again some other day!] |
| 16:24 | | Kindamoody|out is now known as Kindamoody |
| 16:25 | | Syk is now known as syksleep |
| 16:53 | | * iospace eyes the UEFI spec: triple pointer |
| 16:53 | <@iospace> | YO DAWG |
| 16:55 | <@iospace> | no really, ***Var |
| 16:59 | <@TheWatcher> | Yes, and? |
| 17:00 | <~Vornicus> | what, that's it? come now |
| 17:00 | <~Vornicus> | three star is nothing. |
| 17:11 | <@iospace> | it's odd to me considering i've never seen it :P |
| 17:11 | <@iospace> | didn't expect it in the spec to be honest |
| 17:16 | <@ErikMesoy> | objection: three is a magic number |
| 17:16 | <@ErikMesoy> | it should have no, one, or infinite stars |
| 17:26 | | Moltare [Moltare@583787.FF2A18.190FE2.4D81A1] has joined #code |
| 17:27 | | Courage [Moltare@583787.FF2A18.190FE2.4D81A1] has quit [Ping timeout: 121 seconds] |
| 17:41 | <@froztbyte> | ZOI-Addressing sounds like a frightening setup |
| 17:41 | <@froztbyte> | Malbolge v2 |
| 17:43 | < RichyB> | Infinite addressing makes perfect sense, I think. |
| 17:44 | < RichyB> | newtype TurtlePtr = TurtlePtr (Ptr TurtlePtr) |
| 17:54 | | Attilla [Obsolete@Nightstar-0060b348.as43234.net] has quit [Ping timeout: 121 seconds] |
| 17:58 | | Attilla [Obsolete@Nightstar-1c742edd.as43234.net] has joined #code |
| 18:01 | | Kindamoody is now known as Kindamoody|cooking |
| 19:12 | | Vash [Vash@Nightstar-b43e074a.wlfrct.sbcglobal.net] has joined #code |
| 19:12 | | mode/#code [+o Vash] by ChanServ |
| 20:01 | | Kindamoody|cooking is now known as Kindamoody |
| 20:02 | | RichyB [richardb@Nightstar-3b2c2db2.bethere.co.uk] has quit [[NS] Quit: Leaving] |
| 20:18 | | Kindamoody is now known as Kindamoody[zZz] |
| 20:38 | <@iospace> | woops |
| 20:38 | <@iospace> | dear me: verify programming is complete before cycling power Dx |
| 20:39 | <&McMartin> | DX |
| 20:39 | <&McMartin> | Is it bricked or do you just need to do another programming operation? |
| 20:39 | <@iospace> | just another programming op |
| 20:39 | <@iospace> | what do you think i'm working on, apple products? :P |
| 20:40 | <&McMartin> | I actually don't know if I ever knew |
| 20:40 | <&McMartin> | I have no great love for Xilinx either though~ |
| 20:41 | < gnolam> | The Xilinx optimizer works in mysterious ways. |
| 20:41 | <@iospace> | we do do some Xilinx stuff here |
| 20:41 | | Vash [Vash@Nightstar-b43e074a.wlfrct.sbcglobal.net] has quit [[NS] Quit: I lovecraft Vorn!] |
| 20:41 | <@iospace> | yeah, it works :P |
| 20:42 | <@iospace> | though i am seeing some odd errors |
| 20:42 | | * iospace reprograms just to be sure |
| 20:42 | < gnolam> | (The actual response from my professor way back when when we discovered that the reason our gadget wasn't working was because the Xilinx synthesizer had optimized away nearly half of our VHDL) |
| 20:44 | <&McMartin> | (-_-) |
| 20:44 | | * Azash waves |
| 21:10 | < Reiv> | VHDL? |
| 21:11 | < gnolam> | Verbose as Hell Description Language. |
| 21:11 | <&jerith> | (V) Hardware Description Language. |
| 21:11 | <&jerith> | I forget what the V means. |
| 21:11 | <@AnnoDomini> | VHSIC. |
| 21:11 | < gnolam> | VHSIC. |
| 21:11 | < gnolam> | It's recursive. |
| 21:12 | <@AnnoDomini> | No, it's not. :P |
| 21:12 | <@AnnoDomini> | The fully expanded name is like Very High Speed Integrated Cirtuit Hardware Description Language. |
| 21:12 | < gnolam> | Anyway. VHDL and Verilog are the two major HDLs (Hardware Description Languages ~= languages in which to describe (digital) electronics for simulation and synthesis) out there. |
| 21:13 | < gnolam> | No, really. The V is for "VHSIC", in itself an abbreviation. Making it recursive. |
| 21:13 | <@AnnoDomini> | But not in the same way that PHP or others typical examples of recursive names are. |
| 21:13 | <&jerith> | gnolam: Nested, not recursive. Its doesn't call itself. |
| 21:14 | <@AnnoDomini> | They're very similar. VHDL is more like Pascal/Delphi, Verilog is more like C. |
| 21:14 | < gnolam> | jerith: linguistically: recursive. |
| 21:21 | | celticminstrel [celticminst@Nightstar-05d23b97.cable.rogers.com] has joined #code |
| 21:36 | <~Vornicus> | It's weird sometimes thinking you're mostly done but you're really only like half done |
| 21:37 | <&McMartin> | The first 90% takes 90% of the time, and then the last 10% takes the other 90% of the time. |
| 21:38 | <@iospace> | yup |
| 21:38 | <@AnnoDomini> | Do you spend the last 20% drinking 200 proof? :V |
| 21:38 | <@iospace> | McMartin: i thought it was first 90% is 10%, the last 10% is 90% :P |
| 21:39 | <&McMartin> | It's called the "90-90" rule |
| 21:39 | <@Tamber> | iospace, that's the optimist's version~ |
| 21:43 | | * iospace shrugs |
| 21:45 | < gnolam> | AnnoDomini: and now that I'm using Verilog, I find myself missing VHDL. I never thought that would happen. |
| 21:45 | < gnolam> | I'm still hoping that someone could combine the two into a sane HDL. |
| 21:46 | <@AnnoDomini> | You COULD try to build stuff in the graphical editor. :P |
| 21:57 | < gnolam> | (VHDL is very ADA-like, with all the pain that entails. Verilog is much, much nicer to write - but you get basically /no/ compile-time checking. Assign a wire that doesn't exist? No problems! Connect an 8-wide wire to a 1-bit input? Sure thing!) |
| 22:05 | <&ToxicFrog> | (whut) |
| 22:05 | <&ToxicFrog> | (that seems like the kind of thing the Verilog compiler should be able to check) |
| 22:35 | | ErikMesoy is now known as ErikMesoy|sleep |
| 22:48 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 22:56 | | VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has joined #code |
| 23:06 | | Moltare [Moltare@583787.FF2A18.190FE2.4D81A1] has quit [Ping timeout: 121 seconds] |
| 23:09 | | Moltare [Moltare@583787.FF2A18.190FE2.4D81A1] has joined #code |
| 23:13 | < Reiv> | So, in SQL |
| 23:14 | < Reiv> | I have a list of installations that need to be checked against another database. |
| 23:14 | < Reiv> | The list I have been given is an Excel spreadsheet. |
| 23:14 | < Reiv> | But that's merely a small wrinkle |
| 23:15 | < Reiv> | The /fun/ bit is, uh |
| 23:15 | < Reiv> | SELECT * FROM foo WHERE install LIKE '1234.JPG%' is the best method to identify whether said number is in the other database |
| 23:16 | < Reiv> | Because the only place with the key recorded is in a 'keywords' text column >_< |
| 23:16 | < Reiv> | Is there a way to do massed LIKE comparisons? |
| 23:16 | < Reiv> | I may, possibly, have fourty thousand rows. |
| 23:17 | < Reiv> | I *could* do WHERE keywords LIKE '1234.JPG%' OR keywords LIKE '1235.JPG' OR ... |
| 23:17 | < Reiv> | But this feels /extroadinarily unwise/ |
| 23:21 | < Reiv> | Any thoughts? |
| 23:21 | <@iospace> | SPOOOOOOOOOOOOOOOOOOOOOOOOOOOON |
| 23:23 | | syksleep is now known as Syk |
| 23:28 | <@TheWatcher> | Reiv: do you need to do that 'LIKE'? |
| 23:29 | <@TheWatcher> | Because otherwise you could do a SELECT * FROM foo WHERE install IN (SELECT col FROM bar); - horribly inefficient, but if you're only doing it rarely *shrug* |
| 23:30 | < Reiv> | Yes, the LIKE or an equivalent is needed. |
| 23:30 | < Reiv> | The one column has '1234' |
| 23:30 | <@TheWatcher> | Script time! |
| 23:31 | < Reiv> | The one in which I am checking against has '1234.JPG ABCDEFG Photo Meter MeteringAssets' etc |
| 23:31 | < Reiv> | This is, seriously, the only place the bloody key is kept |
| 23:32 | <@TheWatcher> | (or, put another way, I highly suspect that there isn't a sane way to do that in pure SQL, or at least if there is it'll be more SAN-leeching than just writing a script to do the job) |
| 23:32 | < Reiv> | So I need to match 1234 vs 1234% at minimum, preferably 1234.JPG% so I don't get false pairings. |
| 23:32 | < Reiv> | Joyous. |
| 23:32 | <@TheWatcher> | (Also shoot the guy who came up with that) |
| 23:32 | <@TheWatcher> | (please) |
| 23:32 | < Reiv> | How I Script In Microsoft SQL Server? ;_; |
| 23:32 | < Reiv> | (It is a generic file storage system. It's not just /our/ shit in it, and the thing handles searches etc juuuust fine. *sigh*) |
| 23:33 | < Reiv> | (There's also an XML tag set!) |
| 23:33 | < Reiv> | (...I would rather stick to the text box, thx) |
| 23:40 | <@TheWatcher> | perl -e 'use DBI; use Data::Dumper; my $dbh = DBI -> connect("DBI:ODBC:datasourcename", "username", "password"); my @keycheck = ("1234", "1234%", "1234.JPG%", ...etc...); my $checkh = $dbh -> prepare("SELECT * FROM foo WHERE install LIKE ?"); foreach my $key (@keycheck) { $checkh -> execute($key) or die "Unable to execute key query: ".$dbh -> errstr; while(my $row = $checkh -> fetchrow_hashref()) { print Dumper($row); } }' or something, I guess |
| 23:40 | <@TheWatcher> | ¬¬ |
| 23:43 | <@AnnoDomini> | Ia! Ia! Cthulhu pwlyh mwnglui fhtagn! |
| 23:47 | < Reiv> | TW: Now try that without perl and strictly read-only access~ |
| 23:48 | | * Reiv wonders what languages he /does/ have. It's, um, win7. |
| 23:48 | < Reiv> | >_< |
| 23:48 | <@Azash> | VB |
| 23:48 | < Syk> | this sounds like Bad Practice, but why not just dump the whole thing to RAM and work on it there if you need to do string mangling |
| 23:48 | <@Azash> | (I think?) |
| 23:49 | < Reiv> | Syk: Yeah, my alternate option is to dump the entire docstore keyword set into Excel. |
| 23:49 | < Reiv> | I am trying /very hard/ to avoid this. |
| 23:49 | | himi [fow035@D741F1.243F35.CADC30.81D435] has joined #code |
| 23:49 | | mode/#code [+o himi] by ChanServ |
| 23:49 | | * Reiv muses idly on how many rows it has. |
| 23:49 | < Syk> | Reiv: you could always get Visual Studio Express |
| 23:50 | < Syk> | and just use C# or VB.NET |
| 23:50 | < Syk> | (since it's free) |
| 23:50 | < Reiv> | Oh, well then. |
| 23:51 | < Reiv> | It's only six hundred thousand rows! |
| 23:51 | < Syk> | pffff, that's /nothing/ |
| 23:51 | < Reiv> | Excel will handle that /no/ problem, amirite |
| 23:51 | | * Syk secretly cries |
| 23:51 | < Syk> | Excel will handle that no problem. |
| 23:51 | < Syk> | your /machine/ however, will be dying a slow and painful death |
| 23:51 | < Reiv> | I has sixteen gig...? |
| 23:52 | < Reiv> | >_> <_< |
| 23:52 | < Syk> | could always try! :D |
| 23:53 | < Syk> | what's the worst that will happen? |
| 23:53 | < Reiv> | Yeah the thing choked on sodding 60k vs 25k vlookups yesterday |
| 23:53 | <@Tamber> | Oh, *now* you've done it. |
| 23:53 | | * Syk distributes fire extinguishers |
| 23:53 | < Syk> | anyway |
| 23:53 | < Reiv> | I don't know if 60k vs 600k with a text search instead of exact compare is going to go well~ |
| 23:53 | < Syk> | must be off to werk |
| 23:53 | < Syk> | moar trainin |
| 23:54 | < Syk> | will have a nice story for you guys tonight about my company's hiring processes |
| 23:56 | <@TheWatcher> | Reiv: dump to csv, move to a system you're not hamstrung on? |
| 23:58 | < Reiv> | hm |
| 23:58 | < Reiv> | If I /did/ land up with two csvs |
| 23:58 | < Reiv> | ... actually hrm that doesn't help much does it. |
| 23:58 | < Reiv> | Still need text manipulation at some point. |
| --- Log closed Wed Nov 14 00:00:36 2012 |