distal-attribute
distal-attribute
distal-attribute
distal-attribute

Database filter using multiple sessions

User, date Message
Written by energiesysteme
3 years ago
Category: Feature discussion
17 posts since Wed, 24 Feb 10
Hello,

Is it possible to have the database filter customized per session?

When I work on the project #1, I mainly use the database filter "filter1".
When I work on the project #2, I mainly use the database filter "filter2".
That's normal; by definition filters depend on the project loaded!
For the moment, I always have to switch my database filter after logged in.

I think a database filter history per session would be very efficient!

Thank you,
Have a good new year day!

Anthony
Written by ansgar
3 years ago
4988 posts since Fri, 07 Apr 06
The session manager has a per-session database filter which you can use. This is a simple semicolon separated list.

The filter below the tree is intentionally global, not per session.

If you want a session based filter you can only use the first one. I guess it could be problematic that this does not support regular expressions, maybe I can implement such logic here in the future.
Written by energiesysteme
3 years ago
17 posts since Wed, 24 Feb 10
Why do it simple when you can do it complex?smile

The semicolon separated list is very convenient for a session, but if you use it also for the multi session, it quickly become unreadable.

I manage 2 projects with 1900 and 900 databases and 6 others projects with about 30 db each.
Just imagine the non multi session semicolon separated list I have to use... wink
Written by ansgar
3 years ago
4988 posts since Fri, 07 Apr 06
That means now ...?
Written by energiesysteme
3 years ago
17 posts since Wed, 24 Feb 10
Sorry I didn't understand what you mean.
Written by energiesysteme
3 years ago
17 posts since Wed, 24 Feb 10
Sorry I don't understand what you mean.
Written by ansgar
3 years ago
4988 posts since Fri, 07 Apr 06
I'm asking for practical ideas which conclude from your rhetorical question "Why do it simple when you can do it complex?".
Written by energiesysteme
3 years ago
17 posts since Wed, 24 Feb 10
It was a jokesmile

What I meant was that because of the number of databases in my projects, it is very difficult to use the same semicolon separated list for all my sessions.
Written by ansgar
3 years ago
4988 posts since Fri, 07 Apr 06
Yes, I got that. But I did not get what you exactly propose in order to make that filter stuff more easy to use?
Written by energiesysteme
3 years ago
17 posts since Wed, 24 Feb 10
Hello,

Please find screenshots here (link available 4 days from now) :

http://demo.ovh.com/fr/ac14a3fd31c3518c9620c4f6a7ecada4/



Now.jpg
There are 2 projects :
- "Prod - SQL Maitre"
- "Prod - Testing"

The common filter is "infor" which display "information_schema" in both projects.

Idea 1 : Idea1.jpg
To change the content of the filter when we change the current project.
Now, when we change the current project, you dim the others projects.
Maybe you can replace the content of the filter textbox depending on the current project.

Idea 2 : Idea2.jpg
To use tabs for the different projects which contain the databases tree and the filter.

I think the #2 is the best because it is very easy to switch from a project to another one and the filter textbox is visibly linked to the session.

If needed, I can explain more.
Written by ansgar
3 years ago
4988 posts since Fri, 07 Apr 06
I won't add tabs above the tree, so maybe the regex filter should change when focus changes, which may be a slightly implicit, magical approach, GUI wise. Hm. Give me some time to overthink that.
Written by energiesysteme
3 years ago
17 posts since Wed, 24 Feb 10
You don't like my tab picture? :)

Ok, thanks you for think about it and maybe one day I will see it in a release.
Written by ansgar
3 years ago
4988 posts since Fri, 07 Apr 06
Tabs are in use all over the place. And tabs hide their contents untils they are activated. Especially the tree can easily display more than one root node, so I prefer not to have tabs here. Well, I'll think of the other idea.
 

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