gnuherds-app-dev
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: database -- Physical Model


From: Davi Leal
Subject: Re: database -- Physical Model
Date: Wed, 21 May 2008 22:48:00 +0200
User-agent: KMail/1.9.7

Antenore Gatta wrote:
> In the mean while find enclosed the "in progress" version, feel free
> to modify, improve, critics, ... , etc it.

Just a little of feedback,


The capitalization used at SQL Implementation [1] of the database is lost when 
the database is created in PostgreSQL.

  [1] http://gnuherds.org/doc/GNUHerds__SQL_Implementation.sql


So I have googled a little up to get a convertion tool directly from the "SQL" 
to "dot" [2].

  [2] http://www.cisl.ucar.edu/nets/tools/NND/db/schema/render.html

  [3] http://tapoueh.free.fr/softs/src/sql2dot.py
        Ref. from: http://tapoueh.free.fr/softs/tools.html


From the SQL Implementation [1], I have removed all the comments, INSERTs, 
etc. up to get the attached gnuherds.sql file.


Following the procedure exposed at [2] we get a PNG image with capitalized 
strings.  However the final PNG is not so cool as the one you are getting 
Antenore! I do not know why.

At the worst case we could improve such sql2dot.py Python script...

Attachment: gnuherds.sql.dot
Description: Text document

Attachment: gnuherds.sql
Description: Text Data

Attachment: sql2dot.py
Description: application/python


reply via email to

[Prev in Thread] Current Thread [Next in Thread]