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

[[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 !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