#443 Multiple query windows or tabs

[Anonymous]

Originally created by: a...@anse.de
Originally owned by: a...@anse.de

Reported as bug #1728342 by broker@sf on 2007-05-30 07:02

I use query windows alot, and usualy I have several queries i run
alternatively. Now I have to select query and run just selected code. Also,
i oftenneed to be able results of seveal queries at the same time.

I would like to be able to have several query windows that act
independently on each other.

**** Comment 1 by rosenfield@sf, 2007-06-08 01:46

I think we've heard this RFE before, the issue of multiple query tabs has
been lingering for some time now.  It requires a reasonably large effort to
make all the required changes though, so noone has picked it up (yet).

Any chance that you could use multiple instances of HeidiSQL instead?  I
know it's not a perfect solution, but perhaps it can be made to work
satisfactorily, until someone has enough time to do the multi-tabs thing..

**** Comment 2 by ansgarbecker@sf, 2007-06-08 05:15

The plan for implementing query tabs has some side requirements which have
to be solved, most important one is the threaded execution of each query,
so they don't disturb each other. Although I could imagine to do that with
one application thread, while using a new connection for each query-tab.

I think for the first start we should simply implement the tabs graphical,
and add the code afterwards.

One graphical question is: Should the tabs-control (TPageControl) be
visible as long as you only have one query-window? I think yes. Although
Firefox fx doesn't do that if you have only one webpage open. But we should
start with a simple solution.

**** Comment 3 by broker@sf, 2007-06-08 13:38

I do not see need for multithreading. I do not need to execute queries at
the same time, just to have separate window for each query, so I can easily
switch from one to another. You may use one connection for all queries,
maybe just separate datasets to keep results available.

Tabs are ok, but I would prever separate window so I can resize them to be
able to see result of one query while creating another.

**** Comment 4 by rosenfield@sf, 2007-06-10 23:57

In that case, HeidiSQL can already do what you want.
You can have two open windows using the same connection profile, no
problem.

With one session open, click the 'new connection' icon and choose the same
saved session again.  Switch between the two windows using ALT-TAB or the
window list in the menu 'Window'.  Or switch back and forth using the
window list that pops up when clicking the arrow to the right of the
connection icon (first button on toolbar).

[Anonymous]

Originally posted by: rosenfie...@gmail.com

(No comment was entered for this change.)

Labels: -priority-default Severity-Default

[Anonymous]

Originally posted by: a...@anse.de

(No comment was entered for this change.)

Labels: -migrated

[Anonymous]

Originally posted by: a...@anse.de

(No comment was entered for this change.)

Summary: Multiple query windows or tabs

[Anonymous]

Originally posted by: a...@anse.de

Issue 917 has been merged into this issue.

[Anonymous]

Originally posted by: eli.rash...@gmail.com

could be a nice addition to a perfect program

[Anonymous]

Originally posted by: saf...@gmail.com

This is much needed feature.

[Anonymous]

Originally posted by: rosenfie...@gmail.com

kalvaro, I've deleted your comment (comment #8).  It seemed to be a citation, but
not from this issue, and it lacked a reference as to where it came from (or why it
was relevant).

[Anonymous]

Originally posted by: kAlvaro

It's alright. It was a reply to comment #7, which is also gone.

[Anonymous]

Originally posted by: murray.h...@gmail.com

this would be great

[Anonymous]

Originally posted by: a...@anse.de

Adding multiple query tabs will leave the Data tab in some inconsistent state. The
table tab should die in the near future (issue #436), so the Data tab should. We can
instead create a query tab per table and implement a query parser to enable result
editing for simple SELECTs (issue #723).

[Anonymous]

Originally posted by: samueljo...@gmail.com

This is something that the official "MySQL Query Browser" actually does quite well.
I find that I'm using Heidi for most things but if I need to a lot of "query" work, I
have to go back to the Query Browser because it's more convenient.  It would be great
to have multiple query tabs in Heidi

[Anonymous]

Originally posted by: a...@anse.de

Issue 1120 has been merged into this issue.

[Anonymous]

Originally posted by: Maaarti...@gmail.com

> Tabs are ok, but I would prever separate window so I can resize them...

I would NOT. I already use multiple HeidiSql instances, that's fine, but I still
need more query tabs (having more windows would be terrible for me).

[Anonymous]

Originally posted by: murray.h...@gmail.com

Perhaps HeidiSQL can give us a choice - unlimited query tabs in the main window, and
the ability to turn any query tab into a separate window if we want to (and put it
back as a query tab if we decide preferably).

[Anonymous]

Originally posted by: kirankon...@gmail.com

Addition of more query tabs would be wonderful. What I am also missing is the ability
to change the query shortcut key. For instance I want to execute a single line query
and I have to hit shift+ctrl+F9 : Can we change it to Ctrl+Enter by any chance? Can we
modify regex values (Like plists in Mac!) to achieve the results?

[Anonymous]

Originally posted by: a...@anse.de

Custom keys were requested issue #536 .

[Anonymous]

Originally posted by: taterb...@gmail.com

I totally agreed. It would be wonderful.

If you mix it up with connection tabs also, I would be in heaven. If you lads want to
see how somebody made this look good.. download a trial of Quest's Toad for Oracle to
get some inspiration around tabs. Copy with pride!

[Anonymous]

Originally posted by: a...@anse.de

Issue 1275 has been merged into this issue.

[Anonymous]

Originally posted by: byte...@gmail.com

can i get your email ansgar.becker ?

[Anonymous]

Originally posted by: a...@anse.de

Not for feature discussions please - that should always be done here in the tracker.

[Anonymous]

Originally posted by: a...@anse.de

For stuff other than feature discussions you can use my username (see above) plus
googlemail.com.

[Anonymous]

Originally posted by: a...@anse.de

Just started working on this stuff.

* The default "Query" tab will stay, you can add new tabs starting then with "Query
#2", "Query #3" and so on. Only these new tabs will be removable, the default Query
tab will always stay.
* Creating a new tab is done by either doubleclicking the empty space besides
existing tabs or by rightclicking any tab > "New tab". Pretty similar to FireFox's logic.
* Removing a tab is done by either doubleclicking it, rightclicking > "Close tab" or
by clicking a new "X" button on the tab
* Code: To avoid implementing tons of workarounds for accessing e.g.
SynMemoQuery.Lines I'll introduce relevant properties for these:
  SynMemoQuery => ActiveQueryMemo
  lboxQueryHelpers => ActiveLboxQueryHelpers
  QueryGrid => ActiceQueryGrid
  QueryGridResult = ActiveQueryResult
  ...

Feel free to comment with nice ideas to implement.

Labels: Benefits-Many Feasibility-Medium Usability

[Anonymous]

Originally posted by: eli.rash...@gmail.com

you can add the "+" button like in the new firefox to open a new query tab.

thanks ansgar.

[Anonymous]

Originally posted by: a...@anse.de

This issue was closed by revision [r2544].

Status: Fixed

[Anonymous]

Originally posted by: eli.rash...@gmail.com

hi,

all changes looks very great thanks for the great work,
i think there is a small bug when in data tab you try to invoke the filter, if you
try to paste your selection by clicking the right button of the mouse when hovering
in the filter small input field from the right, you will get always the menu for
adding a new tab instead of copy,paste,etc....

thanks