Shulou(Shulou.com)06/01 Report--

Editor to share with you what the role of postgresql, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to understand it!

PostgreSQL is a free object-relational database server (database management system) that is distributed under a flexible BSD--style license. It provides an alternative to other open source database systems such as MySQL and Firebird, and proprietary systems such as Oracle, Sybase, IBM's DB2 and Microsoft SQL Server.

The unusual name of PostgreSQL has led some readers to stop and try to spell it, especially those who spell SQL as "sequel". PostgreSQL developers spell it as "post-gress-Q-L". It is also often abbreviated as "postgres".

In fact, PostgreSQL's features cover SQL-2/SQL-92 and SQL-3/SQL-99. First of all, it includes support for what can be said to be the richest data types in the world, some of which are not even available in commercial databases, such as IP types and geometric types. Secondly, PostgreSQL is a full-function free software database. For a long time, PostgreSQL is the only free software database management system that supports transaction, sub-query, multi-version parallel control system (MVCC), data integrity check and so on. Vendors such as InterBase and SAP of Inprise broke the uniqueness after opening up their original proprietary software to free software. Finally, PostgreSQL has a very active development team, and with the efforts of many hackers, the quality of PostgreSQL is improving day by day.

From a technical point of view, PostgreSQL adopts the classic client/server structure, that is, a client corresponds to a server-side daemon, which analyzes the query requests from the client, generates a planning tree, retrieves the data, and finally formats the results and outputs them back to the client. In order to facilitate the programming of the client, a unified client C interface is provided by the database server. Different client interfaces are derived from this C interface, such as ODBC,JDBC,Python,Perl,Tcl,C/C++,ESQL, etc. At the same time, it should be pointed out that PostgreSQL is also very rich in support for interfaces, supporting almost all types of database client interfaces. This can also be said to be one of the great advantages of PostgreSQL.

Architecture

One of the reasons why PostgreSQL is strong comes from its architecture. Like commercial databases, PostgreSQL can be used in the Candlespace S (client / server) environment. This has many benefits for users and developers.

The core of PostgreSQL installation is the database server process. It is allowed on a stand-alone server. Applications that need to access the data stored in the database must go through the database process. These client programs cannot access data directly, even if they are on the same machine as the service program.

These are all the contents of this article "what is the purpose of postgresql?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.