08 December 2007

Informix-4GL compatible compiler and runtime environment. GPL

Aubit 4GL compiler 1.00.69 translates 4GL source into executable programs, enabling very 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, MySQL, Informix, and ODBC. It supports both ncurses (console mode) and GTK+ (GUI mode) output.

04 December 2007

External Language Stored Procedures for MySQL 1.2712

Patch for MySQL 6.0: "... to provide support for stored procedures written in an external languages. Stored procedures are declared in SQL using SQL standards compliant syntax. Additional stored procedure languages are implemented as plug-ins to be installed at run time into the server. Currently, plugins for Java and Perl are implemented, as well as support for declaring XML-RPC requests as stored procedures."

22 November 2007

WebSQL. Freeware

Web based database administrator tool: "WebSQL wants to run on every DBMS and wants to give you the chance to have a unique tool to access and manage a DB...through a simple web interface. * User can: browse database structure as tables, views, keys, indices etc. * create, edit, and execute SQL scripts * save and reload queries * browse and edit table's content in a 'GridView' (excel-like) * view database structure as ER diagram It works with any JDBC compliant database (Oracle, MS SQLServer, MySQL, DB2, Sybase, Firebird, HSQLDB, PostgreSQL, Apache Derby, Mckoi SQL)"

24 August 2007

Oracle database development and testing tool. GPL

GTKO 2.16
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.

Collection of scripts to ease the daily maintenance work of Oracle database administrators. GPL

DBAHelper 0.2.0
Examples are moving objects between tablespaces, analyzing schemata, and rebuilding invalid indices. Also included is a little framework to simplify the use of RMAN (this framework depends on the use of Oracle 10g with the Recovery Area enabled and properly sized, so all backups go there).

21 August 2007

ETL (Extract, Transform, and Load) tool. GPL

Talend Open Studio 2.2.0M1 can perform jobs that range from datawarehouse feeding to database synchronization, as well as file format transformations. Its graphical interface is made with Eclipse RCP, and data related scripts are generated in Perl. The application was designed to be extended with components written by users.

13 July 2007

ETL (Extract, Transform, and Load) tool. GPL

Talend Open Studio 2.1.0 can perform jobs that range from datawarehouse feeding to database synchronization, as well as file format transformations. Its graphical interface is made with Eclipse RCP, and data related scripts are generated in Perl. The application was designed to be extended with components written by users.

06 July 2007

PL/SQL snippet (embedded in a shell script). GPL

OraRep 0.4.1 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.

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.

31 May 2007

PHP/MySQL report generator. GPL

PM Report 4.1 creates customizable reports and is very simple to setup and use. You can select which database, table, and individual fields to use on your report. You can also select the order in which the fields should appear on the report, the field you would like to group by, the field you would like to sort by, and whether or not you would like a total for each column. Once the report has been generated, you can highlight individual rows and export the results to CSV.

23 May 2007

