Good news, MySQL 5.1.26-rc has been released. From the release notes: “MySQL 5.1.26-rc is slated to be the last release candidate before we declare MySQL 5.1 as “production ready” (GA).”

If I were you, I’d start testing it out in environments that you’re planning to run MySQL in, or upgrade to 5.1 in. Feedback and testing to iron out issues, is important, so if you find a bug that affects you, report it!

In other news, on the Sun Developer Network (SDN) site, there’s a couple of resources such as the Python Developer Center and the Ruby Developer Center. At MySQL, we’ve got the DevZone, focusing on languages such as …

Changes as compared to version 6.56 include:

Features:

* New GRID design (’zebra’ Office 2007 style) for easier navigation.
* Multiple selection in GRIDs with SHIFT+CLICK.
* Improved Data Synchronization. Now typically 2-8 times faster than before depending on data. Option to generate a SQL sync script was added.
*  Drastically improved the speed of exports.
* New more user friendly design for the Schema Synchronisation (renamed from Structure Synchonisation). Various filter (’hide and ignore’) options were added. Also a long-running Schema Sync compare task can now be stopped.
*  Added automatic and manual update check.

Bug fixes:

* A backup script backing up all databases could fail to restore VIEWs referencing another database than the one where the VIEW was.
* Around 50 other small (mostly GUI-related) …

On Thursday, July 17 there will be a web based seminar on MySQL Workbench. 

Seminar will be in Italian and anyone who is interested is invited to join us. You can find details here.

If you are a database architect and you usually work with data models this tool is going to make your life easier and you will learn some interesting features. In the meantime, to better understand the product, take have a look at http://dev.mysql.com/workbench/, where you can download a copy of the community version, read blogs, contribute, discuss and learn.

Happy data-modeling!

On Thursday, July 17 there will be a web based seminar on MySQL Workbench.

Seminar will be in Italian and anyone who is interested is invited to join us. You can find details here.

If you are a database architect and you usually work with data models this tool is going to make your life easier and you will learn some interesting features. In the meantime, to better understand the product, take have a look at http://dev.mysql.com/workbench/, where you can download a copy of the community version, read blogs, contribute, discuss and learn.

Happy data-modeling!

…

Please help save Ivan, son of Andrii Nikitin (MySQL Support Engineer), who needs a bone marrow transplant. Andrii’s message is below:

“My family got bad news - doctors said allogenic bone marrow transplantation is the only chance for my son Ivan.

“8 months of heavy and expensive immune suppression brought some positive results so we hoped that recovering is just question of time.

“Ivan is very brave boy - not every human meets so much suffering during whole life, like Ivan already met in his 2,5 years. But long road is still in front of us to get full recover - we are ready to come it through.

“Ukrainian clinics have no technical possibility to do such complex operation, so we need 150-250K EUR for Israel or European or US clinic. The final decision will be made considering amount we able to find. Perhaps my family is able to get …

SQL proxies have been very much in the news lately, especially for open source databases. MySQL Proxy and PG-Pool are just two examples. Here is another proxy you should look at: Myosotis.

Myosotis is a 'native-client' to JDBC proxy for MySQL and PostgreSQL clients. We originally developed it to allow clients to attach to our Java-based middleware clusters without using a JDBC driver. Myosotis parses the native wire protocol request from the client, issues a corresponding JDBC call, and returns the results back to the client. As you can probably infer, it's written in Java. "Myosotis" incidentally is the scientific name for "Forget-Me-Not," a humble but strikingly beautiful …

Please help save Ivan, son of Andrii Nikitin (MySQL Support Engineer), who needs a bone marrow transplant. Andrii's message is below:

"My family got bad news - doctors said allogenic bone marrow transplantation is the only chance for my son Ivan.

"8 months of heavy and expensive immune suppression brought some positive results so we hoped that recovering is just question of time.

"Ivan is very brave boy - not every human meets so much suffering during whole life, like Ivan already met in his 2,5 years. But long road is still in front of us to get full recover - we are ready to come it through.

"Ukrainian clinics have no technical possibility to do such complex operation, so we need 150-250K EUR for Israel or European or US clinic. The final decision will be made considering amount we able to find. Perhaps my family is …

The two big developments in the SQL world this summer are the pending arrival of the SQL:2008 ANSI standard, and my (Peter Gulutzan’s) attendance on Sun’s behalf at an ANSI meeting. Okay, I concede that the events have unequal importance, but sometimes I slip in a bit about personal involvements.

What’s a standard?

Review: ANSI (which stands for “INCITS Technical Committee H2 on Database”), and its counterparts in many other countries, produce official standards for many things, including SQL. The international co-ordinating body is ISO (International Organization for Standards), so there’s an ANSI standard and an ISO standard, and they’re practically the same. There’s a partially-restricted site containing ISO papers here.

The current edition is ANSI/ISO SQL:2003. But SQL:2008 is only a few days or weeks away. I’m taking a risk here by …

On Thursday, July 17 there will be a web based seminar on MySQL Workbench. 

Seminar will be in Italian and anyone who is interested is invited to join us. You can find details here.

If you are a database architect and you usually work with data models this tool is going to make your life easier and you will learn some interesting features. In the meantime, to better understand the product, take have a look at http://dev.mysql.com/workbench/, where you can download a copy of the community version, read blogs, contribute, discuss and learn.

Happy data-modeling!

On Thursday, July 17 there will be a web based seminar on MySQL Workbench. 

Seminar will be in Italian and anyone who is interested is invited to join us. You can find details here.

If you are a database architect and you usually work with data models this tool is going to make your life easier and you will learn some interesting features. In the meantime, to better understand the product, take have a look at http://dev.mysql.com/workbench/, where you can download a copy of the community version, read blogs, contribute, discuss and learn.

Happy data-modeling!