Database Manager

(Please wait while the Applet is downloading)

What is the Database Manager

The Database Manager is a general administration and querying tool for SQL databases with JDBC driver.

Using the Database Manager

The main window is divided in three parts: the Tree (left), the Command Area (upper right) and the Result (lower right). The Tree contains metadata of the database: tables, columns, indices and connection properties. In the Command Area the SQL commands can be edited. The Result part displays the data in a grid or as text.

Menu Commands

In this Example

Currently, the Manager is running as an Applet against the database engine Hypersonic SQL (which is also running locally, on the client site, in the same sandbox as the Manager). The Manager is connected to a in-memory database that is also running on the client side. The demo tables are created by the Manager after each startup.

When run as Application

The Database Manager can also be used as an application, it is then possible to connect to other databases, too. Also the Hypersonic SQL Database engine can run as application, and there is also a persistent mode where the data is stored on disk, and a client/server version of Hypersonic SQL.

The program runs in an own Frame, because embedded Applets can't have menus. All Java source code (including the Grid and the Tree control, and of course the database engine) of this program are Open Source and included in the download. Database Manager is programmed using AWT.