Generating diagrams from PostgreSQL with Python (Re: postgresql_autodoc in Python?)
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? Postgresql_autodoc is unfortunately written in Perl. ;- TIA, And, btw., please respect my .sig, Sincerely, Wolfgang Keller -- NO Courtesy Copies PLEASE! -- http://mail.python.org/mailman/listinfo/python-list
Re: Generating diagrams from PostgreSQL with Python (Re: postgresql_autodoc in Python?)
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. Diez -- http://mail.python.org/mailman/listinfo/python-list
Re: Generating diagrams from PostgreSQL with Python (Re: postgresql_autodoc in Python?)
On Thu, Dec 10, 2009 at 3:48 AM, Diez B. Roggisch de...@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 -- http://mail.python.org/mailman/listinfo/python-list