ODBC-link is a dblink-style implementation of PostgreSQL database links. It allows users to connect from PostgreSQL to any other ODBC compliant database such as Informix, Oracle, DB2, MySQL, etc. You can integrate data from remote databases into your local query results. Writing requests is fully supported. The implementation is SQL/MED compliant.
AGENCY is software that allows non-profit organizations to track data and manage operations. It is a fork and continuation of CHASERS. AGENCY aims to become a collectively-maintained and developed project that puts organizations in charge of their data systems. There are currently two “flavors” of AGENCY: one for managing clients and services, case management, and such (think “social service”); and one for managing donations and volunteers (think “fundraising”). Features include a report generator, permissions and access control, the ability to merge reports to OpenOffice documents, a log system, and real-time alerts with email notification. In the client version, many tables and data structures are already set up for organizations doing human service, homeless services, or HMIS. The donor version is set up to track donors, addresses, gifts (cash and inkind), flags, volunteers, volunteer activities, and more.
Maatkit is a toolkit for users, developers, and administrators of open-source databases. It is high-quality, formally tested software that is well documented and has an active open-source developer community. It has some unusual goals: all tools are standalone, with minimal dependencies and no need for installation. Documentation is embedded in the tools themselves. There are many other nice attributes, too. Most of Maatkit’s functionality is designed for MySQL. It makes MySQL easier and safer to manage. It provides simple, predictable ways to do things you cannot otherwise do. You can use Maatkit to prove replication is working correctly, fix corrupted data, automate repetitive tasks, speed up your servers, and much more. In addition to MySQL, there is support for PostgreSQL, Memcached, and a growing variety of other databases and technologies.
Collectables Database is a simple, easy-to-use application for using the control and data management capabilities of Postgres to catalog various kinds of collections. It delivers content in a format that is easy to use and manipulate within the convenience of a modern Web browser. The initial focus of the application is on cataloging a comic book collection. Collectables Database can run from a hosted Web server or on the user's local machine through the use of a virtual appliance.
pgDynamicPartitions is a script that allows you to maintain a rolling window of daily table partitions under PostgreSQL. When called daily via cron, it will create x empty partitions into the future and keep only n partitions from the past 30 days, for example, and drop any that are older. It can be used with multiple tables, and each can be treated differently by calling it with different parameters via cron.
SymmetricDS Pro is software for data replication, change data capture, and data transformation in a heterogeneous enterprise environment. Performance and scalability allow it to replicate thousands of databases asynchronously in near real time. With flexible configuration and powerful scripting and programming interfaces, it can be extended to meet a range of requirements. Based on the popular open source version of SymmetricDS, the Pro edition enhances the experience with a click-through installer, Web management console, and production support.
Barman (backup and recovery manager) for PostgreSQL is an administration tool for disaster recovery of PostgreSQL servers. It allows remote backups of multiple servers in business-critical environments and helps DBAs during the recovery phase. Barman's most-wanted features include backup catalogs, retention policies, remote recovery, archiving, and compression of WAL files and backups.