Skip site navigation (1) Skip section navigation (2)

Re: ER Diagramming Tools?

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: Re: ER Diagramming Tools?
Date: 2007-03-28 22:39:58
Message-ID: Pine.LNX.4.64.0703281532060.11746@salmo.appl-ecosys.com (view raw or flat)
Thread:
Lists: pdxpug
On Wed, 28 Mar 2007, Roth, Gabrielle wrote:

> Sounds like a fact-finding mission is in order!  I'm interested in hearing
> what you find out, Richard.

gabrielle,

   What I've found so far is not encouraging.

   1) Dia-0.95-1 and -0.96 won't compile here. There's a problem with missing
docbook.xslt and glibc doubly-freeing memory or a pointer. T'ain't supposed
to happen with the latter version, but it does.

   Regardless, dia will diagram the schema after it's been defined. I, too,
have read of its ability to generate sql, but have not tried that.

   2) Eclipse with the Azurri Clay plug in does a nice job of letting the
user graphically define tables, fields, and relations, then generating the
sql. I used it about 4 years ago for a small project and it worked well.
However, I don't do java (except in the cup next to the keyboard on the
desk), so I removed eclipse from my system.

   Eclipse is a very large, resource-intensive application. It does not seem
worth while for me to reinstall it for this one schema.

   3) Graphviz does both directed (dot) and undirected (neato) graphs
exceptionally well. If I need to make a picture of the schema, graphviz is
what I'll use.

   I was looking for a tool that would facilitate creating the schema for
this project. There does not seem to be anything more efficient than writing
it by hand. I may draw it just to check that it's all there and tables are
properly related, but otherwise it's joe/emacs in a virtual console for the
job.

Thanks,

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

In response to

pdxpug by date

Next:From: Mark WongDate: 2007-03-28 23:09:10
Subject: Re: Storing Binary Large Objects
Previous:From: Roth, GabrielleDate: 2007-03-28 22:27:39
Subject: Re: ER Diagramming Tools?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group