Why PostgreSQL?

By John Doe June 6, 2022

PostgreSQL is an open source relational database system that supports complex query optimization, triggers, stored procedures, and functions. It has gained a good reputation for openness, feature richness, user-friendliness, and more.


The advantage of openness is that users can actively participate in product development and community building, and the participation process is completely transparent and non-exclusive. You can expand your ability and influence by participating in it, and apply for a variety of jobs in society. In addition, the openness of database products also ensures the continuity of enterprise business, such as PostgreSQL, which is popular in the world, its vitality is not comparable to those traditional commercial databases. When you choose PostgreSQL as an open source database, for enterprises, you can choose many PostgreSQL-compatible database vendors to provide services, not bound by a single vendor’s supply; For users, your career development is actually no ceiling, you don’t have to stick to being just a DBA, after you are familiar with PostgreSQL, you can also become an application developer, and even a developer of database products and peripheral ecological products. In the world of open source databases, the roles of DBAs and developers are no longer as clearly defined as traditional commercial databases.

At the same time, openness brings other benefits, and as more enterprises and users participate in the PostgreSQL community and ecosystem, PostgreSQL features become richer. And it is precisely because of the direct participation of users that the user-friendliness of the product has been continuously improved.

The feature richness of database products can not only reduce the development labor cost of application software manufacturers, but also reduce the complexity of application software products. You don’t need to deploy multiple different types of databases at the same time due to the limitations of database products, nor do you need to develop a lot of data processing logic at the application layer. PostgreSQL’s richful features allows companies to focus more on business innovation.

Let’s take a look at the true power of the PostgreSQL database.

Popularity statistical error

We often see a lot of database popularity statistics, and the data collected by the popularity statistics process is all relevant information from Internet platforms. Let’s compare the representative industries and enterprises that use PostgreSQL and MySQL to see the specific differences. Representative companies using MySQL include NetEase in the game industry and Ali in the e-commerce industry, which generally share a lot of knowledge content on the Internet, and there are also many knowledge bloggers. Representative companies using PostgreSQL include Ping An Bank and Huawei in the telecommunications industry, which attach relatively much importance to information security, so they do not share much knowledge content on the Internet. However, if you purely look at the open source database usage of these two types of enterprises, it is basically at a comparable level.

Of course, even according to the relevant information of Internet platforms, statistics on the popularity of database products, the most dazzling star database of the past decade is none other than PostgreSQL, and the statistical results of the db-engines website are the best example. In addition, there are indeed differences in statistics from country to country and region, and there are also reasons for the distribution of industries. However, software products have natural globalization attributes, and foreign software products and industry practices can naturally be applied to China.

Industry perspective bias

In fact, the Internet is only a subdivision of the IT industry, but the development of the domestic IT industry is uneven, and the development of the Internet industry is unique, making many people mistakenly think that the Internet is the whole of the IT industry. At present, there is a lack of traditional application software vendors and new SaaS application vendors in China. These industries require databases that can meet standardized deployment and operation and maintenance, which is quite sensitive to labor investment costs and software product complexity. At the peak of the development of the Internet industry and the rise of the wave of industry digitalization, we need to objectively and rationally select the appropriate database according to the characteristics of the industry.

Homogenization of practitioners

Based on MySQL’s application-layer data processing work, this kind of customized development work of inverse software standardization has spawned a large number of homogeneous software developer job needs. The homogeneity of industry personnel has also caused the survival dilemma of software developers at the age of 35, and their vitality in the industry is limited to a short period of 25~35 years. The IT industry needs software developers to focus more on business innovation than on repetitive custom development efforts. This can not only promote the development of the society as a whole, but also enhance the personal employment competitiveness of IT industry practitioners, and then solve their own survival and development problems in the industry.

The future of PostgreSQL

Above we analyzed the advantages of PostgreSQL in the traditional IT industry. However, even in the Internet industry where MySQL is dominant, PostgreSQL has a big advantage. As we all know, after the release of an Internet product, the probability of real success is very low. So when you start building prototypes, you don’t really need to introduce a bunch of complex technology stacks like MySQL, MongoDB, Elastic Search, Hadoop, Redis, etc. You can quickly prototype your product and verify the commercial viability of your product by using PostgreSQL. Even if the number of product users and business traffic increase in the later stage, you can still introduce databases in other segments to optimize your product technology architecture.

comments powered by Disqus