dbRadar is a tool for the administration, monitoring and development of a variety of Databases. It is available for Linux, Windows and Mac OS X. dbRadar competes very favorably with products such as TOAD from Quest Software and NORAD from Bradmark, but at a fraction of the price.
dbRadar works with the following databases:
Oracle
PostgreSql
MySql
DB2
ODBC
SqlLite
If the connection is successful the worksheet will open and the user can then use any DDL or DML that the target database supports.
dbRadar uses the MDI approach for representing all of its child windows.
This means that the user can open as many windows as he/she wants, close and navigate through them.
From the File menu the user can Print, Save and Load any text files into the worksheet and execute them as sql scripts. The user can drop the actual connection with the database and start a new one from the File menu.
In the worksheet the user can cut, copy and paste any text using the appropriate key (CTRL-X, CTRL-C, CTRL-V) combination or by choosing the edit menu after the text has selected. The Database menu offers the user the ability to open a new worksheet or a new system load window. To switch from one window to another, use the Window menu. For Oracle and PostgreSql connections the
user has the ability to use code completion for selecting columns from the tables.
The user can save the result set by right clicking the mouse over the grid and choosing a name for the file.
For Oracle connections only, the user can browse the objects from the database using the tree representation from the left and also can choose to see the execution path for a specific
select statement by clicking the explain button from the worksheet toolbar.
Features
Worksheet - Issue any DDL or DML that is supported by the target database. The result set is presented in a grid from which it can also be saved. A status display will indicate the progress of the query.
Threaded Queries - Queries run in their own thread so that the application remains responsive even during long executions. A special feature for Oracle databases is the ability to break any long running query.
Multiple, simultaneous database connections. The user can switch from one connection to another.
Powerfull editor with Syntax highlighting for : SQL, PL/SQL, PGPL/SQL, MYSQL, DB2
Code completion - Makes it quick and easy to select columns you want from your particular database. This feature is only available for Oracle and PostgreSQL currently.
Oracle Applications - Only for Oracle Business Suite 11.0.3 and 11.5. You can monitor OA users and kill sessions.
An upcoming version will allow you to view concurrent requests.
Remote Info - Gather remote/local HP-UX, Sun OS, Linux load (system, user, idle) and processes.
Database Objects - Users can visually browse and edit database objects (Oracle only).
Save/Load any text files and execute them as SQL scripts, keep history files.
Print any text in a worksheet.
Tuning - The worksheet provides a tabbed page where the user can see the execution path for the current statement executed in a tree fashion (only for Oracle currently)
Supports statements with placeholders in the worksheet. This way a user can insert something like a large object into the database.
Ftp Support. Users can open, edit and transfer files via ftp.
Planned Features
Users can visually browse and edit database objects for Postgres, Mysql and DB2.
SSH support for retriving remote info.
Support for Sql Server, Sybase, Sap, Interbase, Firebird
Show online database performance indicators (buffer cache hits, library cache hits - for Oracle databases)
By making use of our multiple database connections we will also be able to migrate data from one database to another.
