Arad-OneTable-Editor is a set of perl modules to manage and display a dialog for a single-table SQL query. It can verify types, and scroll between the records. The data handling is separate from the dialog class, so it is possible to write different generic dialogs for the same query. A Perl/Tk dialog and a GNU/readline (or plain text) dialog are included in the distribution.
The DataBrowser is a Java-based tool for browsing virtually any database. It has been tested with Oracle, SQL Server, PostgreSQL/Postgres, MySQL, DB2, and MS Access (among some others). It requires a Java 2 runtime environment. The DataBrowser allows you to execute dynamic SQL, import and export data, view the schema in a treeview, and view query results in a table view. It also logs all SQL executed with the SQLLog feature.
Expresso Framework is an open standards-based J2EE architectural framework that allows the developer to concentrate on application logic. It is a library of extensible Java Server application framework components for creating database-driven Web applications based on open standards. Expresso integrates with Apache Jakarta Struts, which emphasizes presentation and application configuration, and bringing a powerful tag library to Expresso. Expresso adds capabilities for security, robust object-relational mapping, background job handling and scheduling, self-tests, logging integration, automated table manipulation, database connection pooling, email connectivity, event notification, error handling, caching, internationalization, XML automation, testing, registration objects, configuration management, workflow, automatic database maintenance, and a JSP tag library.
iSQL(IndependentSQL)-Viewer is a JDBC 2.0-compliant application that can take advantage of platform features such as transactions, running batch modes, and database abstraction. Even in heterogeneous database environments, it supports all database platforms with a JDBC 2.0-compliant driver, such as PostgreSQL, MySQL, and Oracle. It provides a variety of tools to carry out both simple and complex database activities.
Jacquard is a Web-database integration toolkit, written as a Java Servlet package. It is designed to make it extremely easy to build two- and three-tier client-server applications which will be completely portable to any hardware platform and operating system which supports a Java 1.2-compliant JVM or a JDBC 2.0-compliant database management system, or any Web server or Web Application Server which supports the JSDK 2.0 API.
Metabase is a DBMS-independent PHP API to access SQL databases. It supports MySQL, PostgreSQL, Oracle, Microsoft SQL server, Microsoft Access, ODBC, Interbase, Informix, MiniSQL, and SQLite. It supports nested transactions, blobs, and prepared queries. It can install database schemas defined in a DBMS independent XML format that describe tables, indexes, primary keys, and auto-increment sequences. It is also able to upgrade a database to a new schema without affecting the data that was stored since it was installed or upgraded for the last time. There is also schema reverse engineering support.
XML-DBMS is a set of Java packages for transferring data between XML documents and relational databases. It views the XML document as a tree of objects in which element types are generally viewed as classes and attributes and PCDATA as properties of those classes. It then uses an object-relational mapping to map these objects to the database. An XML-based mapping language is used to define the view and map it to the database.