Web interface on top of a relational database (MySQL, PostgreSQL, SQLite, and MonetDB. GPL

Cubulus OLAP 0.52 is an analytic engine and a slice and dice Web interface on top of a relational database (MySQL, PostgreSQL, SQLite, and MonetDB at the moment). It caches calculated cells and is able to parse basic MDX queries, with a maximum of two dimensions cross-join on rows and/or on columns.

22 May 2007

Free Informix-4GL compatible compiler. GPL

Aubit 4GL compiler 1.00-40 compiler 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.

Integrated database and Web environment. LGPL

MyOODB 2.0.0 is an integrated database and Web environment that provides true distributed objects, implicit/explicit multi-concurrent nested transactions, seamless Web tunneling, and database self-healing. MyOODB is one part of a two part SDK solution. Together with MyOOWEB, MyOOSDK provides a development environment for people who desire small, fast, but powerful applications.

18 May 2007

Program for browsing MySQL databases. GPL

Entrance 0.77.5 includes a "match box" search facility that is simlar to the Mac's Spotlight. Entrance can create charts based on query results, and these charts can be zoomed and panned. Entrance also supports an innovative feature called "data painting" that allows users to select and paint data points interactively.

17 May 2007

API for software developers to different database management systems. LGPL

OpenDBX 1.2.3 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.

26 April 2007

Program for browsing MySQL databases. GPL

Entrance 0.75.0 is a program for browsing MySQL databases. It includes a "match box" search facility that is simlar to the Mac's Spotlight. Entrance can create charts based on query results, and these charts can be zoomed and panned. Entrance also supports an innovative feature called "data painting" that allows users to select and paint data points interactively

17 April 2007

Frontend for MySQL. GPL

Gequel 1.15 is a GTK/C based frontend for the popular MySQL database engine. It was loosely derived from an old program by the same author (xsqlmenu). It can retrieve data from MySQL databases, present them in nice browsers, and allows for update, delete, insert, search, query, and copy operations.

16 April 2007

Applications on more than one database management system (DBMS). GPL

dbmstools 0.4.2 module exists mainly for developers who need to support applications on more than one database management system (DBMS). It's intended to allow all the database information (schema and base data) to be kept in one single place, and to have DBMS-specific scripts (for creating and populating the database schema, and upgrading from one version to the next) generated from that data. It can generate schema documentation for any DBMS (including diagrams), and can export data from a database in several formats. It also has wrappers for several tools so that they can be run from within Apache Ant. It supports PostgreSQL 7 and 8, Oracle, SQL Server, MySQL, and Hypersonic (limited support).

04 April 2007

Database development framework for rapidly creating applications. GPL

building object network databases 2.4.2 is database development framework for rapidly creating applications. It creates live forms for the Web with AJAX and desktop applications using GTK. Using XML to define widget layouts, it drives the live forms to which SQL statements and methods can be attached.

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."

26 February 2007

Database development framework for rapidly creating applications. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "building object network databases 2.4.1 is database development framework for rapidly creating applications. It creates live forms for the Web with AJAX and desktop applications using GTK. Using XML to define widget layouts, it drives the live forms to which SQL statements and methods can be attached."

24 February 2007

Integrated environment for managing data. LGPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "Kexi 1.1.2 is an integrated environment for managing data. It helps with creating database schemas and inserting, querying, and processing data. It integrates smoothly into KDE and KOffice, and is designed to compete with Microsoft Access. It is supported under Linux and MS Windows."

17 February 2007

Java-based tool for browsing virtually any database. Freeware

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

13 February 2007

NG-Admin 1.2.7 specializes in editing the content of Web sites, not the database structures. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "NG-Admin 1.2.7 is designed for the content management of MySQL databases. It allows the user to browse, add, edit, and delete data. It is somewhat similar to phpMyAdmin, but specializes in editing the content of Web sites, not the database structures. Its features are very easy to use and highly tunable."

OK. MySQL script for changes in databases. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "sqlupdate 1.6.3.1 reads a MySQL table declaration file and compares it to an existing database. It then generates a MySQL script for updating the database to match the SQL file."

12 February 2007

API for software developers to different database management systems. LGPL

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

08 February 2007

Web-based MySQL backup program. GPL

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

07 February 2007

Java based user interface frontend for viewing, adding, editing, or deleting entries in a MySQL database. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "MyJSQLView 2.64 provides an easy to use Java based user interface frontend for viewing, adding, editing, or deleting entries in a MySQL database. A basic query frame allows the building of complex SQL statements. Sorting, searching, and exporting of all table data is easy."

Flexible and shapable skin that sits on top of MySQL. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "Dataface 0.6.12 is a flexible and shapable skin that sits on top of MySQL, making it accessible to every-day users. It automatically generates the appropriate forms, lists, and menus for a user to interact with the database without having to know any SQL. It is a full-featured Web application framework, and gives developers the flexibility to customize the features and behavior of their application via configuration files (using the simple INI-file syntax), templates, and plug-ins. A generic application with no customizations is completely functional, but the developer is free to customize things at his leisure."

05 February 2007

Full replacement for sqlplus (and much more). GPL

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

31 January 2007

Tool to document MySQL database into HTML, CHM help, MS Word Documentation. Freeware

New Releases of Computer Software, Games, Tools and Utilities at Simtel.net: "DBScribe for MySQL 1.1 is a free powerful tool to document MySQL database into HTML, CHM help, MS Word Documentation. It supports: rich set of output formats and styles, wizard and command line interfaces, complete database structure documenting"

25 January 2007

Database client with a graphical user interface (GUI). Freeware

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "SQL Uniform 1.8.1 is a database client with a graphical user interface (GUI). It is a helper application to relational databases of various types regarding query, maintenance, data comparison, export (convert), and import. It supports any kind of database and database servers to which there is an ODBC or JDBC standard driver. It has been tested on the following databases: Access, Adabas D, DaffodilDB, dBASE, Excel, HSQL, IBM DB2, Interbase (Firebird), JDataStore, Linter (Relex), McKOI, Mimer, MSSQL, MySQL, Openlink Virtuoso, Oracle, Paradox, Pervasive (Btrive), Pointbase, PostgreSQL, Quadcap QED, Solid, SQLITE, Sybase, ThinkSQL, and Yard."

18 January 2007

Query and view the structure of databases. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "DB Browser 1.7.0 is a program that can be used to run queries and view the structure of databases. It was designed to work with as many RDBMS systems as possible using JDBC. It uses a plugin API and can connect to any system for which a JDBC driver exists."

17 January 2007

Set of scripts and programs that provide a high availability database cluster using MySQL GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "MySQL High Availability clustering 0.6.8 (Default branch) is a set of scripts and programs that provide a high availability database cluster using MySQL replication. It is transparent to client applications, as the cluster uses a shared logical IP to provide the service."

12 January 2007

GTK+ 2 interface to Oracle. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
GTKO 1.80 is a GTK+ 2 interface to Oracle that aids in Oracle application development and testing. 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."

11 January 2007

MySQL database manager. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "WizMySQLAdmin 0.11.2 is a MySQL database manager like phpMyAdmin, but it's very easy to install and maintain. It's composed of only one file, and it supports multiple databases and table creation and manipulation."

06 January 2007

Web site generator implemented in Ruby. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
Ruby webgen 0.4.0 is a Web site generator implemented in Ruby. It is used to generate static Web sites from templates and page description files. It is easy to use and extensible through plugins."

04 January 2007

Visual reporting tool. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
iReport Designer for JasperReports 1.3.0 is a visual reporting tool based on JasperReports and written in pure Java. You can manage charts, images, sub-reports, etc. Data can be retrieved using JDBC, TableModels, JavaBeans, and XML. It supports output in PDF, XML, XSL, CSV, HTML, and Java2D."

03 January 2007

View the structure of a JDBC compliant database. LGPLO

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
SQuirreL SQL Client 2.4 is a graphical Java program that allows you to view the structure of a JDBC compliant database, browse data in the tables, issue SQL commands, etc."

02 January 2007

Web application that serves as a customizable generic front-end to any MySQL table. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
myPhile 1.0.9 is a Web application that serves as a customizable generic front-end to any MySQL table. It provides "view" control and user access privileges for editing, deleting, adding records, and more. Field control allows default strings or MySQL calculations on adds or edits. All functions are provided in a single PHP file. Simple and complex searches are possible and the most recent searches are stored. It supports the creation of CSV files. Row views and detail views are configurable through a simple Web interface."