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

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

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 is

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] Visualize database schema

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: [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. Omnigraffle, yEd

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

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:

[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

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

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

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

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)

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

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 tool

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

Re: [GENERAL] Visualize database schema

2012-08-14 Thread Scott Mead
On Tue, Aug 14, 2012 at 5:24 AM, Robert Gravsjö robert.grav...@imano.sewrote: 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

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ö robert.grav...@imano.se 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

Re: [GENERAL] Visualize database schema

2012-08-14 Thread Merlin Moncure
On Tue, Aug 14, 2012 at 12:14 PM, Wolfgang Keller felip...@gmx.net 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

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 dario.bera...@gmail.com wrote: Hello, Apologies if this question has been asked before, but I couldn't come up with a decent solution... Can anyone advice about