Being quite tied up in my daily job, I totally missed the that Oracle has been developing a database application development tool, SQL Developer. In fact, this tool was previously known as "project Raptor" and has now matured to version 1.1. The -to me- interesting news is that:

• 
  
• It's free of charge.
  
• It runs on Linux, Mac OS/X and Windows
  
• Besides the Oracle database, it also supports other databases, including MySQL
  

Ok - I know all free software adepts will probably have left by now for three reasons, being that the title of this blog entry contains "Oracle", the tool is "free as in beer" and of course because the tool runs on Microsoft Windows. But let's not be distracted. Let's …

I just want to write few tips how to get MySQL from development BitKeeper tree, as there are several tricks.
First of all you need a fresh free client - bk-client2.0 http://www.bitkeeper.com/Hosted.Downloading.html .
Once you get it, you can clone latest tree:
bkf clone bk://mysql.bkbits.net/mysql-5.0 mysql-5.0

New client supports "changes" command, so you can look latest changes
bkf changes in mysql-5.0 directory.
It may be useful to get sources related to specific release. MySQL build team marks tree by TAG
with each new release. What I have looking by existing TAGS:

bkf changes | grep TAG
TAG: clone-5.0.32-build
TAG: mysql-5.0.30
TAG: clone-5.0.30-build
TAG: mysql-4.1.22
TAG: clone-4.1.22-build
TAG: mysql-5.0.28
TAG: mysql-5.0.27
TAG: …

For those that attended the MySQL Camp at Google HQ late last year you may have seen me with my own T-Shirt designs. A number of people inquired about getting them. I’ve finally got around to make them available online, so anybody that would like one can order online.

There are two different shirts. If you want your name on the shirt, you need to make sure you choose the correct one.

• Early Adopters - For those that were the first 48 that signed up, your name as well as position and company are on the shirt.
• The Herd - For everybody that registered on the website, your name is on the shirt.

Ok. I’ve …

As has been pointed out, there is a new version (2.0) of the free BitKeeper client, and furthermore the old one (version 1.1) appears not to work anymore. At first I suspected my daughter's hogging of available bandwidth as the culprit when all of my daily pulls of MySQL source trees failed, but that soon proved not to be the case. I am once again pulling source code successfully.

ZRM for MySQL users manual has been rewritten based on user feedback. It is available at ZRM for MySQL wiki

Thanks to everyone who provided feedback. User contributions to the manual are welcome.

In both Sql Server and Oracle, permission changes to a user take into effect right away, even when said user is connected at the time you made the change.

In MySql, it is a little different, depending on how the permissions are given. If you use the GRANT statement, then it takes into effect right away. However, if you create user and give it permissions by manipulating the user table in the mysql system database directly, that is, using Sql statements, then you need to issue:

flush privileges

for those changes to be picked up.

For those who have been asking me about downloading Falcon (or any development tree), Bitmover has posted a new free client on their website:

http://www.bitkeeper.com/Hosted.Downloading.html

To download the falcon tree grab the client and then do the following to grab the falcon source:

bkf clone bk://mysql.bkbits.net:8080/mysql-5.2-falcon mysql-5.2-falcon

The BUILD directory has a number of our build scripts in it that we use to build binaries, so you may want to consider looking in the directory and executing the appropriate script ( I use compile-amd64- debug-falcon).

After I published my article on how to build MySQL with the new Falcon storage engine from source, the free BitKeeper client was updated to version 2.0. I have now updated the instructions accordingly, our manual has been updated to reflect these changes, too.

However, it is currently still not possible to clone the Falcon tree with this client, some kind of obscure locking error message appears, even though the admin console on bkbits.net does not reveal any active locks in the repository:

$ bkf clone bk:// …

After I published my article on how to build MySQL with the new Falcon storage engine from source, the free BitKeeper client was updated to version 2.0. I have now updated the instructions accordingly, our manual has been updated to reflect these changes, too.

However, it is currently still not possible to clone the Falcon tree with this client, some kind of obscure locking error message appears, even though the admin console on bkbits.net does not reveal any active locks in the repository:

$ bkf clone bk:// …

Now that the source tree for the new Falcon Storage Engine is finally public, here's a quick HOWTO on how to compile the server from source. This procedure is described in more detail in the MySQL Manual. I assume you use Linux and have the required development toolchain installed.

You first should get the free BK client from http://www.bitmover.com/bk-client2.0.shar, unpack and install it:

$ wget http://www.bitmover.com/bk-client2.0.shar
--17:34:34--   …