MySQL Workbench 5.2 GA

• Data Modeling

• Query

• Administration

Please get your copy from our Download site.

Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://dev.mysql.com/downloads/workbench/

Workbench Documentation can be found here.

http://dev.mysql.com/doc/workbench/en/index.html

Utilities Documentation can be found here.
http://dev.mysql.com/doc/workbench/en/mysql-utilities.html

In addition to the new Query/SQL Development and Administration
modules, version 5.2 features improved stability and performance –
especially in Windows, where OpenGL support has been enhanced and the UI
was optimized to offer better responsiveness.

This release also includes improvements to the scripting capabilities of the SQL Editor. You can read more about it in

http://wb.mysql.com/workbench/doc/

For a detailed list of resolved issues, see the change log.

If you need any additional info or help please get in touch with us.

Post in our forums or leave comments on our blog pages.

- The MySQL Workbench Team

•  Data Modeling
•  Query (replaces the old MySQL Query Browser)
•  Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://dev.mysql.com/downloads/workbench/

Workbench Documentation can be found here.

http://dev.mysql.com/doc/workbench/en/index.html

Utilities Documentation can be found here.
http://dev.mysql.com/doc/workbench/en/mysql-utilities.html

In addition to the new Query/SQL Development and Administration modules, version 5.2 features improved stability and performance – especially in Windows, where OpenGL support has been enhanced and the UI was optimized to offer better responsiveness. This release also includes improvements to the scripting capabilities of the SQL Editor. You can read more about it in

http://wb.mysql.com/workbench/doc/

For a detailed list of resolved issues, see the change log.

http://dev.mysql.com/doc/workbench/en/wb-change-history.html

If you need any additional info or help please get in touch with us.

Post in our forums, leave comments on our blog pages or if you want to talk to us directly you can visit us on our IRC channel #workbench onirc.freenode.net.

- The MySQL Workbench Team

Alfredo Kojima

MySQL Workbench 5.2 GA

• Data Modeling
• Query (replaces the old MySQL Query Browser)
• Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://dev.mysql.com/downloads/workbench/

Workbench Documentation can be found here.

http://dev.mysql.com/doc/workbench/en/index.html

In addition to the new Query/SQL Development and Administration modules, version 5.2 features improved stability and performance – especially in Windows, where OpenGL support has been enhanced and the UI was optimized to offer better responsiveness. This release also includes improvements to the scripting capabilities of the SQL Editor. You can read more about it in

http://wb.mysql.com/workbench/doc/

For a detailed list of resolved issues, see the change log.

http://dev.mysql.com/doc/workbench/en/wb-change-history.html

If you need any additional info or help please get in touch with us.
Post in our forums, leave comments on our blog pages or if you want to talk to us directly you can visit us on our IRC channel #workbench on irc.freenode.net.

- The MySQL Workbench Team

The MySQL Developer Tools team is announcing the next maintenance release of it’s flagship product, MySQL Workbench, version 5.2.37. 

This specific version was focused on improving usability of the Query Editor. Some of the changes introduced are:

• New, redesigned Query Editor layout. Output messages are always visible while resultsets and the query editor can be resized according to the task at hand. Resultsets are now in the same tab as their generating query editor.
• Several minor changes that make the difference for a frustration-free, comfortable use of the tool. Sidebar sizes, the last selected schema and other state information is now properly remembered between sessions. Keyboard navigation of resultsets has been fixed to properly handle Tab key navigation in all platforms.
• SELECT queries are now analyzed as in the old MySQL Query Browser tool and, if possible, its resultsets can be edited
• The schema tree now allows applying actions to multiple selected objects at once.
• The schema tree also shows more comprehensive information. In addition to schemas, tables, column, views and routines it also displays information about triggers, indexes and foreign keys. The object information box has been improved.
• A new plugin containing various utilities useful for generating directly usable PHP code from your queries. For example, you can generate code that will run a SELECT statement, with SQL injection-safe variable binding and resultset iteration, from a query being edited in the SQL editor.
• Export recordsets to XLS format files.

The Administrator was also improved in the following areas:

• Server Start and Shutdown page was updated to include server error log output
• The Log browser support was improved to support log files, when managing local servers

In addition, 82 bugs and feature requests have been fixed. A detailed list of closed bugs can be viewed at our Release Info Page.

We hope the included enhancements will make use of MySQL Workbench a lot more productive and fun. This effort is far from complete and the Workbench team will continue working on even more changes and additions to make Workbench the database tool of choice for users both advanced and inexperienced. We still have a lot of nice things in the oven, so keep an eye on new versions coming out!

Please get your copy from our Download site. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://www.mysql.com/downloads/workbench/

Workbench Documentation can be found here

http://dev.mysql.com/doc/workbench/en/index.html

