User: fs Date: 2007/02/05 00:40:55 Modified: dba/www/development/projects.html
Log: SQL syntax highlighting File Changes: Directory: /dba/www/development/ ================================ File [changed]: projects.html Url: http://dba.openoffice.org/source/browse/dba/www/development/projects.html?r1=1.4&r2=1.5 Delta lines: +37 -37 --------------------- --- projects.html 5 Feb 2007 08:33:38 -0000 1.4 +++ projects.html 5 Feb 2007 08:40:53 -0000 1.5 @@ -52,10 +52,10 @@ <li> <a href="#embed_derby">Embed Derby into OpenOffice.org databases</a></li> <li> - <a href="#editable_views">HSQLDB: editable views</a></li> - <li> <a href="#syntax_hilight">SQL Syntax Highlighting</a></li> <li> + <a href="#editable_views">HSQLDB: editable views</a></li> + <li> <a href="#cross_access">native, cross-platform access to MS Access databases</a></li> <li> <a href="#vcards">SDBC driver for vCards</a></li> @@ -513,30 +513,18 @@ <hr style="width: 100%; height: 2px;"> <!-- =============================== --> - <!-- HSQLDB: editable views --> - <h3><a name="editable_views"></a>HSQLDB: editable views</h3> + <!-- SQL Syntax Highlighting --> + <h3><a name="syntax_hilight"></a>SQL Syntax Highlighting</h3> <h4>description</h4> - <p><a href="http:///hsqldb.org"; title="http:///hsqldb.org";>HSQLDB</a>, - used as OpenOffice.org's database engine, features the usage of views - (basically, stored SQL queries).</p> - - <p>An advantage of views over queries is that the former can be re-used in - other queries, i.e. you can do a <code>SELECT * FROM foo</code> where - <code>foo</code> is the name of an existing view, i.e. a <code>SELECT</code> - statement itself.</p> - - <p>A disadvantage of views is that the constituting statement cannot be edited - in OpenOffice.org Base once the view has been created.</p> + <p>The SQL view of the query designer, which displays, and allows to edit, + raw SQL statements, currently is a mere text input field. It would be helpful + especially to the unexperienced user to have syntax highlighting here: SQL keywords + should be notable, literals should be distinguished, and the like.</p> - <p>Goal of this project is to provide an "Edit view" functionality in - OpenOffice.org Base, for the moment for the HSQLDB backend only. - For this, an API needs to be defined which allows editing views. This API has - to be implemented in Base' dedicated HSQLDB driver. Additionally, the user - interface should respect the existence of this API by offering an "Edit View" - item in the context menu of views. Once chosen, Base' query designer is to be - started, to modify the SQL statement constituting the view. Saving the work in - the designer should change the view's underlying statement.</p> + <p>OpenOffice.org already features core components which allow syntax highlighting + in a text field - the most prominent example is the Basic IDE -, so there already is + a foundation to base this feature on.</p> <table style="text-align: left;" cellspacing="0"> <tbody> @@ -545,6 +533,7 @@ <td> <ul> <li>C++</li> + <li>SQL knowledge</li> </ul> </td> </tr> @@ -552,13 +541,13 @@ <td class="effort_header">useful skills</td> <td> <ul> - <li>OpenOffice.org's component model (<a href="http://wiki.services.openoffice.org/wiki/Uno";>UNO</a>)</li> + – </ul> </td> </tr> <tr> <td class="effort_header">estimated effort</td> - <td>3 weeks</td> + <td>2 weeks</td> </tr> <tr> <td class="effort_header">difficulty</td> @@ -570,18 +559,30 @@ <hr style="width: 100%; height: 2px;"> <!-- =============================== --> - <!-- SQL Syntax Highlighting --> - <h3><a name="syntax_hilight"></a>SQL Syntax Highlighting</h3> + <!-- HSQLDB: editable views --> + <h3><a name="editable_views"></a>HSQLDB: editable views</h3> <h4>description</h4> - <p>The SQL view of the query designer, which displays, and allows to edit, - raw SQL statements, currently is a mere text input field. It would be helpful - especially to the unexperienced user to have syntax highlighting here: SQL keywords - should be notable, literals should be distinguished, and the like.</p> + <p><a href="http:///hsqldb.org"; title="http:///hsqldb.org";>HSQLDB</a>, + used as OpenOffice.org's database engine, features the usage of views + (basically, stored SQL queries).</p> - <p>OpenOffice.org already features core components which allow syntax highlighting - in a text field - the most prominent example is the Basic IDE -, so there already is - a foundation to base this feature on.</p> + <p>An advantage of views over queries is that the former can be re-used in + other queries, i.e. you can do a <code>SELECT * FROM foo</code> where + <code>foo</code> is the name of an existing view, i.e. a <code>SELECT</code> + statement itself.</p> + + <p>A disadvantage of views is that the constituting statement cannot be edited + in OpenOffice.org Base once the view has been created.</p> + + <p>Goal of this project is to provide an "Edit view" functionality in + OpenOffice.org Base, for the moment for the HSQLDB backend only. + For this, an API needs to be defined which allows editing views. This API has + to be implemented in Base' dedicated HSQLDB driver. Additionally, the user + interface should respect the existence of this API by offering an "Edit View" + item in the context menu of views. Once chosen, Base' query designer is to be + started, to modify the SQL statement constituting the view. Saving the work in + the designer should change the view's underlying statement.</p> <table style="text-align: left;" cellspacing="0"> <tbody> @@ -590,7 +591,6 @@ <td> <ul> <li>C++</li> - <li>SQL knowledge</li> </ul> </td> </tr> @@ -598,13 +598,13 @@ <td class="effort_header">useful skills</td> <td> <ul> - – + <li>OpenOffice.org's component model (<a href="http://wiki.services.openoffice.org/wiki/Uno";>UNO</a>)</li> </ul> </td> </tr> <tr> <td class="effort_header">estimated effort</td> - <td>2 weeks</td> + <td>3 weeks</td> </tr> <tr> <td class="effort_header">difficulty</td> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
