Nice Mysql Cc Features

[toastedkatz]

I keep trying to find a good alternative to mySQL CC, which is several years out of print, but for some reason every app I've tried, while adding a ton of great features missing in CC, leaves out some that I've come to rely on. I'll list them here with the hopes that A.) I've merely overlooked them in Yog or B.) They can be considered for a future release.

1) Parenthesis highlighting — With some more complex functions it can be hard to ensure you have the right number of closing parenths, and to tell exactly what each set closes off. MySQL CC did this splendidly, and for some reason I've never seen it elsewhere.

2) Infinite history — Saving queries is of course useful, but what I'd really love to see is a persistent history that remembers EVERYTHING, with a time-stamp. I know, CC doesn't have this either.

3) Smart aliases. Another one not done in CC: It would be great if a table alias could be understood by the client when using auto-complete in the joins.

4) This one might just be me–I really liked how CC has a seperate recolor system for table/field names vs SQL functions. I can't seem to seperate them in YOG, which makes bigger queries a bit harder to read.

5) Selection/Clipboard copy from results grid–sometimes I like to just grab a bit of a result set for copying elsewhere, but I can't seem to do this in Yog?

Thanks!

Geoff

[peterlaursen]

1)  Would be very complicated to implement in the tokenizer.  But the idea is snice

2) What is the difference to the SQLyog HISTORY tab?

3) Alias'es and autocomplete is being considered.  Also a nice feature, but we are uncertain exactly hjow to do this

4) In my YOG table/column names are black, functions are lilac/purple.  This is the standard setting.  Screenshot?

5) You can copy a single cell into clipboard (Ctrl-C).  You can also 'display results in text' and you can copy whatever you like

[toastedkatz]

Hi Peter,

Thanks for the comprehensive reply. For the color issue, I had changed the “keyword” to black—when that is done both functions (“select”) and table/field names show up as black as well. I didn't realize that table names apparently always show up as black (and aren't controlled separately through the preferences), and by setting keywords to that color they were showing the same by design.

For the copy functions, the “Display as Text” function is exactly what I was looking for, thanks.

For the history question, it seems to me that the history is only preserved in a given session, but if the program is shut down and restarted, you cannot access previous histories. Is this not the case?

For the parenthesis question; I do not at all pretend to know better than you how such a feature could be implemented. But it is included in MySQL Control Center, as I mentioned, along with most every PHP editor that I've tried (PHP Designer, Zend, etc).

I might as well add one more function I'm not seeing: is there any way to resort by a given column after running a query (sorry, again a MySQL CC feature I use heavily).

Thanks a million. Responses like yours are a big reason why I'm considering buying your program over some others I'm testing.

Geoff

[peterlaursen]

additional:

1) history is kept in memory only.  An option to save/spoll to a file has been requested before.  It is not that we don't want to do this – just a matter of priority.

2) coloring of paranthesis'es levels:  not really possible without a lot of changes, I think.

I do not understand this question: “is there any way to resort by a given column after running a query”.  The meaning of the word 'resort' in this context?.  Filtering by the contents of a cell will be implemented very soon, if that was the question.

[toastedkatz]

By “resort” I meant “re-sort”…meaning that I can click the column header in the result set to order the results by that column's data, no matter what my original “order by” was, if anything.

[peterlaursen]

sorting and filtering is high priority.  Actually we have fully functiuonal code for the DATA tab that lets you combine a filter with sorting multiple columns.  

RESULT tab is a little more complicated due to the data structure that we use (a linked list).  But we intend to solve this too!

[Author]

Posts