Tab by session

nbelfort's profile image nbelfort posted 5 months ago in General Permalink

Is there a way to keep tabs by session? So If I open the database1 session open tabs that were opened with the previous database1 session. I usually worked with different independent databases in which query/tabs are unrelated.

ansgar's profile image ansgar posted 5 months ago Permalink

That was already discussed some time ago. When I implemented support for multiple sessions in one window, I designed it in a way that the left database tree shows these connected sessions, and the tabs were not bound to one session. Instead, you can fire a query in any session you have focused in the left tree.

I know that other clients bind their tabs to a session, and I also see various users seem to expect it that way. I just find it difficult to combine both approaches in HeidiSQL, without losing usability. Especially I have very limited graphical ways on the query tabs for displaying some session-binding.

I could probably introduce some special kind of SQL comment, which you add to a query tab, and which tells Heidi to auto-connect to a certain session when firing the whole query. Something like this:

-- SESSION: "Name of my session"
SELECT ...

But that is highly half-baked...

lotiara's profile image lotiara posted 5 months ago Permalink

Hi guys I love the way Heidisql works. The tabs are not bound to one session. Instead, you can fire a query in any session you have focused in the left tree. In fact it's very usable. I have to use other clients with Postgresdb and the way they work (Dbeaver for instance) is very annoying. You have to open a new Tab write the same select for every DB. Just my 2 cents.

Please login to leave a reply, or register at first.