Why is PostgreSQL about to surpass SQL Server?

DB-Engines 2021 year 10 Monthly statistics ,PostgreSQL Rise in the current month 10.30 spot , The total score is 597.27;SQLServer It fell sharply in the month 16.32, The total score is 954.29 .
At this speed ,2 Within the year ,PostgreSQL About to surpass SQLServer.

PostgreSQL The force is indestructible , be a trend which cannot be halted , There are good reasons to show that , It will surpass SQL Server.

01
The power of open source
Although many other database technologies have risen or fallen , however PostgreSQL Withstood the test of time , It's growing every year , Not only in function , And in terms of popularity , It's all growing .
PostgreSQL It is the most advanced open source relational database in the world . It is riding the wave of soaring popularity , newest Stack Overflow survey , List it as " Most in need of " database ,DB-Engines Select it as 2020 The annual heavyweight DBMS.
What's particularly interesting is this ,PostgreSQL Governance model and ownership model , Compared with other databases on the market , As like as an apple is to an oyster .PostgreSQL Not controlled by any company , It has the freest open source license agreement . This allows it to be shared unconditionally by different companies 、 Use 、 Distribute and redevelop . The free nature of its license agreement , Make business projects 、 Open source projects benefit from community ecology .
02
There is no end to innovation
these years ,PostgreSQL The core functions of continue to mature and improve , But merge the code directly into PostgreSQL The kernel is not always easy . The global development team keeps a strict review of new functions and code .
Although this may cause concern for some contributors seeking official support , but PostgreSQL The architecture is designed to allow the development and delivery of new functions as extensions （ plug-in unit ）.
This effectively isolates new code that may be wrong , Introduce uncertainty . This approach is not unique .MySQL and MariaDB There is also a plug-in architecture ; However , It doesn't prove like PostgreSQL So popular .
This scalability （ plug-in unit ） Allow users and companies to create software , Enhance... In the case of incomplete branching code PostgreSQL For specific use cases . in fact ,45 Extensions provided by different communities have been included in the officially released add-on module , Besides , There are thousands of extensions （ plug-in unit ） Not included by official channels .
Besides , Many companies keep their own PostgreSQL Branches and " Enterprise Edition ". These extensions , Branches and projects are promising , because PostgreSQL Free license agreement , It allows anyone from PostgreSQL The core package starts any iteration and development .
03
Strong ecological community
PostgreSQL The community includes hundreds of thousands of users around the world , And hundreds of modules 、BUG Companies that repair and expand . This broad and diverse group of participants , to PostgreSQL The community brings great advantages .
Just PostgreSQL for , Hundreds of different companies offer marketing 、 engineering 、 sales 、 Training and education . All companies involved in the community have raised awareness and needs , And push the project forward .
This team strength is a huge strategic advantage . The power of the global team crushes everything . Oracle is promoting the popularity of its flagship database , Only some of its partners contributed a little . however , stay PostgreSQL In the community , You have all cloud service providers （ Microsoft 、AWS、Google etc. ）, And the larger PostgreSQL supplier （ Like the Sun Tower in China 、Percona、EDB、CrunchyData、Ongres etc. ）, And different community projects , All these providers work together . There are many forces behind these institutions .
These companies also provide users with a lot of choices , This pair uses PostgreSQL It's a huge benefit for users . It means , If you don't like a supplier , You can easily try another .
" Powerful power " It brings significant advantages here , Added innovation 、 Functions and modules .PostgreSQL14 It is already a fantastic general database , But the company continues to make efforts on this basis , Created a great "NewSQL" database , A greater analysis database , wait .
More engineers 、 More companies and more contributors allow diversification and growth , And this diversity and growth tend to be much slower in large companies , It doesn't even exist （ In those companies , Group thinking can be a real problem ）. stay PostgreSQL, It brings smarter solutions and faster innovation .
04
Disputes among Heroes
obviously , It's not always plain sailing . Like any community , There are also differences and debates on the best way forward . lately , We see some concerns about trademark ownership and project governance . This caused a heated debate , Different community members seem to disagree .
Looking from the outside , This may look bad , But public debates and discussions within the community are common , Usually healthy . Why open source is so great , Part of the reason is to bring together the ideas of people from different angles , And adopt one of the best . Not everyone will be satisfied with the result , But as long as we continue to discuss 、 Debate and evolution , We can all succeed .
PostgreSQL Open development mode 、 Free licenses and rich features have created a very loyal user base and a large number of companies committed to promoting adoption and continuing to keep the user base happy .
PostgreSQL The momentum behind it shows no sign of slowing down , I predict that it will continue to grow in the next few years . If it finally ends MySQL The dominance of , Top of the list , I would not be surprised .

PG Exam related details ：http://www.pgccc.com.cn/
author ：PGCCC

Game programming ️, A game development favorite ~

If the picture is not displayed for a long time , Please use Chrome Kernel browser .