DatabaseFeaturesForNB67


Feature Owner Milestone Issue Number Comments/Description
PRIORITY 2 - Committed Features
David
SQL completion in PHP editor davidvc Completed for SELECT command(6.7M2) 155256
Ability to select a connection for SQL completion in PHP mike,davidvc Completed(6.7M2) 155257 Draft wireframe SQLCodeHints_DatabaseFeaturesForNB67.pdf
SQL Code Completion Connection UI Spec SQLCodeCompletion_DatabaseFeaturesForNB67.pdf
SQL completion for insert P2 Completed(6.7M3) Need to impl to make SQL completion consistent for all kinds of commands 155368
SQL completion for update P2 Need to impl to make SQL completion consistent for all kinds of commands 155369
SQL completion for delete P2 Need to impl to make SQL completion consistent for all kinds of commands
Completion for MySQL functions and procedures davidvc P3 M3 140723
John
Save As for SQL Editor jbaker P2 Completed(6.7M1) 134285 Review page  ; Lots of requests for this
New SQL File template jbaker P2 Completed(6.7M2) 155276
MySQL function documentation in completion john M2 156370 Review Page  ; Have discussed this with MySQL docs team, this seems very doable
MySQL documentation in Help Contents john M3 150201 Review Page  ; Have discussed this with MySQL docs team, this seems very doable
Support auto-generated columns in Create Table UI john M3 57979 Lots of requests for this, big limitation in our Create Table support, prevents a lot of people from using it
Rob
Rewrite DB Explorer infrastructure rob P2 Completed (6.7M2) 153153 We just have to do this
Make schemas visible in the Explorer rob, mike Completed (6.7M2) 155259
Improve New Connection Dialog mike,rob Design - M2, Impl - M3 155260 Draft wireframe PDF for the UI
Revised wireframe PDF for the UI
Wireframe and workflow PDF for the Test Connection UI
Make database features more discoverable in NetBeans mike Design-M3
Implementation-TBD
155261 A lot of complaints, hopefully shouldn't be hard to do
Ahi and Team
In-place insert of row in result set ahi TBD 155262 Browse Specifications
Right now it brings up a separate dialog - very non-intuitive and unattractive. Need Excel-style in-place editing of new row. This is important, it leaves a very bad impression.
Export data from results as XML ahi TBD 154739 Browse specifications
Export data from results as CSV ahi TBD 154740 Browse specifications
Import data from CSV ahi TBD 154742 Browse specifications
A cool thing to do here is create the schema as part of import
Import data from XML ahi TBD 154741 Browse specifications


