Servage Magazine

Information about YOUR hosting company – where we give you a clear picture of what we think and do!

Building data models with MySQL Workbench

Friday, February 8th, 2013 by Servage

Building and maintaing a proper data model is crucial to any web application. I believe that one of the most powerful and often overlooked free tools available is the MySQL Workbench application. It has been introduced here earlier, but it still appears to come as a surprise to many, that such a great tool is available – and even free:

Workbench is a desktop application which helps you design and administrate your MySQL servers, databases, tables, users etc. Extremely useful for large and smal projects. I particularly like the data model editor, where you can get a visual overview over your tables and relations between them. Check out the listed features:

Design

MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort.

Develop

MySQL Workbench delivers visual tools for creating, executing, and optimizing SQL queries. The SQL Editor provides color syntax highlighting, reuse of SQL snippets, and execution history of SQL. The Database Connections Panel enables developers to easily manage database connections. The Object Browser provides instant access to database schema and objects.

Administer

MySQL Workbench provides a visual console to easily administer MySQL environments and gain better visibility into databases. Developers and DBAs can use the visual tools for configuring servers, administering users, and viewing database health.

Download Workbench here

Building data models with MySQL Workbench, 2.5 out of 5 based on 4 ratings
Categories: Software & Webapps

Keywords:

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

No comments yet (leave a comment)

You are welcome to initiate a conversation about this blog entry.

Leave a comment

You must be logged in to post a comment.