NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.
All the Perl that's Practical to Extract and Report
use Perl Log In
davorg (18)
davorg
dave@dave.org.uk
http://dave.org.uk/
Yahoo! ID: daveorguk (Add User, Send Message)
dave@dave.org.uk
http://dave.org.uk/
Yahoo! ID: daveorguk (Add User, Send Message)
Hacker, author, trainer
Technorati Profile [technorati.com]
Monday February 02, 2004
12:21 PM
SQL Fairy
Today I have been mainly playing with the SQL Fairy (aka SQL::Translator).
After watching it install about half of CPAN are prerequisites and finally being galvanised into going thru the pain of installing libgd and GD.pm I finally got to try it out. And it seems like a pretty useful piece of code. It translates SQL DDL between various storage formats. That might be actual DDL code (in various dialects) or perhaps XML or YAML. It'll even have a good stab at drawing a picture of your database (that's what it needs GD for).
I'll be adding it to my standard toolbox.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
--Larry Wall in stab.c from the perl source code
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.
common (Score:3, Funny)
Are there any other kind of modules anymore...?
Reply to This
Re:common (Score:1)
Half of CPAN (Score:1)
Well, we've tried hard not to recreate any wheels unless we really have to. Would you rather we wrote our own bitmap output library? ;)
(darren)
Re:Half of CPAN (Score:3, Interesting)
But if you end up pulling in the annual combined output of Goodyear and Michelin?
What I would like to see is better composability (and therefore decomposability) of modules, so that one pulls in only the parts one is really using.
Re:Half of CPAN (Score:2)
Of course I still need to munge the Makefile some more to make it interactively ask if it should install $module if the user wants / needs it for something.
Autodia has been doing Database Diagrams (from DDL/SQL or DBI and even Druid XML) for yonks. Hopefully I can add the new pureperl directed graph module as an alternative to GraphViz.
If you have databases in Dia you might want to check out tedia2sql which handl
@JAPH = qw(Hacker Perl Another Just);
print reverse @JAPH;