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

Recent work has been focused on database design, taking advantage of this opportunity to sort out some of my understanding of PostgreSQL database, but also a summary of recent learning. For many people may not have heard of this database, usually we are accompanied by Oracle, MySQL, Microsoft SQL Server and other relational databases.

But if you take a look at the ranking of databases, you may be more intuitive to realize the power and universality of PostgreSQL databases.

Since PostgreSQL ranks so high, why is it not as famous as other databases in China? I think the key point lies in two points: first, the strength of marketing; second, the application scenario is not in line with most of the domestic company scenarios. Wait for the follow-up analysis in detail.

PostgreSQL is arguably the most advanced open source database system available in the world. It includes rich support for data types, some of which are not even available in commercial databases, such as IP types and geometric types. It provides multi-version concurrency control, supports almost all SQL artifacts (including subqueries, transactions, and user-defined types and functions), and can obtain a very wide range of (development) language bindings (including C-Cure Java PerlGrainJava Perl TCL, and python); the overall design of PostgreSQL uses the client/server structure and supports almost all types of database client interfaces. Secondly, PostgreSQL has formed a large open source service team because of its open source characteristics, and its related open source components are varied (tablefunc, dict_xsyn, fuzzystrmatch, pg_trgm, cube), which can meet the needs of most scenarios. Of course, some people call it the database system with the longest history and the richest practical experience, and its extensions include natural language parsing, multidimensional indexing, geographic query, custom data types and so on.

Although the PostgreSQL database is very powerful as a whole, it is also flawed. From the perspective of marketing personnel, there is basically no large-scale use experience and architecture design in China before, and most of them stay in the degree of looking for a document. This directly leads to the downturn of the database in the domestic market, and the same Mysql database is in the lead in this respect. MySQL has accumulated a large number of highly available architecture, distributed architecture and disaster recovery experience in the domestic Internet industry, but the PostgreSQL is almost zero, but looking at the international network, it is not difficult to see the world of PostgreSQL. Secondly, in the aspect of de-IOE, PostgreSQL is much easier than others because of the comprehensiveness of language support, data docking and migration, and the difficulty of removing Oracle. Of course, MySQL now has better support for de-Oracle.

Second, in terms of security, PostgreSQL transactions conform to ACID, ensuring that your commits are completely atomic, consistent, isolated, and persistent.

Summary:

PostgreSQL is a fully open source database based on BSD protocol. Its powerful query optimizer and rich data types provide perfect relational data storage (supporting some non-relational database storage). There is a wealth of open source cluster software support, can be applied to different needs in a variety of scenarios. Compared with the use of MySQL, its core InnoDB has been controlled by Oracle, can not achieve maximum play, most of its domestic use of MySQL database as the product core library are small and medium-sized projects, although the reason is a comprehensive comparison, but compared to PostgreSQL in medium and large projects like a fish in water, I have to say that I am more inclined to use PostgreSQL.

Note: the next section talks about the advantages and disadvantages and usage scenarios of MySQL and PostgreSQL.

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.