What is PostgreSQL?
PostgreSQL (pronounced "post-grey-sequel") is a sophisticated, standards-based, Object-Relational database management system (DBMS) supporting almost all SQL constructs, including subselects, transactions, and user-defined types and functions. Initially developed at the University of California at Berkely in the late 1970s and early 1980s, PostgreSQL is, today, the most advanced open-source database server in the world, designed primarily for e-business and enterprise applications.
Why do people use PostgreSQL?
- SQL 92 compliant - An enhancement of the Postgres DBMS, a next-generation research prototype - Retains the powerful data model and rich data types of Postgres while replacing the PostQuel query language with an extended subset of SQL - A very viable alternative to the market-leading proprietary databases in terms of performance and scalability - PostgreSQL has consistently performed an average of four to five times faster than every other database in a variety of tests administered by an independent technology solutions company - In benchmark tests, maintained a consistent output level whether there were one or two simultaneous users - PostgreSQL significantly outperformed both the leading commercial and open-source applications in both speed and scalability PostgreSQL is free, and the complete source is available.
Website: www.postgresql.org