public inbox for [email protected]
help / color / mirror / Atom feedFrom: Avin Kavish <[email protected]>
To: Dave Page <[email protected]>
To: [email protected]
Subject: Re: Query Auto Completion
Date: Tue, 30 Jul 2019 09:49:38 +0530
Message-ID: <CAFpscOS5J8NamP39--ODsvmrD=U9Z8ddc6d_dtVBBugA88dCDg@mail.gmail.com> (raw)
In-Reply-To: <CAFpscORPxXdqn-iuhPQ039HSBrP1VzjyicCK8+YUwOJE-tCm_w@mail.gmail.com>
References: <CAFpscOShVV00rO+US=XvYC21pECwmdrtMJ9PPL5Ag25yctrf6g@mail.gmail.com>
<CA+OCxoy3-5_S++io0qmnKHeh0Mb1PZ+HVymxtTQK551q12wjFQ@mail.gmail.com>
<CAFpscORPxXdqn-iuhPQ039HSBrP1VzjyicCK8+YUwOJE-tCm_w@mail.gmail.com>
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
view thread (3+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Query Auto Completion
In-Reply-To: <CAFpscOS5J8NamP39--ODsvmrD=U9Z8ddc6d_dtVBBugA88dCDg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox