Navicat 8 for MySQL Released

We have just upgraded our copies of the fantastic Navicat 8 in the office from version 7 and first impressions have left me disappointed.

2007-08-02 16:46:00.0

Navicat 8 for MySQL Released

We have just upgraded our copies of the fantastic Navicat 8 in the office from version 7 and first impressions have left me disappointed.

The upgrade process was fast and easy and I had it installed and activated within minutes. The most important thing to me and the bit I was looking forward to was the code-completion when writing queries. Sometimes you have so many field names you cant remember the exact name of all of them so the code-completion would be a God send. Its there alright but not as good as I thought it would be.

For instance, its not really automatic while typing. To activate it for SQL statements/functions etc you have to press CTRL+SPACE and even then it only gives you the name of the function, not the syntax like Visual Studios Intellisense gives you.

Another problem is when your dealing with named tables. You get a blank code-completion window when you try and use p.fieldName from a query detailed as "FROM pages AS p" It does work if you use pages.fieldName in other words, you have to call the table name explicitly.

Another problem I found after using it literally 3 minutes, was a hard crash (and repeating exception window) after I clicked new stored procedure and then cancelled it without doing anything else. I am guessing the app was developed with Delphi as I have seen the same type of problem with Homesite.

One of the most annoying things I found was that they no longer open objects in the tree using a single click. You have to double-click databases/tables etc to open them which when your used to 3 generations of the app over the last 4 years, its quite annoying. I thought surely they would have a Preferences dialog but unfortunately this was not an option in here although they do have quite a few customisable sections.

The good part was that it imported all my settings from Version 7. The app is also slower to start up which is one of the things I loved with Version 7 - It was so fast. Accessing databases online is also slower for some reason.

Overall, there is no real benefit to upgrading to Version 8 so I would hold off until an update is released before shelling out more cash for a product that doesnt necessarily improve anything.

Find Out More : Navicat 8 Official Website

Tags: MySQL | Reviews | Tools
Add to your del.icio.us    DIGG This!    Technorati Cosmos Link    Post to Reddit    Add to your Furl    Add to Blinklist
Comments [4] - Leave a comment

Comments

O?uz Demirkap? said:
Using it for a while and very happy about the new version. :)
Ken Lin said:
I am product manager of Navicat. We are pleased to receive your comments on Navicat 8 and our development team will review your comments. Thanks once again for your suggestions and we will continue to enhance our Navicat. We will keep in touch with you.
Roso said:
Yes, you're quite right about the double click on the DB in order to open it, I rather have one click to open the DB and double click to open the tree view of that DB. One improvement that I needed and it works on version 8 is that I can change the name of a stored procedure, which is not working in 7. Otherwise, Navicat is the best tool for working with your database server, forget myphpadmin, it is far bellow Navicat in terms of interface and functionality.
Bill Jones said:
How does Navicat compare with SQLyog?

I am a SQLyog user for the last 5 years.