Generating diagrams from PostgreSQL with Python (Re: postgresql_autodoc in Python?)

[Chris Rebert]

On Thu, Dec 10, 2009 at 3:48 AM, Diez B. Roggisch <deets at nospam.web.de> wrote:
> Wolfgang Keller wrote:
>
>> Hello,
>>
>> I will re-precise my question:
>>
>> Has anyone ever implemented a script in Python that generates
>> documentation (especially diagrams, in a format such as e.g. Dia, Inkscape
>> SVG or Tikz) for a PostgreSQL database either from an SQL script or by
>> connecting to the database?
>
> I've written a schemadiff-tool for postgres based on SQLAlchemy reflection,
> which is a branch of SQLAlchemy and which should become part of the
> upcoming SA 0.6.
>
> http://svn.sqlalchemy.org/sqlalchemy/branches/reflection
>
> It allows you to extract information about the schema of the DB. This could
> be the foundation of your tool.
>
>>
>> Postgresql_autodoc is unfortunately written in Perl. >;->
>>
>> TIA,
>>
>> And, btw., please respect my .sig,
>
> Which is supposed to mean what? Never heard the term courtesy copy.

It appears to be an incorrect expansion of "Cc", which is actually
Carbon copy. Apparently he means all replies should be directly to the
list and not Cc his individual email address.
Which seems strange, because usually mailinglists are smart enough not
to send the author duplicate copies if they're named in the To or Cc
fields.

Cheers,
Chris
--
http://blog.rebertia.com