Feature Suggestion – Column Widths

[kloki]

Hi, I'm quite new to SQLyog but since I purchased a copy, already it has been a great help.

I do however have one little issue with it so far in that the column widths tend to be far too wide making it difficult to see the “wider picture”.

I have read a few discussions in this forum discussing this but most of the date back to at least a year ago. Is there any plans to allow column widths to either stick to the widest entry of data (without the huge trailing gap) or even better to remember the widths chosen by the user?

The first would be an excellent feature in my opinion…

The current way I get around this is either by temporarily re-ordering the column and then putting them back after or using two screens and extending the desktop across them horizontally. Both are not ideal but it's better than nothing.

Another feature I think would be really usefull is highlighting the row(s) that have been ticked.

By the way I'm using version 5.15

Many thanks.

[peterlaursen]

Quote:

Is there any plans to allow column widths to either stick to the widest entry of data (without the huge trailing gap) or even better to remember the widths chosen by the user?

From tools.. preferences there is the setting “Truncate Column Headers….” to make it 'stick to the widest entry of data' .

As far as 'remember the widths' the problem is where to store that information!

[kloki]

Thanks for responding peterlaursen, but I have already selected “Truncate Column Headers” in the tools menu. Without it, it's even worse. I have some columns with data type TinyInt and they are fine, the column fits the width of the number inside the cell

But with Varchar for example, I have a column with long peices of data in (Field Type is varchar) that on my screen shows up 233px wide (this is the longest at 46 characters). But to the right of this data, I still have a large empty gap of 195px width.

So the column is not far off from being nearly twice as wide as it actually needs to be.

Other dimension: Column Name width is 76px (13 chars).

[peterlaursen]

Do you use very long Column names?

Please attach

* a small structure+data dump of a single table

* and a screenshot

illustrating this.

As I wrote: the problem is where to store all that information! There are 4 options:

1) the sqlyog.ini -file. Not usable if there a lot of data!

2) a table in the MySQL database. Only usable on 'localhost' databases

3) windows registry. As we go for a cross-platform release >> no!

4) some kind of embedded database. (XML,MySQL embedded, SQLite). As we use SQLite allready for autocomplete, that would probably be the best. But this is not overnight!

[kloki]

Hi Peter, I have attached a pretty detailed screenshot that should describe the situation quite well. If you really want a small structure+data dump of a single table, I'll send one to you in a private message.

In terms of implementing the “remember column width set by user” functionality, I can understand that this is not an easy thing to do. I would say this is a “would be nice feature” but I am sure that there are plenty of other features that are far more important that you guys are already working on.

The first issue of columns being too wide as described in the screenshot is far more important from my point of view although I wouldn't dream of asking you to do this now 😀 … Just a modification that I think would be a good one to have in some future release.

Many thanks.

[peterlaursen]

This is not expected behaviour if:

* 1: you checked 'TRUNCATE …'

* 2: there is no 'that long data' outside the visible program window.

Please create a ticket here:

http://www.webyog.com/support/ttx.cgi

.. and attach a small dump that illustrates the problem (if you did not overlook * 2:)

[peterlaursen]

Fixed in the development tree.

[kloki]

Just a quick note to say to anyone who might be experiencing a similar problem that v5.16 fixes the problem but make sure that you make a clean install (unistall old version even go as far as deleting the directory in you Program Files).

Remember that any connection profiles you made will be lost so make sure you have all the details for the profiles you want to keep.

Thanks to Peter Laursen for helping sort out the problem! 😉

[peterlaursen]

I must say that I absolutely do not understand if this will be affected at all on the installation method.

This change is in the sqlyog executable and not some other file in the installation directory.

[Author]

Posts