For a really long time, I’ve been using DBDesigner from FabForce.net.
For those of your who’ve never used it, its a freeware visual
entity-relationship diagram tool, which allows you to make database
designs visually instead of in SQL DDL. You can then use it to generate
the SQL to make your databse design into reality, or even run a
“synchronize” to make any changes you’ve made to the data model
reflected in the database.
Unfortunately, DBDesigner is no longer supported; I understand the
designers have went to work for MySQL on MySQL Workbench. I’ve been
limping along with DBDesigner for some time now, and then I discoverd
I liked the functionality of migrations, but sure didn’t want to give up
my pretty intereface. So, it occurred to me that I could write my own
for working with migrations.
WebERD (working title) is the result of that idea. It has a visual
database designer, using lovely AJAX and Scriptaculous stuff to make it
appear more like a desktop app. Currently, it will generate (somewhat
crippled) migrations from the schema you draw.
I’ve put a decent chunk of hours in on this project, and I’m at a point
where I’d like to see some feedback on what I’ve done so far. If you hop
over to http://test.bryanduxbury.com:8004 (textdrive proxy issues
there…), sign up for an account (please use your email address as the
login), and create a project, I’d appreciate what you all have to say
about the app.
Feature suggestions will be duly considered, and bug reports would be
great. It’s still pretty rough, but I’m pleased with how well it works
for as long as I’ve worked on it so far.
One caveat: for some reason, the app doesn’t work in Firefox. When an
AJAX call is made, Firefox actually crashes. If anyone could suggest a
path to follow to fix this problem, that’d be swell.