Sometimes I see people having great difficulties in describing how to fetch data for a report.They are unable to reason by sets and tend to describe things in procedural terms.Here I'm posting a small example of how you can write a query that reproduces that procedural reasoning and lets the optimizer do the work of translating it into efficient SQL.Say someone has a table structure like this, a

Open Source means that the source code is open. There are many inferences that can be made from this, and many stereotypes that can be applied, but in the end, all it means is that you can read the source code as well as use the binaries. I am not a developer. I fully [...]

I attended the Sun Tech Days last week here in Sydney, Australia with a number of objectives in mind. The first was to meet up with people I knew in Sun to see how the newly confirmed merger was working here in Australia and also to see some of the talks scheduled, particularly the database related ones.

read more

I attended the Sun Tech Days last week here in Sydney, Australia with a number of objectives in mind. The first was to meet up with people I knew in Sun to see how the newly confirmed merger was working here in Australia and also to see some of the talks scheduled, particularly the database related ones.

read more

The March (pun!) continues. Bill Boebel, CTO of Mailtrust (Rackspace’s mail division), saw my previous announcement and asked me to present CouchDB as part of their Racklabs series and I happily agreed. This is a very cool opportunity to meet a bunch of very smart engineers; I am eager to go.

On Monday 17th (St. Patrick’s Day) at 6pm Eastern Time, we meet at Mailtrust’s office. See the announcement for directions and details. There will be pizza and beer afterwards. The talk is open …

The March (pun!) continues. Bill Boebel, CTO of Mailtrust (Rackspace’s mail division), saw my previous announcement and asked me to present CouchDB as part of their Racklabs series and I happily agreed. This is a very cool opportunity to meet a bunch of very smart engineers; I am eager to go.

On Monday 17th (St. Patrick’s Day) at 6pm Eastern Time, we meet at Mailtrust’s office. See the announcement for directions and details. There will be pizza and beer afterwards. The talk is open …

The FederateX Pluggable Storage Engine for MySQL, version 0.2 has been released! I've started to go through a list of bugs in Federated that need fixing, and for this version, I've fixed bug 30051.

The cause of this bug was due to the removal of "check_foreign_data_source" which used to check the connection and existence of the table being referenced in the federated connect string or server definition during "CREATE TABLE". Since then, a nice clean convenience method "real_connect" has been added. I simply modified it to take two arguments: a share, and a simple flag saying if the method call is the result of create table. Before I modified this method, the class share was being used which is made available though the call of "get_share". However, when "CREATE TABLE" is called (ha_federatedx::create), get_share hasn't been called, hence …

Back when I was doing a lot of work with Oracle, I learned to lean heavily on the SYSTEM views - Oracle’s equivalent to the INFORMATION_SCHEMA database. These views can really help you when it comes to writing dynamic SQL in stored procedures, or just taking quick shortcuts while you’re writing code. Or, if you’re [...]

The March (pun!) continues. Bill Boebel, CTO of Mailtrust (Rackspace’s mail division), saw my previous announcement and asked me to present CouchDB as part of their Racklabs series and I happily agreed. This is a very cool opportunity to meet a bunch of very smart engineers; I am eager to go.

On Monday 17th (St. Patrick’s Day) at 6pm Eastern Time, we meet at Mailtrust’s office. See the announcement for directions and details. There will be pizza and beer afterwards. The talk is open …

I wrote a User-Defined Function that implements the FNV (Fowler-Voll-No) hash function for MySQL. I’m not the first person to do this – in fact, I was inspired by the Google patches for MySQL. But my implementation is a little bit different from most, in a very important way that leads directly to much higher performance, especially suited for the Maatkit tools. A bit of background: FNV hashing is a very fast hash algorithm that operates in fixed memory.