Netbeans SQL Editor with functions autocompletion and PostGIS documentation

Netbeans SQL Editor

​Netbeans IDE provides a powerful database explorer and SQL editor. The SQL editor offers features such as:

• Syntax coloring
• Contextual code completion for databases, schemas, tables, columns
• Execution of SQL code at cursor
• Execution of SQL scripts

etc.

Unfortunately, the editor does not autocomplete functions/procedures, a feature that would be cool for PostGIS functions.

The SqlFunctionsCompletion NBM plugin adds this functionality to the SQL editor.

SqlFunctionsCompletion plugin

The SqlFunctionsCompletion plugin is a Netbeans 7.3 plugin (NBM file) extending the default SQL Editor to add User-Defined functions and procedures autocompletion based on the current query context.

When configuring a Netbeans database connection, a default schema can be set. This default schema is used by the module to search functions from.

Features

• Contextual autocompletion of user defined functions
• Default schema aware
• Inline, browsable documentation for PostGIS functions from Postgis.net website.
• Documentation version is chosen according to the running PostGIS version.

How to Install

• Download the SqlFunctionsCompletion Netbeans module (attachment:org-nico-db-sql-editor.nbm​)
• Open Netbeans Plugins Manager (menu Tools | Plugins)
• Click on Downloaded tab and add the downloaded .nbm file
• Install the plugin
• Restart Netbeans IDE

How to Update

The plugin automatically installs an Update Center. If Netbeans Auto Update feature is on, the plugin will be updated automatically when a new version is published.

To do a manual update:

• Open Netbeans Plugins Manager (menu Tools | Plugins)
• Click on Updates tab
• Click on check for Updates

Todo

• Retrieve functions doc URL from live doc instead of hard-coded map.
• Test other databases/env