pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedGUI ERD/ERM tools?
8+ messages / 8 participants
[nested] [flat]
* GUI ERD/ERM tools?
@ 2010-11-12 14:40 Lou Picciano <loupicciano@comcast.net>
2010-11-12 14:46 ` Re: GUI ERD/ERM tools? Thomas Kellerer <spam_eater@gmx.net>
2010-11-12 16:07 ` Re: GUI ERD/ERM tools? Mark Felder <feld@feld.me>
2010-11-12 17:46 ` Re: GUI ERD/ERM tools? Viktor Bojović <viktor.bojovic@gmail.com>
2010-11-15 16:36 ` Re: GUI ERD/ERM tools? Chris Browne <cbbrowne@acm.org>
0 siblings, 4 replies; 8+ messages in thread
From: Lou Picciano @ 2010-11-12 14:40 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: GUI ERD/ERM tools?
2010-11-12 14:40 GUI ERD/ERM tools? Lou Picciano <loupicciano@comcast.net>
@ 2010-11-12 14:46 ` Thomas Kellerer <spam_eater@gmx.net>
2010-11-12 16:18 ` Re: GUI ERD/ERM tools? Dinesh Bhandary <bhandary@iii.com>
3 siblings, 1 reply; 8+ messages in thread
From: Thomas Kellerer @ 2010-11-12 14:46 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: GUI ERD/ERM tools?
2010-11-12 14:40 GUI ERD/ERM tools? Lou Picciano <loupicciano@comcast.net>
2010-11-12 14:46 ` Re: GUI ERD/ERM tools? Thomas Kellerer <spam_eater@gmx.net>
@ 2010-11-12 16:18 ` Dinesh Bhandary <bhandary@iii.com>
0 siblings, 0 replies; 8+ messages in thread
From: Dinesh Bhandary @ 2010-11-12 16:18 UTC (permalink / raw)
To: Thomas Kellerer <spam_eater@gmx.net>; +Cc: pgsql-admin
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
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: GUI ERD/ERM tools?
2010-11-12 14:40 GUI ERD/ERM tools? Lou Picciano <loupicciano@comcast.net>
@ 2010-11-12 16:07 ` Mark Felder <feld@feld.me>
2010-11-12 18:48 ` Re: GUI ERD/ERM tools? Dinesh Bhandary <dbhandary@iii.com>
3 siblings, 1 reply; 8+ messages in thread
From: Mark Felder @ 2010-11-12 16:07 UTC (permalink / raw)
To: pgsql-admin; Lou Picciano <loupicciano@comcast.net>
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: GUI ERD/ERM tools?
2010-11-12 14:40 GUI ERD/ERM tools? Lou Picciano <loupicciano@comcast.net>
2010-11-12 16:07 ` Re: GUI ERD/ERM tools? Mark Felder <feld@feld.me>
@ 2010-11-12 18:48 ` Dinesh Bhandary <dbhandary@iii.com>
0 siblings, 0 replies; 8+ messages in thread
From: Dinesh Bhandary @ 2010-11-12 18:48 UTC (permalink / raw)
To: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: GUI ERD/ERM tools?
2010-11-12 14:40 GUI ERD/ERM tools? Lou Picciano <loupicciano@comcast.net>
@ 2010-11-12 17:46 ` Viktor Bojović <viktor.bojovic@gmail.com>
3 siblings, 0 replies; 8+ messages in thread
From: Viktor Bojović @ 2010-11-12 17:46 UTC (permalink / raw)
To: Lou Picciano <loupicciano@comcast.net>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: GUI ERD/ERM tools?
2010-11-12 14:40 GUI ERD/ERM tools? Lou Picciano <loupicciano@comcast.net>
@ 2010-11-15 16:36 ` Chris Browne <cbbrowne@acm.org>
2010-11-15 21:47 ` Re: GUI ERD/ERM tools? Samuel Stearns <SStearns@internode.com.au>
3 siblings, 1 reply; 8+ messages in thread
From: Chris Browne @ 2010-11-15 16:36 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: GUI ERD/ERM tools?
2010-11-12 14:40 GUI ERD/ERM tools? Lou Picciano <loupicciano@comcast.net>
2010-11-15 16:36 ` Re: GUI ERD/ERM tools? Chris Browne <cbbrowne@acm.org>
@ 2010-11-15 21:47 ` Samuel Stearns <SStearns@internode.com.au>
0 siblings, 0 replies; 8+ messages in thread
From: Samuel Stearns @ 2010-11-15 21:47 UTC (permalink / raw)
To: Chris Browne <cbbrowne@acm.org>; pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2010-11-15 21:47 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-11-12 14:40 GUI ERD/ERM tools? Lou Picciano <loupicciano@comcast.net>
2010-11-12 14:46 ` Thomas Kellerer <spam_eater@gmx.net>
2010-11-12 16:18 ` Dinesh Bhandary <bhandary@iii.com>
2010-11-12 16:07 ` Mark Felder <feld@feld.me>
2010-11-12 18:48 ` Dinesh Bhandary <dbhandary@iii.com>
2010-11-12 17:46 ` Viktor Bojović <viktor.bojovic@gmail.com>
2010-11-15 16:36 ` Chris Browne <cbbrowne@acm.org>
2010-11-15 21:47 ` Samuel Stearns <SStearns@internode.com.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox