Netbeans SQL Editor with functions autocompletion and 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 do 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 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
• Open Netbeans plugin manager (tools -> plugins)
• Click on Downloaded tab and add the downloaed .nbm file
• Install the plugin, restart Netbeans IDE

How to Update

Todo

Retrieve functions doc URL from live doc instead of hard-coded map.