The GdaBrowser program is a graphical tool to get a quick access to a database's structure and contents. This is a work in progress and more features will be added with time.
This tool aims at being simple to use, visually appealing, and full of features usefull to the database administrator or to discover a new database.
The main features are:
- it is possible to open any number of connections withing a running instance
- can access any database Libgda supports
- is fully multi-threaded to the UI never locks on an operation
is organized around the notion of perspective which correspond to activities, and is easy to extend adding new perspectives
- fullsreen support
- integrated help
Schema browser perspective
In this perspective, one is able to browse through the database's tables and view their properties and relations:
Query execution perspective
Use this perspective to execute SQL commands:
Data manager perspective
Use this perspective to work on the data actually stored in the database using auto-refresh tabular views. All you have to do is define "data sources" which are each either a specified SELECT SQL query or a table, and define dependencies between the data sources. When executed, the perspective looks like the following screenshot:
There are 5 data sources defined (from left to right and top to bottom):
- one listing all the rows in the "cutomers" table
- one listing the selected customer's details
- one listing all the selected customer's orders
- one listing all the products in the selected order
- one listing all the orders contains the selected product
Each time a selected row changes, the dependent data sources are re-executed to display an up to date result.