Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E3848632EA0 for ; Mon, 5 Apr 2010 19:56:40 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 14019-09 for ; Mon, 5 Apr 2010 22:56:30 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-out2.uio.no (mail-out2.uio.no [129.240.10.58]) by mail.postgresql.org (Postfix) with ESMTP id 246C7632588 for ; Mon, 5 Apr 2010 19:56:30 -0300 (ADT) Received: from mail-mx5.uio.no ([129.240.10.46]) by mail-out2.uio.no with esmtp (Exim 4.69) (envelope-from ) id 1NyvDY-0003w9-6c; Tue, 06 Apr 2010 00:56:28 +0200 Received: from ti0153a380-2121.bb.online.no ([83.108.27.77] helo=[10.1.1.200]) by mail-mx5.uio.no with esmtpsa (TLSv1:AES256-SHA:256) user rafael (Exim 4.69) (envelope-from ) id 1NyvDX-0003ld-NY; Tue, 06 Apr 2010 00:56:28 +0200 Message-ID: <4BBA6B13.8080002@usit.uio.no> Date: Tue, 06 Apr 2010 00:58:27 +0200 From: Rafael Martinez User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Peter Eisentraut CC: Tom Lane , pgsql-docs@postgresql.org Subject: Re: Documentation and explanatory diagrams References: <4BB9E69F.9080203@usit.uio.no> <20317.1270476132@sss.pgh.pa.us> <4BB9F919.2090709@usit.uio.no> <1270488458.18421.5.camel@vanquo.pezone.net> In-Reply-To: <1270488458.18421.5.camel@vanquo.pezone.net> X-Enigmail-Version: 0.95.7 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-UiO-Ratelimit-Test: rcpts/h 3 msgs/h 1 sum rcpts/h 4 sum msgs/h 1 total rcpts 2052 max rcpts/h 14 ratelimit 0 X-UiO-Spam-info: not spam, SpamAssassin (score=-8.0, required=5.0, autolearn=disabled, UIO_MAIL_IS_INTERNAL=-5, UIO_PGP_SIGNED=-3, uiobl=NO, uiouri=NO) X-UiO-Scanned: 747F13131E325D621772C8CD0C99187986E91BE1 X-UiO-SPAM-Test: remote_host: 83.108.27.77 spam_score: -79 maxlevel 80 minaction 2 bait 0 mail/h: 1 total 4 max/h 1 blacklist 0 greylist 0 ratelimit 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201004/39 X-Sequence-Number: 5438 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Peter Eisentraut wrote: > On mån, 2010-04-05 at 16:52 +0200, Rafael Martinez wrote: >> Well, I was thinking about DIA [1]. It runs on Unix, Windows and Mac. >> It loads and saves diagrams to a custom XML format and it can export >> diagrams to a number of formats, including EPS, SVG, XFIG, WMF and PNG. > > Preferably, any tool that we would use would save a reasonably plain > text source file that we could check into VCS and would provide a tool > for automatically converting to a variety of target formats. For > example, graphviz could work well. (Not saying that graphviz is the > right tool for producing the kinds of diagrams that you want, but it > provides the right toolchain interfaces.) Dia might, but it would be > interesting to see how human-readable that XML format really is. (This > is necessary for change tracking. I would like to use a diff tool to > see what happened to a diagram over various revisions. If opening the > file in the editing tool, changing one bit, and saving it produces a > completely different machine-readable-only XML mush, then it's no good.) > Hello I mentioned Dia because is the one I have experience with and I know it works with different operative systems. It is not perfect but in my opinion it is good enough and it does a decent job. With Dia: * We have a program that works on Unix, Windows and Mac. * We can create/update a diagram in an easy way without having to learn a new complex/powerful system. * We can save the diagrams in a plain text format that can be check into CVS. * We can convert to a variety of target formats with commandline tools. I have had good experience converting to png and eps. I have made a quick check of some of your concerns: * Changing one bit a diagram and saving it, does not produce a completely different machine-readable-only XML mush. It changes only the portion of the code affected by your changes. A diff will show only the lines affected by your changes. * It looks like the objects in a diagram are saved in the same order they were created. * Modified objects keep their position in the saved file. * The XML format used is human-readable and not so difficult to understand but it has so much information that it would not be a good idea to edit it manually. Straightforward changes will not be difficult to do manually, complex changes have to be done via the program. regards, - -- Rafael Martinez, Center for Information Technology Services University of Oslo, Norway PGP Public Key: http://folk.uio.no/rafael/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAku6axAACgkQBhuKQurGihR2YQCeJCE8ZNR3TgP5rkcBYyeZ/9nl ZfEAn1/HQlw/1IrhY1mGNLRGD9bHzdns =fXkD -----END PGP SIGNATURE-----