Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

Re^2: The Alzabo Schema Editor is Sweet

by autarch (Hermit)
on Nov 20, 2004 at 17:39 UTC ( [id://409268] : note . print w/replies, xml ) Need Help??

in reply to Re: The Alzabo Schema Editor is Sweet
in thread The Alzabo Schema Editor is Sweet

Here's a crazy idea. You could offer patches to Alzabo.

Replies are listed 'Best First'.
Re^3: The Alzabo Schema Editor is Sweet
by castaway (Parson) on Nov 20, 2004 at 19:01 UTC
    Yes, I could. Here's the history, I was originally looking for something that uses Perl/DBI to create/edit/update database schemas with, which I couldn't find any of. Alzabo must of missed my search entirely at that stage, I'm not sure why. So I started to look for CPAN SQL schema type modules, which encompassed as complete a selection of SQL bits as possible. There are quite a few modules, most were disgarded because all they knew were tables.

    As far as I remember, from re-looking at Alzabo just now, it failed my criteria because of that, and because the interface just seemed pretty complex. (For me, that means each module has heaps of methods whose names dont immediately suggest their function). I still didn't notice that it has something to design schemas with, I guess I missed it somehow.

    Anyhow, I'm now basing my tool on SQL::Translator, and contributing code to that. It's probably missing some stuff that Alzabo has, but its understandable (to me), has a nice internal format, which it can convert to/from multiple SQL/other formats (currently Oracle, SQLLite, MySQL, DB2, PostGres, Sybase, TT, GraphViz, HTML... ) which means all I need to build is the actual interface to create/modify the schema objects, and buttons to export/import from the available formats.

    In short, sorry, I would, but at this stage it would probably only be an Producer for SQL::T to make something Alzabo can read, and vice versa.