True to the words telling why I started this blog, I found some excellent, seemingly-taylor made advice a few minutes ago when I went looking for some help on enabling the InnoDB storage mechanism in my development MySQL server. The help came from My Digital Life in the form of clear instructions. Totally awesome!
Turns out, I'm using XAMPP which is a distribution from Apache and Friends (which sounds like a Saturday morning cartoon show - and should have been!) that bundles Apache, PHP, and MySQL. The problem is they don't enable the InnoDB storage engine by default. This was a downer because I'm a foreign key kind of guy. You can't do that with the MyISAM engine. However, you can't use full text indexes with InnoDB! So basically, what I'm hearing from the open source community, is that their super star product that's supposed to stack up against Microsoft SQL Server can't do all the things I'd ever want. Okay, I guess that's fair. I'd better say something nice, quickly, so that the open sourcies don't leave burning dog poo on my door step.
Recent Comments