Insights and outlooks on software development

S'true

Win-Alt keyswap under VMware Fusion

Friday, May 30, 2008 by Thomas L

Update: The process below is for Fusion 1.x. For 2.0 onward, see this post instead.

Recently I upgraded the OS on my Mac to Leopard instead of Tiger, and thus had to do a re-install of all of my programs. After re-installing VMware Fusion I noticed that the Win and Alt keys were swapped. To swap it back to the way everyone is used to it working in Windows, create a text file called config in ~/Library/Preferences/VMware Fusion/ and fill it with the following line:

mks.keyboard.swapAlt = TRUE

Ahh, much better.

Blog redesign

Sunday, May 18, 2008 by Thomas L

It's hard to have a nice looking and readable blog at the same time. My last design looked slightly bad, but had quite good readability. I hope the looks of this one will last a bit better. Scroll down to see the credits.

MySQL error when restoring large sets of data

Wednesday, May 14, 2008 by Thomas L

So there I was, humming along with doing some mysql administration, basically MySQL dump ('mysqldump -u username -p mydatabase table1 table2 > some_file.sql') and a restore ('mysql -u username -p someotherdatabase < some_file.sql'). Suddenly I got the error:

"ERROR 2006 (HY000) at line 123: MySQL server has gone away"

After some head-scratching and a couple of googlings, I found out that the crash happened since the inserts exceeded the max_allowed_packet size. The solution was to increase the max_allowed_packet from 1M to 16M, by editing my.ini for my MySQL installation.

This happened for a 4.1 MySQL instance; I don't know if it's fixed in later versions.

References:

http://bugs.mysql.com/bug.php?id=32543 (see post 7 Dec 2007 15:05)

See also http://dev.mysql.com/doc/refman/4.1/en/program-variables.html.

Jeremy nails it again

Thursday, May 1, 2008 by Thomas L

"Why are teams still writing persistence code by hand?  There's a bazillion persistence tools out there that all save development costs in some way over writing data access code by hand.  With very few exceptions, I'd say that at this point that if you're writing ADO.Net code or SQL by hand, you're stealing money from your employer. "

(From Jeremy D. Miller's blog, http://winforms.codebetter.com/blogs/jeremy.miller/archive/2008/04/30/a-train-of-thought-alt-net-seattle-edition.aspx)

Quite harshly put, but in my book it's very much true. Writing SQL by hand is basically throwing the hours away.