Since 2005, every year we have done some kind of "Mayflower weekend". As we're a bit of a distributed company (departments in Munich and Würzburg, called Herbipolis, several "on-site departments" at some of our biggest customers, an offshore department in beautiful Argentinia and since 2007 a sister company called SektionEins located at Cologne watching out for Web Security) it's always fun packing the crowd together and putting them into a hotel somewhere in Germany (or Barcelona, Spain in 2006 and Budapest, Hungary in 2007). If you followed Wolfram's blog you noticed that we also had some external guests (if you need a Dojo freelancer, I recommend hiring Wolfram although he's a Pythoneer ;-) ) alongside the camp. The event was located at the hotel …

One of the workshops on our Barcamp two weeks ago had to do with the MySQL-Proxy from Jan Kneschke.

Yet, we found out, that the proxy is rather unuseable for our task. Read here why.

Continue reading "Playing arround with the MySQL-Proxy on Mayflower-barcamp"

March 2008 will be a month of publicity for CouchDB. I will be giving a total of three presentations around the globe, the northern hemisphere, less then half of that, actually. Anyway.

March 1st, 2008 — Chemnitzer Linux Tage

As early as 9:00 a.m. on a Saturday morning, I’ll be giving the 45 minute version of my Next Generation Data Storage with CouchDB talk to a crowd of hopefully awake Linux enthusiasts. The conference is only 5€ (3€ for students), so be sure to show up! The presentation will be in German and so is the information page.

March 7th, 2008 — O’Reilly ETech — San Diego

This is a big one, and actually, they help sponsoring my flight to the US, so a big thanks upfront! In fact, this is a double session …

March 2008 will be a month of publicity for CouchDB. I will be giving a total of three presentations around the globe, the northern hemisphere, less then half of that, actually. Anyway.

March 1st, 2008 — Chemnitzer Linux Tage

As early as 9:00 a.m. on a Saturday morning, I’ll be giving the 45 minute version of my Next Generation Data Storage with CouchDB talk to a crowd of hopefully awake Linux enthusiasts. The conference is only 5€ (3€ for students), so be sure to show up! The presentation will be in German and so is the information page.

March 7th, 2008 — O’Reilly ETech — San Diego

This is a big one, and actually, they help sponsoring my flight to the US, so a big thanks upfront! In fact, this is a double session …

March 2008 will be a month of publicity for CouchDB. I will be giving a total of three presentations around the globe, the northern hemisphere, less then half of that, actually. Anyway.

March 1st, 2008 — Chemnitzer Linux Tage

As early as 9:00 a.m. on a Saturday morning, I’ll be giving the 45 minute version of my Next Generation Data Storage with CouchDB talk to a crowd of hopefully awake Linux enthusiasts. The conference is only 5€ (3€ for students), so be sure to show up! The presentation will be in German and so is the information page.

March 7th, 2008 — O’Reilly ETech — San Diego

This is a big one, and actually, they help sponsoring my flight to the US, so a big thanks upfront! In fact, this is a double session …

I’m following what ezComponents doing for sometime now.
Quite nice framework for whatever you need.
I gave a try to write a mysql schema sync.
Real easy to write. only 4-5 lines of code to sync schemas.
It would have been great if it was actually working. The outout sql ddl is not runnable in some cases (syntax errors). Or the order of the columns are different.
I’m sure they’ll fix it soon but this tells me they are not yet ready for production quality.

See the code below, maybe I’m doing something wrong.


<?php
require_once "ezcomponents/Base/src/base.php";

function __autoload( $className ){
ezcBase::autoload( $className );
}

$sourcedb['host']= isset($_POST['sourcedb']['host'])? $_POST['sourcedb']['host']:”;
$sourcedb['port']= …

Like in the years before, I (and some other colleagues from MySQL) will be attending FOSDEM 2008 in Brussels, Belgium on February 23rd and 24th.

The schedule is packed as usual and lists several MySQL-related topics and sessions:

• Main tracks: Unicoding With PHP 6 by Andrei Zmievski and the talk about CakePHP by Garrett J Woodworth are certainly relevant for web developers using PHP.
• Lightning …

Sun Microsystems has released Solaris Express Developer Edition 1/08, Sun's free OpenSolaris-based distribution targeted at developers.

This release brings together integrated web stack (Apache, MySQL, Ruby, Php, PostgreSQL), NetBeans 6.0, interoperability with Microsoft's CIFS protocol, support for virtual machines via Sun xVM hypervisor, based on  technology developed by the Xen community, Sun HPC ClusterTools based on the Open MPI effort.

There are …

Thanks to everyone who attended the performance coding webinar today. I think there were about 250 people online, which is a great turnout! Sorry for dropping off about fifteen minutes into the webinar — that'll teach me to use Skype for presenting!

There were a bunch of questions from attendees and I have tried to quote them and answer to the best of my knowledge below. They are in no particular order, and where possible, I refer to the slide where I think the question referred to. Happy tuning and coding!

Miscellaneous Questions Will MySQL Support Functional Indexes Soon?

This comes up every time! Not sure why...perhaps there's lots of Oracle and DB2 users also using MySQL and wanting to migrate to MySQL without changing schemas. In any case, the short answer is no, they won't. There is a Worklog task that describes the status of this feature …

As documented, the FLOAT datatype does not guarantee precise storage of decimal values. But where the non-precision is apparent can be a little confusing - take the following example:

mysql> CREATE TABLE my_table (a FLOAT);
Query OK, 0 rows affected (0.25 sec)

mysql> insert into my_table (a) VALUES ('2.2');
Query OK, 1 row affected (0.08 sec)

mysql> SELECT * FROM my_table WHERE a = 2.2;
Empty set (0.05 sec)

mysql> SELECT a, IFNULL(a,0) FROM my_table;
+------+-----------------+
| a    | IFNULL(a,0)     |
+------+-----------------+
|  2.2 | 2.2000000476837 | 
+------+-----------------+
1 row in set (0.00 sec)

mysql> SELECT a, a+0 FROM my_table;
+------+-----------------+
| a    | a+0             |
+------+-----------------+
|  2.2 | 2.2000000476837 | 
+------+-----------------+
1 row in set (0.00 sec)

Need precision? Try Decimal.