I’m sure you are all aware by now of Mike Hillyer’s MySQL Sakila Sample Database that will be launched at the MySQL Conference. We now have an official MySQL Forum for this as well.

As part of leveraging this existing database, and using this for the basis of my MySQL Conference presentation on MySQL for Oracle Developers, I’ve released the first version of my MySQL Sakila Sample Application at http://sakila.arabx.com.au which I would very much like some feedback on. Please use the official …

Just released at the MySQL Forums yesterday an updated source version of MySQL Workbench for Linux available at ftp://ftp.mysql.com/pub/mysql/download/mysql-workbench-1.0.1.tar.gz.

So can Version 1.0.1 compile when I had no success with compiling 1.0.0?


$ su -
$ cd /src
$ wget ftp://ftp.mysql.com/pub/mysql/download/mysql-workbench-1.0.1.tar.gz
$ tar xvfz mysql-workbench-1.0.1.tar.gz
$ cd mysql-workbench-1.0.1
$ cd mysql-gui-common
$ ./configure --enable-grt --enable-canvas
$ make
MySQLGRT/MGRTValueTree.cc:255: instantiated from here
/usr/include/sigc++-2.0/sigc++/adaptors/bound_argument.h:158: error: 'const …

As requested by Frank, here are the working parts of my earlier Downgrading a MySQL schema from 5 to 4 article.

The Problem

To recap, I received a MySQL Version 5.0 schema via a sql file, however I was unable to upgrade from MySQL 4.0 to MySQL 5.0 on my old RedHat 7.3 production server. As an interim solution, I still wanted the schema and data to allow for initial development (without the 5 specific features including Views,Triggers and Procedures/Functions). However the MySQL 5.0 SQL file would not run in MySQL 4.0.

Sample

Here is a small subset of the MySQL Sakila Sample Database schema to demonstrate the problem.

DROP SCHEMA IF EXISTS sakila;
CREATE …

One piece of SQL functionality that doesn’t appear to have any consistency or an ANSI SQL Standard is the management of system generated sequential numbers, used for example in suggorate keys.

MySQL uses AUTO_INCREMENT which serves the purposes adequately, however in my documenting of differences with Oracle in my upcoming MySQL Conference presentation “MySQL for Oracle Developers” there a number of key differences with Oracle’s SEQUENCE usage.

MySQL AUTO_INCREMENT to Oracle SEQUENCE Differences

• AUTO_INCREMENT is limited to one column per table
• AUTO_INCREMENT must be assigned to a specific table.column (not allowing multi table use) …

Just a friendly reminder. The Columbus area MySQL User Group Meetup is scheduled for Thursday, February 2nd. I will be there and would love to see as many local MySQlers as possible! Also, I'll be going to the PHP User Group meetup on Thursday, February 9th. Hope to see you there!

Peter Zaitsev, a Senior Performance Engineer at MySQL, recently let me know about Andrew Aksyonoff, an open source developer who has written a high performance FULLTEXT indexer and query engine called Sphinx. While not (yet!) a pluggable MySQl storage engine, Sphinx does include native support for querying MySQL databases. A while back, Peter blogged about Sphinx. I'm extremely impressed with Sphinx's performance characteristics, and I'll be interviewing Andrew sometime in this coming week, so look out for the interview on the MySQL Developer Zone. I'm very interested to hear Andrew's thoughts on the new MySQL 5.1 Pluggable Storage Engine Architecture and how he …

Another excellent conference of note: the EclipseCon 2006, from March 20th through 23rd, will be held in Santa Clara. Those of you Java-ites out there using MySQL, be sure to check out the speakers and possibly submit a proposal for a presentation. Hopefully, at least one MySQL staff member will be in attendance; I'll let everyone know when I hear who that might be.

BTW, one keynote speaker you shouldn't miss is Joel Spolsky. He's been in the industry for many years (at Microsoft, Juno, and more) and now heads Fog Creek Software. He's also the author of quite a few books, some under Apress, which …

The New York City PHP Conference and Expo 2006 today opened it's call for papers. All you in the community out there, I will probably be attending this conference, so if you're in the area, be sure to stay tuned. If you are a MySQL user with some cool ideas or projects (especially ones featuring MySQL 5's newest features), please submit a presentation proposal highlighting your area of expertise. I'll be doing the same.

Some nifty ideas I think might be great presentation material:

• Exploring the mysqli API interface -- How to migrate and use the newest MySQL 5 features
• Encapsulating MySQL Data Access using Object Oriented programming practices (including PDO for PHP5)
• Demonstrating PHP5/MySQL5 simple AJAX applications

Just some thoughts. Let me know your ideas, …

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 …

UPDATED (Had to fix some inaccuracies)

And I thought we had grown out of this....

Part of today's SDForum Open Source in the Enterprise executive summit involved some furious debate on where open source is going. I had the interesting luck to sit at a table with John Roberts (CEO, SugarCRM), Mary Coleman (Managing Partner with Walden International, a smart and active (and savvy) open source investor), and representatives from two of software's biggest proprietary vendors, among others.

It's [one of] these last two who surprised me with a willful disregard for facts about open source adoption. I'm actually used to an increasingly sophisticated view of open source from both companies, but what I heard today was an embarrassment to [one of their employers].

It was …