Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
DTP SQL Query Builder Ganymede Project Plan
Revision as of 05:45, 20 September 2007 by Jeremyl.sybase.com (Talk | contribs) (→SQL Query Builder)
← Back to DTP SQLDevTools Ganymede Project Plan
SQL Query Builder
The SQL Query Builder Project Plan is broken down into the following bugzilla enhancement requests.
Note that the milestones targeted for each feature are currently under review and may be revised.
PRIORITY 1
- Migrate Project Properties to Preferences and SQL Properties, 202585.
- These properties enable/disable the inclusion of the current schema name in generated SQL.
- Est: 7 days, Target: M3
- Make SQL Builder database and sql dialect Neutral, 202586.
- Est: 5 days, Target: M3
- Componentization, 202587.
- - Rather than loading a file containing a SQL statement and a Connection Profile, the SQL statement and Connection Profile will be passed to/from the SQL Builder through an API.
- - Make the SQL Builder a component which can be invoked through an API.
- - Allow the SQL Builder to run in a dialog.
- Est: 17 days, Target: M3
- Improved look and feel, 202589.
- Improve the layout of the SQL Builder's panes, making them customizable.
- Est: 15 days, Target: M4
- SQL Support: Variables, 202600.
- Includes support for variables and parameter markers.
- Est: 5 days, Target: M4
- SQL Support: Comment Handling, 202602.
- Support comments preceding or inside SQL statements.
- Est: 8 days, Target: M4
- Integration with DTP SQLEditor, 202590.
- Make the SQL Builder use the DTP SQLEditor's editing control, rather than its own control.
- Est: 10 days, Target: M5
- Integration with DTP SQLScrapbook, 202591.
- Allow SQLScrapbook to invoke the SQL Builder.
- Est: 7 days, Target: M5
- DTP Enablement: SQL Dialect Support / Extensibility, 202592.
- Define enablement framework to support SQL dialect variations.
- Est: 30 days, Target: M6
- DTP Enablement: User-Interface Enablement, 202593.
- Define enablement framework for UI
- Est: 15 days, Target: M6
- DTP Enablement: Enablement for exemplary database, 202594.
- Enable the SQL Builder for an exemplary database, probably Apache Derby.
- Est: 10 days, Target: M6
Total Estimate: 129 days / 26 weeks
PRIORITY 2
- Improve Core UI, 202596.
- Usability enhancements to the UI.
- Est: 20 days, Target: post Ganymede
- Easy Access to Database objects, 202597.
- Enhanced support for accessing database objects.
- Est: 7 days, Target: post Ganymede
- Properties Pane, 202598.
- Re-work the bottom pane of the SQL Builder's UI, where detailed parts of SQL Queries are defined.
- Est: 15 days, Target: post Ganymede
- SQL Support: Quoted Identifiers, 202601.
- Support quoted and unquoted identifiers.
- Est: 5 days, Target: post Ganymede
- SQL Support: Qualified and Unqualified Names, 202603.
- Support qualified and unqualified names.
- Est: 5 days, Target: post Ganymede
- SQL Support: SQL Execution, 202604.
- Enhance ability to execute SQL queries from SQL Builder.
- Est: 1 days, Target: post Ganymede
- SQL Support: Subquery Support, 202605.
- The SQL Builder currently has very limited support for subqueries. This will be enhanced.
- Est: 20 days, Target: post Ganymede
- SQL Support: UNION, INTERSECT, EXCEPT, 202606.
- Improve support for UNION, INTERSECT, EXCEPT.
- Est: 12 days, Target: post Ganymede
Total Estimate: 85 days / 17 weeks
PRIORITY 3
- Type mismatch detection, 202607.
- Detect type mismatches and suggest type conversions where possible.
- Est: 10 days, Target: post Ganymede
- SQL Validation, 202608.
- Apply SQL validation constraints.
- Est: 13 days, Target: post Ganymede
- Improve Expression and Condition Builder UI, 202609.
- Rewrite the expression and condition builder to make them more user friendly.
- Est: 60 days, Target: post Ganymede
- Undo and redo Support, 202610.
- Add undo and redo editing support.
- Est: 15 days, Target: post Ganymede
Total Estimate: 98 days / 20 weeks