Maintaining diagrams in a Perl way?

neilwatson has asked for the wisdom of the Perl Monks concerning the following question:

I have a drawing that documents tables and relationships in a database. Here is sample. Normally, this is in PDF format which I create from OpenOffice. In the future I will not be the only one who has to make changes to this diagram. However, I am the only one who uses OpenOffice. Is there some Perl way, in the GD modules perhaps, to create this type of diagram and still be relatively easy to maintain?

Neil Watson
watson-wilson.ca

Comment on Maintaining diagrams in a Perl way?

Replies are listed 'Best First'.
Re: Maintaining diagrams in a Perl way? by borisz (Canon) on Sep 22, 2004 at 19:36 UTC
GraphViz::DBI is what you want. Give it a try: `use GraphViz::DBI; print GraphViz::DBI->new($dbh)->graph_tables->as_png;` [download] Boris	[reply] [d/l]
Re: Maintaining diagrams in a Perl way? by Zaxo (Archbishop) on Sep 22, 2004 at 19:09 UTC
GD could do that pretty well, but I think you should look at Graph and GraphViz. That would separate the graphics generation from the content. After Compline, Zaxo	[reply]
Re^2: Maintaining diagrams in a Perl way? by waswas-fng (Curate) on Sep 22, 2004 at 19:58 UTC
Or check out sqlfairy. -Waswas	[reply]
Re: Maintaining diagrams in a Perl way? by dragonchild (Archbishop) on Sep 22, 2004 at 19:30 UTC
There are many 3rd party tools that do this. Most RDBMSes, such as Oracle and Sybase, come with similar tools. I'd look at working with them. If you do have a tool that works and you can GPL it, I would strongly suggest that you do. ERD generation is a big thing. ------ We are the carpenters and bricklayers of the Information Age. Then there are Damian modules.... sigh* ... that's not about being less-lazy -- that's about being on some really good drugs -- you know, there is no spoon.* - flyingmoose I shouldn't have to say this, but any code, unless otherwise stated, is untested	[reply]