14 June 2008

Distribution of PostgreSQL. GPLv2

Postgres Plus 8.3.3 is a distribution of PostgreSQL that contains the following additional features integrated in a convenient installation package: Postgres Studio for administration, Procedural Language Debugger, Geospatial extensions, GridSQL Parallel Query, MySQL Migration utility, Slony-II for replication, and pgmemcache for application scaling. The package contains both BSD and GPLv2 licensed software.

10 June 2008

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

Talend Open Studio 2.4.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 RC P, and data related scripts are generated in Perl or Java. The application was designed to be extended with components written by users.

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

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

04 June 2008

GUI (graphical user interface) for MySQL. GPL

MyJgui 0.6.1 aims to be easy to use for new users as well as experts. You can store multiple connections that can be used simultaneously. Stored passwords are encrypted using symmetric encryption. Underlying databases and tables are displayed in a tree structure with the connections being the first level nodes. MyJgui is capable of easy data manipulation through a grid. It has a unique feature of bookmarking parametrical queries (sqlmarks). The documentation (user guide) is quite comprehensive and kept up-to-date.