You add tables, by rightclicking in the main window, and choosing "Tables", "Add". You can then change the name and contents of each table by right-clicking in the different tables and choosing "Edit". You add relations between tables by drag'n'drop-ing fields from one table to the other.

Using the Configuration, you can change a few colors and fonts, useful if you want to export it to an image that has to match a certain style. You can access the Configuration by right-clicking in the main window and choosing "Configuration".

By rightclicking in the main window, and choosing "Relations", "Remove all", all the relations between tables will be cleared. By rightclicking in the main window, and choosing "Output", "as JPEG", you will be prompted for a filename, and the current contents of the main window will be printed. The JPEG's dimensions will match those of the window, so you should resize the window to the proportions you need before saving.

The rest (there ain't that much more to it, actually) of the program is pretty self-explanatory.

There were no programs that did exactly what I wanted. I were up for an exam when I started writing this program, where the design of databases was one of the requirements, and as such, I started looking for a program that could draw entity-relation diagrams. There were one alternative, Microsoft Access, but as I have based my database-training upon mySQL and PHP, I decided that I should rather look at alternative solutions. I first started out drawing ASCII-representations of the diagrams, but quickly found out that this was to time-consuming to do at a 5-hour exam. This is the result. The images exported by this program could easily be included in any database documentation, and was used in the presentation of the resulting database.

Features that will (probably) be added in the near future;

• Ability to import from and export to common database formats (especially SQL)
• Saving of configuration with the database
• Creating SELECT statements from the diagram

0.0.5;

• You can edit relations (directions, type, etc.)
• Snap to grid
• Displays information about the table column the mouse pointer is over
• Converted to Delphi 2005
• Bug fixes:
  • [1045033] Comma not included between columns and key
  • [1040326] Table MaxHeight to small
  • [780341] Program crashes when tables are deleted

0.0.4; uploaded to Sourceforge, and renamed to MyDBExpert. Added support for primary keys, unique, index, binary and auto_increment constraints. Can dump mySQL to screen.

0.0.3; supports exporting to (my)SQL dump files, and therefore allows descriptions for each field, as well as a field type.

0.0.2; supports saving and loading of databases, using valid XML.

0.0.1; first public release.