Soft82.com » Windows » Internet » Web Servers » PostgreSQL 9.1.3-1

PostgreSQL Description

PostgreSQL is a powerful, open source relational database system

With significant new functionality and performance enhancements, this release represents a major leap forward for PostgreSQL. This was made possible by a growing community that has dramatically accelerated the pace of development. This release adds the following major features:

Featureful and Standards Compliant

PostgreSQL prides itself in standards compliance. Its SQL implementation strongly conforms to the ANSI-SQL 92/99 standards. It has full support for subqueries (including subselects in the FROM clause), read-committed and serializable transaction isolation levels. And while PostgreSQL has a fully relational system catalog which itself supports multiple schemas per database, its catalog is also accessible through the Information Schema as defined in the SQL standard.

Data integrity features include (compound) primary keys, foreign keys with restricting and cascading updates/deletes, check constraints, unique constraints, and not null constraints.

It also has a host of extensions and advanced features. Among the conveniences are auto-increment columns through sequences, and LIMIT/OFFSET allowing the return of partial result sets. PostgreSQL supports compound, unique, partial, and functional indexes which can use any of its B-tree, R-tree, hash, or GiST storage methods.

GiST (Generalized Search Tree) indexing is an advanced system which brings together a wide array of different sorting and searching algorithms including B-tree, B+-tree, R-tree, partial sum trees, ranked B+-trees and many others. It also provides an interface which allows both the creation of custom data types as well as extensible query methods with which to search them. Thus, GiST offers the flexibility to specify what you store, how you store it, and the ability to define new ways to search through it --- ways that far exceed those offered by standard B-tree, R-tree and other generalized search algorithms.

GiST serves as a foundation for many public projects that use PostgreSQL such as OpenFTS and PostGIS. OpenFTS (Open Source Full Text Search engine) provides online indexing of data and relevance ranking for database searching. PostGIS is a project which adds support for geographic objects in PostgreSQL, allowing it to be used as a spatial database for geographic information systems (GIS), much like ESRI's SDE or Oracle's Spatial extension.

Other advanced features include table inheritance, a rules systems, and database events. Table inheritance puts an object oriented slant on table creation, allowing database designers to derive new tables from other tables, treating them as base classes. Even better, PostgreSQL supports both single and multiple inheritance in this manner.

The rules system, also called the query rewrite system, allows the database designer to create rules which identify specific operations for a given table or view, and dynamically transform them into alternate operations when they are processed.

The events system is an interprocess communication system in which messages and events can be transmitted between clients using the LISTEN and NOTIFY commands, allowing both simple peer to peer communication and advanced coordination on database events. Since notifications can be issued from triggers and stored procedures, PostgreSQL clients can monitor database events such as table updates, inserts, or deletes as they happen.
Highly Customizable

PostgreSQL runs stored procedures in more than a dozen programming languages, including Java, Perl, Python, Ruby, Tcl, C/C++, and its own PL/pgSQL, which is similar to Oracle's PL/SQL. Included with its standard function library are hundreds of built-in functions that range from basic math and string operations to cryptography and Oracle compatibility. Triggers and stored procedures can be written in C and loaded into the database as a library, allowing great flexibility in extending its capabilities. Similarly, PostgreSQL includes a framework that allows developers to define and create their own custom data types along with supporting functions and operators that define their behavior. As a result, a host of advanced data types have been created that range from geometric and spatial primitives to network addresses to even ISBN/ISSN (International Standard Book Number/International Standard Serial Number) data types, all of which can be optionally added to the system.

Just as there are many procedure languages supported by PostgreSQL, there are also many library interfaces as well, allowing various languages both compiled and interpreted to interface with PostgreSQL. There are interfaces for Java (JDBC), ODBC, Perl, Python, Ruby, C, C++, PHP, Lisp, Scheme, and Qt just to name a few.

Best of all, PostgreSQL's source code is available under the most liberal open source license: the BSD license. This license gives you the freedom to use, modify and distribute PostgreSQL in any form you like, open or closed source. Any modifications, enhancements, or changes you make are yours to do with as you please. As such, PostgreSQL is not only a powerful database system capable of running the enterprise, it is a development platform upon which to develop in-house, web, or commercial software products that require a capable RDBMS.

PostgreSQL Version History

PostgreSQL Download Button For Your Site

If you want to place a Download Button for PostgreSQL on your website just insert the following code:

