[clug-talk] Web Based Data Modeling Tool

sgrover sgrover at open2space.com
Thu Aug 9 00:22:42 PDT 2007


Hello Everybody!

I got to playing with JavaScript a couple months ago and came up with a 
web based database modeling tool that can automagically generate the SQL 
scripts needed.  I decided to put this out to the general public and am 
real close to getting it set for the "official" release.  But I'm 
looking for some folks to help me test it out properly, and thought of 
my good friends here at CLUG first.. :)

If you'd like to take a look, you can find the site at 
http://scriptgen.open2space.com.  (DNS propagation may still be 
happening, so if the URL doesn't work, please try again in a day or so...)

There are a couple minor issues I know of that need to be dealt with 
before I do the "official" release.  The two biggies are:

- FireFox only.  IE isn't playing well with the tool (no surprise there).
- Save / Load.  I've had to disable this for now until I figure out what 
piece is missing in my PEAR configurations.

The tool as is allows multiple tables, Foreign Key relationships, 
drag/drop of the tables (relationship lines are redrawn as needed), and 
selection of different data engines (currently MySQL and PostgreSQL, and 
a generic thing).

The website has forums setup for discussions and bug reports.  Please 
use those rather than the CLUG lists.  Or email me directly.

Thank you to anyone who helps out.

Shawn



More information about the clug-talk mailing list