Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Maintaining diagrams in a Perl way?

by neilwatson (Priest)
on Sep 22, 2004 at 19:03 UTC ( [id://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
watson-wilson.ca

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

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?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others wandering the Monastery: (5)
As of 2024-03-29 06:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found