Re: [GENERAL] Visualize database schema

2012-08-20 Thread Johann Spies
On Thu, Aug 16, 2012 at 04:04:48PM +0200, Wolfgang Keller wrote: > > I could not get the script sqlalchemy_schemadisplay3.py to work with > > sqlalchemy 0.7.8-1 (on Debian). > > Have you asked on the SQLalchemy mailing list? No. Thanks for the link. Regards Johann -- Johann Spies

Re: Messy data models (Re: [GENERAL] Visualize database schema)

2012-08-18 Thread Gavin Flower
] Visualize database schema) [...] Also, in some models, there are relations that are so prevalent that including all them just adds noise to the layout when a top-level description would be just as clear and remove the extra lines from the graph. How to code a pure layout algorithm to be able to

Re: Messy data models (Re: [GENERAL] Visualize database schema)

2012-08-18 Thread Wolfgang Keller
> > In fact, shouldn't reasonably well-designed data models at least > > mostly follow SER principles? In that case, they could be displayed > > essentially > as a > > tree. > > No - and what the heck are "SER principles"? Structured Entity Relationship model. It means that the dependency graph

Re: Messy data models (Re: [GENERAL] Visualize database schema)

2012-08-17 Thread Sébastien Lorion
Short answer: no. Even with a good auto-layout, nothing (up to now) beats a human made one because the latter will incorporate semantic which is not available to the modeling tool; for example, positioning, spacing and routing of relations will respect some sense of aesthetic and organization that

Re: Messy data models (Re: [GENERAL] Visualize database schema)

2012-08-17 Thread David Johnston
> -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Wolfgang Keller > Sent: Friday, August 17, 2012 9:08 AM > To: pgsql-general@postgresql.org > Subject: Messy data models (Re: [GENERAL] Visuali

Messy data models (Re: [GENERAL] Visualize database schema)

2012-08-17 Thread Wolfgang Keller
> Concerning auto-layout, most if not all tools I have used up to now > make a mess for anything that is not dead simple. If a data model can not be reasonably "untangled" by an auto-layout algorithm (such as e.g. Graphviz) for display as a human-readable graph, wouldn't that mean that this model

Re: [GENERAL] Visualize database schema

2012-08-16 Thread Wolfgang Keller
> I could not get the script sqlalchemy_schemadisplay3.py to work with > sqlalchemy 0.7.8-1 (on Debian). Have you asked on the SQLalchemy mailing list? http://www.sqlalchemy.org/support.html#mailinglist Sincerely, Wolfgang -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] Visualize database schema

2012-08-16 Thread Johann Spies
On Wed, Aug 15, 2012 at 01:48:45PM +0200, Wolfgang Keller wrote: > > >> Can anyone advice about a tool to visualize a database schema? > > > > > > SQLalchemy, a Python module, can produce dot (Graphviz) output > > > which you can load into your favourite diagramming application such > > > as e.g. O

Re: [GENERAL] Visualize database schema

2012-08-15 Thread Wolfgang Keller
> >> Can anyone advice about a tool to visualize a database schema? > > > > SQLalchemy, a Python module, can produce dot (Graphviz) output > > which you can load into your favourite diagramming application such > > as e.g. Omnigraffle, yEd or Dia: > > > > http://www.sqlalchemy.org/trac/wiki/UsageRe

Re: [GENERAL] Visualize database schema

2012-08-14 Thread Dario Beraldi
Many thanks to everybody for advice! I'll give it a go to the tools you suggested. Dario On 14 August 2012 09:54, Dario Beraldi wrote: > Hello, > > Apologies if this question has been asked before, but I couldn't come up > with a decent solution... > > Can anyone advice about a tool to visualiz

Re: [GENERAL] Visualize database schema

2012-08-14 Thread Merlin Moncure
On Tue, Aug 14, 2012 at 12:14 PM, Wolfgang Keller wrote: >> Can anyone advice about a tool to visualize a database schema? > > SQLalchemy, a Python module, can produce dot (Graphviz) output which you > can load into your favourite diagramming application such as e.g. > Omnigraffle, yEd or Dia: > >

Re: [GENERAL] Visualize database schema

2012-08-14 Thread Edson Richter
Em 14/08/2012 15:47, Scott Mead escreveu: On Tue, Aug 14, 2012 at 5:24 AM, Robert Gravsjö mailto:robert.grav...@imano.se>> wrote: > Can anyone advice about a tool to visualize a database schema? Ideally, I would like something that takes the SQL definition of a schema or databas

Re: [GENERAL] Visualize database schema

2012-08-14 Thread Scott Mead
On Tue, Aug 14, 2012 at 5:24 AM, Robert Gravsjö wrote: > > > Can anyone advice about a tool to visualize a database schema? Ideally, > I would like something that takes the SQL definition of a schema or database > > (essentially the output of pg_dump) and produces a graphical > representation of t

Re: [GENERAL] Visualize database schema

2012-08-14 Thread Wolfgang Keller
> Can anyone advice about a tool to visualize a database schema? SQLalchemy, a Python module, can produce dot (Graphviz) output which you can load into your favourite diagramming application such as e.g. Omnigraffle, yEd or Dia: http://www.sqlalchemy.org/trac/wiki/UsageRecipes/SchemaDisplay Sinc

Re: [GENERAL] Visualize database schema

2012-08-14 Thread Dann Corbit
...@postgresql.org] On Behalf Of Dario Beraldi Sent: Tuesday, August 14, 2012 1:55 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Visualize database schema Hello, Apologies if this question has been asked before, but I couldn't come up with a decent solution... Can anyone advice about a to

