Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic

Re^2: The Alzabo Schema Editor is Sweet

by autarch (Hermit)
on Nov 20, 2004 at 17:39 UTC ( #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.
  • Comment on Re^2: The Alzabo Schema Editor is Sweet

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.


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://409268]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (4)
As of 2020-03-29 07:07 GMT
Find Nodes?
    Voting Booth?
    To "Disagree to disagree" means to:

    Results (169 votes). Check out past polls.