Projects tagged ‘postgres’ and ‘postgresql’

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 ... [More] 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/roles. [Less]

This project's main objective is to provide routing functionality to PostGIS / PostgreSQL. pgRouting is part of PostLBS, which provides core tools for Location Based Services (LBS) as Open Source ... [More] Software (OSS). Its tools are similar to those found on proprietary software. [Less]

South is a database migration framework for Django applications.

xTuple ERP is a family of ERP, CRM and accounting applications built on a core of open source software. PostBooks Edition (PostBooks) is our free open source ERP solution for small to medium sized ... [More] businesses. Built with the open source PostgreSQL database, and the open source Qt framework for C++, it provides the ultimate in power and flexibility for a range of businesses and industries. PostBooks runs equally well on Windows, Linux, and Mac - and it's fully internationalized (multi-currency, support for multiple tax structures, and multilingual translation packs maintained by our global community) xTuple ERP Standard Edition and OpenMFG Edition include additional features but require a commercial license from xTuple. [Less]

BlackRay is a relational database system designed to offer performance features commonly associated with search engines. It offers SQL support and sophisticated operational and management features. ... [More] Load-balancing and operational stability by means of N+1 redundance are included. BlackRay is called a "Data Engine" since it combines traditional, relational database features and SQL with the power and flexibility of search engines. It is a true hybrid, offering transaction support, data-versioned snapshots, and sophisticated function-based indices. Wildcards, phonetic, and fuzzy logic searches are supported, as well. Commercial support is available, and the project is released under a the GPLv2 license. [Less]

Multi-master replication system for Postgres.

Postgres monitoring script for use with Nagis, MRTG, or standalone usage. Includes checks for locks, table and index bloat, number of connections, database size, idle transactions, and many others.

A Postgres database driver for the NaviServer nsdbi interface.

drush is a command line shell and Unix scripting interface for Drupal, a veritable Swiss Army knife designed to make life easier for those of us who spend some of our working hours hacking away at the ... [More] command prompt. A few core drush features: * The Drush Package Manager allows you to download, enable, disable, uninstall, update modules/themes/profiles/translations from the command line in a very simple way (apt-get style) - just type e.g. drush dl views and drush enable views in a Drupal directory to install the Views project! * Additionally, the Drush Package Manager also allows you to update all your modules with just one command - drush update. * Drush Core: several useful utilities for site administrators and developers (e.g. drush cron; drush cache clear; drush sql dump) [Less]

Django External Schema Evolution Branch Django, via the command ./manage syncdb, can automatically build a database schema based on your applications models.py file. However, after you've done this ... [More] once, it leaves you with two unpleasant follow-up options if you ever make any changes to your model structure: 1. destroy your existing schema (along with all your data) and let ./manage syncdb rebuild it for you 2. manage your own schema upgrades by writing your own SQL Project deseb aims to fill this void by providing s third option: 3. generate schema upgrades via the command: ./manage evolvedb [Less]