fabForce DBDesigner I found a great visual database design tool, DBDesigner 4, to help with creating databases. DBDesigner is an Open Source project and is published under GNU GPL, So that is great!

I’ve been using the software for a couple of weeks now and have found it very useful. It has actually helped me learn a bit more about indexes for your database tables. You create tables by using the table tool in the work space and entering your fields. Once you have multiple tables you can use one of the relation tools (1:n or n:n) and create connecting lines that represent the table’s relationships. Very Cool! When creating these relations, the program even adds the appropriate id field and index for the relation.

Last but not least, once you have created your database you can generate the SQL create scripts to actually make the database. Very nice! Something else I found cool is it stores your projects in an XML file. So backing-up and moving things around manually will not cause havoc.

It even has a Reverse Engineering feature which I have yet to use, but I imagine it will connect to your database, analyze the structure and re-create it in software.

I have found the interface to be a bit buggy. When creating/editing tables, sometimes the focus does not goto the field you click. Seems to get stuck, until freeing yourself by just clicking random fields and pressing enter. Doesn’t sound appealing, but easy to over-look once you start using the program. Hopefully it will be fixed in later releases.

Links in this Post