Looking At MySQL Again
I installed MySQL 5.0.x Community Edition the other
day to test something out and I have to admit that
I’m impressed with where the database has come since
the last time I looked at it (which was around
version 3!).
I installed everything on Mac OS X (Leopard) using
the standard Mac installer. I didn’t have any issues.
There are two other parts of the installation
package, a startup item installer allowing the db
server to start at startup and, a prefpane that
allows you to start/stop the server from System
Preferences.
MySQL has an optional package that installed the MySQL Administrator and MySQL Query Browser applications. It’s obvious from both of these tools that they’ve spent a lot of time and effort in making these tools usable and for the most part I was happy with their smoothness in Mac OS X. They definitely don’t feel like a port of Windows apps to Mac OS X. (Without using them in Windows I can’t tell you that the opposite is true or not, however.)
The REALbasic MySQL Plugin now available from Alacatia Labs at http://alacatialabs.com/products/realbasic-mysql-plugin/ and works with the Community and Enterprise Edition. I had absolutely no problems connecting to my newly installed database (after adding a new db and user using the Administrator tool).
If it weren’t for the stupid licensing issues that accompany MySQL I’d recommend it for everyday use. Alas, the licensing issues make that problematic. From the Alactia Labs website:
It allows access to community installations of MySQL database servers using REALbasic's built-in database API. While we are not lawyers, our interpretation of the GPL is that it is viral, and any applications that are distributed publicly must also contain the source code of the application and plugin. If you are in doubt about how the GPL applies to you, please consult your attorney.
Emphasis added by me.
That sucks because I think they’ve got some things going for it. I know a lot of RB developers have stopped using MySQL due to the GPL licensing rules and I can’t say that I blame them. Oh well, I guess it’s time to look at PostgreSQL or maybe MS SQL Server.
MySQL has an optional package that installed the MySQL Administrator and MySQL Query Browser applications. It’s obvious from both of these tools that they’ve spent a lot of time and effort in making these tools usable and for the most part I was happy with their smoothness in Mac OS X. They definitely don’t feel like a port of Windows apps to Mac OS X. (Without using them in Windows I can’t tell you that the opposite is true or not, however.)
The REALbasic MySQL Plugin now available from Alacatia Labs at http://alacatialabs.com/products/realbasic-mysql-plugin/ and works with the Community and Enterprise Edition. I had absolutely no problems connecting to my newly installed database (after adding a new db and user using the Administrator tool).
If it weren’t for the stupid licensing issues that accompany MySQL I’d recommend it for everyday use. Alas, the licensing issues make that problematic. From the Alactia Labs website:
It allows access to community installations of MySQL database servers using REALbasic's built-in database API. While we are not lawyers, our interpretation of the GPL is that it is viral, and any applications that are distributed publicly must also contain the source code of the application and plugin. If you are in doubt about how the GPL applies to you, please consult your attorney.
Emphasis added by me.
That sucks because I think they’ve got some things going for it. I know a lot of RB developers have stopped using MySQL due to the GPL licensing rules and I can’t say that I blame them. Oh well, I guess it’s time to look at PostgreSQL or maybe MS SQL Server.