Some Potential Database Features

The following are taken from a list put together by Andrei Badea

1. 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.
2. Read-only E-R diagram. Visually displays the tables and relationships in a given connection. Some work on this is already in progress.
3. Code completion in the SQL editor.
4. 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.
5. Option to generate quoted or non-quoted identifiers in the Create Table / Add Column dialogs.
6. 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).
7. 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.
8. 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.
9. 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.