PostgreSQL is a robust relational database system with over 25 years of active development that runs on all major operating systems. It is fully ACID compliant, and has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, and ODBC, among others, and exceptional documentation.
SymmetricDS 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, H2, HSQLDB, Derby, MS SQL Server, Firebird, IBM DB2, Informix, Interbase, and Greenplum databases.
Cego implements a relational and transactional database system with support for the SQL query language. The current release contains the most common database features for basic table manipulation and data retrieval. Indexes, foreign keys, views, and stored procedures are also implemented. Future releases (2.0 and above) will support a multi-node database concept with log file shipping for an automatic database application failover.
MUSCLE (Multi User Server Client Linking Environment) is an N-way messaging server and networking API. It includes client-side networking APIs for various languages, including C, C++, C#, Delphi, Java, and Python. MUSCLE lets programs communicate over a network via streams of serialized Message objects. The included server program ("muscled") lets its clients message each other and store information in its server-side hierarchical database. The database supports flexible queries via hierarchical wildcarding, and "live" updates via a subscription mechanism.
libdbi implements a database-independent abstraction layer in C, similar to the DBI/DBD layer in Perl. Writing one generic set of code, programmers can leverage the power of multiple databases and multiple simultaneous database connections by using this framework. The plugin architecture allows for new database drivers to be easily added by a third party with flexible licensing.
H2 is an SQL database engine written in Java that implements the JDBC API. Embedded, server, and clustering modes are available. A browser based console application is included. The database has strong security features. Disk based and in-memory databases and tables are supported.
phpPgAdmin is a fully functional PHP-based administration package for PostgreSQL. It 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.
CloverETL is Java-based tool/framework for data integration and creation of data transformations. It is component based and follows the concept of transformation graphs which consist of individual nodes/components performing simple (or complex) operations on data. Any transformation can be defined as a set of interconnected nodes through which data flows. CloverETL can be used as a standalone application or be embedded into a larger project.