Projects tagged ‘postgres’ and ‘sql’

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]

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]

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]

A Postgres database driver for the original AOLserver/NaviServer nsdb driver interface. See also: nsdbipg

Small python class and utility for using PostgreSQL database as XML document storage.

This is a project for a class at ITC Dortmund called 'nap'. It either stands for 'not another pgadmin' or 'n00bs avoid postgres' or 'network admin for postgres' or something completely else. The ... [More] code will be ugly, unmaintainable and hardly compilable. Just don't try it out. seriously... [Less]

This is a new intiative to develop a unique Dashboarding application. The development will be in PHP. The studio will allow to connect to any database and Excel files. It will allow you to create ... [More] reports and Dashboards. Dashboard Studio will be able to import dashboard definitions directly from InfoCaptor Designer. It will also have in-built role and security mechanism. This will be a totally new application from InfoCaptor which is a java based Dashboard application. [Less]

A Postgres database driver for the AOLserver nsdb driver interface. Includes additional Tcl commands not specified in the nsdb interface which emulate bind variables.

PgPatcherMaintaining a live PostgreSQL database is easier when you create patches - this way you can keep track of everything you've done to the database and replay each patch on another installation ... [More] (dev, test, live, etc). And also having transactional DDL (thanks Postgres) means this is a whole lot easier. By placing patch files (patch_0_1.sql, patch_1_0.sql) into a directory and pointing pgpatcher at them, you can patch - and reverse patch - to your hearts content. [Less]