PostgreSQL

PostgreSQL is a basic Management system of data relational and object (SGBDRO). It is a free tool available according to the terms of a license of the type BSD.

This system is competitor other basic management systems of data, which they are free (like MySQL and FirebirdSQL), or owners (like Oracle, Sybase, DB2 and Microsoft SQL Server). Like the free projects Apache and Linux, PostgreSQL is not controlled by only one company, but is founded on a world community of developers and companies.

History

The history of PostgreSQL goes back to the database Ingres, developed with Berkeley by Michael Stonebraker. When this last decided in 1985 to start again the development of zero, it named the Logiciel Postgres, like short cut of post-Ingres . At the time of the addition of the functionalities SQL in 1995, Postgres was famous Postgres95. This name was changed at the end of 1996 into PostgreSQL.

Main features

PostgreSQL can store more types of data than the traditional types entirety, characters, etc the user can create types, functions, use the heritage of the type etc

PostgreSQL functions on Solaris, SunOS, Mac OS X, HP-UX, AIX, Linux, Irix, DIGITAL Unix, BSD, NetBSD, FreeBSD, OpenBSD, SCO Unix, NeXTSTEP, UnixWare and all kinds of Unix. Since version 8.0, PostgreSQL functions also nativement on Windows. Before version 8, PostgreSQL functioned under Windows using an emulator of the type Cygwin.

Respect of the standards

PostgreSQL est' pratiquement' conforms (more and more conforms) to the standards ANSI SQL 89, SQL 92 (SQL 2), SQL 99 (SQL 3) and SQL: 2003. It functions on various platform S material and under different operating systems.

Diffusion

Million specimens of DBMS PostgreSQL is installed on waiters Web and waiters of application. This DBMS is very advanced; it is a DBMS Relational-Object (SGBDRO).

Related tools

  • DBLink is a module making it possible to work on two different bases.
  • ECPG is a tool of embarked SQL.
  • In Java, PostgreSQL can be used in a transparent way with the standard JDO.
  • the software pgAdmin, currently in version 3, makes it possible to control the PostgreSQL databases via an graphical interface. This program is available on the platforms Windows and Unix.
  • PhpPgAdmin is a Web application written in to manage PostgreSQL bases.
  • PostGIS is the space module which confers on PostgreSQL the statute of space SGDBR.
  • Benetl is a tool of free LTE resting on PostgreSQL.

External bonds

  • Official site.
  • French-speaking Site.
  • Développez.com: forum of mutual aid for developers; heading dedicated to PostgreSQL.

Random links:1806 en literatura | Peder Sørensen | Mors Principium Is | Been vermiculated Œdicnème | France Blue Champagne | Bokor