Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Maintaining diagrams in a Perl way?

by neilwatson (Curate)
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
watson-wilson.ca

Comment on Maintaining diagrams in a Perl way?
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

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

Log In?
Username:
Password:

What's my password?
Create A New User
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? | Other CB clients
Other Users?
Others imbibing at the Monastery: (6)
As of 2014-09-23 21:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (241 votes), past polls