Turning off column autowidth
I love using HeidiSQL, but the one thing driving me kind of crazy is that after entering information in the grid view and updating the record, the columns automatically resize to fit the window width. With a lot of columns, that means I usually can't see the data. If there's a preference setting for this, I haven't found it.
I would prefer to have some option to save (and override) the auto-calculated width, because I could see all the columns without scrollbars ;)
for example ... I have date like 2010-01-01 and the width of the column is 15-20px (0,5 cm) bigger than it is necessary ... and if I have 20 such columns :)
for example ... I have date like 2010-01-01 and the width of the column is 15-20px (0,5 cm) bigger than it is necessary ... and if I have 20 such columns :)
I agree with AliG. Auto width calculation is fine but it will never be able to always guess how the user wants to view the data. Therefore, saved column widths would be the way to go. It wouldn't be leaving effort to the user because it could be turned off by default. Anyway, in my experience it actually takes more effort to adjust the widths every time heidi recalculates them.
It's not only date columns that are slightly wider than necessary - it can be because some space is reserved for the cell editing button (...) or control (up and down arrows for dates). In this case I don't think it's possible to squeeze them much.
But... sometimes the extra space is good for readablity because having all columns cramped close with almost no space may look like a mess. Sometimes we need to be able to get rid of the spaces to see more columns. What I'm getting at is you will never be able to make an auto-calculation that will please all users and fit all cases. Correcting date column widths is just a minor problem (if it's a problem at all) while the real solution is remembering user-defined widths - then such small auto-width miscalculations won't matter at all.
For example, I often like to see only the first 10-15 characters of a varchar or text field because that's enough. If a column is a username I usually want to see all text. But if a column contains a 64-character hexadecimal hash then it's useless for me to see it in full, just first 10 characters is enough. I could give you plenty of other examples like that. No program will ever be able to guess all that for the user, that's why I think user-defined widths is the real solution.
But... sometimes the extra space is good for readablity because having all columns cramped close with almost no space may look like a mess. Sometimes we need to be able to get rid of the spaces to see more columns. What I'm getting at is you will never be able to make an auto-calculation that will please all users and fit all cases. Correcting date column widths is just a minor problem (if it's a problem at all) while the real solution is remembering user-defined widths - then such small auto-width miscalculations won't matter at all.
For example, I often like to see only the first 10-15 characters of a varchar or text field because that's enough. If a column is a username I usually want to see all text. But if a column contains a 64-character hexadecimal hash then it's useless for me to see it in full, just first 10 characters is enough. I could give you plenty of other examples like that. No program will ever be able to guess all that for the user, that's why I think user-defined widths is the real solution.
I have the same problem. I spend more time in resizing columns than in other DB operations. It's almost ridiculous that Heidi hasn't still implemented the "save columns width" button.
The optimal solution would be to save widths in memory during the same session even if I switch between tables, plus an "autosize" button to reset them to default calculated widths.
The optimal solution would be to save widths in memory during the same session even if I switch between tables, plus an "autosize" button to reset them to default calculated widths.
Please login to leave a reply, or register at first.