For the intensely curious, these are the final results from DEV, DBA and Cluster certification examinations at the MySQL Conference 2007.

Progress slows this week. Got hung up on a few things.

Since last update:
- Fixed a ton of bugs.
- Got the state machine working. Supports only a subset of commands right now, but easily extended.
- Lua is used to establish listener connections
- Lua callback structure
- Planned lua API in more detail.

After a lot of thought I've come up with a simple lua "interface"


callback = {}

function got_new_client(c)
print "Got a new client! Yay!"
callback[c:id()] = {["Received Command"] = start_new_cmd, ["Waiting for Command"] = end_cmd}
end

function setup_listener(c)
callback[c:id()] = {["New Client"] = got_new_client}
end

myp.new_listener("127.0.0.1", 5500, setup_listener)

etc.

Calling myp.new_listener() is a C function to start a new bind …

Today I tried to add this little function to our impekkable List template:

template
inline
List::List(const List &rhs, MEM_ROOT *mem_root)
:base_list(rhs, mem_root)
{
/* Make a deep copy of each element */
List_iterator it(*this);
T *el;
while ((el= it++))
it.replace(new (mem_root) T(*el));
}

That is, for the referecne, the default copy constructor for List template is shallow.
So, I needed a _normal_ copy constructor. I don't want to rewrite the existing one -- it is used eveywhere (and don't ask me how one can make any sane use of a shallow copy constructor of a container - because all the usages are insane).
And here we go - this won't compile:

sql_list.h: In constructor ‘List::List(const List&, MEM_ROOT*) [with T = Item]’:
item.cc:6917: instantiated from here
sql_list.h:581: error: cannot …

This massive fix has been pushed into 5.1.19 and so far I cannot repeat any crashes!! Well done Ingo and reviewers ! My testing continues!

changing key_buffer_size on a running server can crash under load

Novell has done one amazingly thoughtless, short-sighted thing related to patents. Now it's apparently trying to rectify some of the damage it has done to open source. And it's doing it with a group that has an impeccable record on patent reform: the Electronic Frontier Foundation (EFF). This is a great move by Novell. I just wish that it would have done this before it sealed its deal with Microsoft. It might have thought better of that Faustian pact.... As Brian Proffitt reports:"EFF is partnering with Novell to try to get rid of software patents that are hurting innovation all... READ MORE

MySQL Connector/Net 5.1.1 a new version of the all-managed .NET driver for MySQL has been released.

This is a big release and represents a change in how we package our products. Until now, we've shipped our core provider and the Visual Studio integration bits as separate downloads. This has become a bit of a problem. Often we would fix a bug that involved changing code both in the VS package and in the core provider. This provided a versioning problem where users would need to upgrade both products to see the benefit of the bug fix. To solve this, we've decided to discontinue Tools for Visual Studio as a separate product and have, instead, integrated it into a new Connector/Net installer. We hope this provides a better "out of box" experience for our users.

All previous versions of Tools for Visual Studio should be uninstalled prior to installing this product.

Version 5.1.1 works with all …

mysqlconf, mysqlconf07, presentation video

For folks to know — to create the page with links to conference material, I took the slides from the O?Reilly official page, combines it with the myriad of ?here are my slides? posts to Planet MySQL, and links to Baron, Kevin and Mike?s audio and video as well as the video and audio I processed (Because Baron made statements about bandwidth, I downloaded the .ogg files and technocation.org is hosting them, whereas Kevin and Mike?s files are linked to).

I know I hate going to 20 places to find everything I want. There?s no need for folks to have to go to more than one site, just because the content …

This is a drawing for my ideas on the future of opentaps, namely:
1. A set of core opentaps ERP + CRM applications for transacting business day throughout the enterprise
2. Bringing in analytics and search tools
to help make better sense of the data
3. Integrating with devices of all stripes, for mobile phones to robots to shop floor machinery, and of course the desktop.
4. Pulling all of these components together into a unified front end.
5. Supporting it with documentation and context sensitive help.

The big unknowns are what that front end will be and how it will be developed. Would the user interface of the future be the desktop, the browser, a mobile phone, or something else entirely different? Or would there simply be more choice of how we interact with …

MySQL Connector/Net 5.1.1 a new version of the all-managed .NET driver for MySQL has been released.

This is a big release and represents a change in how we package our products. Until now, we've shipped our core provider and the Visual Studio integration bits as separate downloads. This has become a bit of a problem. Often we would fix a bug that involved changing code both in the VS package and in the core provider. This provided a versioning problem where users would need to upgrade both products to see the benefit of the bug fix. To solve this, we've decided to discontinue Tools for Visual Studio as a separate product and have, instead, integrated it into a new Connector/Net installer. We hope this provides a better "out of box" experience for our users.

All previous versions of Tools for Visual Studio should be uninstalled prior to installing this product.

Version 5.1.1 works with all …

On Saturday, June 16 2007, Ibuildings and Zend Technologies are organizing the Dutch PHP Conference 2007. The event is intended for professional PHP developers and will be held in the RAI in Amsterdam.

The program is mostly in English, offering about 15 speakers and three separate tracks: Frameworks, Case studies and a separate data-oriented/database track. I will be speaking there about MySQL stored routines, and how …