Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Developer Center > Navicat

Navicat
Thread Tools
selowitch
Mac Elite
Join Date: Nov 2003
Location: Rockville, MD
Status: Offline
Reply With Quote
Jan 4, 2006, 11:59 AM
 
I've been using Navicat to edit my remote MySQL databases using a very nifty spreadsheet-like interface. It's pretty nice. Unfortunately, even though Navicat is a $99 program, it lacks some of the features of the open-source/free phpMyAdmin.

For example, in pMA you can populate fields containing a foreign key with the contents of a different field in the foreign table instead of, say, its id number — very convenient. This is quite useful because if, for example, we have one table named Players and another named Teams and you're creating an entry for Larry Bird and want to fill in the field for Team, it's much nicer to select "Boston Celtics" from a pick list (which also offers you Detroit Pistons, Dallas Mavericks, Cleveland Cavaliers, etc.) rather than having to look up the the id number for the Celtics in the Teams table and choose/enter that number.

So it looks like even though I have bought Navicat, I'll still need to use pMA from time to time.
     
   
 
Forum Links
Forum Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Top
Privacy Policy
All times are GMT -4. The time now is 11:40 PM.
All contents of these forums © 1995-2017 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.8 © 2000-2017, Jelsoft Enterprises Ltd.,