I’ve never used database columns that embedded defined valid values within the schema definition. Within MySQL there are 2 definitions, ENUM and SET. There are a few reasons why, but first an explanation of these data types.

In summary, using the MySQL Sample Database.

CREATE TABLE film (
film_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
...
rating ENUM('G','PG','PG-13','R','NC-17') DEFAULT 'G',
special_features SET('Trailers','Commentaries','Deleted Scenes','Behind the Scenes') DEFAULT NULL,
PRIMARY KEY (film_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;


So from this, the following commands allow you to inspect this information via mysql.

…

As part of my next conference presentation Overcoming the Challenges of Establishing Service and Support Channels I’ve been struggling to find with my professional sources, any quality organisations that provide full support for a technology stack, for example a LAMP stack, or a Java Servlet stack.

Restricted to searching via online, I’ve been impressed by what I’ve found at Spike Source www.spikesource.com. An organisation with an experienced CEO, well known in the Java Industry. They certainly have all the buzz words covered in their product information.

Benefits of their SpikeSource Core Stack.

• Fully tested and certified
• Installs in minutes with integrated …

Did I push to much in my last post? I don’t think so, but I guess it’s a fragile balance sometimes in Open Source between those keen end users, and the developers that do give so much towards their own creations (I understand, I’m in that category myself).

I was very proud of my work yesterday, it took a whole day of my time (I do have better things to do, like finish my own Open Source project HTMLtags, while will allow me to build my sample application, which I can then use for my MySQL Users Conference presentation). I learnt to dig around the net a lot, go on the wild goose chase several times, understand some more under the hoods of compiling, libraries and dependencies in the GTK world I would have otherwise not really cared about. But as I said, I got to a brick wall by the end, and it was dishearting.

It …

One of the great benefits of Open Source, it’s Free, and you can get great support, sometimes even from the developers directly (rather then 5 levels of paid customer support for a commercial product). One of the greatest banes of Open Source, if you have a problem, and nobody has experienced and documented in a forum etc the problem you have with the same OS, libraries etc, you could be totally up the creek without a paddle, boat and for that matter water. (luckily you still have oxgyen)

Well, I’m having this problem with MySQL Workbench. A product promising so much, but if you can’t get the binary working on Linux to even start, where do you go.

You will see via the Forums, I’m not the only person. This is the current …

Would it not be great if on the MySQL website there was a page of stats (updated daily) that provided statistics like number of installations, a breakdown of versions registered (not certain I like that exact word) , OS’s, countries etc. More specifically, some useful stats on the engine types in practical use, avg number of tables per database etc. Of course the types of stats could be limitless, but with the success of MySQL as well as other open source projects, more imperial figures on installations other then just downloads I think would definitely benefit given the current momentum. (Availability of information to competitors could be both a good and bad thing.) Perhaps figures can be shown in percentages, not actual numbers.

Anyway, nice idea you say, we can all come up with ideas, but how could you implement something like this. …

In a recent job interview I was asked the question regarding Unit Testing/Automated Testing of a Database? An interesting question and indeed an interesting problem. I thought it was a good topic to describe what I’ve done in the past, and where I would go for a more complete testing environment given the opportunity of a entire XP project.

This is the approach I have implemented successfully in the past. It’s not a complete solution, however at the time with the client it provided appropriate coverage.

I don’t use a framework such as dbUnit to load data via XML, or specifically test data. XML is ugly to store data, and also with maintenance and comparison. I start with a pre-configured database of representative sample data, refer to my notes later on this, and then I use the tests of the application to perform the necessary data …

Ben Forta sent me a copy of his latest book: MySQL Crash Course a book based on his: Teach yourself SQL in 10 minutes book.

MySQL Crash Course is a concise guide (it's actually about the size of a novel, but 300 pages) to MySQL. I am a big fan of short and to the point books. Good job keeping it short Ben, I know you have written some hefty ones. ;)

The book doesn't focus on the system administration of MySQL, but rather the programming side of things - SQL.

I think this book would be great for someone who doesn't do a …

The Linux Format magazine is having it’s annual reader awards in a number of categories.

These include (I’ve include my picks after each category):

• Best Desktop Application (Gnome)
• Best Distro (CentOS 4.2)
• Best Development Tool (Eclipse 3.1)
• Best Hardware Support (NVidia for my Dell Laptop)
• Free Software Project of the Year (Gaim)
• Embedded Linux Award
• Best Server Software (MySQL 5.0)
• Best Office Software (Open Office …

Total cost of ownership (TCO) for relational databases is, in my opinion, comprised of 3 parts. License cost, support costs and the people costs of maintaining and managing the database.

The first component, database license cost, is a one-time fee paid to the vendor for the right to use the database on one processor. The license is generally perpetual, so youll need to work this out over the expected life time of the application or the time you’re going to continue to use database software. In some cases, if this money has already been spent, you might not include it in the TCO estimates.

Second, the ongoing support costs must be included. For Informix, DB2 and Oracle the support cost is usually a percentage (typically between 15% and 23%) of the initial license purchase price. In my experience it can range between $5k and $10K per CPU depending on which database you’re using and the initial purchase price for the licenses. …

MySQL V5.0 has been out for a while; it addresses most of the major objections people have had about “MySQL is not a ‘real’ database”. With support for XA transactions, triggers, stored procedures and support for views, i think MySQL has the feature set that will enable people to migrate to MySQL.

The only thing that’s still missing is resolution of the InnoDB storage engine problem, and some additional work to get on-line transactional backups if InnoDB goes away. I previously wrote a post about these issues; i’ll dredge it up and re-post it. Innobase is a problem because it’s (currently 12/28/2005) the only transactional storage engine, and since Oracle bought the company that owns InnoDB (Innobase Oy), it’s going to be a licensing challenge until the dust settles. InnoDB is the only choice for applications that require transactions.

As far as the choice of what database to select as a migration candidate, my first …