PlanetMysql.ru – информация о СУБД MySQL

Happy New Year! Monday night is the first meeting of the North Texas MySQL Users Group for 2010! And the topic for discussion will be MySQL Workbench.

Workbench is a tool for visual database design, schema documentation, change management, and is replacing the old MySQL GUI tools. If you have not tried the latest releases, you will be for a pleasant surprise.

NorthTexasMySQL.org meets at 7:00PM sharp at the Sun Offices, Suite 700, 16000 Dallas Tollway, Dallas TX. We welcome all who want to know more about MySQL, databases, or Open Source. Admission is free and I will bring cookies!
PlanetMySQL Voting: Vote UP / Vote DOWN

Given the announcement earlier this week of an updated release of the actively developed MySQL Workbench 5.2, I thought I'd give it a quick look...

Install on Windows went without a hitch.

One thing I noticed, which I don't remember being previously available in MySQL GUI tools, is the ability to connect to a remote MySQL server via SSH tunneling.

Below is a screen shot:



Well done! A small, but significant addition for folks that require SSH to connect to their systems.

I did notice that the design in Workbench involves selecting "Standard TCP/IP over SSH" from the drop down and then providing credentials in a more "form" oriented layout. An "SSH" tab like we see in Navicat or SQLyog might be more familiar for some folks. (Also, a minor note, no "browse" button next to the "Path to SSH key file" option.)

I know that 5.2 is still in active development, but the functionality in regards to SSH looks good to go...with maybe just a few tweaks to the connections dialog :)
PlanetMySQL Voting: Vote UP / Vote DOWN

Yesterday, 7 Oct 2009, MySQL Workbench 5.2.4-alpha was released. What interests me in particular is that Workbench 5.2 brings support for writing plugins using Python. Before it was only possible using LUA.

Workbench comes with GRT (Generic RunTime) shell which allows you to access objects at runtime. It's pretty neat, but how you enable it to use Python? Here is how:

1. Open the Workbench Preferences dialog
2. In the General section, set Interactive GRT Shell Language to Python.
3. Restart Workbench
4. Go to View > Advanced and choose CRT Shell.

It's a bit of a chore writing in that shell as you can't copy/paste (at least not in MacOS, workaround is to drag!). Here are a few commands you can do there (or check on the Workbench team blog). Make sure you have at least one Model open, and one table defined.

>>> import grt
>>> model = grt.root.wb.doc.physicalModels[0]
>>> for tab in model.catalog.schemata[0].tables:
...   print "Table: `%s`" % (tab.name)
... 
Table: `t1`

Using the GRT shell it makes it possible to test first some lines of code. I do personally like it, although the shell feels still a bit buggy, but usable.

PlanetMySQL Voting: Vote UP / Vote DOWN

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!
PlanetMySQL Voting: Vote UP / Vote DOWN

In case you have not already noticed, Workbench 5.2 alpha / preview release of MySQL's premier development and design tool, has been announced.

For an independent preview, you can also see here.