Nice product but lacks features

[gplatt]

I've been using SQLyog evaluation daily for hte last two weeks and had some comments.

I find I really enjoy using SQLyog for running queries as it is fast to load and provides a good command window for typing in the queries, however I am dissapointed in a couple of things which I hope you'll add (I tried the search engine to see whether these requests had been made but kept getting errors or no matched foudn when I searched).

1) Ability to edit the result set returned from a query.

2) Export features are weak and don't save the previously used options making it annoying to use.

3) my database name has Swedish characters. I can't seem to figure out how to set the display character set. Actually there are almost no preferences to set in the product (3.71)

I guess Navicat, despite it's slowness and quirks. is still the best tool for me.

— Guy

[Ritesh]

Quote:

1) Ability to edit the result set returned from a query.

You require Edit->Execute Query->Execute for Update…. or you just need to execute the query by pressing F8 instead of F5.

Quote:

Export features are weak and don't save the previously used options making it annoying to use.

Which area do you think SQLyog is weak? Can you tell me the options where SQLyog does not save previously used options? Maybe you are missing something. If its a bug, I assure you that it will fixed within a week.

Quote:

I can't seem to figure out how to set the display character set. Actually there are almost no preferences to set in the product

This feature is planned for SQLyog Max.

Quote:

I guess Navicat, despite it's slowness and quirks. is still the best tool for me.

I would love to know the features that you like in Navicat and is not present in SQLyog.

BTW, have you tried SQLyog 4.0 BETA. It has lot of improvements and bug-fixes. For more information visit: http://www.webyog.com/forums/index.php?act…ct=ST&f=2&t=977

[gplatt]

Ritesh,

Thanks for the response. My post was not intended to be a “product A is better than product B” but since I couldn't find anywhere to post an evaluation feedback, and I like using SQLyog, I thought I'd put a post here.

To elaborate on my first post:

Editing:

I guess the biggest feature I miss is easier editing of returned data.

I'd like:

— a “click” sort of the columns while in edit mode

— the ability to oggle the visibility of columns displayed.

Which area do you think SQLyog is weak? Can you tell me the options where SQLyog does not save previously used options? Maybe you are missing something. If its a bug, I assure you that it will fixed within a week.

Great offer for the bug fixes.. I tried the beta and it looks like you might have fixed them already. 🙂

Other features:

The Navicat filtering of displayed data is pretty cool. SQLyog's quick filters are neat, but I like the ability to build a complex where clause with the Navicat filters. Mind you I find that as I get better at just typing what I want I am quicker in SQLyog. Now that I know about the F8 key SQLyog is working pretty well for me.

Dragging and dropping tables from one database to another is pretty handy feature. Itr seesm that we're often building test databases to try something on. I like the ability of dragging the tables I want to a new database.

thanks again

Guy

[Ritesh]

Quote:

— a “click” sort of the columns while in edit mode

— the ability to oggle the visibility of columns displayed.

These options are planned for SQLyog Max.

Quote:

Dragging and dropping tables from one database to another is pretty handy feature. Itr seesm that we're often building test databases to try something on. I like the ability of dragging the tables I want to a new database.

The above feature is also planned for SQLyog Max.

Quote:

The Navicat filtering of displayed data is pretty cool. SQLyog's quick filters are neat, but I like the ability to build a complex where clause with the Navicat filters. Mind you I find that as I get better at just typing what I want I am quicker in SQLyog. Now that I know about the F8 key SQLyog is working pretty well for me.

What you want to do is currently available using F8 option. I guess you want a GUI to do the same. Am I correct?

[gplatt]

Quote:

What you want to do is currently available using F8 option. I guess you want a GUI to do the same. Am I correct?

Of course 😀

GUI's are nice when I've had enough of typing.

Thanks for letting me know about the planned features. I'll go buy a copy now 😎

— Guy

[zzapper]

Hi Y'All

Edit->Execute Query->Execute for Update…. or you just need to execute the query by pressing F8 instead of F5.

Just the answer I woz a lookin' for!!!

That is sooo cool!!!

[JBB]

Hi,

i've been looking and testing different kinds of mysql gui/ide apps these past few days.

I have a final project to do @ college and we can use any type techonologies/tools as we wish. I decided to do a web application with mysql. The only experience i have managing mysql databases is with phpmyadmin.

I had the pleasure working with a great IDE program called pl/sql developper (http://www.allroundautomations.com/) with Oracle during the past 2 years.

I tested about 10 applications so far, and i would put sqlyog in the top 3. But not of them has come close to pl/sql developper.

i like sqlyog simply because it's one of the fastest apps i've used so far. It has some good features, but lacks a few i've been spoiled to 🙂

I would really like to see :

• a command line window ( like in pl/sql dev )
• autocomplete ??
• query builder ( like in pl/sql dev )

the other apps that i like for the moment are : navicat, EMS MySQL Manager, Aqua Data Studio and Toad Mysql

[Ritesh]

Why do you require a command line window?

Auto-complete and query builder are planned for SQLyog Max 😀

[JBB]

Mostly to be able to execute/develop scripts on the fly, also improve the text output ( so we are not limited to 80 cols, like in the command prompt ).

The command line also comes with an editor (check screenshots ) which really comes in handy for creating scripts. We are not limited to one query result in the command line window, we can scroll back up and view our history. We can also execute our old commands by pressing up on the keypad….it's basically the same command line of but with nice features / improvements

As for the query builder, what's great in pl sql , it automatically detects if there's a relationship between two tables….we are giving the option to join the keys or not. I haven't seen a mysql gui do this yet.

Depending where the query builder was called from…it will generate the sql for us.

If it was called from the command line dialog, it will execute the sql…if it was called from the editor, it pastes the code in the editor.

[Ritesh]

Thanks for your reply.

You can switch between result in Text and Grid by pressing Ctrl+L. You can execute multiple queries together by pressing Shift+F5 and different result will come in different tabs. You can then switch between multiple tabs to compare results. I guess this is what you want. Am I right?

An advanced query builder and diagramming tool is under development for SQLyog Max.

[Author]

Posts