This is a photo (taken by Lukas Smith using Marcus Boerger's camera - Marcus himself is actually in the photo ;-) from the event Kaj and I reported on earlier. Spot all the faces from the many different open source RDBMS in there!



We had a great exchange of ideas. Naturally, there are differences were each of us needs to follow their own path. However, we also have many things in common and so there is scope to work together. In my opinion, this is a sign of the maturity of our products, companies and projects. Kaj's message elaborates on this.

Personally, I had some …

This is a photo (taken by Lukas Smith using Marcus Boerger's camera - Marcus himself is actually in the photo ;-) from the event Kaj and I reported on earlier. Spot all the faces from the many different open source RDBMS in there!



We had a great exchange of ideas. Naturally, there are differences were each of us needs to follow their own path. However, we also have many things in common and so there is scope to work together. In my opinion, this is a sign of the maturity of our products, companies and projects. Kaj's message elaborates on this.

Personally, I had some …

MySQL AB today reported record interest in the newest version of its popular open source database. MySQL 5.0 has already been downloaded over one million times since its introduction on October 24.

I'm on a flight to LGW, and have had time to finish (yet another) Anthony Trollope novel - Dr. Whortle's School. I'm not sure what I'm going to do with myself once I've finished all 47 of Trollope's novels - I think I've read 45 or 46 of them already. It will be like closing off a great friendship. Trollope, like Mark Twain, is one of those people that I wish I could have shared a dinner with. He's so funny and sometimes acerbic in his analysis of the customs and attributes of his Victorian society.

One of which - the propensity to gossip and slander - he rebukes in Dr. Whortle's School (in reference to an unintentionally bigamous marriage of Mr. Peacocke, and the fall-out that ensues when the neighbors find out). Like any good book, …

mysql is looking for a north american mysql community relations manager. quality assurance engineer is another position available, and there are more listed on the website.

Arjen was mentioning about the perks of working at MySQL. It got me interested, so I joined them :) So I guess this is my change in affiliation announcement.

A timely photo from William, that I scanned in… (circa a couple of years back)

I don’t know if I can talk about what I do yet (I’m a Community Engineer). I already have a task on hand, but I guess there are meeting times to work out, and other stuff. I’m rather excited, and my drive (that was lost for a while) is back. I’m not leaving any mentioned project either, in fact I think my Fedora goodness should be stepped up, as will the OOo (db related) stuff.

Do you know a potential MySQL evangelist with a lot of passion for Open Source? Able to talk to key Open Source projects, understanding both technology and people issues? An outstanding track record in written skills — published articles in print and on the web, and perhaps even published a book or two? Excellent oral presentation skills, able to go to conferences, give talks and come back with a network even larger and more well-connected than before?

We describe the job in more detail in Jobs at MySQL AB.

Our current Community Relations team consists of (in chronological order of recruitment to the team) Arjen Lentz in Brisbane, Australia, Lenz Grimmer in Hamburg, Germany, myself in …

I just finished a couple day's work, documenting and adapting the 'rcall' (Remote Call) tool, and added it to the Mycat project on sourceforge. The readme is available here.

'rcall' is designed to run in non-homogeneous *nix clusters, to ease use of these clusters by creating a single place from which to securely run commands across logical groups of servers.

I'll give some examples.... The past two companies I have worked for both had separate web (apache) servers, mailing (MTA) servers, and database (MySQL) servers. Using rcall (its previous incarnation, that is), I was able to easily track down an error that was causing seemingly random entries in the databases to have wrong timestamps; `rcall -on web -C 'date'` would print the current date on each web server, making it easy to see …

In one of my latest postings I mentioned a way to create semi materialized views in MySQL. The problem was that the solution required a stored procedure for every materialized view. That's very annoying. So I looked for a more general and dynamic approach. The result is another stored procedure with 3 parameters:

• the name for the source table / view
• the primary key columns of the source table / view
• the desired name for the materialized view

Basically this procedure does the following:

• It drops the materialized view if it already exists
• It creates the materialized view with the structure and data of the source table
• It adds a primary key to the newly created materialized view

However the procedure does not create triggers on the table. This could be an improvement for a …

Several months ago I finished a series of articles on Visual Basic.NET and MySQL. I have decided to start a new series that will focus more on new features of MySQL 5 and Visual Basic 2005.

The first installment is up at this link and will hopefully be the start of a useful series.