= Netbeans SQL Editor with functions autocompletion and PostGIS documentation =

== Netbeans SQL Editor ==

[http://netbeans.org/ 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.

[[Image(sqleditor.png)]]

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.

[[Image(pgissqleditor.png)]]

=== 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 attachment:org.nico.db.sql.editor.nbm !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.