An Architect's View

36 responses so far ↓

• 1 moises // Jun 20, 2006 at 11:57 PM

  You should try SQLYog, it's fast, easy and very powerful. And they have a free version. Head up to www.webyog.com and take a look.

• 2 Jerry Hamby // Jun 21, 2006 at 12:13 AM

  On my Mac, I use Navicat and SQL4x Manager J

• 3 Sean Corfield // Jun 21, 2006 at 12:16 AM

  Moises - this post was tagged "osx" - SQLYog looks like Windows only which is no use to me.
  
  Jerry, so Navicat is worth the money? More details about SQL4x Manager J?

• 4 Sean Corfield // Jun 21, 2006 at 12:22 AM

  Jerry, I found SQL4x Manager J and downloaded it and tried it but the MySQL connector stuff didn't install properly and it seemed clunky and non-intuitive. So I uninstalled it.

• 5 John Barrett // Jun 21, 2006 at 12:26 AM

  Hi Sean,
  I use Navicat, and I would say, yes it is worth the money! You can use it free for 30 days,and then make your choice(that is what I did). I am not sure what else is out there for Mac only, but I have been so happy with navicat that I have not looked.
  

• 6 Jerry Hamby // Jun 21, 2006 at 12:52 AM

  To be more clear, I use Navicat for MySQL and I use SQL4x Manager J for Microsoft SQL databases. If Navicat could support MS SQL, I would only use Navicat. I think it's worth the money, they also make Navicat for Windows and Linux.

• 7 dickbob // Jun 21, 2006 at 1:56 AM

  Aqua Data Studio from www.aquafold.com is worth a look.

• 8 Roger Lancefield // Jun 21, 2006 at 2:43 AM

  I found the pre-7.0 versions of Navicat (on Windows) to be the most bug-ridden commercial software I've ever used. I'm not going to list all my complaints here, but suffice it to say that it was like a bad alpha build until v7.0 was released. What's more, after being initially helpful, or at least honest and admitting to bugs and glitches, Navicat support didn't respond to two of my support requests (about further buggy behaviour), something which left a further bad taste.
  
  Having said all this, post 7.0 versions are much improved it seems (again, on Windows). Yes, I stuck with it because the 'competition' seemed little better. Now that it has settled down I find it to be a very useful application -- for me, worth the money. It certainly slaps a more relaxed face on MySQL and has some genuinely useful functionality wrapped up in simple commands (such as the database backup and data transfer). Not sure to what extent the Win32 version is comparable to the Mac version in terms of reliability, but anyway, for what it's worth...

• 9 Wayne McFetridge // Jun 21, 2006 at 2:46 AM

  I got put onto Navicat (windows) and I think it is great.

• 10 Tom Chiverton // Jun 21, 2006 at 2:52 AM

  I use MySQL's mysqlcc and it's great - simple and powerful GUI.

• 11 Joc // Jun 21, 2006 at 3:17 AM

  I used to use YourSQL which is open source I think. Unfortunately it doesn't want to play on the MacBook Pro.

• 12 shimju david // Jun 21, 2006 at 3:41 AM

  install php and run this killer app "phpmyadmin.net"

• 13 brian // Jun 21, 2006 at 4:52 AM

  I agree with dickbob, Aqua Data Studio is worth a try.

• 14 bob // Jun 21, 2006 at 4:54 AM

  Aqua Data Studio is definitely worth checking out!

• 15 Rick // Jun 21, 2006 at 5:03 AM

  Yep, Navicat get's my vote, I use it for both OSX and on Windows. MySQL administrator is quite good too but doesn't have all the useful back kind of stuff that Navicat has. Also transferring data or synchronising data and / or structure of databases is possible and works pretty well. So yep, worth the money IMHO. For anyone that's come from using something like Access where you've got a visual interface to the database to using MySQL and all it's command line nature then Navicat does make it seem much friendlier.

• 16 Joe // Jun 21, 2006 at 5:47 AM

  Navicat over here too. I played with PHPMyAdmin but the interface started bugging me. Also, if you're not already running PHP, setup can be a bit of a chore. I also found the MySQL admin / Query Browser to be unstable.

• 17 Jeff // Jun 21, 2006 at 6:35 AM

  I don't. I value my data too much to use MySQL. I use PostgreSQL. :-)
  
  Not trying to start any flamewars!

• 18 Doug // Jun 21, 2006 at 6:56 AM

  I use SQLyog. As mentioned above there is a free version - short some "Powertools" which is more a matter of convenience. For a license fee of $9.00 for single user or for enterprise functionality at $47.00 - Well what can you say + you get the "Powertools"?
  I have used Navicat and PHPMyAdmin as well and don't find any major advantages over SQLyog. I really enjoy having the local copy to admin my local and remote dbs.

• 19 Rick // Jun 21, 2006 at 7:08 AM

  There is also Navicat for PostgreSQL for those of that persuasion!

• 20 Jeff // Jun 21, 2006 at 7:58 AM

  I find Aqua Data Studio to be kinda buggy but I use it quite a bit.
  
  I find I use phpmyadmin the most on a day to day basis becuase it loads so quickly.

