Обсуждение: GUI ERD/ERM tools?
Friends,
This question from our users keeps coming up...
What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder is helpful, but doesn't address the need.
Can any of you recommend specific tools, preferences, etc?
Regards, Lou Picciano
Lou Picciano, 12.11.2010 15:40: > Friends, > > This question from our users keeps coming up... > > What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder is helpful, but doesn't address the need. > > Can any of you recommend specific tools, preferences, etc? > > Regards, Lou Picciano If you are looking for a commercial tool, dbWrench is pretty good and reasonably priced. The only usable open source/free tool that I know of is PowerArchitect Regards Thomas
On Fri, 12 Nov 2010 08:40:54 -0600, Lou Picciano <loupicciano@comcast.net> wrote: > > What tools are each of you using for ERD ERM? pgAmin's Graphical Query > Builder is helpful, but doesn't address the need. > I'm not a database guru and I'm not 100% clear on "ERD ERM", but I will try to help anyway :) I used to work at an Oracle-heavy shop and the preference for the DBAs and developers was a tool called TOAD. You can find this software at http://toadworld.com/. It doesn't seem to be well known outside of the Oracle circles, but if their support for Postgres is half as good as their support for Oracle I think you would find it to be an amazing tool for visualizing the database, building queries, etc. Good luck! Regards, Mark
On Fri, Nov 12, 2010 at 3:40 PM, Lou Picciano <loupicciano@comcast.net> wrote:
Friends,This question from our users keeps coming up...What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder is helpful, but doesn't address the need.Can any of you recommend specific tools, preferences, etc?Regards, Lou Picciano
i prefer EMS postgre manager. but it is not free
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me
I've used eclipse with clay ( plugin) in the past, it is pretty good. And it is free,. Dinesh On 11/12/2010 8:07 AM, Mark Felder wrote: > On Fri, 12 Nov 2010 08:40:54 -0600, Lou Picciano > <loupicciano@comcast.net> wrote: > >> >> What tools are each of you using for ERD ERM? pgAmin's Graphical >> Query Builder is helpful, but doesn't address the need. > > I'm not a database guru and I'm not 100% clear on "ERD ERM", but I > will try to help anyway :) > > I used to work at an Oracle-heavy shop and the preference for the DBAs > and developers was a tool called TOAD. You can find this software at > http://toadworld.com/. It doesn't seem to be well known outside of the > Oracle circles, but if their support for Postgres is half as good as > their support for Oracle I think you would find it to be an amazing > tool for visualizing the database, building queries, etc. > > Good luck! > > > Regards, > > > Mark >
I've used eclipse with clay (plugin) in the past and it is good. It is free. Dinesh On Nov 12, 2010 06:46 AM, Thomas Kellerer <spam_eater@gmx.net> wrote: >Lou Picciano, 12.11.2010 15:40: >>Friends, >> >>This question from our users keeps coming up... >> >>What tools are each of you using for ERD ERM? pgAmin's Graphical Query >>Builder is helpful, but doesn't address the need. >> >>Can any of you recommend specific tools, preferences, etc? >> >>Regards, Lou Picciano > >If you are looking for a commercial tool, dbWrench is pretty good and >reasonably priced. > >The only usable open source/free tool that I know of is PowerArchitect > >Regards >Thomas > > > >-- >Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-admin > >
loupicciano@comcast.net (Lou Picciano) writes: > This question from our users keeps coming up... > > What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder > is helpful, but doesn't address the need. > > Can any of you recommend specific tools, preferences, etc? I have tended to find that when doing design work, nothing is better for the purposes of discussion of alternatives than a whiteboard and markers. Once the thinking has been done, I might use TCM to draft diagrams of some of the relationships <http://wwwhome.cs.utwente.nl/~tcm/> to compactly present them. Once the thinking is stable enough to create tables, I like SchemaSpy for providing diagramming that people can "click through" to examine the relationships between tables. <http://schemaspy.sourceforge.net/> -- output = ("cbbrowne" "@" "gmail.com") "Implying that you can build systems without rigourous interface specification is always a powerful selling technique to the clueless." -- Paul Campbell, seen in comp.object.corba
Another option is 'Database => Reverse Engineer' in Visio. Sam -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Chris Browne Sent: Tuesday, 16 November 2010 3:06 AM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] GUI ERD/ERM tools? loupicciano@comcast.net (Lou Picciano) writes: > This question from our users keeps coming up... > > What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder > is helpful, but doesn't address the need. > > Can any of you recommend specific tools, preferences, etc? I have tended to find that when doing design work, nothing is better for the purposes of discussion of alternatives than a whiteboard and markers. Once the thinking has been done, I might use TCM to draft diagrams of some of the relationships <http://wwwhome.cs.utwente.nl/~tcm/> to compactly present them. Once the thinking is stable enough to create tables, I like SchemaSpy for providing diagramming that people can "click through" to examine the relationships between tables. <http://schemaspy.sourceforge.net/> -- output = ("cbbrowne" "@" "gmail.com") "Implying that you can build systems without rigourous interface specification is always a powerful selling technique to the clueless." -- Paul Campbell, seen in comp.object.corba -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin