Graphical modelling tool

On Tue, 6 Dec 2005, Thomas Hallgren wrote:

I'm about to start a new project where the first task is to design a
database. I'm looking for some tool that will allow me to model the tables
and relationships graphically, UML or similar, and then let me generate the
SQL with PostgreSQL flavor. What's the best tools out there? Are there any
open source alternatives?

Thomas,

This will do some of what you want:

<http://pydbdesigner.sourceforge.net/&gt;

Rich

--
Richard B. Shepard, Ph.D. | Author of "Quantifying Environmental
Applied Ecosystem Services, Inc. (TM) | Impact Assessments Using Fuzzy Logic"
<http://www.appl-ecosys.com&gt; Voice: 503-667-4517 Fax: 503-667-8863

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Thomas Hallgren wrote:
| Hi,
| I'm about to start a new project where the first task is to design a
| database. I'm looking for some tool that will allow me to model the
| tables and relationships graphically, UML or similar, and then let me
| generate the SQL with PostgreSQL flavor. What's the best tools out
| there? Are there any open source alternatives?
|
| Kind regards,
| Thomas Hallgren
|
|
| ---------------------------(end of broadcast)---------------------------
| TIP 9: In versions below 8.0, the planner will ignore your desire to
| choose an index scan if your joining column's datatypes do not
| match
|

Hi,

Perhaps, you'll like this one:
http://www.memoriapersistente.pt/en/opensource/gaudi/index.html

Regards,

Carlos
- --
MEM�RIA PERSISTENTE, Lda.
Tel.: 219 291 591 - GSM: 967 511 762
e-mail: geral@m16e.com - URL: http://www.m16e.com
AIM: m16e - ICQ: 257488263 - Jabber: m16e@amessage.de
Skype.com username (VoIP): m16e.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDlfDR90uzwjA1SJURAkLAAJ4519ZfgUS1GSXSxZIbiwQd+uYS2QCg0FHt
0es2I1VGBk96I0REcP2iEAw=
=ovOS
-----END PGP SIGNATURE-----

I wrote a little app that does basically what you're looking for:

http://www.hardgeus.com/projects/pgdesigner/

It's not professional quality, and is a little flaky, but it gets the
job done. It has a wxGTK dependency, and of course postgres. Your best
bet for running it is to pull it from my CVS server (instructions on
page) rather than trying the binaries etc.

Thomas Hallgren wrote:

