So from what I realize from this topic is that we miss a professional tool to deal with ERD
On Tue, May 26, 2009 at 8:25 AM, Ognjen Blagojevic <ognjen@etf.bg.ac.yu> wrote:
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.
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.