Andrew E. Bruno: Database Design with Dia

Back in December Diaof 2007, Andrew E. Bruno wrote an excellent article on how to use the open source program Dia to design databases.  He used the resultant design to create a MySQL database but the same principles could be used to create just about any relational database from the design.  Dia is available for Linux, *nix, and Windows.

Database Design with Dia

In this post I’m going to give a quick how-to on creating database schemas with a wonderful tool called Dia. I’ve often found having a nice visual representation of a database to be quite helpful but can’t stand keeping it up to date. As soon as you add a new column or change the design around you end up having to sync your visual diagram with your SQL files. It’s tedious having to manage the various SQL for building the database and this can be a larger pain when trying to support different database platforms each with their own SQL syntax. So before you create your next database read on and see how Dia can make your life a bit easier.

Dia is a program for creating diagrams and for this exercise we’ll be creating UML diagrams from within Dia. We’re also going to use a perl script called tedia2sql which will transform our Dia files directly to SQL for our target database. What’s also nice about creating database schemas this way is that you can generate SQL for multiple target databases without the maintenance overhead.

read more….

Share Button

Long time no here

I was away for vacation then went into hiding while I brushed up on my Oracle skills for work.  All I can say is that I have a lot of material to put into the MyDatabases magazine this week.  So much to do it is hard to find time to get any of it done lately.  Oh well.  The next issue should be out this coming weekend.

In the meantime, count with me the days to Ubuntu 8.10 Intrepid being released:

Can’t wait that long? Try out the BETA. Check out the new features!

Share Button

It’s here! The very first issue of MyDatabases!

MyDatabases Volume 1 Issue 1 (July 2008)

MyDatabases Volume 1 Issue 1

Geek Spotlight:  Michael Peppler
Sybase ASE on Ubuntu 8.04
Multicore Processors
VMware Virtualization
Logical Process Manager

Share Button

MyDatabases license: Creative Commons


Creative Commons License


MyDatabases by
Jason L. Froebe is licensed under a
Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 United States License.

Based on a work at
froebe.net.

Share Button

The first issue of “My Databases” coming next week!

As many of you know, I’ve been working on a free magazine regarding various database systems (dbms) called My Databases.  I hope to have multiple authors in future issues covering all sorts of open source and proprietary databases.

I should have the first issue done Sunday night.  I’m using OpenOffice, Scribus, Gimp, and Inkscape.

Share Button