Re: [GENERAL] Visualize database schema

2012-08-14 Thread Sébastien Lorion
Concerning auto-layout, most if not all tools I have used up to now make a mess for anything that is not dead simple. One exception I found is Embarcadero Data Architect ( http://www.embarcadero.com/products/er-studio-data-architect). It's not free, but there is a trial you can use and then you can

Re: [GENERAL] Visualize database schema

2012-08-14 Thread Zdeněk Bělehrádek
Hello, Apologies if this question has been asked before, but I couldn't come up with a decent solution... Can anyone advice about a tool to visualize a database schema? Ideally, I would like something that takes the SQL definition of a schema or database (essentially the output of pg_dump) and

Re: [GENERAL] Visualize database schema

2012-08-14 Thread Johann Spies
On Tue, Aug 14, 2012 at 09:54:34AM +0100, Dario Beraldi wrote: > Can anyone advice about a tool to visualize a database schema? > Ideally, I would like something that takes the SQL definition of a > schema or database In addition to other suggestions: postgresql-autodoc is another option. Regard

Re: [GENERAL] Visualize database schema

2012-08-14 Thread Robert Gravsjö
> Can anyone advice about a tool to visualize a database schema? Ideally, I > would like something that takes the SQL definition of a schema or database > (essentially the output of pg_dump) and produces a graphical representation > of the tables, constraints and indexes which can be moved aroun

Re: [GENERAL] Visualize database schema

2012-08-14 Thread José Pedro Santos
Hi, I use to visualize a database schema Quantum GIS or UDIG. Both are open source software and very esay to add a database schema. Best Regards, José Santos Date: Tue, 14 Aug 2012 09:54:34 +0100 Subject: [GENERAL] Visualize database schema From: dario.bera...@gmail.com To: pgsql-general

Re: [GENERAL] Visualize database schema

2012-08-14 Thread John R Pierce
On 08/14/12 1:54 AM, Dario Beraldi wrote: Hello, Apologies if this question has been asked before, but I couldn't come up with a decent solution... Can anyone advice about a tool to visualize a database schema? Ideally, I would like something that takes the SQL definition of a schema or dat

[GENERAL] Visualize database schema

2012-08-14 Thread Dario Beraldi
Hello, Apologies if this question has been asked before, but I couldn't come up with a decent solution... Can anyone advice about a tool to visualize a database schema? Ideally, I would like something that takes the SQL definition of a schema or database (essentially the output of pg_dump) and pr