phpPgAdmin is a fully functional PHP-based administration package for PostgreSQL. It has all the basic functionality you need to completely administer a PosgreSQL server and/or database, including the ability to administer views, sequences, stored procedures, and triggers. Features include the ability to create and drop databases; create, copy, drop, and alter tables/views/sequences/functions/triggers; edit and add fields (to the extent Postgres allows); execute any SQL-statement, even batch-queries; manage keys on fields; create and read dumps of database and tables; and administer one single database, multiple servers, and Postgres users/groups.
]project-open[ is a Web-based enterprise project management application with a focus on finance and collaboration. Its main purpose is to coordinate the work of project managers, project members, and stake holders across multiple projects. Target organizations are companies or corporate departments that need to track finances, tasks, and resources for a large number of concurrently running projects. ]project-open[ consists of about 200 modules for resource management, time sheet management, HR, CRM, ITSM, collaboration, and financials. It is built on top of OpenACS.org, an open-source Web platform featuring role-based permissions, workflows, dynamically extensible objects, and full-text search.
Uhura is a Web console for databases. It works with MySQL, PostgreSQL, and FirebirdSQL. It presents trees that let you browse databases, tables, columns, constraints, triggers, views, and procs. It has panels for history and fragments. Its editor features autocompletion and autoindenting. It is easy to install.
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.
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.