Databases
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).
Read moreCompiling 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.
Read moreMySQL 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.
Read moreUnexplained 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.
Read moreWhat is a BLOB?
If your answer was Binary Large Object, then you would be wrong. Check out Mike’s comments on History of Database Blobs from the man that created the BLOB, Mr Jim Starkey.
Read moreMercurial 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.
Read moreWhat 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.
Read moreDifferences 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.
Read moreUsing 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.
Read moreUsing 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.
Read moreUsing 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.
Read moreWhat constitutes a good error message to the user?
Today, will go down in my professional history as quite possibly the lowest I would ever think of a software developer. I’ve carefully avoided the term “fellow coder”, speaking of a IT industry sticking by fellow IT people, but not today.
Read moreMySQL Ideas
Seems I have over time, thought of many ideas, jotted some notes on some, and even done some work, but everybody knows that “home projects” can take a long time.
Read moreImproving Open Source Databases – WordPress
As part of both my UltimateLAMP side project, and my greater involvement with MySQL Workbench, I’ve been wanting to review and document the database schemas of Open Source products. Indeed, as part of discussions with Mike Zinner of MySQL AB at the recent MySQL Users Conference, I suggested an idea used in the Java World, for example by Clover and Agitar, where to promote the usefullness of their respective tools (in this case code coverage), they provide results against Open Source Products.
Read more