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!

Free Workshop + Free Workbench SE at MySQL UC

Everybody attending the MySQL Users Conference this year please mark your calenders! This is your chance to become a MySQL schema design expert as well as learn how to use Workbench from the experts.

We are going to do a free Workshop called “Introduction to Data Modeling with MySQL Workbench” on Tuesday – Thursday 3 – 4:30 PM in the Santa Clara Ballroom.

Some of the topics that will be covered:

  • Database Schema Design
    • Get familiar with common concepts of database schema design
    • Learn to avoid typical mistakes (do-s & don’t-s)
    • Tricks how to resolve typical problems
    • Performance-tune your schemata
  • MySQL Workbench
    • Get introduced to MySQL Workbench
    • Learn how to use MySQL Workbench in real world scenarios
    • Make use of add-ons
    • Check out the MySQL Workbench Standard Edition
    • Learn about the MySQL Workbench roadmap

In addition, everybody attending the Workshop will receive a 12-month MySQL Workbench Standard Edition subscription ($99 value) for free.

There will be a limited number of seats available so make your reservation as soon as possible following this link:

We are also offering a full tutorial on this topic on Monday that will have even more advanced content. Learn more about this here.

Join the MySQL Workbench Team!

If you are a Mac developer, interested in a new professional challenge and like what we have done with MySQL Workbench so far, please consider applying for our open position in the Workbench team.We are looking for an Objective-C / UI coding wunderkind who is also not easily scared by C++.

You can be located anywhere around the world, only hard requirements are that you are comfortable with working from home, have a decent internet connection and are not too far from an airport.We would be happy to have you on the team.

More details about the job below. To speed up the hire process please send your CV to workbench@sun.com. We are preferring people with open source background so please do not forget to include links to your open source work.

Job Summary:

Sun Microsystems is looking for a strong Mac UI developer with in-depth knowledge of Objective-C, C++, X-Code and the Mac OS X 10.5 operating system. Responsibilities will include ownership of upcoming Mac versions of the MySQL Workbench product, user interface design and integration with C++ backend as well as extensive unit- and UI testing.

Job Description

Sun Microsystems, the developer of the world’s most popular open source database MySQL, is looking for a Software Engineer to join a growing team of professionals.  The ideal candidate must have excellent experience in Mac application- and user interface development with X-Code using Objective-C as well as good C++ knowledge.Join the #1 open-source software company, with great benefits, competitive salary, the flexibility to work from home, and the experience of interacting with a worldwide, multi-cultural workforce!

Responsibilities

  • Take responsibility for Mac versions of the MySQL Workbench product
  • Design and develop sophisticated Mac user interfaces
  • Work on the integration of C++ back-end implementation and Objective-C UI code
  • Develop and maintain automated unit-/UI- tests on the Mac platform

Qualifications

  • Minimum 6+ years hands-on Software Development on the Mac platform with strong focus on UI development work
  • Strong background in database technologies and previous experience in maintaining/administrating or developing for DBMS systems (MySQL, SQLite, Oracle, MS SQL Server, DB2 and others)
  • Strong background in SQL (experience developing applications using complex SQL structures), scripting languages (Lua / Python)
  • Ability to define, create, document and verify testing methods and results
  • Strong knowledge of the Mac operating system with in-depth experience of the current APIs found in OS X 10.5
  • Strong knowledge in Database concepts
  • Ability to work independently and remotely with limited supervision
  • Fluent written and spoken English
Desired:
  • Experience with C#/.Net and extensive knowledge of scripting languages Lua, Python, Ruby
  • Experience on the Linux platform
  • Background in QA methodologies and experience using UI test automation tools

MySQL Workbench on Mac OS X

MySQL Workbench Mac support has been requested from our community for a very long time. We got several emails and comments on the web and IRC channel that Workbench is the only tool why a lot of people are still running a VMware Fusion or Parallels session with Windows.

Therefore we are very happy about the recent release of WB 5.1 Beta1 which is the first release that is available on our three main platforms, Windows, Mac & Linux.

Those who have been giving MySQL Workbench 5.1 Beta1 on Mac OS X a try may have noticed the huge speed gain, compared to the Windows version, especially when working with bigger models. We even got complaints why we have “slowed down” the Windows version 🙂 but this is simply due to the GUI hardware acceleration support available on the Mac, as well as on Linux systems.

So for the moment (until we finally get to re-enable full OpenGL support) using the Mac version is the new benchmark of model rendering speed for MySQL Workbench projects.

We are working hard to get closer to a WB 5.1 Release Candidate and plan to release the WB 5.1 Beta2 next week. It will include more than 30 bug fixes and improvements for the Mac UI.

MySQL Workbench Pre-Beta Hackfest – Bring It On!

Following our plan to release the MySQL Workbench 5.1 Beta1 later this week we have uploaded a last Alpha build for Ubuntu and the Mac for you to check for serious issues. The following binaries will not be published on our official download site but are only available trought the following links.

