10 projects tagged "postgresql"
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.
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.
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.
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.
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.