MySQL
If you don’t know your data, you don’t know your application.
The art of data modelling is definitely lost on some [most] people, or they never found it, even though they think they did. Over dinner with good friend Morgan last night we were swapping present stories on the topic.
Become named in Firefox 2
So, FireFox have come up with a novel idea to promote it’s product. Check out Firefox Day. The official blurb: Share Firefox with a friend. If your friend downloads Firefox before September 15, you’ll both be immortalized in Firefox 2.
Pride
I’ve recently completed a contract and I’ve been in discussions with agents and other employers for further work. Having had one of the worse experiences in my previous work, I’ve been extra careful to ensure what I’m told at the interview/meeting stage is indeed true and accurate (in my last case it was not).
Compiling MySQL Tutorial 2 – Directly from the source
Should you want to be on the bleeding edge, or in my case, don’t want to download 70MB each day in a daily snapshot (especially when I’m getting build errors), you can use Bit Keeper Free Bit Keeper Client that at least lets you download the MySQL Repository.
Compiling MySQL Tutorial 1 – The Baseline – Update
Just to confirm my earlier confusion about verified snapshots at Compiling MySQL Tutorial 1 – The Baseline . “Daily snapshot sources are only published, if they compiled successfully (using the BUILD/compile-pentium-debug-max script) and passed the test suite (using make test).
Compiling MySQL Tutorial 1 – The Baseline
Pre-requisites This tutorial is aimed at Linux installations that has the standard development tools already installed. The INSTALL file in the source archives provides good details of the software required (e.
MySQL Response to Bugs
I’ve read at times people complaining about the response to bugs, and people bag the support of MySQL on the forums at times. Well today I logged a bug, not the first and I’m sure it’s not the last.
Unexplained replication authentication behaviour
I’m playing with the latest 5.1.11 beta in a master/slave replication situation. Given a lack of H/W lying around I’m configuring a mixed H/W setup to leverage an existing office’s after hours CPUs running Windows XP for my slaves.
Mercurial Version Control Software
I got asked (being a Java developer) about what was involved in creating an Eclipse Plugin for Mercurial. Well in true Google style, why invent when somebody probably already has. A quick check finds Mercurial Eclipse by VecTrace.
What is software quality?
Greg Lehey wrote today Is MySQL getting buggier?. The underlying question of his comments is a more fundamental and passionate topic, and especially for me. That is “Software Quality”. The quintessential question is this.
Differences in syntax between mysql and mysqltest
As I wrote earlier in Using the MySQL Test Suite I found an issue with using the current MySQL Sakila Sample Database as a test with mysqltest. I was running an older version of 5.
Using PBXT 0.9.5
Paul has released Version 0.95 of his PBXT MySQL Transactional Storage Engine. Here is what I did to get it operational under CentOS 4.3. su - useradd pbxt su - pbxt wget http://www.
Using the MySQL Test Suite
MySQL provides two different tools to test the MySQL Server with SQL statements. One is mysqltest and in 5.1 mysqlslap. Both of these tools have quite different purposes. This is a quick review of the usage of mysqltest.
Using Cascade in Foreign Keys
For those that are using a Referential Integrity based Storage Engine in MySQL, the use of Foreign Keys can provide an extra level of data integrity within your application. There are of course caveats to this statement, such as correct design, proper transactional use etc, but that’s a topic for another time.