PostgreSQL is a Object-Relational [[DBMS]] supporting almost all [[SQL]] constructs, including subselects, transactions, and user-defined types and more. The name comes from the fact that many of the original developers also worked on [[Ingres]], and so this is the "post-ingres" database. Design for the system began in 1986, with an explicit goal of providing a database that completely supported types with the minimum number of features necessary. By the early 1990s, the database had reached a significant number of users. Around this time, its status as a University of California, Berkeley project ended, but due to the open source license, development continued, as it does to this day.

PostgreSQL is seen as the most popular open source database after [[MySQL]], although it has in many ways more advanced and more mature implementations of key features, particularly those required by heavy-duty [[OLTP]] applications.

<b>Useful links:</b>

An "overview":http://www.postgresql.org/about/ of features.

"Frequentlyl asked Questions":http://www.postgresql.org/docs/faq/

PostgreSQL is a Object-Relational [[DBMS]] supporting almost all [[SQL]] constructs, including subselects, transactions, and user-defined types and more. The name comes from the fact that many of the original developers also worked on [[Ingres]], and so this is the "post-ingres" database. Design for the system began in 1986, with an explicit goal of providing a database that completely supported types with the minimum number of features necessary. By the early 1990s, the database had reached a significant number of users. Around this time, its status as a University of California, Berkeley project ended, but due to the open source license, development continued, as it does to this day.

"Frequentlyl asked Questions":http://www.postgresql.org/docs/faq/

PostgreSQL is a Object-Relational [[DBMS]] supporting almost all [[SQL]] constructs, including subselects, transactions, and user-defined types and more.

"Frequentlyl asked Questions":http://www.postgresql.org/docs/faq/

PostgreSQL is a Object-Relational [[DBMS]] DBMS supporting almost all [[SQL]] SQL constructs, including subselects, transactions, and user-defined types and more.

List of links relating to using [[PostgreSQL]] PostgreSQL from various languages, including [[ADA]], [[Bash]], [[Ruby]], [[SmallTalk]], ADA, Bash, Ruby, SmallTalk, plus generic [[ODBC]], ODBC, also dev tools, admin tools, report writers.

List of links relating to using PostgreSQL from various languages, including ADA, Bash, Ruby, SmallTalk, plus generic ODBC, also dev tools, admin tools, report writers. ODBC

PostgreSQL is a Sophisticated open-source Object-Relational DBMS supporting almost all SQL constructs, including subselects, transactions, and user-defined types and more.

"Converting MySQL-only software to use some other backend is not hard -- it merely takes a bit of digging to find out how MySQL is not compatible with the SQL standard and how the "tweaks" in MySQL are achieved with SQL-conforming database management systems. This article is not about converting applications from MySQL to other RDBMS, but rather how to convert a MySQL database to Postgresql."

- Straightfoward tutorial on how to switch to PostgreSQL which many consider a more robust database

<h3>General Advantages</h3>

There are several key advantages of using PostgreSQL:

<ol>

<li> PostgreSQL is free, Open Source software</li>

<li> PostgreSQL has excellent commercial and community support options</li>

<li> PostgreSQL has legendary reliability and stability</li>

<li> PostgreSQL is very scalable and extensible</li>

<li> PostgreSQL is cross platform</li>

<li> PostgreSQL is designed for high volume environments</li>

<li> PostgreSQL is easy to administer</li>

</ol>

<h3>Performance</h3>

PostgreSQL, like other <a href="/tag/RDBMS">RDBMS</a>, its companions, will always require tuning and optimizing based on the particular application. And so each of the systems -- SQL Server, Oracle, <a href="/project/MySQL">MySQL</a>, MySQL, and PostgreSQL -- will be have particular areas of performance where they excel "out of the box".

PostgreSQL is generally optimized and faster than others for scenarios involving high transactional loads, high numbers of users (especially non-read-only applications), and complex queries. Other related features -- like views, ACID compliance, etc. -- also contribute to PostgreSQL's overall performance.

Database benchmarking appears to be an area where little industry-wide data is available, again mostly due to the degree to which each database system can be tuned to meet certain performance expectations.

<h3>General Advantages</h3>

There are several key advantages of using PostgreSQL:

<ol>

<li> PostgreSQL is free, Open Source software</li>

<li> PostgreSQL has excellent commercial and community support options</li>

<li> PostgreSQL has legendary reliability and stability</li>

<li> PostgreSQL is very scalable and extensible</li>

<li> PostgreSQL is cross platform</li>

<li> PostgreSQL is designed for high volume environments</li>

<li> PostgreSQL is easy to administer</li>

</ol>

<h3>Performance</h3>

PostgreSQL, like its companions, will always require tuning and optimizing based on the particular application. And so each of the systems -- SQL Server, Oracle, MySQL, and PostgreSQL -- will be have particular areas of performance where they excel "out of the box".

PostgreSQL is generally optimized and faster than others for scenarios involving high transactional loads, high numbers of users (especially non-read-only applications), and complex queries. Other related features -- like views, ACID compliance, etc. -- also contribute to PostgreSQL's overall performance.

Database benchmarking appears to be an area where little industry-wide data is available, again mostly due to the degree to which each database system can be tuned to meet certain performance expectations.

<h3>General Advantages</h3>

There are several key advantages of using PostgreSQL:

<ol>

<li> PostgreSQL is free, Open Source software</li>

<li> PostgreSQL has excellent commercial and community support options</li>

<li> PostgreSQL has legendary reliability and stability</li>

<li> PostgreSQL is very scalable and extensible</li>

<li> PostgreSQL is cross platform</li>

<li> PostgreSQL is designed for high volume environments</li>

<li> PostgreSQL is easy to administer</li>

</ol>

PostgreSQL "supports "It supports SQL92 and SQL99 and offers many modern features:

* complex queries

* foreign keys

* triggers

* views

* transactional integrity

* multiversion concurrency control

Additionally, PostgreSQL can be extended by the user in many ways, for example by adding new

* data types

* functions

* operators

* aggregate functions

* index methods

* procedural languages"

"It supports SQL92 and SQL99 and offers many modern features:

* complex queries

* foreign keys

* triggers

* views

* transactional integrity

* multiversion concurrency control

Additionally, PostgreSQL can be extended by the user in many ways, for example by adding new

* data types

* functions

* operators

* aggregate functions

* index methods

* procedural languages"

"PostgreSQL "ostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial database systems much later."

"ostgreSQL "PostgreSQL is an a highly scalable, SQL compliant, open source object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at system. With more than 15 years of development history, it is quickly becoming the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial de facto database systems much later." for enterprise level open source solutions."

"PostgreSQL is a highly scalable, SQL compliant, open source object-relational database management system. With more than 15 years of development history, it is quickly becoming the de facto database for enterprise level open source solutions."