Thread: GUI ERD/ERM tools?

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

--
---------------------------------------
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