Re: Tool for modeling

Thomas Kellerer wrote:

Luiz Eduardo Cantanhede Neri wrote on 25.05.2009 12:44:

Hi guys,

Which tool do you recommend for modeling pg database? I'm using Aqua Data Studio, and it has a good and friendly UI and its ER it's quite well too, but it's paid and besides of design of it, it still has a lot of things to improve like, specially with E/R Diagram. I also had some problem with views with case it didnt accepted the syntax but when I executed it created the view anyway

[...]

And you guys any tool to suggest? specially Open Source?

Try out Power*Architect.

It is free and quite good although not (yet) complete though.

http://www.sqlpower.ca/page/architect

As a developer who used to work with MySQL, I got used to DBDesigner. I find it to be very intuitive, easy to use, and free.

However, it has two serious shortcomings:

1. It is not developed anymore. It is replaced with MySQL Workbench, witch I personally don't like.
2. It works only with MySQL, so my team uses a Java tool which reads DBDesigner files (old school XML) and generates DDL.

Regards,
Ognjen

--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice