[Phpwm] OT Database Schema Diagram Software

[Andy Cowan]

I've been using Eclipse on OSX and Windows, the way I have it set up is almost perfect for PHP/Symfony/MySQL development. However, the only thing I'm missing from it is decent database (not just MySQL) modelling... I'd looked at Clay and found the same as yourself, and not really found anything else that was comparable even to SQLyog's limited schema designing capabilities.

Now that is an interesting question - is anyone aware of a decent database plugin for Eclipse that covers SQL editing/modelling and possibly schema synchronisation?

A.




-----Original Message-----
From: phpwm-bounces at mailman.lug.org.uk [mailto:phpwm-bounces at mailman.lug.org.uk] On Behalf Of Lester Caine
Sent: 03 October 2008 13:30
To: West Midlands PHP User Group
Subject: Re: [Phpwm] OT Database Schema Diagram Software

Andy Cowan wrote:
> Embarcadero ER/Studio is very good, but totally over the top for most people.
>
> SQLyog enterprise has a basic schema editor, whilst doing a lot of other stuff and being inexpensive.
>
> MySQL workbench is very good.
>
> MySQL Maestro is probably the best all-rounder I've used.
>
> None work on OSX however, I'm still looking for a good schema designer for the Mac. :-(

Of cause if you have not been pulled into the MySQL hype these don't help anyway.
I use Eclipse for probably 95% of development work. Transparent on Windows and
Linux, and I think it runs fine on OSX. There are a number of SQL plugins that
give good results. The Clay packages WAS ideal, and is still available, but is
not generally available outside Japan which is a shame (comes top looking for
'eclipse sql modelling tool' on Google ;) ). There are other modelling tools
that do the job, I'm running SQL Explorer at the moment but that does not go
as far as modelling. http://wiki.eclipse.org/Data_Tools_Platform_Project is
the official support area.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php

_______________________________________________
Phpwm mailing list
Phpwm at mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/phpwm

Wave Rider Internet is a trading style of OpenSense Ltd.
Registered in England and Wales No 04999653