PGObject::Simple::Role provides an interface to the PGObject service locator for Moo and Moose Perl classes. This service locator is intended to integrate Perl objects with PostgreSQL user-defined functions, and this uses the "simple" mapping approach. Between PGObject::Simple::Rrole and PGObject::Util::DBMethod, it is possible to write fully-declarative classes in which all calculation logic is handed off to database functions.
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.
DBeaver is a universal database manager and SQL Client. It supports MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, SQLite, Derby, and any database that has a JDBC driver. It is a GUI program that allows you to view the structure of a database, execute SQL queries and scripts, browse and export table data, handle BLOB/CLOB values, modify database meta objects, etc. It has a native UI (provided by the Eclipse SWT library), great performance, and relatively low memory consumption.
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.
WebIssues is a multi-platform system for issue tracking and team collaboration. It can be used to store, share, and track issues with various attributes, description, comments, and file attachments. It is easy to install and use but has many capabilities and is highly customizable. Desktop and Web clients are provided.
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.