Edit-DB provides a web browser interface to easily view and edit database data,
and view an edit other standard database objects for Oracle, MS SQL Server, MySQL, Postgre, IBM DB2, IBM Series i (iSeries, AS/400)
and HSQLDB databases.
Edit-DB is fully compatible with
Internet Explorer and
Edit-DB is hosted within a servlet container such as
Apache Tomcat or
Installation of Edit-DB on the server is simply to drop the application .war
file into Apache Tomcat's or Resin's webapps directory.
Giving a user access to Edit-DB is as simple as informing them of the url, by default
http://yourserver:8080/EditDB, and providing them with the name of the database server
and a userid and password.
- Selection of a database object, e.g. a table, from a list, to display it.
- A multi-record display of Table or View data allowing easy selection and sorting of the data
without the need for SQL knowledge.
- Display and Print the data
- Display associated data in foreign key tables
- Edit data in-line
- A single-record display of a Table or View record, simply by double clicking on a row in the
- Display and Print the record
- Edit the record, or delete it or copy it to another record.
- Copy a table, or a selection of its rows, to another table.
- List, Display, Create, Edit, Delete functions for other database object types such as:
- Stored Procedures
- Packages and their objects (Oracle only)
- Indexes (list & display only)
- Sequences (list & display only)
- List relationships between tables and other tables, with the ability to display the relationships
graphically using Scalable Vector Graphics (SVG).
- A SQL entry interface to directly enter SQL commands.
- A multi-window option to enable different tables' data, or different objects to be displayed
The browser window is divided into sections, known as frames as in the following diagram
which can be compared with the screenshots which follow:
|1. database, owner, object-type choice
3. object details
These frames will be referred to as:
1. The Object-Type frame
2. The Object-List frame
3. The Object-Detail frame