[TriLUG] Data Modeling Tools

[Owen]

I've been using DbVisualizer (http://www.minq.se/products/dbvis/)
against DB2, but it also supports MySQL and PostgreSQL. The free version
has a few features disabled, but the paid for version isn't too
expensive anyway. Downsides are that it isn't open source (not
everything can be), and that it's a Java app (matter of opinion), but
pretty well behaved as far as Java GUI apps go.

Owen

On Thu, Aug 30, 2007 at 11:03:37AM -0400, Glenn Starling wrote:
> I'm designing a a new database application with about 30 tables.  What
> back-end design tools do you use and/or recommend?  Database will be
> MySQL 5.0 running on Ubuntu.  At this stage, switching to PostgreSQL
> would not be out of the question if there was a good reason.
> 
> The design tools I have tried (MySQL Navigator, MySQL Query Browser,
> Workbench, Ferret) all seem to be weak compared to Erwin and some of the
> ones that come with Oracle, SQL Server, and Access.  Some support for
> stored procedures and stored functions is mandatory.  Naturally, there
> is a strong preference toward open source.
> 
> Thanks!
> 
> -- Glenn