I recommend Clay (http://www.azzurri.jp/en/software/clay/index.jsp).

It requires a JRE + Eclipse (as it is an eclipse plugin), but it is really nice to work with and has built-in support for PostgreSQL DDL generation.

/Mikael

Carlos Correia wrote on 06.12.2005 21:13:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Thomas Hallgren wrote:
| Hi,
| I'm about to start a new project where the first task is to design a
| database. I'm looking for some tool that will allow me to model the
| tables and relationships graphically, UML or similar, and then let me
| generate the SQL with PostgreSQL flavor. What's the best tools out
| there? Are there any open source alternatives?
|
| Kind regards,
| Thomas Hallgren
|
|
| ---------------------------(end of broadcast)---------------------------
| TIP 9: In versions below 8.0, the planner will ignore your desire to
| choose an index scan if your joining column's datatypes do not
| match
|

Hi,

Perhaps, you'll like this one:
http://www.memoriapersistente.pt/en/opensource/gaudi/index.html

Regards,

I tried to run this (under Windows) but after selecting the database I
always get the following exception:

Exception in thread "main" java.lang.ExceptionInInitializerError
at
com.m16e.free.tools.xgui.XGuiFactory.readLayout(XGuiFactory.java:1152)
at com.m16e.dbed.DbEditor.showFrame(DbEditor.java:254)
at com.m16e.dbed.DbEditor.main(DbEditor.java:400)
Caused by: java.util.MissingResourceException: Can't find bundle for
base name i18n/xgui-locale, locale de_DE
at
java.util.ResourceBundle.throwMissingResourceException(ResourceBundle.java:839)
at java.util.ResourceBundle.getBundleImpl(ResourceBundle.java:808)
at java.util.ResourceBundle.getBundle(ResourceBundle.java:552)
at
com.m16e.free.tools.i18n.MpBundle.setBundleFile(MpBundle.java:35)
at com.m16e.free.tools.xgui.XGuiBundle.<init>(XGuiBundle.java:62)
at com.m16e.free.tools.xgui.XGuiBundle.<clinit>(XGuiBundle.java:57)
... 3 more

I fiddled around with the locale settings in dbeditor.properties but to
no avail. I even created a file i18n/xgui-locale.properties (and one
xgui-locale_de.properties) but to no avail.

What am I missing here?

Regards
Thomas

On Tuesday 06 December 2005 12:58, Thomas Hallgren wrote:

Hi,
I'm about to start a new project where the first task is to design a
database. I'm looking for some tool that will allow me to model the
tables and relationships graphically, UML or similar, and then let me
generate the SQL with PostgreSQL flavor. What's the best tools out
there? Are there any open source alternatives?

Kind regards,
Thomas Hallgren

You can try Dia with tedia2sql

Luca

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Thomas Kellerer wrote:
| Carlos Correia wrote on 06.12.2005 21:13:
|
|> -----BEGIN PGP SIGNED MESSAGE-----
|> Hash: SHA1
|>
|> Thomas Hallgren wrote:
|> | Hi,
|> | I'm about to start a new project where the first task is to design a
|> | database. I'm looking for some tool that will allow me to model the
|> | tables and relationships graphically, UML or similar, and then let me
|> | generate the SQL with PostgreSQL flavor. What's the best tools out
|> | there? Are there any open source alternatives?
|> |
|> | Kind regards,
|> | Thomas Hallgren
|> |
|> |
|> | ---------------------------(end of
|> broadcast)---------------------------
|> | TIP 9: In versions below 8.0, the planner will ignore your desire to
|> | choose an index scan if your joining column's datatypes do not
|> | match
|> |
|>
|> Hi,
|>
|> Perhaps, you'll like this one:
|> http://www.memoriapersistente.pt/en/opensource/gaudi/index.html
|>
|> Regards,
|>
|
| I tried to run this (under Windows) but after selecting the database I
| always get the following exception:
|
| Exception in thread "main" java.lang.ExceptionInInitializerError
| at
| com.m16e.free.tools.xgui.XGuiFactory.readLayout(XGuiFactory.java:1152)
| at com.m16e.dbed.DbEditor.showFrame(DbEditor.java:254)
| at com.m16e.dbed.DbEditor.main(DbEditor.java:400)
| Caused by: java.util.MissingResourceException: Can't find bundle for
| base name i18n/xgui-locale, locale de_DE
| at
|
java.util.ResourceBundle.throwMissingResourceException(ResourceBundle.java:839)

|
| at java.util.ResourceBundle.getBundleImpl(ResourceBundle.java:808)
| at java.util.ResourceBundle.getBundle(ResourceBundle.java:552)
| at
| com.m16e.free.tools.i18n.MpBundle.setBundleFile(MpBundle.java:35)
| at com.m16e.free.tools.xgui.XGuiBundle.<init>(XGuiBundle.java:62)
| at
com.m16e.free.tools.xgui.XGuiBundle.<clinit>(XGuiBundle.java:57)
| ... 3 more
|
|
| I fiddled around with the locale settings in dbeditor.properties but to
| no avail. I even created a file i18n/xgui-locale.properties (and one
| xgui-locale_de.properties) but to no avail.
|
| What am I missing here?
|
| Regards
| Thomas
|
|
| ---------------------------(end of broadcast)---------------------------
| TIP 2: Don't 'kill -9' the postmaster
|

It is really missing that file (i18n/xgui-locale.properties) from the
tarball, my apologies for that.

Just create one with the following 2 lines:

msg-null-file-layout=Unknown layout file: {0}\!
msg-file-not-found=Error opening file: {0}\!

Most probably, next you will get another error, stating that tha program
could not find a layout file, because of CLASSPATH issues.

If that's the case, I suggest you send a post to Gaud�'s mailing list
(http://lists.sourceforge.net/lists/listinfo/gaudi-users) and continue
the thread in there.

Just one tip: it seems you have not installed the application in the
default directory, if that's the case you should look in the manual for
configuration setup.

Regards,

Carlos
- --
MEM�RIA PERSISTENTE, Lda.
Tel.: 219 291 591 - GSM: 967 511 762
e-mail: geral@m16e.com - URL: http://www.m16e.com
AIM: m16e - ICQ: 257488263 - Jabber: m16e@amessage.de
Skype.com username (VoIP): m16e.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDlhZj90uzwjA1SJURAiHQAJ41IfxNGxi4vtn12C60qjfT+uD1IQCgk1OI
JjkjnA9gND/rJjELq4PL3Qc=
=XYZt
-----END PGP SIGNATURE-----

Thank you for all good suggestions. Clay will probably be my choice for this project since
it indeed is an Eclipse plugin that is developed.

Thanks again,
Thomas Hallgren