Please join us in our #workbench IRC channel on freenode to discuss issues or simply leave a comment here.

ftp://ftp.mysql.com/pub/mysql/download/gui-tools/mysql-workbench-oss-5.1.8-1-alpha-i386.deb

ftp://ftp.mysql.com/pub/mysql/download/gui-tools/mysql-workbench-oss-5.1.8-alpha.app.zip

To verify your downloads please check the md5 sums:

3feb64fd5dbd5384ad43c639228bb792  mysql-workbench-oss-5.1.8-1-alpha-i386.deb

08d0a13d1bbc09b27cb10cfde2f194ec mysql-workbench-oss-5.1.8-alpha.app.zip

To install use dpkg -i mysql-workbench-oss-5.1.8-1-alpha-i386.deb on Ubuntu 32bit or

unzip the file mysql-workbench-oss-5.1.8-alpha.app.zip on your Mac OS X 10.5 and drag the Workbench.app to your Applications directory.

If you want to test with an existing model file you can download the Sakila Workbench model file from here.

ftp://ftp.mysql.com/pub/mysql/download/gui-tools/sakila_full.mwb

Have fun!

MySQL Workbench to win Product of the Year 2009 Award

We are proud to announce that MySQL Workbench has won the Developer.com’s Product of the Year 2009 voting in the category “Database Tool”. 

Product of the Year 2009

We would like to thank all our customers and users who have voted in favor of our application. This reflects the very positive feedback we get when talking to people about MySQL Workbench.

With the upcoming support for Linux & Mac and the resounding feedback from this developer community we hope to grow the support and usage of the product even further.

If you want to see MySQL Workbench in action or want to learn about the tricks & tweaks to get even more out of the application, please consider joining us at this year’s MySQL Conference & Expo 2009.

Nice MySQL Workbench Tutorial – Creating A MySQL Forum Database

For everybody interested, please check out this very descriptive tutorial written by Adrian ‘yEnS’ Mato Gondelle. It shows how to create a database schema design with MySQL Workbench.

If you have written your own tutorials or blog posts about MySQL Workbench please drop us an email and we might feature it on our blog.

MySQL Workbench 5.1 Alpha for Linux in Less Than 30 Days

A lot of people have been waiting for this a long time – so I am very happy to announce that we will publish the first Alpha that runs natively on Linux end of September. We will release generic binaries and the 5.1 source tarball including everything that is needed to build yourself.

This will not be a feature-complete beta release yet, but we are trying to get the basic functionality working so everybody can start modeling right away. We spent most of the last few months working on updating the Back-End implementation to use the GRTv4 and to prepare our platform-independent mForms. I expect the actual Front-End port to make good progress.

Let me share two screenshots I just made on Ubuntu, our Linux distro of choice. The first one shows the MySQL Model page. The Sakila demo model has been loaded.

WB 5.1 Linux Preview 1 Small

The second screenshot shows the EER Diagram. This first Alpha will still use the software rendering option but we are looking forward to enable the OpenGL pretty soon.

WB 5.1 Linux Preview 2 Small

Keep monitoring the blog – we will publish new screenshots as we go.

Nice Blog Postings About MySQL Workbench

Quite a few Blog postings pop up recently, let me outline two of them.

Gerry Narvaja talks about multi-page printing by using the MySQL Workbench community edition utilizing the PDF output. Find his posting here.

Weizh posted a nice step-by-step tutorial on how to use Workbench to show differences between two databases. Find it here.

Both workflows get you what you want by using the Community Edition. For those of you who want everything on a silver plate there is the Standard Edition of course, which simplifies these tasks even more.

On a side note: To get more information about the printing topic Gerry joined us on our IRC #workbench channel on irc.freenode.net. Somebody from the team usually hangs out there from 10:00 am European time till 18:00 EST. Don’t be shy and join us there if you have a WB-related question. We might also be able to answer general MySQL questions but the better channel for that is #mysql. For more information see this page.

MySQL Workbench Has Reached a Major Milestone: 400.000 downloads

I would like to say a big Thank-You to the community. It has been quite a ride this last year for my team and me, designing and coding MySQL Workbench, getting it to GA quality, presenting at the UC and constantly continue to improve quality since then. Now let’s look at the facts.

  • I am happy to announce that we have reached more than 400.000 downloads of MySQL Workbench today, which is quite a lot for a highly specific tool in such a short time-frame (406690 at 18:25 GMT+1 to be exact).
  • We have about as many downloads a day as the MySQL Server 5.1 server on Windows, also quite impressive I think for a little database design tool (I am only comparing Windows since Workbench is only available on Windows yet).
  • The number of incoming bugs has been going down after each new release and we are now at a constantly low level. Nevertheless we are continuing our bug-fix releases while working on MySQL Workbench 5.1, the ports to Linux/Solaris and OS X.

WB weekly bugs stats

Stay tuned for more good information.