wwwsqldesigner short review


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!


There is a small tool bar to the right, very simple and intuitive to
use, it is grouped in 4 areas:

  1. Save/load
  2. Table actions (Add,Edit,Keys,Remove,Align,Clear)
  3. Field actions (Add,Edit,Up/Down,foreign key management, remove field)
  4. 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

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.


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


Product: wwwsqldesigner
Comment: a very productive tool
Rating: 4.0/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