Sunday
Feb182007
Database Design Tool with Some Rails Smarts
Sunday, February 18, 2007 at 5:34AM
SQL Editor is an entity relationship diagram (ERD) tool for OS X with a tie-in to Rails. This might be of interest to folks who want to bring complex database designs into a Rails app, though I think there might be some mismatch there between the idea of big design up front and Rails more agile TDD approach. Anyhow, the idea is that SQL Editor lets you build this:
And with a single save operation get this:
SQL Editor certainly doesn't have all the bells and whistles of some of the high-end ERD tools I've used under Windows, but for a $69 shareware package it's serviceable enough. In addition to generating Rails migrations, it can export DDL for MySQL, Postgresql, or Oracle, as well as reverse engineer existing databases via JDBC.
And with a single save operation get this:
SQL Editor certainly doesn't have all the bells and whistles of some of the high-end ERD tools I've used under Windows, but for a $69 shareware package it's serviceable enough. In addition to generating Rails migrations, it can export DDL for MySQL, Postgresql, or Oracle, as well as reverse engineer existing databases via JDBC.
Reader Comments