pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Auto-complete and Calltips in SQL Editor
4+ messages / 3 participants
[nested] [flat]

* Auto-complete and Calltips in SQL Editor
@ 2014-07-27 13:16  klo uo <klonuo@gmail.com>
  0 siblings, 2 replies; 4+ messages in thread

From: klo uo @ 2014-07-27 13:16 UTC (permalink / raw)
  To: pgsql-admin

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....;

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.

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

Attachments:

Clipboard01.png (image/png, 7.1K) download view image
Clipboard02.png (image/png, 10.7K) download view image
^ permalink raw reply [nested|flat] 4+ messages in thread

* Re: Auto-complete and Calltips in SQL Editor
@ 2014-10-09 09:16  jaime soler <jaime.soler@gmail.com>
  parent: klo uo <klonuo@gmail.com>
  1 sibling, 0 replies; 4+ messages in thread

From: jaime soler @ 2014-10-09 09:16 UTC (permalink / raw)
  To: klo uo <klonuo@gmail.com>; +Cc: pgsql-admin

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.
> 
> 
> 




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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Fwd: Auto-complete and Calltips in SQL Editor
@ 2014-10-09 14:32  klo uo <klonuo@gmail.com>
  parent: klo uo <klonuo@gmail.com>
  1 sibling, 1 reply; 4+ messages in thread

From: klo uo @ 2014-10-09 14:32 UTC (permalink / raw)
  To: pgadmin-hackers@postgresql.org

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....;

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.

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

Attachments:

Clipboard01.png (image/png, 7.1K) download view image
Clipboard02.png (image/png, 10.7K) download view image
^ permalink raw reply [nested|flat] 4+ messages in thread

* Re: Fwd: Auto-complete and Calltips in SQL Editor
@ 2014-10-11 13:23  Guillaume Lelarge <guillaume@lelarge.info>
  parent: klo uo <klonuo@gmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Guillaume Lelarge @ 2014-10-11 13:23 UTC (permalink / raw)
  To: klo uo <klonuo@gmail.com>; +Cc: PgAdmin Hackers <pgadmin-hackers@postgresql.org>

2014-10-09 16:32 GMT+02:00 klo uo <klonuo@gmail.com>:

> 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....;
>
> 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.
>
>
>
Sorry, I forgot to follow on this. This seems interesting. I'd love to see
a patch for that :)


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2014-10-11 13:23 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-07-27 13:16 Auto-complete and Calltips in SQL Editor klo uo <klonuo@gmail.com>
2014-10-09 09:16 ` jaime soler <jaime.soler@gmail.com>
2014-10-09 14:32 ` klo uo <klonuo@gmail.com>
2014-10-11 13:23   ` Guillaume Lelarge <guillaume@lelarge.info>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox