Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Maintaining diagrams in a Perl way?

by neilwatson (Priest)
on Sep 22, 2004 at 19:03 UTC ( #393023=perlquestion: print w/replies, xml ) Need Help??

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

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;
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,

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

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://393023]
Approved by FoxtrotUniform
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (5)
As of 2020-10-20 06:22 GMT
Find Nodes?
    Voting Booth?
    My favourite web site is:

    Results (209 votes). Check out past polls.