- Green versionCheck
- Green versionCheck
- Green versionCheck
- Green versionCheck
Software advantages
PostgreSQL can be said to be the most distinctive free database management system, and we can even say it is the most powerful free software database management system. In fact, the features of PostgreSQL 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 can be said to be continuous. Commercial databases do not have it, such as IP types and geometry types; secondly, PostgreSQL is a full-featured free software database. For a long time, PostgreSQL has been the only one that supports transactions, subqueries, multi-version parallel control systems, data integrity checks, etc. Features of the only free software database management system. Only recently have vendors such as Inprise's InterBase and SAP opened up their original proprietary software to free software. Finally, PostgreSQL has a very active development team, with more than 30 current committers. And with the efforts of many hackers, the quality of PostgreSQL is improving day by day, which also increases people's confidence in using PostgreSQL from another aspect. After all, the database management system cannot be down like a desktop operating system once a day and still feel quite satisfied :-P.
From a technical point of view, PostgreSQL uses a relatively classic C/S (client/server) structure, that is, a client corresponds to a server-side daemon process. This daemon process analyzes query requests from the client and generates plans. tree, perform data retrieval and finally format the results and output them back to the client. In order to facilitate the writing of client programs, the database server provides a unified client C interface. Different client interfaces are derived from this C interface, such as ODBC, JDBC, Python, Perl, Tcl, C/C++, ESQL, etc. It should also be pointed out that PostgreSQL's support for interfaces is also very rich, almost All types of database client interfaces are supported. This can also be said to be a major advantage of PostgreSQL.
it works
it works
it works