Advantages and features of PostgreSQL

PostgreSQL is the world's most advanced open-source database system. It provides multi-version parallel control and supports almost all SQL components (including subqueries, transaction and user defined types and functions), and can obtain a very wide range of (Development) language binding (including C, C ++, Java, perl, tcl, and python ). The specific advantages and features are as follows:

1. PostgreSQL features cover SQL-2/SQL-92 and SQL-3/SQL-99, is currently the world's most supported data types of databases.

2. postgreSQL is a full-featured free software database. PostgreSQL is the only free software database management system that supports features such as transactions, subqueries, multi-version parallel control systems, and data integrity check.

3. postgreSQL uses a classic C/S (client/server) structure, that is, the mode in which a client corresponds to a server-side daemon. This daemon analyzes the query requests from the client, generate a planning tree, perform data retrieval, format and output the results, and return them to the client.

4. PostgreSQL supports a wide range of interfaces, and supports almost all types of database client interfaces.

Salesforce.com recently announced that it has provided the PostgreSQL-as-a-service:

1. PorstgreSQL is a good technology.

2. MySQL is struggling to catch up, but PostgreSQL is still far ahead in many aspects.

3. PostgreSQL has many users who have a wide range of fields, including academia and a wide audience. Many users are Russians.

4. Whether in the EnterpriseDB or PostgreSQL community, we are happy to manage and maintain this database.

5. Many DBMS products are PostgreSQL derivatives, such as Greenplum, Aster Data nCluster, and Netezza.

6. PostgreSQL's innovation continues, such as http://www.dbms2.com/2011/11/08/hadapt-is-moving-forward/

7. There is no guarantee that Oracle will continue to strengthen its investment in the MySQL project. In particular, Oracle's anti-monopoly commitment will expire on January 1, 2014.