Archive for the ‘Coding’ Category

ODBC and Unicode in Linux

Friday, August 10th, 2012

Recently I've had to spend countless hours trying to debug a problem mixing various ODBC components. Since I couldn't find any answers online, at least not in a way that was easy for a ODBC beginner like me to understand, I've decided to write it down here so it can ...

MySQL Workbench: Script for adding columns to all tables in a model

Thursday, June 7th, 2012

Here's a quick Python script for adding columns for all tables in your EER model. This will create a create_time and update_time columns in all tables, but you can modify it to your needs. To execute: go to Scripting -> Scripting Shell... click the New Script toolbar icon at the top left ...

MySQL Workbench: PHP development helper plugins

Friday, September 23rd, 2011

In the new MySQL Workbench 5.2.35, a plugin that will be of interest to PHP developers, both experienced and newbies, has been added. The plugin contains a couple of functions that allows you to create PHP code straight out of your current work in the Workbench SQL Editor, ready to be ...

MySQL Workbench: Introducing Utilities

Thursday, December 9th, 2010

MySQL has the well earned reputation for ease-of-use and "15-minutes-to-success", since we continually focus making the server easy to use. MySQL Workbench provides the visual tools for database design, development, and administration. However, many DBAs prefer using the command-line, and there are many tasks that require the creation ...

MySQL Workbench Plugin: Auto-Create Foreign Keys

Wednesday, November 3rd, 2010

To automatically create Foreign Key relationships is a typical use case for developers working with the MyISAM storage engine. This has been a popular topic on the Blog and forums so we’re revisiting it here - with a new and improved plugin written in Python. While the InnoDB storage engine supports ...

MySQL Workbench 5.2 – Code Statistics

Monday, November 30th, 2009

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 ...

Give and Take

Monday, May 4th, 2009

Have you ever looked at the source code of MySQL Workbench? There are quite some hidden gems there, e.g. the OpenGL canvas and our latest addtion: a new UI port of the famous open source edit control Scintilla. This port allows us to use this fantastic editor control natively on ...

Join the MySQL Workbench Team!

Wednesday, April 8th, 2009

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 ...

Python Scripting in Workbench

Sunday, March 8th, 2009

Updated: 2010-8-11 updated sample code to reflect changes in plugin registration API Python support has been added to the latest version of MySQL Workbench. In addition to Lua, you can now write scripts and modules or interact with the GRT shell using the Python language. The integration allows you to use GRT ...

Automate Figure Arrangement In Workbench

Thursday, October 30th, 2008

Initiated by a question on the forum I took some time to exercise my Workbench-Scripting-Knowledge. The question was, if it's possible to do some figure-arrangement/organizing via scripts. To be more precise, the task I had to master was to get tables that have names starting with a given prefix moved ...