Hi,

I am still at work to improve my software.

Some new releases have been made while the last post. But an eyecatcher feature is now under development: Design in my application without using UML!

Here is a screen shot about what it could look like:



It is yet only a designer with no real functionality, but that's showing what is possible - ane this is simply a plugin into my application!

While trying to reverse engineer a database schema I discovered a table with two constraints of foreign keys pointing to the same primary table using the same foreign key column.

It struggled me thinking - what am I doing wrong - but it's not my fool

But how to handle it?

The database is postgresql and the schema is quite more complex than having some tables (CRM / ERP).

Is it a fool of the postgresql database to allow foreign key constraints based on the same columns on a set of tables?

Or is it a fool of the software vendor missing a check that this should not happen while the development and changes go on?

At least the software and the database works, so it may be my responsibility to detect this issue.

What is your opinion?

Thanks

Lothar

I have finally released my software and set it to production/stable. So when one has to do with prototyping and database applications, please review. Now printing has been added as an important business task.

To use the UML modelling feature, please download BoUML at http://bouml.free.fr and don't forget to donate

I'll add an article about setting up printing on my project web page: http://lbdmf.sourceforge.net

Thanks very much

Lothar

How fast do you sketch or paint your first ideas of an application to paper or paint a paper prototype?

Wouldn't you like to have a better solution (runnable prototype rather than a paper version) in shorter time?

I have created a comparison with a simple CD cataloging sample application. The topic here is related to creating database application prototypes only. The comparison includes simple paper sketches and using 'computerized' methods (with an UML editor). It is kept simple and is focusing on used time only.

You can read more at the following link.

Regards

Lothar Behrens

This is my first blog here, so I will begin with a description for what this blog is about.

About: lbDMF is a project that enables you to rapidly create database application prototypes. You can model the ideas first in UML and then import. Later you may export for doing further UML modelling and also database schema can be reverse engeneered to be in the UML model.

A planned and partly implemented table view variant:

This release contains many changes to get a better working application. The main enhancements are using initial Sqlite database to enable easy tryout of the software. The software should run out of the box. Additionally an UML (XMI) export has been added to enable reverse engineering of existing database schemas. A new documentation has been added that explains usage with BoUML and as an example for reverse engineering the postbooks database is used...