Stories
Slash Boxes
Comments
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

Log In

[ Create a new account ]

davorg (18)

davorg
  dave@dave.org.uk
http://dave.org.uk/
Yahoo! ID: daveorguk (Add User, Send Message)

Hacker, author, trainer

Technorati Profile [technorati.com]

Journal of davorg (18)

Monday February 02, 2004
12:21 PM

SQL Fairy

[ #17151 ]

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.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • common (Score:3, Funny)

    by jhi (318) <jhi@iki.fi> on 2004.02.02 13:33 (#27976) Homepage Journal
    > about half of CPAN are prerequisite

    Are there any other kind of modules anymore...?
  • about half of CPAN are prerequisites

    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)

      > Well, we've tried hard not to recreate any wheels unless we really have to

      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.
      • I manage to only require a handful of modules in Autodia and acheive much the same result.

        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;