Some time in the next month or so, I am going to release an ultralight DatabaseMetaData to XML routine and an XML to org.hsqldb.util.Tree display adapter. I have much of it done already, but it needs refinement and testing. When finished, this will allow displaying a much broader range of DatabaseMetaData in the hsqldb Tree control, as well as filtering of displayed items and the ability to create XML output of database schema to file. The new classes are based on nanoXML-lite, with modifications I have added @ ~8-10K, plus the DatabaseMetaData to XML converter @ ~ 8K, plus the XML to Tree display adapter @ ~ 2k, with sizes noted as compiled with no debugging info. All in all, this should come in at under 20K, or about 10K jar space, which is pretty good, considering that any XML document will be displayable in the Tree control without additional custom code, and considering that the full range of metadata that each driver actually provides can be displayed.
I replied here in response to your request to make refreshTree protected.
It might also be nice to allow Tree layouts and font adjustments that look
nicer on the smaller screen.
The attached shot is of my personal version of DatabaseManger. The split
panels and image buttons are part of a 100% JDK 1.1.x/applet use compliant
lightweight set of controls that I have developed for hsqldb use, which
include a mouse-over tooltip manager, toolbar with button separators, etc.
The tree shows some of the information my hsqldb metadata patch provides and
uses my MetaData -> XML -> tree display approach to do so.
If you are interested in helping to finish off the MetaData -> XML -> tree
display stuff, it would be very welcome. I have a huge load at the moment.
If not, oh well: I'll just take longer.
----- Original Message -----
From: "Ulrich Vollert" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 12, 2002 4:12 PM
Subject: [Hsqldb-developers] hsqldb on Sharp Zaurus
> Hi,
>
> I got the new Sharp Zaurus PDA which is running with Linux (!).
>
> And the Sharp feels very comfortable with hsqldb.
>
> The screen has only 240 x 320 pixel, so I decided to change the
> layout of the DatabaseManager.
>
> I separated the tree, command and result panels in a card layout, so
> that every view is on its own and can be choosen by a three buttons
> row above them.
>
> To follow easier the development of hsqldb and especially the
> DatabaseManager, I subclassed DatabaseManager and ConnectionDialog and
> implemented there the methods
>
> class ZDatabaseManager
> +> connect ()
> +> main ()
> +> showUsage ()
> +> main ()
> +> keyTyped ()
> +> actionPerformed ()
> +> initGUI ()
>
> class ZConnectionDialog
> +> ZConnectionDialog ()
> +> create ()
> +> createConnection ()
>
> Questions:
>
> 1. I ask for changing the method of DatabaseManager from
>
> private void refreshTree() {}
>
> to
>
> protected void refreshTree() {}
>
> so that the subclass ZDatabaseManager is able to inherit/access this
> method.
>
> 2. If I finish my development and there are people who are interested in
> this code, it could be brought into the general source code for
> hsqldb. Is there any interest?
>
> 3. I packaged the necessary files for the Zaurus in an installation
> (ipkg) file which includes
>
> - a control-file for installation and de-installation,
> - a starter script (i. e. the call of the JVM with
> org.hsqldb.util.ZDatabaseManager)
> - a so-called desktop file which contains some informations
> about the application
> - hsqldb.jar
> - an icon file
>
> For the last, I choosed the icon on the homepage of hsqldb
>
>
DatabaseManager.gif
Description: GIF image
