20 June 2007

Web client interface for the MySQL database. GPL

MyClient 3.1.4 runs with PHP's register_globals off and outputs validated XHTML and CSS. Features include support for standard and persistent MySQL connections and PHP5's MySQLi interface. It also supports unlimited multiple tabbed interfaces, connection to multiple databases, one-button table descriptions, one-button database switching, query saving and loading, query results saving, and localization. It is not a full featured administration tool, but rather a multiple interface command client that improves upon the command line interface using a Web-based implementation.

05 June 2007

Oracle database development and testing tool. GPL

GTKO 2.03
Its features include a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets in the command window, and SQL*Plus-style command scripting. For SQL statement analysis and tuning there is a tree-style SQL statement "explain plan" facility and the ability to load SQL statements from the runtime cursor cache (V$SQL table), Oracle Statspack repository, the Oracle Automatic Workload Repository in Oracle version 10g, and full AWR reports.

PHP-based administration package for PostgreSQL. GPL

phpPgAdmin 4.1.2 has all the basic functionality you need to completely administer a PosgreSQL server and/or database, including the ability to administer views, sequences, stored procedures, and triggers. Features include the ability to create and drop databases; create, copy, drop, and alter tables/views/sequences/functions/triggers; edit and add fields (to the extent Postgres allows); execute any SQL-statement, even batch-queries; manage keys on fields; create and read dumps of database and tables; and administer one single database, multiple servers, and Postgres users/groups.