MySQL Proxy got a bunch of changes in the svn-repo over the last weeks. Most of the important changes are in and we are working on making it a good 0.7.0 release.

The important changes are:

• script cache to improve the proxy performance
• central low-level decoding + lua wrappers
• plugins for proxy, admin and debug
• admin plugin is now lua based (more flexible)
• improved test coverage
• close a connection where we did throw a assertion before

Script Cache

In 0.7.0 we added a script-cache to only reload a script when it has changed and use a byte-cached version of it if it is unchanged.

This speeds up all script functionality quite nicely. No extra compile step as we did in 0.6.x when a connection was opened.

Plugins

We moved the proxy functionality into a plugin that can be loaded at startup as needed. We have at …

Hooray! The MySQL reference manual has a new search system. It now uses a Google Appliance and the results should be a lot better. The old system was not very helpful. It used to break config variables into multiple words and search on them individually and give a billion results I didn’t care about. I’ve just tried to search for some things like key_buffer_size and got results I think are very useful.

I love the MySQL manual. It is a great example of quality software documentation. As someone recently mentioned, it is not released under a Free license though — that would be a great improvement, too!

When did this change happen, by the way? Maybe it’s been there for a while and I just missed it because I grew accustomed to using Google search instead.

Edit: I actually would suggest a …

PDO_MYSQLND is in the PHP CVS repository at php.net: PDO_MYSQL has been patched (PHP 5.3, PHP 6.0). Try out PDO_MYSQL with the MySQL native driver for PHP (mysqlnd). Its has new features.

Since Kaj’s announcement of the MySQL native driver for PHP (mysqlnd), we promised to to patch all three PHP MySQL extensions (ext/mysql, ext/mysqli and PDO_MYSQL) optionally support it. Almost exactly a year ago, on July 27th 2007, mysqlnd and updated versions of ext/mysql and ext/mysqli have been …

PDO_MYSQLND is in the PHP CVS repository at php.net: PDO_MYSQL has been patched (PHP 5.3, PHP 6.0). Try out PDO_MYSQL with the MySQL native driver for PHP (mysqlnd). Its has new features.

Since Kaj’s announcement of the MySQL native driver for PHP (mysqlnd), we promised to to patch all three PHP MySQL extensions (ext/mysql, ext/mysqli and PDO_MYSQL) optionally support it. Almost exactly a year ago, on July 27th 2007, mysqlnd and updated versions of ext/mysql and ext/mysqli have been …

PDO_MYSQLND is in the PHP CVS repository at php.net: PDO_MYSQL has been patched (PHP 5.3, PHP 6.0). Try out PDO_MYSQL with the MySQL native driver for PHP (mysqlnd). Its has new features.

Since Kaj’s announcement of the MySQL native driver for PHP (mysqlnd), we promised to to patch all three PHP MySQL extensions (ext/mysql, ext/mysqli and PDO_MYSQL) optionally support it. Almost exactly a year ago, on July 27th 2007, mysqlnd and updated versions of ext/mysql and ext/mysqli have been …

I had a great time at O'Reilly's 10th annual Open Source Convention aka OSCON08.  I will post later about the conference itself including the podcasts I did, the announcements we made etc.  For now, here are some pics I took from the Sun Zend bash that was held in the Double Tree parking lot (which actually isn't used as a parking lot).

Above -- Row 1: (L) Tim Bray all dressed up with no place to go; (R) …

I had a great time at O'Reilly's 10th annual Open Source Convention aka OSCON08.  I will post later about the conference itself including the podcasts I did, the announcements we made etc.  For now, here are some pics I took from the Sun Zend bash that was held in the Double Tree parking lot (which actually isn't used as a parking lot).

Above -- Row 1: (L) Tim Bray all dressed up with no place to go; (R) …

I got to actually speak to Brian Aker for maybe a total of 5 minutes after his micro-presentation about Drizzle, which took place at the Sun booth at OSCON 2008. I was a bit nervous to ask what questions I had out loud, because the things I had wondered about were things I really didn’t see too much discussion about out in the intarweb. I’m happy to report that, if Brian Aker is to be considered any kind of authority (hint: he is), my ideas are not completely ridiculous, so maybe I’ll start talking a bit more about them.

UPDATE: lest anyone get the wrong idea, Brian Aker did, in fact, state that views are not on the short list of priority items for Drizzle, but he did say that views are one of the features he finds most useful, and that they’d probably be higher on any future priority list than, say, …

The organizers of OSDC::Israel::2009 have asked me to help them find sponsors for their event.

The Open Source Developers' Conference in Israel, 2009 is planned to be a low-cost three-day muliple track conference held somewhere in Israel. The conference will be held in the beginning of 2009. Exact dates and location will be announced later on our mailing lists.

The conference theme is Open Source Tools with an emphasis on Test Automation and Quality Assurance. The talks presented at the conference will be about practical uses of Perl, Python, PHP, Ruby and some other languages and technologies.

I am particularly intrigued by the idea of the …

So I'm back from OSCON 2008. As usually it is fun conference to attend. Though I could only come for couple of days (Wed/Thu) as things are too busy here.

Same as previous year I would note the conference is not as much backend and high performance focused as MySQL Conference or even Velocity, though this year there are number of interesting talks for example about Hypertable and lucidDB.

Honestly I could visit less talks than I wanted because I had too many things to do - talk to bunch of people, staff Sphinx .ORG booth (Andrew could not come so that was on me).

Sphinx both turned out …