Relational Data Explorer (RDE) 1.0

Relational Data Explorer (RDE) is a tool to comfortably navigate between database tables connected by foreign key relationships. It is not meant as database administration tool, but as viewer tool that allows the user to do all the task necessary to find information in a larger network of tables.

In order to do this a definition of the relationships and dialog structures is done nearly completely by using SQL. These definitions get done via RDE Designer and get executed by RDE Explorer. The SQL statements may contain everything that the database system supports, union, functions, procedures, i.e. quite a mighty toolset to tailor the data to be displayed. Currently the following database systems are supported by native interface:
- MySQL
- SQLite3
- PostgreSQL
- Oracle
A lot of other systems are supported via ODBC (esp. MS SQL- Server, Access)

So the target is to provide an easy to use and easy to configure development platform for database investigation tasks. RDE is not meant to replace tailor-made, sophisticated, large scale and expensive business applications, but to do its job in those cases, where you do not need the full complexity of a database application, i.e. in the home and small business area, or for development and support people who need a more direct and unfiltered view of the data than what a complex application may offer.

In effect, RDE is based on the idea, that there is a relatively small number of concepts, from which an application is composed, a one- or multi-column list of data with selection possibilities, a tree, plain multi-line text, a two-dimensional list etc., which obviously can be varied visually in multiple ways, but which logically always stay the same; and even if you do not want to pay for the comfort of these variations you can come quite far with the RDE approach, with the benefit of speed, cost and transparency.

RDE is available in English, German, French and Spanish, the help file only in English.