In addition to the new Query/SQL Development and Administration modules, version 5.2 features improved stability and performance – especially in Windows, where OpenGL support has been enhanced and the UI was optimized to offer better responsiveness. This release also includes improvements to the scripting capabilities of the SQL Editor. You can read more about it in

http://mysqlworkbench.org/workbench/doc/

For a detailed list of resolved issues, see the change log.

http://dev.mysql.com/doc/workbench/en/wb-change-history.html

If you need any additional info or help please get in touch with us.

Post in our forums, leave comments on our blog pages or if you want to talk to us directly you can visit us on our IRC channel #workbench on irc.freenode.net.

- The MySQL Workbench Team

Redesigned Query Editor

• The log of executed commands and server responses is now always visible while resultset grids and the query editor can be resized according to your needs. Resultsets are also grouped in the same tab as the query editor that generated them.
• SELECT queries are now analyzed as in the old MySQL Query Browser tool and, if possible, its resultset can be edited in the grid. If the resultset cannot be edited, you can place the mouse over the ReadOnly label and view the reason.

• Improved snippets manager and editor, allows having snippets list always at hand, while editing can be done without disrupting work on the main query area.

• Editor state is now properly saved between sessions. Sidebar sizes, the last selected schema and other state information is now properly remembered between sessions.
• Script and resultset tabs can be reordered.
• Keyboard navigation of resultsets has been fixed to properly handle Tab key navigation in all platforms.
• The schema tree will now work with multiple selections, allowing the same action to be performed with more than one object at a time. You can select the columns to appear in a SELECT statement.
• A filter box was added to the live schema tree, allowing you to restrict the number of visible items in the tree to what you’re interested in.

• The schema tree was expanded to show more information about objects. In addition to schemas, tables, column, views and routines it also displays information about triggers, indexes and foreign keys. The object information box has been improved.
• Export recordsets to Excel, JSON and XML files that match the format used by MySQL. The export code has also been revamped to make writing custom export formats easier, which will be explained in a future post.

Improved Administrator

The Administrator was also improved in the following areas:

• Server Start and Shutdown page was updated to include server error log output
• The Log browser support was improved to work with log files, in addition to log tables, when managing local and remote servers.
• Export/Import layout was cleaned up and is now roomier and less cluttered.

Modeling

The focus of this release was on the SQL Editor, so there isn’t much new here. But heavy modeling users on Linux and Mac should be happy to know that the catalog tree has been finally fixed to stop scrolling back to the top.

We’re still working hard on adding and finishing more improvements to the major features we already have in MySQL Workbench, to make it the best and easiest to use database tool; but we think this is a good step forward.

UPDATE: A new 5.2.35.1 msi package has been uploaded, which resolves this issue. You can download it from the usual location.

Note: On a Core2 Quad 2.4 GHz and a 4G of RAM it takes about 30-40 minutes to build Workbench. Also it uses about 4.2G of hdd space to build.

Here are steps to build Workbench on Ubuntu/Debian:

1) install deps. It is better to use terminal. The command to install deps is below:

sudo apt-get install build-essential autoconf automake libtool libzip-dev libxml2-dev libsigc++-2.0-dev libglade2-dev libgtkmm-2.4-dev libglu1-mesa-dev libmysqlclient15-dev uuid-dev liblua5.1-dev libpcre3-dev g++ libglade2-dev libgnome2-dev python-pexpect libboost-dev libsqlite3-dev python-dev libgnome-keyring-dev libctemplate-dev

2) Get source code from http://www.mysql.com/downloads/workbench/

3) unpack downloaded archive and run autogen.sh from the unpacked directory. The actual invocation may vary, for example:

./autogen.sh –prefix=/usr/local

or

./autogen.sh –prefix=/opt/

–prefix tells configuration utility that install of Workbench should be done using the pivot directory.

Upon successful completion ./autogen.sh should generate Makefiles.

4) Build the tool.

That is simply make. If you have more than one core the you may like to use parallel build. For example, on a 4 cores box it is advised to use make -j5 install, on 2 cores – make -j3 install.

When built and installed, the directory which contains source files can be deleted.

UPD: to apply patch, get in the source directory and do patch -p0 < 5.2.35-ubuntu_11_10_compile_fix.patch

UPD2: libglitz* is no longer needed to compile Workbench.

The point is that MySQL Workbench relies on glib’s idle signals which are emitted when Gtk’s main event loop has nothing to do. In Ubuntu 11.10, for some reason, for certain types of windows we use, these idle signals are not emitted cause window drawing code constantly reschedules idle redraws.

The bug report which is related to the freezes and compilation problems is at http://bugs.mysql.com/62347

Here is a link to the patch: is http://bugs.mysql.com/file.php?id=17639