Talking about PostgreSQL database

The focus of recent work has been on database design, with this opportunity to take time to sort out some of my PostgreSQL Database Understanding, but also for the recent period of time to learn a summary. For many people who may not have heard of this database, we usually have a relational database of Oracle,MySQL, andMicrosoft SQL Server .

but looking at the database leaderboard, it may be more intuitive to recognize the power and universality of PostgreSQL database

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/8A/DE/wKioL1g-LCKwF6STAAHQ0cc7IsE238.png-wh_500x0-wm_3 -wmp_4-s_1014127460.png "title=" 11111.png "alt=" Wkiol1g-lckwf6staahq0cc7ise238.png-wh_50 "/>

since PostgreSQL ranks so high, so why not in the domestic fame than other databases? This one I think the focus is two points: first, the problem of marketing efforts; second, the application scenario and the majority of domestic company scenarios do not meet the cause. Detailed follow-up and further analysis.

PostgreSQLCan be said to be the world's most advanced Open source database system, which includes rich data types of support, some data types can be said that even commercial databases are not available,likeIptypes and geometry types; it provides multiple versions of concurrency control to support almost allSqlartifacts (including subqueries, transactions, and user-defined types and functions),and can get a very wide range of (development) language bindings(includingC,C++,Java,Perl,Tcl, andPython);PostgreSQLThe overall design usesc/S (client/server)structure, almost all types of database client interfaces are supported. SecondPostgreSQLdue to its open source features, a large open source service team is formed, and its related open source components are diverse (Tablefunc,Dict_xsyn,Fuzzystrmatch,PG_TRGM,Cube) to meet the needs of most scenarios. Of course, some people call it the oldest and most experienced database system, its extension includes natural language parsing, multidimensional index, geographic query, custom data type, etc.

Although the PostgreSQL database is very powerful, it is flawed. From the market personnel point of view, before in the domestic basic no large-scale use of experience and architecture design, most of the stay in a document to find the extent of the toss. This directly led to the database in the domestic market downturn, the same Mysql database in this area is more advanced. MySQL has accumulated a large number of high-availability architectures, distributed architectures and disaster preparedness experiences in the domestic Internet industry, but PostgreSQL is almost 0, but looking at the international network, it is not difficult to see PostgreSQL of the world. Next in the go to the IOE because of the full language support, data docking migration, to Oracle difficulty compared to the other is a lot simpler, of course, MySQL now to go Oracle has better support.

second, in terms of security , The PostgreSQL transaction is ACID-compliant, ensuring that your commits are completely atomic, consistent, isolated, and persistent.

Summarize:

PostgreSQL is an all-open source database of BSD protocol, its powerful query optimizer, rich data types provide perfect relational data storage (support partial non-relational database storage). There is a wealth of open source cluster software support, can apply various scenarios under different requirements. Compared to using MySQL, its core InnoDB has been controlled by Oracle , unable to maximize the play, its domestic use of MySQL database as the core of the product library is the majority of small and medium-sized projects, The reason for this is a comprehensive comparison, but compared to PostgreSQL in large-scale projects, I have to say that I am more inclined to use PostgreSQL.

Remarks: Next section talk about MySQL with the PostgreSQL comparison of advantages and disadvantages and usage scenarios.

This article is from the "Less" blog, please be sure to keep this source http://huashao.blog.51cto.com/5279975/1878005

Talking about PostgreSQL database