Changes between Version 7 and Version 8 of UsersWikiNbSqlFunctionsEditor
- Timestamp:
- 09/24/13 06:06:00 (11 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UsersWikiNbSqlFunctionsEditor
v7 v8 5 5 [http://netbeans.org/ Netbeans IDE] provides a powerful database explorer and SQL editor. 6 6 The SQL editor offers features such as: 7 7 8 * Syntax coloring 8 9 * Contextual code completion for databases, schemas, tables, columns 9 10 * Execution of SQL code at cursor 10 11 * Execution of SQL scripts 11 * etc. 12 * etc.|| 12 13 13 14 [[Image(sqleditor.png)]] 14 15 15 Unfortunately, the editor do not autocomplete functions/procedures, a feature that would be cool for PostGIS functions.16 Unfortunately, the editor does not autocomplete functions/procedures, a feature that would be cool for PostGIS functions. 16 17 17 18 The !SqlFunctionsCompletion NBM plugin adds this functionality to the SQL editor. … … 19 20 == !SqlFunctionsCompletion plugin == 20 21 21 The !SqlFunctionsCompletion plugin is a Netbeans plugin (NBM file) extending the default SQL Editor to add User-Defined functions and procedures autocompletionbased on the current query context.22 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. 22 23 23 24 When configuring a Netbeans database connection, a default schema can be set. This default schema is used by the module to search functions from. … … 35 36 36 37 * Download the !SqlFunctionsCompletion Netbeans module (attachment:org-nico-db-sql-editor.nbm) 37 * Open Netbeans plugin manager (tools -> plugins) 38 * Click on Downloaded tab and add the downloaed .nbm file 39 * Install the plugin, restart Netbeans IDE 38 * Open Netbeans Plugins Manager (menu Tools | Plugins) 39 * Click on ''Downloaded'' tab and add the downloaded .nbm file 40 * Install the plugin 41 * Restart Netbeans IDE 40 42 41 43 === How to Update === 42 44 45 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. 46 47 To do a manual update: 48 49 * Open Netbeans Plugins Manager (menu Tools | Plugins) 50 * Click on ''Updates'' tab 51 * Click on ''check for Updates'' 52 43 53 === Todo === 44 54 45 Retrieve functions doc URL from live doc instead of hard-coded map. 55 * Retrieve functions doc URL from live doc instead of hard-coded map. 56 * Test other databases/env