Thread: Graphical Query Builder -- expanding public requires annoying double click
Hi All,
Peter Dietz
Systems Developer/Engineer
Ohio State University Libraries
I have a minor grievance with pgAdmin3's Graphical Query Builder.
I click plus on Schemas, then public has no plus, so I must double click public, then the plus button appears, which I can then click to expand the list to see whats in my database.
[-] my-database-name
[+] Catalogs
[-] Schemas
public
I would like that public would already have the expand symbol present by default.
This is only a minor inconvenience, but it will hopefully save me, and every other user a little bit of time.
-- Affects Version --
1.10.2 (Aug 23 2010, rev:8217)
Ubuntu 10.04
and
1.10.2 (Mar 10 2010, rev:8217)
CentOS 5
P.S. I really like pgAdmin3, and the Graphical Query Builder really make big hairy queries very simple and easy to create, quickly.
Thank you,
Peter Dietz
Systems Developer/Engineer
Ohio State University Libraries
On Thu, Sep 23, 2010 at 9:27 PM, Peter Dietz <pdietz84@gmail.com> wrote: > Hi All, > I have a minor grievance with pgAdmin3's Graphical Query Builder. > I click plus on Schemas, then public has no plus, so I must double click > public, then the plus button appears, which I can then click to expand the > list to see whats in my database. > [-] my-database-name > [+] Catalogs > [-] Schemas > public > I would like that public would already have the expand symbol present by > default. > This is only a minor inconvenience, but it will hopefully save me, and every > other user a little bit of time. It probably wouldn't, because it would require pre-populating the node. If you have multiple schemas, that means scanning all of them for objects in advance of when you actually want them. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company
Re: Graphical Query Builder -- expanding public requires annoying double click
From
Guillaume Lelarge
Date:
Le 23/09/2010 22:31, Dave Page a écrit : > On Thu, Sep 23, 2010 at 9:27 PM, Peter Dietz <pdietz84@gmail.com> wrote: >> Hi All, >> I have a minor grievance with pgAdmin3's Graphical Query Builder. >> I click plus on Schemas, then public has no plus, so I must double click >> public, then the plus button appears, which I can then click to expand the >> list to see whats in my database. >> [-] my-database-name >> [+] Catalogs >> [-] Schemas >> public >> I would like that public would already have the expand symbol present by >> default. >> This is only a minor inconvenience, but it will hopefully save me, and every >> other user a little bit of time. > > It probably wouldn't, because it would require pre-populating the > node. If you have multiple schemas, that means scanning all of them > for objects in advance of when you actually want them. > The only issue I have with that is that GQB works in a different way than the browser. Not sure what we should do against that though. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com
Re: Graphical Query Builder -- expanding public requires annoying double click
From
Thom Brown
Date:
On 23 September 2010 21:31, Dave Page <dpage@pgadmin.org> wrote: > On Thu, Sep 23, 2010 at 9:27 PM, Peter Dietz <pdietz84@gmail.com> wrote: >> Hi All, >> I have a minor grievance with pgAdmin3's Graphical Query Builder. >> I click plus on Schemas, then public has no plus, so I must double click >> public, then the plus button appears, which I can then click to expand the >> list to see whats in my database. >> [-] my-database-name >> [+] Catalogs >> [-] Schemas >> public >> I would like that public would already have the expand symbol present by >> default. >> This is only a minor inconvenience, but it will hopefully save me, and every >> other user a little bit of time. > > It probably wouldn't, because it would require pre-populating the > node. If you have multiple schemas, that means scanning all of them > for objects in advance of when you actually want them. It is a bit unintuitive to present the user with a tree which suddenly stops, but expect them to know to double click on it to go further. Couldn't this have a [+] anyway, which would disappear if there was nothing inside? And is there that much of a cost of doing the scan anyway? The user will nearly always need to open the schema node anyway. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935
Re: Graphical Query Builder -- expanding public requires annoying double click
From
Guillaume Lelarge
Date:
Le 23/09/2010 22:37, Thom Brown a écrit : > On 23 September 2010 21:31, Dave Page <dpage@pgadmin.org> wrote: >> On Thu, Sep 23, 2010 at 9:27 PM, Peter Dietz <pdietz84@gmail.com> wrote: >>> Hi All, >>> I have a minor grievance with pgAdmin3's Graphical Query Builder. >>> I click plus on Schemas, then public has no plus, so I must double click >>> public, then the plus button appears, which I can then click to expand the >>> list to see whats in my database. >>> [-] my-database-name >>> [+] Catalogs >>> [-] Schemas >>> public >>> I would like that public would already have the expand symbol present by >>> default. >>> This is only a minor inconvenience, but it will hopefully save me, and every >>> other user a little bit of time. >> >> It probably wouldn't, because it would require pre-populating the >> node. If you have multiple schemas, that means scanning all of them >> for objects in advance of when you actually want them. > > It is a bit unintuitive to present the user with a tree which suddenly > stops, but expect them to know to double click on it to go further. > Couldn't this have a [+] anyway, which would disappear if there was > nothing inside? And is there that much of a cost of doing the scan > anyway? The user will nearly always need to open the schema node > anyway. > I'm not sure we can do this. The "+" sign appears when the node has children. And before one double clicks on the node, there are no children to this node. I don't say this is impossible. Just that I don't see an easy way to code what you want. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com
Re: Graphical Query Builder -- expanding public requires annoying double click
From
Magnus Hagander
Date:
On Thu, Sep 23, 2010 at 22:44, Guillaume Lelarge <guillaume@lelarge.info> wrote: > Le 23/09/2010 22:37, Thom Brown a écrit : >> On 23 September 2010 21:31, Dave Page <dpage@pgadmin.org> wrote: >>> On Thu, Sep 23, 2010 at 9:27 PM, Peter Dietz <pdietz84@gmail.com> wrote: >>>> Hi All, >>>> I have a minor grievance with pgAdmin3's Graphical Query Builder. >>>> I click plus on Schemas, then public has no plus, so I must double click >>>> public, then the plus button appears, which I can then click to expand the >>>> list to see whats in my database. >>>> [-] my-database-name >>>> [+] Catalogs >>>> [-] Schemas >>>> public >>>> I would like that public would already have the expand symbol present by >>>> default. >>>> This is only a minor inconvenience, but it will hopefully save me, and every >>>> other user a little bit of time. >>> >>> It probably wouldn't, because it would require pre-populating the >>> node. If you have multiple schemas, that means scanning all of them >>> for objects in advance of when you actually want them. >> >> It is a bit unintuitive to present the user with a tree which suddenly >> stops, but expect them to know to double click on it to go further. >> Couldn't this have a [+] anyway, which would disappear if there was >> nothing inside? And is there that much of a cost of doing the scan >> anyway? The user will nearly always need to open the schema node >> anyway. >> > > I'm not sure we can do this. The "+" sign appears when the node has > children. And before one double clicks on the node, there are no > children to this node. > > I don't say this is impossible. Just that I don't see an easy way to > code what you want. Could we just create a fake empty item under it that says "loading..." or something like that? -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/
Re: Graphical Query Builder -- expanding public requires annoying double click
From
Guillaume Lelarge
Date:
Le 23/09/2010 22:48, Magnus Hagander a écrit : > On Thu, Sep 23, 2010 at 22:44, Guillaume Lelarge <guillaume@lelarge.info> wrote: >> Le 23/09/2010 22:37, Thom Brown a écrit : >>> On 23 September 2010 21:31, Dave Page <dpage@pgadmin.org> wrote: >>>> On Thu, Sep 23, 2010 at 9:27 PM, Peter Dietz <pdietz84@gmail.com> wrote: >>>>> Hi All, >>>>> I have a minor grievance with pgAdmin3's Graphical Query Builder. >>>>> I click plus on Schemas, then public has no plus, so I must double click >>>>> public, then the plus button appears, which I can then click to expand the >>>>> list to see whats in my database. >>>>> [-] my-database-name >>>>> [+] Catalogs >>>>> [-] Schemas >>>>> public >>>>> I would like that public would already have the expand symbol present by >>>>> default. >>>>> This is only a minor inconvenience, but it will hopefully save me, and every >>>>> other user a little bit of time. >>>> >>>> It probably wouldn't, because it would require pre-populating the >>>> node. If you have multiple schemas, that means scanning all of them >>>> for objects in advance of when you actually want them. >>> >>> It is a bit unintuitive to present the user with a tree which suddenly >>> stops, but expect them to know to double click on it to go further. >>> Couldn't this have a [+] anyway, which would disappear if there was >>> nothing inside? And is there that much of a cost of doing the scan >>> anyway? The user will nearly always need to open the schema node >>> anyway. >>> >> >> I'm not sure we can do this. The "+" sign appears when the node has >> children. And before one double clicks on the node, there are no >> children to this node. >> >> I don't say this is impossible. Just that I don't see an easy way to >> code what you want. > > Could we just create a fake empty item under it that says "loading..." > or something like that? > > Could be working. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com
Re: Graphical Query Builder -- expanding public requires annoying double click
From
"Bob McConnell"
Date:
From: Guillaume Lelarge > Le 23/09/2010 22:37, Thom Brown a écrit : >> On 23 September 2010 21:31, Dave Page <dpage@pgadmin.org> wrote: >>> On Thu, Sep 23, 2010 at 9:27 PM, Peter Dietz <pdietz84@gmail.com> wrote: >>>> Hi All, >>>> I have a minor grievance with pgAdmin3's Graphical Query Builder. >>>> I click plus on Schemas, then public has no plus, so I must double click >>>> public, then the plus button appears, which I can then click to expand the >>>> list to see whats in my database. >>>> [-] my-database-name >>>> [+] Catalogs >>>> [-] Schemas >>>> public >>>> I would like that public would already have the expand symbol present by >>>> default. >>>> This is only a minor inconvenience, but it will hopefully save me, and every >>>> other user a little bit of time. >>> >>> It probably wouldn't, because it would require pre-populating the >>> node. If you have multiple schemas, that means scanning all of them >>> for objects in advance of when you actually want them. >> >> It is a bit unintuitive to present the user with a tree which suddenly >> stops, but expect them to know to double click on it to go further. >> Couldn't this have a [+] anyway, which would disappear if there was >> nothing inside? And is there that much of a cost of doing the scan >> anyway? The user will nearly always need to open the schema node >> anyway. >> > > I'm not sure we can do this. The "+" sign appears when the node has > children. And before one double clicks on the node, there are no > children to this node. > > I don't say this is impossible. Just that I don't see an easy way to > code what you want. The file browsers I am familiar with display the "+" by default and assume there are children until they have reason to scanand find there are none, Then the "+" disappears. Bob McConnell
On Thu, Sep 23, 2010 at 9:34 PM, Guillaume Lelarge <guillaume@lelarge.info> wrote: > Le 23/09/2010 22:31, Dave Page a écrit : >> On Thu, Sep 23, 2010 at 9:27 PM, Peter Dietz <pdietz84@gmail.com> wrote: >>> Hi All, >>> I have a minor grievance with pgAdmin3's Graphical Query Builder. >>> I click plus on Schemas, then public has no plus, so I must double click >>> public, then the plus button appears, which I can then click to expand the >>> list to see whats in my database. >>> [-] my-database-name >>> [+] Catalogs >>> [-] Schemas >>> public >>> I would like that public would already have the expand symbol present by >>> default. >>> This is only a minor inconvenience, but it will hopefully save me, and every >>> other user a little bit of time. >> >> It probably wouldn't, because it would require pre-populating the >> node. If you have multiple schemas, that means scanning all of them >> for objects in advance of when you actually want them. >> > > The only issue I have with that is that GQB works in a different way > than the browser. Not sure what we should do against that though. Y'know, I just realised this is about the GQB, not the browser (being compared to the GQB). I really need to learn to read subject lines. Sorry. Pre-loading the GQB treeview should be less painful than the main one, as it loads far less data. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise Postgres Company