RecDB is a recommendation engine built entirely inside PostgreSQL 9.2. It allows application developers to build recommendation applications using a wide variety of built-in recommendation algorithms such as user-user collaborative filtering, item-item collaborative filtering, and singular value decomposition. Applications powered by RecDB can produce online and flexible personalized recommendations to end-users. It is easily used and configured and allows novice developers to define a variety of recommenders that fits their application's needs in few lines of SQL. It can seamlessly integrate recommendation functionality with traditional database operations.
pg_xnode is an extension (module) which adds several data types to the PostgreSQL database server, allowing it to store XML documents, XML (tree) nodes, and XPath expressions. Unlike the in-core implementation of XML, pg_xnode does not require repeated parsing of XML data, and thus should be more efficient. In addition, the extension has functions to add/remove nodes to/from existing XML documents, and templates to create XML documents from tables.
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.
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.
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.