Thread: Auto-complete and Calltips in SQL Editor

Auto-complete and Calltips in SQL Editor

From
klo uo
Date:
Hi list,

Initially I posted this message in general list, where I was suggested to use this list instead.
This is the link to initial message: message

It was confirmed that pgAdmin uses Scintilla which has interface for calltip and auto-complete functions defined in:

    scintilla\src\CallTip.h
    scintilla\src\AutoComplete.h

with simple implementation described in

    scintilla\doc\ScintillaUsage.html

or full in SciTE editor.


As implemented in SciTE these controls are evoked only if user provides calltip and auto-completion definitions (through *.api files) and user defines triggers for each action.


These can be seen as helpers at least in these scenarios:

 - novice user learning SQL or PL/pgSQL
 - user learning PostgreSQL extension, like PostGIS
 - user manages own function


I attached screenshots of these suggestions as they appear in SciTE.


Attachment

Re: Auto-complete and Calltips in SQL Editor

From
jaime soler
Date:
El dom, 27-07-2014 a las 15:16 +0200, klo uo escribió:
> Hi list,
>
> Initially I posted this message in general list, where I was suggested
> to use this list instead.
> This is the link to initial message: message
better, you should send to:

pgadmin-hackers@postgresql.org

>
> It was confirmed that pgAdmin uses Scintilla which has interface for
> calltip and auto-complete functions defined in:
>
>     scintilla\src\CallTip.h
>     scintilla\src\AutoComplete.h
>
> with simple implementation described in
>
>     scintilla\doc\ScintillaUsage.html
>
> or full in SciTE editor.
>
>
> As implemented in SciTE these controls are evoked only if user
> provides calltip and auto-completion definitions (through *.api files)
> and user defines triggers for each action.
>
>
> These can be seen as helpers at least in these scenarios:
>
>  - novice user learning SQL or PL/pgSQL
>  - user learning PostgreSQL extension, like PostGIS
>  - user manages own function
>
>
>
> I attached screenshots of these suggestions as they appear in SciTE.
>
>
>