MySQL Workbench Wins Top 10 Placing

Jack Wallen from TechRepublic put together a Top-10 list of his favorite cross-platform applications. It is humbling to find MySQL Workbench in the company of such popular products like FireFox, Chrome, and Open Office.

Find his full list of applications here.

We can learn a lot from the other app in that list, e.g. we also want to be like FireFox in building a big set of community developed plugins. That is the reason we designed MySQL Workbench in a modular way and made it fully scriptable.

We are currently in the process of updating the documentation of how to write plugins and the scripting API. Watch out for more posts on this topic soon.

MySQL Workbench – Presentation Slides

Everybody at the MySQL Conference & Expo 2010 who is interested in MySQL Workbench, please feel free to join me for an in-depth presentation about the current MySQL Workbench 5.2 product and future plans. Looking forward to see you there!

Follow this link to the Conference Schedule for time and coordinates.

For everybody who could not joins us at the MySQL Conference & Expo this year I have uploaded the slides below. I included a lot of tips & tricks in the presentation. So even if you are not able to see the live demo, taking a look at the slides might still be a good idea.

MySQL_Conference2010_MySQL_Workbench_V3.pdf

Enjoy!

Using MySQL Workbench with XAMPP

David Coveney from interconnectit.com has written an excellent tutorial of how to use MySQL Workbench with XAMPP, a very nice bundle of Apache, MySQL, PHP and Perl. If you are running XAMPP or what to give it a try, make sure to check out his tutorial that describes how to set the correct MySQL Server Instance profile parameters.

This tutorial is also a good resource for people who do not use a default installation of MySQL and need to manually adjust their MySQL Server Instance profile parameters in order to make their setup work with MySQL Workbench. Default installations should work out of the box of course.

Please find the tutorial here: http://www.interconnectit.com/764/using-mysql-workbench-with-xampp/

EOL of MySQL Query Browser, MySQL Administrator, MySQL Migration Toolkit

With the beta releases of MySQL Workbench 5.2 well under way, we recently announced the EOL (http://www.mysql.com/support/eol-notice.html) of the MySQL GUI Tools Bundle.

The MySQL Tools team has been working on MySQL Workbench 5.2 to give DBAs and developers an integrated tools environment for:

  • Database Design & Modeling
  • SQL Development (replacing MySQL Query Browser)
  • Database Administration (replacing MySQL Administrator)

MySQL Workbench 5.2 also provides:

  • Remote Administration (using SSH-Tunneling)
  • Python scripting and plugins
  • Native GUI for Windows, Mac, Linux

A future release of MySQL Workbench (post 5.2) will add a migration plugin, providing features comparable to the MySQL Migration Toolkit component of the MySQL GUI Tools Bundle.  We will also be adding many other enhancements and new features.

Thanks go out to the community for the great feedback, new ideas, and bug reports on Workbench.  That helps immensely. We promise to keep listening and working hard to incorporate your feedback in improving the product.

To learn more about MySQL Workbench:

Best Regards,

Mike Zinner, Lead MySQL GUI Tools

MySQL Workbench Webseminar

To all people, interested to see a presentation/live demo of MySQL Workbench 5.1 and 5.2 – you’re welcome to join the MySQL Workbench Web-Seminar, held tomorrow, May 27th at 15:00 CET. Important side-note: it’s held in German!
For about 45 minutes I will walk you through various parts of the application and show many features live from my screen:

  • Overview of the interface
  • How to create tables and other objects
  • Layouting objects on the canvas
  • Show how to get your model to the database (and back)
  • Take a quick look into the scripting interface
  • See the database querying of upcoming 5.2 in action

Every participant will be able to ask questions via chat during the presentation and subsequently there will be a Q&A for about 15 mins. The session is free to attend, all you need to do is head over to the Registration-page and enter your data:

http://www.mysql.de/news-and-events/web-seminars/display-341.html

Once again – just a reminder – language used for this session is German. Looking forward to meet you online tomorrow!

MySQL Workbench replacing MySQL Query Browser

Our lastest Alpha2 release of MySQL Workbench 5.2 made it pretty clear that one of our main goals for WB 5.2 is to replace the old MySQL Query Browser (QB) tool.

Even this Alpha2 release already covers most of the essential QB functionality, while at the same time removes some of the biggest limitations that the old QB tool suffers from. Here is a short list of the most important features.

MySQL Workbench 5.2 Features replacing QB

  • Database Connection management
  • SQL statement editor with syntax highlighting
  • Edit multiple statements at the same time (scripts)
  • Editable result sets for table data
  • Database Schema browsing

New MySQL Workbench 5.2 Features

  • Intuitive Database Connection listing on Home page and direct access to SQL Editor
  • Ability to open SQL Editors for many different connections at the same time
  • Instant SQL parsing and syntax error detection while typing
  • Dedicated Output tab-sheet showing database server output
  • Dedicated History tab-sheet showing time-sorted execution history
  • Connection Info tab

MySQL Workbench 5.2 improvements (in respect to QB)

  • One single, unified editor for SQL Queries and Scripts
  • Multiple result sets for SQL Scripts displayed on individual tab-sheets
  • No auto-commit after each execution, possibility to use SQL session variables
  • Automatic limiting of number of result set rows to avoid unwanted network traffic
  • More intuitive, streamlined interface
  • Schema tree fetches data on demand, preventing freezes for huge catalogs

Planned Feature Additions in future Releases

  • Easy to use live Catalog overview & management (in the style of the MySQL Model Page)
  • Live Database Object Editors (reusing the powerful Table/View/Routine editors)
  • SQL Snippets repository
  • New MySQL HTTP Tunneling Connector, allowing owners of web accounts to upload a PHP page to access their database

Please give this early Alpha version a try and tell us what you think.  Your ideas are very welcome!

Sidenote: If you just want to use MySQL Workbench as a schema modeling tool, stick to WB 5.1. We have not added any new modeling features in WB 5.2 yet – and as the model file format has changed – you cannot open your 5.2 models in 5.1 or 5.0 anymore.

MySQL Workbench Workshop Online

Last week we did a Workbench tutorial and three workshops at the MySQL Users Conference. One reason for that was to get people familiar with schema design principles and MySQL Workbench in general. The other reason was to watch people using the tool and learn how we can improve in the UI. We learned a lot and already made some improvements in the next releases that are due this week.

Thanks for everybody attending our sessions and also a big thank you to Mike Hillyer who did a very good job presenting the material.

The material for this workshop as well as a live recording can be found here.

Enjoy!

MySQL Workbench 5.0.29 Released

Wasn’t there a release just some days ago, you might ask? Yes, indeed – but we had to create a quick follow-up because a nasty bug found its way through our test and into the recently released 5.0.28. A bit of debug code from our latest canvas changes was left behind and causes Workbench to crash under certain circumstances. Once discovered we found and fixed the root of the problem quite quickly. Additionally we introduced some new icons last time which didn’t find their way into the installer script as well … so frankly its a quickly delieverd follow up to fix 2 things we missed on last release.
We strongly recommend to update to this release asap.

Download version 5.0.29 from our Download Page or – for our SE users – use the integrated update wizard to get you up2date.

MySQL Workbench 5.0.27 Ready for Download

We have finished the next release of MySQL Workbench 5.0 GA, 5.0.27. It features a number of bugs fixed, especially in the synchronization code, a huge improvement in terms of memory usage and an updated layer-pane, listing all objects on a diagram-canvas – now including conections too (this allows easy selection of hidden objects). Use the Update-function from the help menu or head over to the download pages to get your copy:

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

Please let us know if bigger models now load faster and if you are seeing an improved performance of the canvas.