Install
Download from http://code.google.com/p/wwwsqldesigner/
Very easy installation: you need a webserver running, unpack
wwwsqldesigner it in a folder, setup your virtual host (I use
personal domain for my pc), all done!
Use
There is a small tool bar to the right, very simple and intuitive to
use, it is grouped in 4 areas:
- Save/load
- Table actions (Add,Edit,Keys,Remove,Align,Clear)
- Field actions (Add,Edit,Up/Down,foreign key management, remove field)
- Option & Documentation
You can also load data directly from existing db, to do so you have to
edit your backend file, for me is backend/php-mysql/index.php
function setup_import
. Be careful, if you load a db and you think to have
canceled the action, actually you don’t and the action is performed
at a random time in the future, so wait to action execute, then clear
table.
Save/load your data
For save I like php-file backend, it is needed set
backend/php-file/data folder writeable by web server, when project is
complete generate sql, and all done.
Conclusions
I used dia ( http://projects.gnome.org/dia/ ) in the past for design/modify db, wwwsqldesigner is very db specific tool, so it is probably a more productive solution
Summary
Product: wwwsqldesigner
Comment: a very productive tool
Rating: /5
Long comment: with this tool you can design a new database or load existing design it has all you need as db designer and support a number of different databases, also as backend to load/save your projects