code logs -> 2008 -> Sun, 02 Mar 2008< code.20080301.log - code.20080303.log >
--- Log opened Sun Mar 02 00:00:50 2008
00:14 AnnoDomini [AnnoDomini@83.21.28.ns-3498] has quit [Quit: You can't eat someone's pet hamburger!]
01:02 Vornicus [~vorn@ServicesOp.Nightstar.Net] has quit [Ping Timeout]
01:34 * McMartin relicenses the heck out of his application.
01:48
<@McMartin>
OK, then.
01:49
<@McMartin>
I think the next release of Blorple is ready for release.
01:50
<@McMartin>
Time to learn how to use launch4j.
02:05
<@McMartin>
Well, no
02:06
<@McMartin>
First, time for uploading the other two versions, then errands and dinner, then I can mess around with launch4j and NSIS.
02:06
<@McMartin>
If SF.net weren't being ridiculously, comically slow, anyway.
02:08 You're now known as TheWatcher
02:09
<@gnolam>
From what license to what license?
02:16
<@McMartin>
GPL2 to 3 for most of it.
02:17
<@McMartin>
The new libraries written for the new release, however, are simplified BSD, and one file in particular that I've added to the project was and thus remains fully public domain.
02:17
<@McMartin>
And now, dinner.
02:18 * McMartin will have more pluggery available once he finishes creating the distribution files.
02:20 gnolam [lenin@Nightstar-10613.8.5.253.static.se.wasadata.net] has quit [Quit: Z?]
02:44
<@McMartin>
Well, OK
02:44
<@McMartin>
I suppose there's no sense in hiding the release given that absolutely nobody is monitoring the thing.
02:46
<@McMartin>
https://sourceforge.net/project/showfiles.php?group_id=193774&package_id=228298& release_id=580991 - the Nice Windows Version is forthcoming.
02:46
<@McMartin>
If someone with, say, a PPC Mac Running Tiger wants to try out the dmg to make sure the thing runs, that would be all kinds of awesome.
02:58
<@McMartin>
http://www.inform-fiction.org/I7/About%20IF%20-%20Anthology.html has a bunch of files you can point it at (well, put them in a directory and point it at). The Plotkin ones generally don't have cover art, though.
04:02 Vornicus [~vorn@Admin.Nightstar.Net] has joined #code
04:03 * McMartin points Vorn at http://downloads.sourceforge.net/blorple/blorple-0.2-macosx.dmg?use_mirror=osdn
04:03 Vornicus is now known as NSGuest-5343
04:03
<@McMartin>
Since I'm not actually sure if Tiger's inherent version of Java is up to snuff, so it would be nice to have independent confirmation.
04:04 NSGuest-5343 is now known as Vornicus
04:24 * Vornicus downloads accordingly.
04:25 * McMartin also learns about SF.net's automatic platform detection.
04:25
<@McMartin>
That's pretty sweet.
04:25
< Vornicus>
okay, looks like it works.
04:25
<@McMartin>
Awesome, thanks.
04:40
<@McMartin>
Blorple 0.2 is thus now officially released! http://blorple.sourceforge.net/
04:42
< Vornicus>
Wootcake
04:47
<@McMartin>
Also, for the record, launch4j is a wonderful application.
04:48
<@McMartin>
Adds 21kb to your .jar file, but turns it into an .exe that is guaranteed to be click-and-run, and more importantly, it can also carry icons and such that the OS will know about.
04:54 Vornicus [~vorn@ServicesOp.Nightstar.Net] has quit [Ping Timeout]
04:55 Vornicus [~vorn@ServicesOp.Nightstar.Net] has joined #code
04:55 mode/#code [+o Vornicus] by ChanServ
05:51 You're now known as TheWatcher[T-2]
05:54 Vornicus is now known as Vornicus-Latens
05:54 You're now known as TheWatcher[zZzZ
05:54 You're now known as TheWatcher[zZzZ]
06:10 GeekSoldier|bed is now known as GeekSoldier
06:10 GeekSoldier [~Rob@91.18.78.ns-3991] has quit [Quit: Off to the field]
09:05 Netsplit DeepThought.NY.US.Nightstar.Net <-> Blargh.CA.US.Nightstar.Net quits: @Serah
09:05 Netsplit over, joins: Serah
09:05 ServerMode/#code [+o Serah] by Blargh.CA.US.Nightstar.Net
09:05 mode/#code [-o Serah] by ChanServ
09:10 Netsplit DeepThought.NY.US.Nightstar.Net <-> Blargh.CA.US.Nightstar.Net quits: Serah
09:14 Netsplit over, joins: Serah
09:14 ServerMode/#code [+o Serah] by Blargh.CA.US.Nightstar.Net
09:14 mode/#code [-o Serah] by ChanServ
09:15 Netsplit DeepThought.NY.US.Nightstar.Net <-> Blargh.CA.US.Nightstar.Net quits: Serah
09:19 Netsplit over, joins: Serah
09:19 ServerMode/#code [+o Serah] by Blargh.CA.US.Nightstar.Net
09:19 mode/#code [-o Serah] by ChanServ
09:22 Netsplit DeepThought.NY.US.Nightstar.Net <-> Blargh.CA.US.Nightstar.Net quits: Serah
09:24 Netsplit over, joins: Serah
10:09 Vornicus-Latens [~vorn@ServicesOp.Nightstar.Net] has quit [Ping Timeout]
10:51 You're now known as TheWatcher
11:05 AnnoDomini [AnnoDomini@83.21.28.ns-3498] has joined #Code
11:05 mode/#code [+o AnnoDomini] by ChanServ
13:05 AnnoDomini [AnnoDomini@83.21.28.ns-3498] has quit [Ping Timeout]
13:12 AnnoDomini [AnnoDomini@83.21.68.ns-4057] has joined #Code
13:12 mode/#code [+o AnnoDomini] by ChanServ
13:22
<@AnnoDomini>
Anyone here work with BIOS interrupts? I'm trying to redefine a character, and find the documentation entry for the 10,11 interrupt confusing.
13:37
<@AnnoDomini>
Nevermind! Making a gamble, putting zeros where I wasn't sure what to put seems to have worked.
13:37 gnolam [lenin@Nightstar-10613.8.5.253.static.se.wasadata.net] has joined #Code
13:37 mode/#code [+o gnolam] by ChanServ
14:07
<@AnnoDomini>
Hm... Where could I find 16 byte representations of the base DOS characters?
14:08
<@gnolam>
16 byte representations?
14:09
<@AnnoDomini>
A definition of what they look like, each 8 pixel line being represented by a byte.
14:11
<@AnnoDomini>
A tip-downwards triangle looks like "00,00,00,254,254,254,254,7CH,7CH,7CH,7CH,38H,38H,38H,38H,10H".
14:19
<@gnolam>
http://www.ctyme.com/cgi-swish/intr.cgi?query=font&submit=Search%21&metaname=swi shdefault&sort=swishrank&dr_o=12&dr_s_mon=3&dr_s_day=2&dr_s_year=2008&dr_e_mon=3 &dr_e_day=2&dr_e_year=2008
14:26 AnnoDomini [AnnoDomini@83.21.68.ns-4057] has quit [Ping Timeout]
14:33 AnnoDomini [AnnoDomini@83.21.68.ns-4057] has joined #Code
14:33 mode/#code [+o AnnoDomini] by ChanServ
14:33
<@AnnoDomini>
gnolam: How is this supposed to help me?
14:38 * AnnoDomini is specifically looking for a way to restore default fonts.
14:39
<@AnnoDomini>
But the damned documentation very clear isn't.
17:02 Vornotron [~vorn@Admin.Nightstar.Net] has joined #code
17:33 You're now known as TheWatcher[afk]
18:36 Vornotron [~vorn@Admin.Nightstar.Net] has quit [Connection reset by peer]
18:39 Vornotron [~vorn@Admin.Nightstar.Net] has joined #code
19:02 You're now known as TheWatcher
19:04 Mango [~Mango@24.86.9.ns-26788] has joined #code
19:04
< Mango>
Hello. Can someone explain to me why running a nested query takes so much longer than running two queries individually, one after the other?
19:04
< Mango>
SELECT * FROM `table` - .0010 sec
19:04
< Mango>
SELECT DISTINCT `id` FROM `table2` - .0006 sec
19:04
< Mango>
SELECT * FROM `table` WHERE `id` IN (SELECT DISTINCT `id` FROM `table2`) - 1 min 46 sec.
19:04
< Mango>
`id` is the primary key on both tables
19:05
<@jerith>
Because it runs the inner query for every row in the outer.
19:06
< Mango>
that was my guess. but...but...but...why?!?
19:06
<@jerith>
You probably want something like "SELECT table.* FROM table JOIN table2 ON table.id = table2.id"
19:06 * Mango tries it
19:08
< Mango>
...by golly
19:08
< Mango>
less than a second
19:08
< Mango>
Thanks Jerith :)
19:09 * Mango checks out section 12.2.8.11, "Rewriting Subqueries as Joins"
19:58
<@jerith>
You can make it faster by indexing id on both tables. :-)
19:58
< Mango>
already done ;)
20:00
< Mango>
Here's a follow-up question.
20:01
< Mango>
Can a time limit be set on MySQL queries? i.e. anything more than, say, 10 sec gets killed?
20:13
< Mango>
that's curious.
20:13
< Mango>
I did set_time_limit(10); in the php script, and it went on for over a minute.
20:15
< Vornotron>
Did you do that before or after the query?
20:15
< Mango>
before.
20:15
< Mango>
it never actually timed out; I got bored and killed it :P
20:16
< Vornotron>
Suck.
20:22
<@jerith>
PHP ftl.
20:38 * Mango ponders.
21:04 Vornotron is now known as Finerty
21:08
<@AnnoDomini>
Damn. Assembly-generated programs are SMALL.
21:08
< Mango>
lol, really?
21:09
<@AnnoDomini>
400 B of code translated here into 800 B of exe.
21:09
< Mango>
wow.
21:18
<@Attilla>
:O
21:32
<@gnolam>
That reminds me to go buy an Atmel programmer.
21:57
<@gnolam>
(By which I mean I'll buy the physical thingamabob you program the chips with, not that I'm going to cruise the Bangalore code slave market)
23:41
<@McMartin>
Each line of assembler is one machine instruction.
23:42
<@McMartin>
On a RISC architecture, typically, Every Instruction is 4 Bytes Long.
23:42
<@McMartin>
And it generally varies from 1 to 8, tops.
23:43
< Finerty>
ARM is a risc system with four byte instructions and a two-byte "thumb" high-speed instruction set.
23:44
<@ToxicFrog>
Honestly I'm surprised the exe turned out as large as it did.
23:45
<@ToxicFrog>
For asm, I'd expect it to be smaller than the source.
23:47
<@AnnoDomini>
ToxicFrog: Disassembly reveals that there are many comments in the file.
23:47
<@AnnoDomini>
Or it's just the disassembler. I dunno.
23:50
<@ToxicFrog>
...
23:50
<@ToxicFrog>
That would be the disassembler; .text doesn't contain comments.
23:50
<@ToxicFrog>
Is this an actual EXE, or an object file or a .COM?
23:51
<@AnnoDomini>
EXE.
23:51
<@ToxicFrog>
Aah.
23:51
<@AnnoDomini>
The OBJ file is 300 B.
23:51
<@ToxicFrog>
That's more reasonable.
23:51
<@ToxicFrog>
EXEs contain lots of additional data.
23:52
<@AnnoDomini>
Hello world done as a COM goes from 146 B of code to 22 B of COM file.
23:54
<@ToxicFrog>
More than half of that being the string itself.
23:54
<@ToxicFrog>
I suspect it's at most three or four instructions, since it can do an interrupt for the actual display
23:55
<@AnnoDomini>
Four, including the RET.
--- Log closed Mon Mar 03 00:00:00 2008
code logs -> 2008 -> Sun, 02 Mar 2008< code.20080301.log - code.20080303.log >