Db Gui

[EricBrian]

Does anybody know of any GUIs for Oracle DB and MySQL DB?

For MySQL, I found CocoaMySQL but that program does not work with MySQL 4.1+

For Oracle, I haven't found any at all.

Any help is much appreciated!

Thanks,
Eric

 

[Pengu]

for mysql, try MySQL administrator from mysql.com

not sure about oracle. may be able to find a web-interface for it.

 

[elander]

There is also a GUI to edit data and run queries against the databases, MySQL Query Browser. You'll find it on MySQL's homepage (Developer section).

Another one that works well in combination with MySQL Administrator is YourSQL, you can find it here:
http://yoursql.ludit.it/

 

[mactaco]

SQLNavigator is the biggest for oracle, but i don't know if they have an os x port

 

[elander]

If you want an application that can handle both Oracle and MySQL, you might want to try "dbRadar". There is a demo you can download for free, and registration is $49.95 for the download only version, and $59 for the CD.

http://www.thekompany.com/products/dbradar/

 

[agusgriego]

There's a great app thaht is called Aqua Data Studio that can connect to oracle, sybase, mysql, sql server and more. it has code completion but is built in java though.
it's a great app.

on the other hand a very simple yet effective app is YourSQL, for mysql databases.

 

[andehlu]

phpmyadmin - keep it all web based...... not sure how it runs with oracle but i dont see why it couldnt with a bit of a hack. http://www.phpmyadmin.net/home_page/

ha....well check this out.... never knew...
http://phporacleadmin.org/

 

[mdnky]

For MySQL, I use CocoaMySQL and PHPMyAdmin.

I haven't messed with Oracle for a while now, mainly been using Sybase when I need that kind of 'power', which they provide some tools for. I have heard about the [ulr=http://www.aquafold.com/]Aqua Data Studio[/url] that agusgriego mentioned...the general consensus was it does and ok job. Haven't tried it out myself though.

 

[EricBrian]

Thank you all for the replies.

I am trying navicat for mysql and will give the other recommendations a spin!