PRIORITY 3 - Nice To Have
Metadata API public davidvc Started M3 - stretch goal 155258
Allow database connections to have names not tied to URL john M3 144112 Lots of requests for this
Make it possible to browse to table directly from MySQL node mike Design - M2? 150660
Ability to filter tables for large schemas 153622 A performance issue. Need to think about how to design this.
Make columns sortable in DB Explorer 155345 Have gotten a number of requests for this. Currently hardcoded to sort by order in table.
Improve Add Column UI 155346
Create a text field above SQL editor that shows current delimiter 155349
Improve Create Table UI 155347 See SQLYog for inspiration. Includes support for auto-increment
Improve Create Index UI 155348
Need UI support for creating a foreign key 155350
After creating a connection, move focus to that connection 150659
Provide action to show procedure text from procedure node 145283
Execute stored procedure does nothing right now 155351 We should get rid of this action if it doesn't work
Provide action to view/edit SQL for a view 155354
Visual Database Explorer TBD 105075 This is basically a read-only E/R diagram. Will be done as a plugin for now.
Predefined code templates for SQL Editor davidvc TBD 152411 Would be great to have this in the code editors too, but that's extra credit.
Import data from JSON ahi 155352
Export data from results as JSON ahi 155353
Support for enable/disable autocommit on connection 65764 To avoid breaking the DB Explorer API, this change will need us to add connection pool support to the DB Explorer, so that autocommit can be set on a pooled connection without impacting other users of the DB connection
Show execution plan for MySQL jbaker 134212 Lots of votes for this - need to understand what this really means.
Matchbox support in results panel ahi 155174 There wasn't time for this in the last release, but is very useful for filtering results
Execute SQL without opening editor 136538 This is something Wen asked for as well. Should be pretty easy to do with SQLExecution API
Navigate foreign key relationships in results ahi 155355 Survey participant idea - very cool.
Completion in Java editor 155356
Set up ssh tunnel in NetBeans davidvc 155357 Supports access to remote services (web, database, debugger). Not sure if feasib
Export schema to SQL DDL davidvc 155358 DDLUtils may give us what we need here with little effort. I think what I want to do here is provide it as a plugin, get feedback, and perhaps incorporate in a followon release
Add a tab to DDL wizards to show resulting SQL as it's being built 155359 See Aqua Studio for an example of this
Make SQLExecution API public 90452 Could be useful to other modules. No specific request for it that I know of...
Better UI support for stored procedures 145284 Currently can't view, update or delete from explorer
Make metadata API public andrei 155258 Not sure if we have time for this, but it's the first step for templating/scripting support
Generate INSERT statements from result set ahi 155360 We already generate code for selected rows, but generating INSERT statement for entire resultset will be nice to have
Schema refactoring 155361 See liquibase refactoring tool, which we could integrate. Things like rename table, combine tables, split table, etc.
Show triggers and functions as well as procedures under a MySQL Connection 155362 See Aqua Studio for an example
Quick view of table info Not Staffed 134213 SqlYog has a nice feature where there is a tab called "Object Info" that shows the data for the selected object (table, index, view).
Quick view of column info Not Staffed 134214 SQLYog again: each column shows all the information without having to bring up a dialog
Full support for MySQL extensions in DDL wizards 155363 When it's a MySQL connection, add all the extra stuff to our wizards.
Support logging JDBC driver 155364 See log4jdbc
Versioning for SQL files 155365 Maybe we have this, but there are a lot of requests for it
Schema browse filters 153622 Some schemas are huge. Allow to filter what tables you pull down when browsing a schema
Better support for constraints 155366 Currently hidden and not well supported in DB Explorer. Support dropping tables in right order
Detect SQL injection risks in PHP code 155370 This is actually a big issue for PHP developers
Generate PHP REST endpoints from DB tables 155371 Very useful for Javascript/JMaki front ends. This may belong with WS team. Note I have contacted the Srividhya and her team is looking into this.
Read/write metadata API 155367 Support scripts that modify the db schema
SQL completion for keywords 140274 Start with Mysql
SQL completion for stored procedures 151282 Start with MySQL


Future Ideas

This section lists areas that we believe are useful but which are not even stretch goals for this release

Developer improvements

Feature Owner Milestone Issue Number Comments/Description
Integrate dbUnit support Needs more research - survey participant idea


SQL Editing/Execution/Results

Feature Owner Milestone Issue Number Comments/Description
Debug stored procedures and triggers This requires support from the vendor. MySQL first, PostgreSQL second
SQL "lint" that tells you whether SQL is standard or not Idea from survey user
Ability to plug in SQL dialect This allows other SQL procedural languages to be supported


Procedural language support This includes things like unused variables, goto declaration, basic refactoring, etc. MySQL first, PostgreSQL second


Schema management

Schema migrations Provide SQL-based migrations ala Ruby on Rails. Related to schema refactoring below, but this has to do with versioning...
Schema compare/diff Note this is already supported in MySQL WorkBench, but we want a generic solution (not specific to MySQL)


Data Management

Feature Owner Milestone Issue Number Comments/Description
Import/export from/to another database This could import/export the schema too
Import data from XML
Export data to CSV
Export data to XML
Import data from JSON
Export data to JSON


Administration

Feature Owner Milestone Issue Number Comments/Description
Manage users
Manage rights for users (GRANT/REVOKE)
Not logged in. Log in, Register

By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo