30 March 2007

API for software developers to different database management systems. LGPL

OpenDBX 1.3.1 library provides a unified and consistent API for software developers to different database management systems. The function library is written in the C programming language and aims at implementing access to the native database interfaces efficiently via a thin abstraction layer. It consists of a basic set of functions that are part of all vendor database libraries and can be extended by additional function blocks. Currently, Firebird/Interbase, MS SQL Server, MySQL, Oracle, PostgreSQL, SQLite 2 and 3, and Sybase ASE are supported.

28 March 2007

Aubit 4GL compiler is a project to make a free Informix-4GL compatible compiler. GPL

Aubit 4GL compiler 1.00-25 is a project to make a free Informix-4GL compatible compiler. It translates 4GL source into executable programs, enabling fast creation of screen/form-based applications. With support for SQL statements forming an intrinsic part of the language, it's especially suitable for developing database-oriented applications. Database connectivity is provided for PostgreSQL, Informix, and ODBC. It supports both ncurses (console mode) and GTK+ (GUI mode) output.

21 March 2007

PL/SQL snippet (embedded in a shell script) which creates a well-formatted HTML report on a given database instance. GPL

OraRep 0.3.7 is a PL/SQL snippet (embedded in a shell script) which creates a well-formatted HTML report on a given database instance, providing you with an overview on your instance(s), some hints for performance tuning, and more. It has been tested with Oracle 8.1.7, 9.0.1, and 9.2. The script easily fits into a cron task to be run on a regular basis. Sample output (HTML) is included. OSPRep does the same job for Oracle StatsPack Reports based on SnapShot Levels up to 7, and provides additional "plugins" for more detailed reporting on special issues. It also optionally creates a separate page with charts to visualize the results and more.

19 March 2007

Full replacement for sqlplus. GPL

PySQL 0.10 aims to be a full replacement for sqlplus (and much more). It has features such as history, completion, and line editing. It has high level functions (searching for tables, indexes, count, explain plan, list of sessions, etc.), proper output for screen and files (CSV ready for inclusion in spreadsheets), support for user-defined SQL, background queries, graphical output for the schema data model, object dependencies, a PL/SQL package function call tree, and much more.

16 March 2007

Web-based MySQL backup program. GPL

phpMyBackupPro 2.0 is a Web-based MySQL backup program. You can schedule backups (without cron jobs), and download, email, or upload backups with FTP. File directories can also be backed up. No compression, zip compression, or gzip compression of the backups is possible. HTTP or HTML authentication is possible. It has an easy user interface and is easy to install. Many languages and online help are available.

09 March 2007

Command line tool to output your database schema and data in a readable form. LGPL

SchemaCrawler 4.2 is a platform (OS and database) independent command line tool to output your database schema and data in a readable form. The output is designed to be diff-ed with previous versions of your database schema. SchemaCrawler is also an API that improves on standard JDBC metadata.

01 March 2007

Java-based tool for browsing virtually any database. Freeware

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "DataBrowser 3.5.1 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."