SQL in easy steps, 3rd Edition errata

I was reading through SQL in easy steps, 3rd Edition and made it to page 152 where it covered Sub-query calculated fields. It’s a fancy way of saying a SELECT statement within a SELECT statement, but isn’t that hard to grasp if you’re familiar with how variable interpolation works with Bash or similar shells.

My problem was understanding how even though a column wasn’t listed as one to be returned by SELECT it was seemingly returned as a byproduct of an ORDER BY statement. I couldn’t find this mentioned in any of the MySQL documentation or another MySQL book I have so I was getting pretty frustrated. I fired my MySQL this morning and opened up subquery-calc.sql and had a good laugh: The mental block I was having was due to an error in the book’s code that wasn’t present in the SQL file.

I fired off an errata report in the hopes that it will be correct in future printings so others won’t be as confused as I was.

Continue reading

Francis Glassborow’s homepage is offline

It probably comes as no surprise, but content gets shuffled about and at some point gets lost, misplaced or thrown away. I’m hoping this isn’t a case of the latter, but Francis’ homepage is giving the dreaded 404 error when trying to view the resources page for his books.

Thankfully I’ve previously created a PDF of the errata page and have downloaded all material, but if you’re one of those who haven’t yet, please see these resources kindly provided by Jaime Moreno here and here. Of particular note is the link to building the fgw library on Mac OS X.

In addition, I have instructions for how to compile the library using Quincy 2005 (the book uses Quincy 2002) and the current MinGW here.

I hope this helps someone.

Edit:

Those instructions also provide a link to a public Subversion repository that contains revisions of the library from the book’s accompanying CD, the author’s website and from the publisher’s website for the book.

FREESCO Bootable CD

This is a continuation of the previous post

After a bit of cleanup, I’ve got section 1 of 5 of the FREESCO 0.2.7 Bootable CD guide moved to the new wiki here: http://wiki.whyaskwhy.org/GNU_Linux/FREESCO/.

Wow, talk about a walk back in time! I first started working with FREESCO about 10 years ago and I still see traffic in the web server logs from folks looking for the guide. After having it offline for several years where it collected dust with the rest of the website I took offline in late 2006, I decided I’d start resurrecting the content where others could find it.

Hope it helps someone.

404 entries: a subtle reminder to fix your links!

Often they’re just from bots banging on your box trying to find some software that can be exploited, but sometimes they’re also from content getting moved over the years and redirects never worked into the plan. Wikis have the right idea when you move something and they offer to leave a redirect behind so visitors can still find the content they’re looking for.

I used to give more weight to 404 entries, and I figure it’s probably time I did so again. With the recent move to MediaWiki and my finding it easy to work with, there is little reason aside from time that I can’t resurrect old site content and place it there.

I’ll start with an older guide I had to converting a default floppy-disk-based FREESCO 0.2.7 installation to a bootable CD. If I were to have one project that I’ve ever worked on that really brought me joy, it would be that one. The feeling as a newbie of overcoming the, “It can’t be done”, mentality was amazing.

Anyway, the new section for the FREESCO articles I posted years ago can be found here: http://wiki.whyaskwhy.org/GNU_Linux/FREESCO

Adding a new disk (LVM) to a VMware Workstation Ubuntu VM

Note: There is a newer version of this document here.


For all steps listed, I’m working with an Ubuntu 10.04 LTS virtual machine. It consists of a single disk (/dev/sda) that I didn’t size properly when I originally created the VM.

Later I added a second disk (/dev/sdb, independent of snapshots) to hold audio files from ripping cds prior to transferring to them to a player. I did not add this disk to the existing logical volume.

Now we’re going add a third disk (/dev/sdc) to the VM and place it in the same volume group as the original disk to help alleviate the space problem as shown here:

df -h

Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/ubuntu-root
                      7.3G  6.5G  487M  94% /
none                  245M  264K  244M   1% /dev
none                  249M  1.1M  248M   1% /dev/shm
none                  249M   92K  249M   1% /var/run
none                  249M     0  249M   0% /var/lock
none                  249M     0  249M   0% /lib/init/rw
/dev/sda1             236M   54M  170M  24% /boot
/dev/sdb1              30G  497M   30G   2% /media/bucket
.host:/                79G   68G   12G  86% /mnt/hgfs

Continue reading