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.
MixERP is a multi-currency, multi-lingual, and multi-establishment ERP solution. It allows you to operate multiple Office Groups and Offices, and consolidate and/or split reports on the fly, and provides a policy engine for G/L access, integrated workflow engine for transaction posting and verification, automatic decision making based on your configuration, and end of day operation.
papaya CMS is a Web Content Management System based on open standards (including XML, XSLT, PHP, and MySQL/PostgreSQL). It is compatible with almost every operating system, is platform-independent, is multi-lingual, offers great usability, and is easy to extend via its plugin system. It is scalable and perfect for business websites.
"PHP Web Security Monitor" is designed to protect Internet sites created with PHP from malicious queries from hackers and Web viruses. It filters common PHP variables via prepared security patterns and compares (unprotected) input variables against patterns of dangerous data, such as SQL injection, XSS injection, and PHP code compromising.
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.
The YB.ORM library aims to simplify writing C++ code that has to deal with SQL databases. The goal is to provide a convenient interface like SQLAlchemy (Python) or Hibernate (Java). The library itself is cross-platform and supports a variety of SQL dialects: SQLite3, MySQL, Postgres, Oracle, and Firebird. Integration with Boost, Qt4, and wxWidgets is built-in. In a typical usage scenario, you would describe your database schema and table relationships in a simple XML-based format, generate SQL code to populate database schema with tables, generate C++ classes, add application-specific logic to the classes, and use these classes in cooperation with the Session object to query objects from the database, create new or modify/delete existing objects, or link and unlink objects using relations. Simple serialization to XML is supported along with connection pooling.
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.