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 5.2 – Code Statistics

A community member recently noted, that it takes quite a long time to compile MySQL Workbench. So he started wondering about how big the project actually is and asked for the Lines Of Code we have in our MySQL Workbench 5.2 repository.

We did not have this information at hand and therefore Alfredo ran some scripts during the weekend and generated this nice breakdown.

WB52_code_stats

As you can see, we almost have 700k lines of code to maintain. Given that the MySQL Server itself has about 900k lines of code this is a pretty decent number I think, especially for a small team of 7.

MySQL Workbench 5.2 Quick-Start Tutorial

MySQL Workbench 5.2 introduces a lot of new functionality and therefore this short tutorial will help you to get started quickly.

The Home Screen

The most prominent new addition in respect to previous Workbench releases is the new Home Screen. It allows you to access the main features of Workbench in a nice and easy way and is divided into 4 parts.

The upper Workbench Central panel features a few Links and Action Buttons to quickly access common resources.

The lower Workspace panel shows the main feature sets, grouped horizontally.

  • SQL Development allows editing and execution of SQL queries and scripts, create or alter database objects and edit table data.
  • Data Modeling covers the EER Modeling functionality you might already be familiar with from previous MySQL Workbench releases.
  • Server Administration offers administrative tasks like starting/stopping the server, edit the database server configuration, create user accounts, do data dumps and much more.

To quickly get started, use the following steps.

Home Screen Tutorial
Home Screen Tutorial
  1. Create a new Connection – Before you can start any other tasks — using the SQL Editor, forward engineering your model, or managing your database server, you need to create a new Database Connection. You can do that by using the New Connection Wizard or – if you are an advanced user – by using the Manage Connections dialog.You will have to enter the usual connection parameters, like IP address and port the server is running on as well as your username and password.
  2. Open Editor – After you have created a new connection, it will be displayed in the list of available Database Connections. Simply double-click on the list entry to open a SQL Editor and start querying.
  3. Create a new model – If you want to start your work by designing a visual database design first, click the Create new EER Model action item. An empty model will be created for you, only featuring the my_db schema which you can easily rename to the desired name.
  4. Create a New Server Profile – In order to administer your database server you have to register it within MySQL Workbench first.  Use the New Server Profile Wizard or – if you are an advanced user – use the Manage Server Profiles dialog.
  5. Open Admin – Once the new Server Profile is registered and appears in the list box you can double-click it to open the Admin.

Let’s take a closer look at the SQL Editor.

SQL Editor

The SQL Editor features a straight forward interface that gets you going, immediately.

SQL Editor Tutorial
SQL Editor Tutorial
  1. To give you instant access to your database objects we have added the Live Schema Overview panel to the SQL Editor. To start editing the data of an existing table, insert new data rows or manipulate existing data, simply double-click on the table.
  2. You can also modify the table structure by right-clicking on the table and select Alter … . This also works for any other database object.
  3. Enter your SQL queries and scripts on the SQL Statement panel. You can execute a single or multiple statements at the same time by clicking the Execution Arrow toolbar icon or hitting Ctrl+Return on the keyboard.
  4. If you create new objects by using SQL statements make sure to click the Refresh toolbar icon to update the Live Schema Overview panel and the Schema Tree.

We assume you already know how to use the EER Modeling and therefore we proceed with the Admin.

Admin

The Admin also features a very clear design that makes it easy to access the desired features.

Admin Tutorial
Admin Tutorial
  1. After opening the Admin you can see the Server Status panel at the top. Use this panel to verify the current server status and to check the current Server Health graphs.
  2. Select the corresponding Configuration tab that fits your current task.
  3. After selecting the correct Configuration tab perform the necessary actions on the Configuration page.

After studying this tutorial you should have a basic idea how the use MySQL Workbench 5.2 most efficiently. Please write a comment if you have a tip for other users.

Time To Upgrade – MySQL Workbench 5.1 Is Here on Win, Mac & Linux

We just announced the latest MySQL Workbench 5.1 release, 5.1.16. This release was labeled GA, which means that everybody using WB 5.0 or an earlier version of WB 5.1 is recommended update to WB 5.1.16.

We are now putting our main focus on the WB 5.1 branch and will continue to provide rapid update releases during the next months. Please report any hidden issues you may still find on our bug-tracker bugs.mysql.com so we can take care of those quickly.

WB 5.1.16 is out!

After the dust settles we will also continue to work on WB 5.2 in parallel, to give you query & administrative functionality within a single, powerful but easy to use tool.

Happy schema designing with MySQL Workbench 5.1!

MySQL Workbench 5.2 Querying Quick-Tour

For anybody interested in trying out our new MySQL Workbench 5.2 Alpha2 I have prepared a short Quick-Tour that will show you the most important steps to successfully use WB to query your databases.

Manage Your Connections

MySQL Workbench 5.2 introduces a new Home Page that makes it very easy to access all your Database Connections and EER Models. It features the Workbench Central Panel, the Database Connections Panel and the Model Files Panel.

In order to be able to connect to your  MySQL server you have to create a new Database Connection so MySQL Workbench knows about your server instance. Follow the steps shown below to create your first Database Connection.

Click on the screen shot to see it at full size.WB Query QuickTour Screen 1 small

Connecting to and Working with the MySQL Server

Once you have created your connection, a new Connection Icon will appear on the Database Connections Panel. Double-click this icon to open a SQL Editor for this connection.The next screen-shot shows how to query the database.

Again, click on the image to see it at full size.WB Query QuickTour Screen 2 small

Apart from writing SQL statements in the editor, you can also load scripts via the tool bar buttons.

As you can see it is really straight forward to use the Database Connection management and the new Query Functionality inside of MySQL Workbench 5.2. The current Alpha2 is a very early release but it already shows off some of the potential the final WB 5.2 GA feature set release will offer.

Please give it a try and tell us which features you would like to see in the future. But please remember, this is an Alpha version, so do not work on critical production data.

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 speaks SQLite

As many of you already know, MySQL Workbench offers powerful scripting support and a plugin interface that allows anybody to extend the application or add new functionality.

The latest addition to the WB plugin family has been written by Thomas Henlich. It features SQLite compatible SQL export of your Workbench models.

Download it from his blog and please provide feedback on the forums.

We are working on improving the scripting support in WB 5.2 and finally adding proper documentation so even more people can contribute.