31 January 2008

GUI (graphical user interface) for MySQL. GPL

MyJgui 0.5.7 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.

24 January 2008

Data synchronization/replication software. LGPL

SymmetricDS 1.2.0 is Web-enabled, database independent, data synchronization/replication software. It uses Web and database technologies to replicate tables between relational databases in near real time. The software was designed to scale for a large number of databases, work across low-bandwidth connections, and withstand periods of network outage. It includes support for Oracle, MySQL, PostgreSQL, and MS SQL Server databases.

16 January 2008

Program for browsing MySQL databases. GPL

Entrance 1.2.18 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.

08 January 2008

Extract, Transform, and Load. GPL

Talend Open Studio 2.2.4 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.