Mantis Bugtracker

Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000124 [sqliteman] GUI major always 2008-02-22 22:48 2010-02-11 20:39
Reporter pmycro View Status public  
Assigned To subzero
Priority normal Resolution fixed  
Status closed   Product Version
Summary 0000124: GUI Layout
Description There a few issues with the GUI layout I have found.
The biggest issue is that it is hard to resize the query result window to more than a 1/3 of the screen even when the application is maximized. This is a MAJOR issue as databases with thousands of rows are commonplace. Being able to see only 10 at a time isn't very useful. This shouldn't be a major fix as it simply requires changing the minimum sizes for the query and error boxes, or perhaps using a split pane which would allow them to be hidden if necessary.

The second issue I noticed is that the toolbars in the main window didn't change position properly when the window is resized, particularly the one in the middle. To reproduce this bug, simply move the middle toolbar and then place it back in its original location. When resizing the window, it won't act as a 'docked' toolbar

Anyways, that's all I have for now. I hope these comments are helpful.
Additional Information
Tags No tags attached.
Attached Files

- Relationships

-  Notes
(0000190)
subzero (administrator)
2008-02-23 11:04

can you provide sample screenshots, please?

And what operating system are you using? Which Sqliteman and Qt version?
(0000196)
subzero (administrator)
2008-03-14 11:36

please, attach screenshots and OS informations. I cannot reproduce it at all.
(0000197)
pmycro (reporter)
2008-03-20 01:27

I retract the second comment. It seems to be possible, although you have to know what to expect.

In terms of the query result window not being able to be resized much, this is still an issue. This has to do with the large minimum size of the query window when it is present.

In terms of the OS I am using, it is Windows. My screen resolution is 1280*800.

I hope this clarifies it a bit
(0000198)
bugger (reporter)
2008-03-20 17:40

version 1.1.0svn:
I also found the squeezed space for the result set/table annoying. The error pane can be easily reduced to status bar message (or at least a dockable pane so that I can hide it or move it under the table treeview on the left).

The query textbox could be made dockable, too, and its minimal height should be one line, not several. The horizontal scrollbar should be made visible only when necessary and hidden for most of the time (I doubt that most people will write such long sql query that runs over the screen all the time!) The cursor position indicator (Col 4 Row 1/1) really belongs to the status bar (in my humble opinion) rather than taking up a substantial portion of vertical space.

I guess I can alway use the snapshot function if I need to see more rows at the same time, but that is just one extra step plus I will need to use the mouse to do that (since I haven't found a keyboard shortcut for that yet).

While I'm at it, there are a few more GUI issues (maybe a new task for this?)
1) the toolbar positions / item order are not persisted after app closing. After restarting, everything is back to default.
2) the toolbar function should be available at the menu, too, so that I can hide the toolbar and use accelerator keys for those instead of reaching for the mouse.
3) ctrl+A in the query editor should select all, not go to alter table! (it is just so counter-intuitive for any frequent keyboard shortcut user)
4) the auto-resize in the data table works well for long column but not for short columns such as column containing only small integers (the default width is too wide and wastes too much screen real estate...)

Hope these comments are helpful.
(0000285)
subzero (administrator)
2009-11-02 21:29

all GUI parts (item tree, data viewer, sql editor) can be switched on/off. Issues mentioned in additional notes are fixed too (toolbars, ctrl+a etc).

Committed revision 500.

- Issue History
Date Modified Username Field Change
2008-02-22 22:48 pmycro New Issue
2008-02-23 11:04 subzero Note Added: 0000190
2008-03-14 11:36 subzero Note Added: 0000196
2008-03-14 11:36 subzero Status new => feedback
2008-03-20 01:27 pmycro Note Added: 0000197
2008-03-20 17:40 bugger Note Added: 0000198
2009-11-02 21:29 subzero Note Added: 0000285
2009-11-02 21:29 subzero Status feedback => resolved
2009-11-02 21:29 subzero Fixed in Version => 1.3svn
2009-11-02 21:29 subzero Resolution open => fixed
2009-11-02 21:29 subzero Assigned To => subzero
2010-02-11 20:39 subzero Status resolved => closed


Mantis 1.1.7[^]
Copyright © 2000 - 2008 Mantis Group
Powered by Mantis Bugtracker