Welcome to WebmasterWorld Guest from 50.17.114.227

Forum Moderators: travelin cat

Message Too Old, No Replies

MySQL Front Ends

There's a new one / Which do you use

     
1:39 pm on Apr 21, 2004 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Aug 1, 2003
posts:815
votes: 0


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.)

1:44 pm on Apr 21, 2004 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Oct 15, 2003
posts:1418
votes: 0


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.

1:48 pm on Apr 21, 2004 (gmt 0)

Preferred Member

10+ Year Member

joined:June 16, 2003
posts:633
votes: 0


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.
3:27 pm on Apr 21, 2004 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Aug 1, 2003
posts:815
votes: 0


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?

5:21 pm on Apr 21, 2004 (gmt 0)

Junior Member

10+ Year Member

joined:Mar 8, 2004
posts:196
votes: 0


I use EMS MySQL Manager and have found it pretty similar to Microsoft's Enterprise Manager.
5:58 pm on Apr 21, 2004 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Aug 1, 2003
posts:815
votes: 0


EMS MySQL Manager

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

1:24 pm on Apr 22, 2004 (gmt 0)

Preferred Member

10+ Year Member

joined:June 16, 2003
posts:633
votes: 0


am I missing something?

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

11:36 pm on Apr 22, 2004 (gmt 0)

Full Member

10+ Year Member

joined:Dec 3, 2002
posts:260
votes: 0


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.

3:03 am on May 10, 2004 (gmt 0)

Junior Member

10+ Year Member

joined:Sept 27, 2003
posts:156
votes: 0


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.

8:16 pm on June 16, 2004 (gmt 0)

Junior Member

10+ Year Member

joined:Aug 4, 2003
posts:174
votes: 0


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.

8:30 pm on June 16, 2004 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 21, 2003
posts:2355
votes: 0


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

Watch it! ;)

7:33 am on June 17, 2004 (gmt 0)

Junior Member

10+ Year Member

joined:Aug 4, 2003
posts:174
votes: 0


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.
11:47 am on July 6, 2004 (gmt 0)

Full Member

10+ Year Member

joined:May 13, 2003
posts:313
votes: 0


aqua data studio, quite nice or cocoa

but to be honest terminal is always the fav!

7:12 pm on July 13, 2004 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Aug 1, 2003
posts:815
votes: 0


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

[navicat.com ]