MySQL
Building 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
Blog/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.
MySQL 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.
MySQL 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.
Downgrading 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.
What 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?
Sequences 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.
To 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.
Support for Technology Stacks
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.
Downgrading a MySQL schema from 5 to 4
Why oh why would you want to do this. Well it my case, I’ve committed to developing a web application using MySQL 5 features, knowing that I had to upgrade my production server from 4.
The challenges of compiling non working Open Source (Part 2)?
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).
The challenges of compiling non working Open Source?
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).
Database Modelling Software for MySQL
I’m stuck between a rock and a hard place. I’ve been using DBDesigner 4 from FabForce, an open source visual design tool, and apart from working around a number of bugs, I’ve found it practical to design from scratch.
How many installations, and just what are they doing?
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.