Databases
MySQL Workbench 1.0.1 First Impressions
These are my first impressions of MySQL WorkBench 1.0.1. Rant and rave you may say, but a new user, or an experienced modeller would probably observe these points. Also, given that (with a poll?
Read moreTesting/Trialing new MySQL Releases
By now, I’m sure you have all heard about Free VMware Player allowing easy and quick access to see, view and use other OS’s easily. For those Windows users out there, now is your chance to trial MySQL under Linux with no impact to your system, why wait.
Read moreA working MySQL Workbench Under Linux
I must admit I’d given up trying to get MySQL Workbench working under Linux. I guess I’d spent at least 4 or 5 days full time at it, and it was just out of my league, with GTK and C++ errors.
Read moreFederated Syntax
I’ve never used Federated. I’m waiting for the JDBC version capabilities so I can connect to a non MySQL Server (specifically Oracle). In reading the docs, I see that the syntax includes a CONNECTION String.
Read moreBrisbane MySQL Users Group Meeting with Brian Aker
We had the privilege of Brian Aker Director of Architecture for MySQL speaking at the Brisbane MySQL Users Group this week (28 th Jan 2006). After the initial discussions on various topics, Brian got into his discussion on MySQL 5.
Read moreBuilding MySQL Workbench 1.0.1 for Linux (Part 2)
Following my earlier post of MySQL Workbench 1.0.1 for Linux and logging a MySQL Bug, I’ve had the Bug verified, and the a further update of a compiler success. Details of compile from Bug #16880
Read moreBlog/Wiki Spamming – What makes your blood boil
Well this is low. I’ve just been spammed on my Wiki . And it was cunning, I just found it by accident. An enterprising hacker embedded into my Home Page hidden links that were not visible via normal page view, but ultimately would be via a search bot or some other means.
Read moreMySQL Sakila Sample Application
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.
Read moreMySQL Workbench 1.0.1 for Linux
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.
Read moreDowngrading a MySQL schema from 5 to 4 (Part 2)
As requested by <a href=“http://mysqldatabaseadministration.blogspot.com/2006/01/downgrading-mysql-5-to-mysql-4.html" target=_blank”>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.
Read moreWhat makes your blood boil?
It’s appalling that in this day of technological advancements and communication, the excuse for publishing dated information just doesn’t fly. 50 or 100 years ago you could be excused for writing something that was 6 months out of date, yet this article “Which Database Is Right For You?
Read moreSequences in MySQL
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.
Read moreAdding to the Library Collection
In the past week I’ve added some more reading to my list, extended the library and hammered the credit card. Some of this has been in part to keep abreast of things as a result of being quizzed in job interviews.
Read moreTo enum or not to enum?
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.
Read more