If you want a Link to this page you can use one of the logos bellow:

PostgreSQL User Reviews

New Web Servers Software

vuTrapCon May 22, 2012 A very descriptive and user friendly SNMP Trap Console				Node May 21, 2012 A platform built on Chrome's JavaScript runtime for easily building fast
QTracker May 17, 2012 Qtracker lets you say goodbye to the in-game browser				JumpBox for the OTRS Trouble Ticketing System May 17, 2012 An intuitive user interface to quickly guide users through deployment
TurboFTP Server May 15, 2012 A high performance, secure, scalable and management friendly file transfer server				Server Status Monitor May 15, 2012 Monitor multiple servers and give you notifications when the servers are down
JumpBox for the GLPI IT and Asset Management System May 15, 2012 GLPI is an IT and Asset Management System				Newsletter Infowise Ltd May 14, 2012 Deliver news directly to your recipients' mailboxes
SMTP Relay Server May 11, 2012 A program for Windows that lets you convert any Windows based PC into SMTP server				BitNami WAMPStack May 11, 2012 Easy-to-install environment to develop and deploy PHP applications
JumpBox for the MoinMoin Wiki Software May 11, 2012 Ready to run Virtual Machine/Virtual Appliance for VMware, Parallels, VirtualBox				Cascaded Lookup Column May 10, 2012 Enhance standard Microsoft SharePoint lookup functionality
Advanced Onion Router May 10, 2012 A client for OR networks				FreeNAS May 10, 2012 An embedded open source NAS (Network-Attached Storage) distribution based on FreeBSD
SPCarousel May 7, 2012 A webpart that allows you to have a carousel that contains an image with a link below it				MyConnection Server May 7, 2012 MyConnection Server (formerly MySpeed Server) is a server side Java application
NeoLoad May 4, 2012 The load testing solution for all your web applications				RISE Editor May 3, 2012 RISE is a software suite for model driven information system development
Web Log Explorer May 2, 2012 Web log analysis on-the-fly. Get as deep into your log files as you need to				Column Permissions April 27, 2012 Manage access to list content on column level

Last 7 Days Most Downloaded Web Servers Products

Apache Tomcat 68 downloads An open source software implementation of the Java Servlet and JavaServer Pages technologies				JumpBox for the PunBB Discussion Forums Software 57 downloads JumpBox makes using server software quick and simple
Microsoft Office Migration Planning Manager 24 downloads A group of tools designed to help administrators				PS3 Media Server 17 downloads A DLNA compliant Upnp Media Server for the PS3, written in Java, with the purpose of streaming
PostgreSQL 15 downloads PostgreSQL is a powerful, open source relational database system				ESET Mail Security for Microsoft Exchange Server 14 downloads Fast, Light and Effective Messaging Security
dbForge Studio for MySQL Express Edition 14 downloads A cutting-edge administration tool and development environment for professional working with MySQL				Navicat for SQLite 12 downloads Navicat for SQLite is a powerful Database administration and development tool for SQLite
Wild media server (UPnP, DLNA, HTTP) 11 downloads Provides media resources (photographs, audio and video files) on your computer to other UPnP (DLNA)				Google Chrome Frame 6 downloads An open source plug-in that seamlessly brings Google Chrome's open

All Time Most Downloaded Web Servers Products

Apache Tomcat 2,869 downloads An open source software implementation of the Java Servlet and JavaServer Pages technologies				JumpBox for the PunBB Discussion Forums Software 5,175 downloads JumpBox makes using server software quick and simple
Microsoft Office Migration Planning Manager 2,451 downloads A group of tools designed to help administrators				PS3 Media Server 4,403 downloads A DLNA compliant Upnp Media Server for the PS3, written in Java, with the purpose of streaming
PostgreSQL 9,354 downloads PostgreSQL is a powerful, open source relational database system				ESET Mail Security for Microsoft Exchange Server 646 downloads Fast, Light and Effective Messaging Security
dbForge Studio for MySQL Express Edition 577 downloads A cutting-edge administration tool and development environment for professional working with MySQL				Navicat for SQLite 338 downloads Navicat for SQLite is a powerful Database administration and development tool for SQLite
Wild media server (UPnP, DLNA, HTTP) 1,840 downloads Provides media resources (photographs, audio and video files) on your computer to other UPnP (DLNA)				Google Chrome Frame 3,313 downloads An open source plug-in that seamlessly brings Google Chrome's open