MySQL Front Ends

There's a new one / Which do you use

[timster]

There's a new MySQL/PostreSQL front end for Mac OS X called DataWerkz. It's definitely 1.0, but it shows promise.

Anyone care to extol the virtues of their favorite MySQL front end? Or do you find yourself launching the Terminal to "do it yourself"?

(I'm still looking for the answer to MS SQL Server Enterprise Manager.)

[digitalv]

Wrote two of my own, one web based and one in Visual Basic. Gives me the layout I want and the option to run command-line style when necessary.

What do you need to know about Enterprise Manager? Microsoft SQL is my preferred environment.

[panic]

Using your own customized front end is always the way to go. That way, you can have only the features you need, and none that you don't need.

[timster]

Thanks for the tips.

I used to develop some with VB Script/SQL Server 2000, and found Enterprise Manager very useful.

I'm looking for a product that works basically like Enterprise Manager, runs on OS X, and lets you administrate MySQL databases for use with PHP Web apps.

I've scoped out YourSQL, SQL 4x Manager J, CocoaMySQL, DBDesigner 4, and DataWerkz. (At this piont, rolling my own is not an option.) Anyone like any of these, or is there something better out there?

[stevenmusumeche]

I use EMS MySQL Manager and have found it pretty similar to Microsoft's Enterprise Manager.

[timster]

EMS MySQL Manager

I don't see a Mac version -- am I missing something? Thanks in any case.

[panic]

am I missing something?

You're not missing anything. There just isn't a Mac version.

[aus_dave]

I use Navicat [navicat.com]. You can download a fully featured trial version.

It has some nice features but probably the best one is the ability to copy databases and tables between sites (e.g. from your development machine to the remote site). It is also excellent for loading a table from an Excel file.

[madmac]

I use CocoaMySQL and a local install of phpMyAdmin at mysqladmin.home

I like CocoaMySQL but I just seem to always use phpMyAdmin... maybe because it is was I'm used to.

I'll check out that DataWerkz though.

[mgm_03]

Does anyone know of a tool for creating ERD's (entity relationship diagrams) for MySQL on the Mac? Something like dbdesigner4 and Dezign (they're windows)

I use phpMyadmin for MySQL management but only because it's what the webhosts use. Otherwise, I like Navicat because it has a great interface and is a real application (not web-based).

Incidentally, I came upon a book called Mastering phpMyAdmin (check amazon) for those who, like me, are still new to dbases.

[bcolflesh]

...is a real application (not web-based).

Watch it! ;)

[mgm_03]

what I meant was that it is much faster because it doesn't rely on a client server model. And being free of HTML makes the interface better IMHO. sorry if i touched a nerve.

[humpingdan]

aqua data studio, quite nice or cocoa

but to be honest terminal is always the fav!

[timster]

Well, look at that: Navicat has released a Mac OS X version.

[navicat.com ]