NB6DatabaseIssuezilla
Some Potential Database Features
The following are taken from a list put together by Andrei Badea
- Database schema development. Big thing, not really well thought out
yet. It should do what the current Create Table / Add Column dialogs do and more, like support foreign keys, have a more user-friendly UI, perhaps also have an E-R modeler.
- Read-only E-R diagram. Visually displays the tables and relationships
in a given connection. Some work on this is already in progress.
- Code completion in the SQL editor.
- More user-friendly dialogs for adding a new connection and connecting
an existing one. See http://www.netbeans.org/issues/show_bug.cgi?id=68991.
- Option to generate quoted or non-quoted identifiers in the Create
Table / Add Column dialogs.
- Add a file template for SQL files (invoke File - New File, select
Databases, select SQL file, a new SQL file is created and opened in the SQL editor).
- History in the SQL editor. Not trivial, since the editor can now
execute scripts, so it is not clear what to put in the history (all executed statements?). Ideas on this welcome.
- Editable SQL execution result. When you execute a SELECT statement in
the SQL editor a read-only table with the results is displayed. It would be nice to allow editing and adding data in that table.
- Visual query builder. Allows you to generate queries by dragging
tables and their relationships in a way similar to MS Access. This is already being worked on.