• 21 Dave Ross // Jun 21, 2006 at 9:42 AM

  I use the MySQL administrator tool - doesn't seem to bad on windows

• 22 Sean Corfield // Jun 21, 2006 at 10:33 AM

  Seems like the consensus is that Navicat is worth buying but I should also try Aqua Data Studio (which seems to be about $50 more than Navicat). I'll download that today. Thanx everyone!

• 23 David Fekke // Jun 21, 2006 at 10:57 AM

  Aqua Data Studio. It is free and works on the Mac. Plus it will work with Oracle and SQL server.

• 24 Jared Rypka-Hauer // Jun 21, 2006 at 2:50 PM

  I may need to update ADS, but I absolutely hate it. I've actually taken to hand-scripting my MySQL DDL and using CFQUERY to execute it. For the money, it's the best thing out there. However that brings up a whole new question:
  
  Should we, as a community, create a CF-based SQL administrator like PHPMySQL that will work against MySQL, SQL Server, and Oracle? Hehehe... yeah, my eyes are rolling back in my head and I'm twitching too. It's a dream, probably a nightmare, but it may be just the thing we're wanting.
  
  I have to say, though, that ADS (proviso: I may need to update the version I'm using), CocoaMySQL, and the MySQL administrator for OSX ALL SUCK PRETTY BADLY so if there's a commercial package out there that works at all it's got my vote before I've even used it. I'll check out Navicat tonight, hopefully, and see how it fares.
  
  Laterz!

• 25 Sean Corfield // Jun 21, 2006 at 3:19 PM

  Jared, there already is a CF version of the PHP admin web app (I don't remember who built it and I don't have a link). If you like the PHP version (I don't!), you'll like the CF version I guess...

• 26 John Barrett // Jun 21, 2006 at 4:38 PM

  oops, I guess no links Sorry!
  it is called cfmyadmin. It is windows only, so I have not tried it.
  John

• 27 Jerry Hamby // Jun 21, 2006 at 5:11 PM

  If anyone was going to build another MySQL admin program using Coldfusion, it should done with a bunch of CFC's in a framework with a beautiful Flex front-end. Maybe an Apollo version for the desktop.

• 28 Sean Corfield // Jun 21, 2006 at 5:31 PM

  John, I remember it now you mentioned it was Windows only... yes, that seemed like a particularly poor design decision at the time and I probably wiped cfmyadmin from my mind based on that.
  

• 29 Chris Scott // Jun 21, 2006 at 6:09 PM

  :~ chris$ mysql -h xxx.xxxx.xxx -u chris -p
  
  AquaDataStudio is good for just running queries and getting statistics, but for full on administration, the command line tools are where it's at!

• 30 Daryl // Jun 22, 2006 at 7:54 AM

  DbVisualizer:
  
  www.minq.se/products/dbvis/
  
  

• 31 Mike Tangorre // Jun 22, 2006 at 10:45 PM

  Sean,
  
  I use "SQL Manager 2005" from www.mysqlmanager.com. The last time I checked it was only available for Winblows but they may have a version for you special people. :-)
  
  I used to use Aqua Data Studio as previous peeps already mentioned, however, I was not too impressed with it. To be fair though, it has been awhile since I checked it out so it may have improved.
  
  Shimju David,
  
  phpmyadmin.net?? Seriously? It sucks!.. royally!
  
  -Tango

• 32 Mike Tangorre // Jun 22, 2006 at 11:06 PM

  Sean,
  
  I use "SQL Manager 2005" from www.mysqlmanager.com. The last time I checked it was only available for Winblows but they may have a version for you special people. :-)
  
  I used to use Aqua Data Studio as previous peeps already mentioned, however, I was not too impressed with it. To be fair though, it has been awhile since I checked it out so it may have improved.
  
  Shimju David,
  
  phpmyadmin.net?? Seriously? It sucks!.. royally!
  
  -Tango

• 33 Mark // Jun 25, 2006 at 3:03 PM

  EMS SQL Manager for MySQL
  
  Looked at Yog & navicat and EMS got chosen. A little quirky in places but has everything I need. The DB compare from EMS is very good too - diff for DBs.
  
  

• 34 cody caughlan // Jun 26, 2006 at 9:46 AM

  I use Aqua Data Studio from Aqua Fold [www.aquafold.com]. Its commercial software but they have non-commercial and eduational licenses available. The great thing about it is that it can connect to pretty much any other DB server, SQL Server, Oracle, Sybase, PostgreSQL, etc. Its a one-stop shop!

• 35 kyle // Nov 30, 2006 at 5:23 AM

  I've been using Navicat on OSX and love it when it works. It hangs frequently and I'm yet to find a rhyme or reason why. Very frustrating, I'm going to try something else.
  
  Interface and functionality are awesome, if they'd get the bugs out it'd be tough to beat.

• 36 Jared Rypka-Hauer // Nov 30, 2006 at 10:27 AM

  I bought Navicat a few weeks ago... no crashes, but it works awesome. Very similar to SQL Designer from Oracle.
  
  J

Leave a Comment