[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    [ADMIN] Auto-complete and Calltips in SQL Editor
From:       klo uo <klonuo () gmail ! com>
Date:       2014-07-27 13:16:04
Message-ID: CAA-8Ld8RntybiqWOz1rh69UGj0NBp30Cgj1vV2_T6kLY7Me8FA () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


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
<http://www.postgresql.org/message-id/CAA-8Ld8vgnA4VRHQbuC72N9pQaeApf2YguxVXpEkHu-Bc1CkfA@mail.gmail.com>

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 #5 (text/html)]

<div dir="ltr"><div>Hi list,<br><br>Initially I posted this message in general list, \
where I was suggested to use this list instead.<br>This is the link to initial \
message: <a href="http://www.postgresql.org/message-id/CAA-8Ld8vgnA4VRHQbuC72N9pQaeApf2YguxVXpEkHu-Bc1CkfA@mail.gmail.com">message</a><br>
 <br>It was confirmed that pgAdmin uses Scintilla which has interface for calltip and \
auto-complete functions defined in:<br><br>       scintilla\src\CallTip.h<br>       \
scintilla\src\AutoComplete.h<br><br>with simple implementation described in <br> <br> \
scintilla\doc\ScintillaUsage.html<br><br>or full in SciTE editor.<br><br><br>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.<br> <br><br>These can be seen as helpers at least in these scenarios:<br><br> \
- novice user learning SQL or PL/pgSQL<br>  - user learning PostgreSQL extension, \
like PostGIS<br>  - user manages own function<br><br></div><br>I attached screenshots \
of these suggestions as they appear in SciTE.<br> <br><div><br></div></div>


["Clipboard01.png" (image/png)]
["Clipboard02.png" (image/png)]

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[prev in list] [next in list] [prev in thread] [next in thread]