SOFA is a statistics, analysis, and reporting program with an emphasis on ease of use, learning as you go, and beautiful output. SOFA can connect directly to your database and lets you display results in an attractive format ready to share or put in a spreadsheet. SOFA will help you learn as you go, whether you are a student, business analyst, or researcher.
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.
vmm is an easy-to-use and configurable commandline tool for administrators and postmasters, used to manage domains, alias-domains, accounts, and relocated mail users. It allows fast and easy management of mail servers. It's designed for installations using Dovecot and Postfix with a PostgreSQL backend.
KForge is a stable, enterprise application for project hosting. KForge provisions project services on-demand and controls access with a robust, role-based, single sign-on access controller. Project services include version control systems (e.g. Git, Mercurial, Subversion); project frameworks with mechanisms to plan and track work (e.g. Trac); wikis and mailing lists (e.g. MoinMoin, Mailman); and content management systems and blogs (e.g. Joomla, Wordpress). KForge also provides a complete Web interface for administration of project members and services, as well as a fully-developed plugin system so that new kinds of services can be added easily.
Pyrseas provides a framework and utilities to upgrade and maintain a relational database. It currently includes the dbtoyaml utility to create a YAML description of a PostgreSQL database's tables, and the yamltodb utility to generate SQL statements to modify a database to match an input YAML specification. It also aims to develop data administration tools to supplement an agile database development process.
HTSQL a high-level query language and Web service gateway for relational databases. It comes with source code and is royalty free for any use with open source database systems such as MySQL, PostgreSQL, SQLite, etc. Licenses for using HTSQL in conjunction with proprietary databases such as Microsoft SQL and Oracle can be purchased.
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.
py-postgresql is a set of Python modules providing interfaces to various parts of PostgreSQL. Notably, it provides a pure-Python driver + C optimizations for querying a PostgreSQL database. It features: prepared statement driven interfaces; cluster tools for creating and controlling a cluster; support for most PostgreSQL types (composites, arrays, numeric, datetimes, and many more); and COPY support.