public inbox for [email protected]help / color / mirror / Atom feed
Query Auto Completion 3+ messages / 2 participants [nested] [flat]
* Query Auto Completion @ 2019-07-25 11:23 Avin Kavish <[email protected]> 2019-07-25 15:42 ` Re: Query Auto Completion Dave Page <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Avin Kavish @ 2019-07-25 11:23 UTC (permalink / raw) To: [email protected] Hi Hackers, One major improvement I can think of for pgAdmin is query auto completion. In the Jetbrains IDEs, the database console does smart completion using relation and column names and even completes the join based on references. For example, to get the query below I only had to type "s * f ma ij mo" (with enters in between) [image: Screenshot from 2019-07-25 15-40-35.jpg] I'm predominantly a front end developer and willing to take a crack at this. Regards, Avin Attachments: [image/jpeg] Screenshot from 2019-07-25 15-40-35.jpg (54.6K, 3-Screenshot%20from%202019-07-25%2015-40-35.jpg) download | view image ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Query Auto Completion 2019-07-25 11:23 Query Auto Completion Avin Kavish <[email protected]> @ 2019-07-25 15:42 ` Dave Page <[email protected]> 2019-07-30 04:19 ` Re: Query Auto Completion Avin Kavish <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Dave Page @ 2019-07-25 15:42 UTC (permalink / raw) To: Avin Kavish <[email protected]>; +Cc: pgadmin-hackers <[email protected]> Hi On Thu, Jul 25, 2019 at 12:23 PM Avin Kavish <[email protected]> wrote: > Hi Hackers, > > One major improvement I can think of for pgAdmin is query auto completion. > In the Jetbrains IDEs, the database console does smart completion using > relation and column names and even completes the join based on references. > > For example, to get the query below I only had to type "s * f ma ij mo" > (with enters in between) > [image: Screenshot from 2019-07-25 15-40-35.jpg] > > Are you aware that there is already an auto-complete feature? When you want to auto-complete something, just hit Ctrl+Space for options which will popup in a menu. > I'm predominantly a front end developer and willing to take a crack at > this. > Cool - we'd be happy to take improvements. For example, there was a request a short while ago to have the auto complete menu appear automatically if configured to do so (if memory serves). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company Attachments: [image/jpeg] Screenshot from 2019-07-25 15-40-35.jpg (54.6K, 3-Screenshot%20from%202019-07-25%2015-40-35.jpg) download | view image ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Query Auto Completion 2019-07-25 11:23 Query Auto Completion Avin Kavish <[email protected]> 2019-07-25 15:42 ` Re: Query Auto Completion Dave Page <[email protected]> @ 2019-07-30 04:19 ` Avin Kavish <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Avin Kavish @ 2019-07-30 04:19 UTC (permalink / raw) To: Dave Page <[email protected]>; [email protected] Oh okay, it seems that the connection to the database needs to be alive in order for auto-completion to appear. I have been trying the hotkeys while the connection was down. To be honest, it's more of a search when one forgets something, rather than a "let me help you type faster". I was thinking more along the lines of intellisense where it predicts the most suitable option in advance and highlights it. Currently, options seem to be sorted alphabetically and no option is highlighted by default. For example I typed "select * f" only to get freeze as the first option which is not a suitable keyword in that scenario. I'll take a look at improving this, starting with opening the window automatically as you mentioned. On Fri, Jul 26, 2019 at 5:46 AM Avin Kavish <[email protected]> wrote: > No, it doesn't work on my pc. > > On Thu, Jul 25, 2019 at 9:12 PM Dave Page <[email protected]> wrote: > >> Hi >> >> On Thu, Jul 25, 2019 at 12:23 PM Avin Kavish <[email protected]> >> wrote: >> >>> Hi Hackers, >>> >>> One major improvement I can think of for pgAdmin is query auto >>> completion. In the Jetbrains IDEs, the database console does smart >>> completion using relation and column names and even completes the join >>> based on references. >>> >>> For example, to get the query below I only had to type "s * f ma ij mo" >>> (with enters in between) >>> [image: Screenshot from 2019-07-25 15-40-35.jpg] >>> >>> >> Are you aware that there is already an auto-complete feature? When you >> want to auto-complete something, just hit Ctrl+Space for options which will >> popup in a menu. >> >> >>> I'm predominantly a front end developer and willing to take a crack at >>> this. >>> >> >> Cool - we'd be happy to take improvements. For example, there was a >> request a short while ago to have the auto complete menu appear >> automatically if configured to do so (if memory serves). >> >> -- >> Dave Page >> Blog: http://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EnterpriseDB UK: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company >> > Attachments: [image/jpeg] Screenshot from 2019-07-25 15-40-35.jpg (54.6K, 3-Screenshot%20from%202019-07-25%2015-40-35.jpg) download | view image ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2019-07-30 04:19 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2019-07-25 11:23 Query Auto Completion Avin Kavish <[email protected]> 2019-07-25 15:42 ` Dave Page <[email protected]> 2019-07-30 04:19 ` Avin Kavish <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox