Contents

• What Is Database Designer?
• How to Create a Database Diagram
• Navigating the Diagram
• How to Quickly Print Diagram
• Saving and Restoring the Diagram

What Is Database Designer?

Database Designer is a powerful visual design tool for database development that allows you to build a clear and effective database structure visually and to see the complete picture representing all the tables, foreign key relations between them, views, and stored routines of your database on a database diagram.

Database Designer allows you to view and edit your database in a convenient visual way. You can observe all objects of your database, see foreign key relations between tables, viewing database objects information, easily access database …

If you are a twitter user, you may like to know that there are many people from MySQL who are regular twitters.

For a start, you may want to follow these ones:

People

1. kajarno Kaj Arnö
2. datacharmer Giuseppe Maxia
3. bytebot Colin Charles
4. LenzGr Lenz Grimmer
5. dups Dups Wijayawardhana

Non-people

1. mysqlconf MySQL Users Conference, which is going to be used during the conference to collect feedback for the panel …

Here are some quotes from a recent article talking about Oracle's maintenance and support fees:

Before Oracle acquired BEA earlier this year, the company charged 18% to 20% for support and maintenance. Oracle increased those fees to meet its own structure and also raised list prices on most BEA products.

That didn't sit well.

and


One Java-centric VAR, who spoke on the condition of anonymity, said some of his BEA WebLogic customers are moving to alternative application servers just to get away from Oracle.

and

"What company comes in this climate and not only jacks up prices but support prices as …

MySQL HA: 1. Desirable – most of the time, 2. Needed – often enough, 3. Available – there are some good options out there. Typical solutions consist of: Heartbeat with DRBD on Linux. Although HB was introduced to Linux, it can be used on Solaris, FreeBSD and others without the DRBD but with other solutions. Sun Cluster, Veritas (commercial), MySQL Proxy (still in [...]

After the Sunrise and Landrush phases (underway until March 23rd), .TEL domains will finally be available to everyone as of March 24th.

Online pre-reservation for this final phase is available at Gandi. Registration will be made on a first-come, first-served basis. Registration requests that failed will be fully refunded. The price for a .TEL domain has been set at 14 euros per year excl. VAT under A rates.

As a reminder, please do not forget that the .TEL extension is unlike other extensions! You will be unable to have a website with an address like example.tel. The purpose of the extension is to store and manage your personal contact information in a format that can be easily handled and accessed by everyone or specific persons via DNS records.

We invite you to discover all of the possibilities that are available to you on the registry's website at …

Quite common task during schema review is to find the optimal data type for the column value - for example column is defined as INT but is it really needed or may be SMALLINT or even TINYINT will do instead. Does it contain any NULLs or it can be defined NOT NULL which reduces space needed and speeds up processing in most cases ?

These and similar tasks are often done by bunch of SQL queries while really MySQL has a native feature to perform this task - PROCEDURE ANALYSE

Here is sample run of PROCEDURE ANALYSE on drupal schema of Percona web site. The output contains row for each column in the table but I've omitted everything by few rows.

PLAIN TEXT SQL:

1. mysql> SELECT * FROM node  …

This is a re-run of an earlier webinar.

Would you like to know how JRuby,NetBeans, GlassFish, and MySQL can power your Rails applications ?



This informative technical webinar explains the fundamentals of JRuby and how the NetBeans IDE makes developing/debugging/deploying Rails applications on GlassFish quick, fun and cost-effective.

The webinar starts 10am PT on Mar 31st, 2009 and can be …

The reference manual explains it in detail.
There are two things that you must remember, if you are …

If you are a twitter user, you may like to know that there are many people from MySQL who are regular twitters.

For a start, you may want to follow these ones:

People

1. kajarno Kaj Arnö
2. datacharmer Giuseppe Maxia
3. bytebot Colin Charles
4. LenzGr Lenz Grimmer
5. dups Dups Wijayawardhana

Non-people

1. mysqlconf MySQL Users Conference, which is going to be used during the conference to collect feedback for the panel …

If you are a twitter user, you may like to know that there are many people from MySQL who are regular twitters.

For a start, you may want to follow these ones:

People

1. kajarno Kaj Arnö
2. datacharmer Giuseppe Maxia
3. bytebot Colin Charles
4. LenzGr Lenz Grimmer
5. dups Dups Wijayawardhana

Non-people

1. mysqlconf MySQL Users Conference, which is going to be used during the conference to collect feedback for the panel …