In this post I will present the process for creating the MySQL database used in the VoiceHotel project, using the MySQL Workbench Community Edition, focusing on the features offered by this tool. The VoiceHotel project was the Grand Prize Winner of the Sun Students Contest in 2008, MySQL and GlassFish step.

What is MySQL Workbench?In general terms we can say that MySQL Workbench is a tool that enables a DBA or developer in general, to create and manage visually all types of MySQL databases, from a simple database in a web application, to a even more complex, …

In this post I will present the process for creating the MySQL database used in the VoiceHotel project, using the MySQL Workbench Community Edition, focusing on the features offered by this tool. The VoiceHotel project was the Grand Prize Winner of the Sun Students Contest in 2008, MySQL and GlassFish step.

What is MySQL Workbench?

In general terms we can say that MySQL Workbench is a tool that enables a DBA or developer in general, to create and manage visually all types of MySQL databases, from a simple database in a web application, to a even more …

update 1: english readers can view here the translated version of this post.

Neste post apresentarei o processo para criação da base de dados MySQL utilizada no projeto VoiceHotel, utilizando o MySQL Workbench Community Edition, focando nas funcionalidades oferecidas por esta ferramenta. O projeto VoiceHotel foi vencedor do primeiro lugar no desafio da Sun para Estudantes em 2008, etapa MySQL e Glassfish.

O …

update 1: english readers can view here the translated version of this post.

Neste post apresentarei o processo para criação da base de dados MySQL utilizada no projeto VoiceHotel, utilizando o MySQL Workbench Community Edition, focando nas funcionalidades oferecidas por esta ferramenta. O projeto VoiceHotel foi vencedor do primeiro lugar no desafio da Sun para Estudantes em 2008, etapa MySQL e Glassfish.

…

Visual database design is very essential. Almost every web application needs database. And by designing visual representation, relation of tables makes an developer easy to understand on the database. There are many tools to design database like DBDesigner, SQLYog. Recently I found another application that is called MySQL Workbench. It can be used to efficiently design, manage and document database schemata. After using it’s functionality, I found this is a really good tool for design database specially for MySQL.

It is available as both, open source and commercial editions. The Community (OSS) Edition is available from this page under the free software/opensource GNU General Public License (commonly known as the “GPL”)

Download MySQL Workbench …

So, you want to compile Workbench for Linux, on Fedora 9. You need to install the following packages:

autoconf automake libtool libzip-devel libxml2-devel libsigc++20-devel libglade2-devel gtkmm24-devel mesa-libGLU-devel mysql-libs mysql mysql-devel uuid-devel lua-devel glitz-devel glitz-glx-devel pixman-devel pcre-devel libgnome-devel gtk+-devel pango-devel cairo

I feel I’m being too liberal with dependencies, but I’m not about to strip it, I just want to get it working first :)

You need to have ctemplate and ctemplate-devel installed from updates-testing-newkey (relevant koji build log).

By default, configure.in in Workbench looks for “google-ctemplate”, as opposed to just “ctemplate” as Fedora calls it. You can fix this (easy), or “cheat” - in /usr/local/include you can do sudo ln -s …

I had the pleasure of sitting right across the MySQL GUI Tools Team, and decided to try my hand at Workbench (Workbench for Linux, that is). Congratulations to the entire team for the great work! I am excited.

First up, the things you need on Ubuntu 8.04 (I created a fresh install, and installed all the updates), if you’re downloading the binary:

• liblua5.1-0
• libglitz1
• libzip1
• libmysqlclient15off
• mysql-common
• libglitz-glx1

Workbench on Linux

It works. It starts up. Its exciting. Of course, when I try to edit a table name or even create a table, it fails by segmentation fault. Segfaults are annoying… so the best way to debug it, is of course to run catchsegv. …

Wow... I had a great time at the annual MySQL Users Conference in Santa Clara.Highlights:Received my CMDBA designation. Woohoo!Sun announced the possibility of an open source mobile phone;All day mysql proxy tutorial with Jan Kneschke and Giuseppe Maxia;Amazon's Power of Infrastructure as a Service - great premise; glitches remain;Great food and a nifty side trip to Santa Cruz;MySQL Workbench -

Allow me to provide some relaxed photographic observations from this morning’s MySQL UC keynotes.

Warning 1: My view is distorted, by my favourite lens, Sigma 8mm.

Warning 2: I took the pics with a shaky hand in low light, so they’re not sharp ones, of the James Duncan Davidson type (the guy who takes all the great pics for O’Reilly).

On Johnny Good’s command, doors open, and the audience starts pouring in.

Zack Urlocker has challenged me in the James Callis Lookalike Contest (of Battlestar Galactica fame), but is himself clearly in the lead.

Journalist James Niccolai of IDG, taking a picture of Rich Green and Mårten Mickos (Note: I am a fan of recursion; it would have been even better if Zack had taken a picture of me taking a picture of James, Rich and Mårten).

Mårten Mickos talking to Sheeri Kritzer Cabral.

Jay Pipes’s head is moving so fast talking to …

MySQL Workbench, the successor to DBDesigner 4 from FabForce, is a visual database design tool that integrates database design, modeling, creation and maintenance into a single, seamless environment for the MySQL database system. You can use it to design and create new database schemas, document existing databases and even perform complex migrations to MySQL.

It’s now a good week ago since our first Release Candidate numbered 5.0.15, and if you haven’t checked it out yet, now is a good time!

References:

• Wikipedia: http://en.wikipedia.org/wiki/MySQL_Workbench
• MySQL Forge: …