Auto-complete and Calltips in SQL Editor

From: klo uo <klonuo(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Auto-complete and Calltips in SQL Editor
Date: 2014-07-27 13:16:04
Message-ID: CAA-8Ld8RntybiqWOz1rh69UGj0NBp30Cgj1vV2_T6kLY7Me8FA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers 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.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 Content-Type Size
image/png 7.1 KB
image/png 10.7 KB

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dmitriy Olshevskiy 2014-07-28 20:09:35 PATCH: Update russian translation
Previous Message Guillaume Lelarge 2014-07-26 14:09:17 pgAdmin III commit: Update french translation

Browse pgsql-admin by date

  From Date Subject
Next Message Rural Hunter 2014-07-27 15:44:09 Re: Very slow planning performance on partition table
Previous Message Lacey Powers 2014-07-26 19:14:16 Re: disk testing