PostgreSQL surpasses MySQL

Produced | OSC Open Source Community (ID: oschina2013)

The Stack Overflow 2022 Developer Survey is out now. The Stack Overflow annual developer survey is the largest and most comprehensive survey of developers around the world, covering everything from developer favorite technologies to job preferences. 2022 marks the twelfth year of Stack Overflow’s annual developer survey, which includes more than 73,000 developers from 180 countries. Among them, the United States and India still have the largest number of respondents, followed by Germany and UKI (United Kingdom and Ireland); only 632 survey responses came from Chinese developers, accounting for 0.88%.

Some of the highlights of the survey are as follows:

• The proportion of online learning programming has risen from 60% to 70%. Respondents over 45 like to learn knowledge from books, and young people (under 18) rely on online learning and resources.

• Docker appears to be becoming an essential tool for professional developers, increasing from 55% to 69%.

• Rust has been the most-loved language for the seventh year in a row, with 87% of developers saying they want to continue using it.

• Phoenix replaced Svelte as the most popular web framework. Angular.js was the most hated framework for developers for three years in a row, and React.js was the framework for developers to learn the most for five years in a row.

• Docker and Kubernetes were ranked No. 1 and No. 2, respectively, as the most loved and wanted tools. People’s willingness to use Docker doesn’t seem to be slowing down, increasing from 30% last year to 37% this year.

• Clojure remains the highest-paid language known. Chef developers are the highest paid, but it’s also one of the least favorite tools for developers.

• 69% of respondents work full-time, up 4 percentage points from last year.

• 85% of developers say their organization is at least partially remote-enabled.

• 62% of respondents spend more than 30 minutes a day looking for answers or solutions to problems, and 25% spend more than an hour a day. For a team of 50 developers, the entire team spent a total of 333-651 hours per week searching for answers/solutions.

most popular technology

Programming, scripting and markup languages

The top five languages ​​used by professional developers remain unchanged; JavaScript is the most popular programming language for the tenth year in a row. But the report points out that HTML/CSS, Javascript and Python are almost tied as the most commonly used languages ​​for those who are learning to program. Those who are still learning are more likely than professional developers to use Python (58% vs. 44%), C++ (35% vs. 20%) and C (32% vs. 17%). Compared with professional developers, those who are still learning to program are less likely to use SQL (38% vs. 53%), TypeScript (15% vs. 40%), and Bash/Shell (19% vs. 29%).

database

Overall, MySQL remains the most popular database. But in the professional developer group, PostgreSQL (46.48%) has surpassed MySQL (45.68%) and won the first place. Professional developers are more likely to use Redis, PostgreSQL, Microsoft SQL Server, and Elasticsearch than people who are learning to program.

MongoDB is used in similar proportions in both groups, and it is the second most popular database among beginners (after MySQL). “It makes sense because it supports a huge number of languages ​​and application development platforms.”

cloud platform

AWS remains the most used cloud platform, with Microsoft Azure overtaking Google Cloud for the second spot.

Web Frameworks and Technologies

Node.js and React.js are the two most commonly used web technologies. More professional developers use Angular than beginners (23% vs. 10%), as are ASP.NET (16% vs. 10%) and ASP.NET Core (21% vs. 10%).

Other frameworks and libraries

When it comes to machine learning, TensorFlow is still more popular than PyTorch, with Scikit-learn following TensorFlow. Flutter and React Native are two of the most popular cross-platform tools. Beginners are more likely than professional developers to use NumPy (43% vs 24%) and Pandas (35% vs 22%), as well as TensorFlow (18% vs 11%) and Scikit-learn (17% vs 11%) ).

Other tools

Last year’s report stated that Git is an essential tool for being a developer. But this year, Docker appears to be emerging as a similarly basic tool for professional developers, increasing its share from 55% to 69%.

Integrated Development Environment

Visual Studio Code remains the IDE of choice for all developers. PyCharm is used more by beginners (26% vs. 16%), while Vim is used more by professional developers (24% vs. 16%).

Asynchronous tool

Sync tool

operating system

Windows is the most popular operating system for developers, both for personal and professional use. Linux-based operating systems are more popular than macOS; this underscores the appeal of using open source software, the report said.

Favorite, most feared, most want to learn technology

Programming, scripting and markup languages

Rust was the most loved programming language for the seventh year in a row, with 87% of developers saying they would like to continue using it.

▲ Favorite and most feared language

▲The language you most want to learn

database

Five years after Redis topped the charts, PostgreSQL has managed to claim the most-loved and most-wanted-to-learn database position. IBM DB2 is the most feared database for the third year in a row.

cloud platform

AWS is not only the most used cloud platform, but also the most beloved and most eager to learn cloud platform for developers.

Web Frameworks and Technologies

Phoenix replaced Svelte as the most popular web framework. Angular.js has been at the bottom of the list for three years in a row, and React.js has been the most wanted framework for developers for five years in a row.

Other frameworks and libraries

Hugging Face Transformers is the most loved library and Tensorflow most wants to be learned.

Other tools

Docker and Kubernetes were ranked No. 1 and No. 2, respectively, as the most loved and wanted tools. 77% of users prefer Docker and 75% prefer Kubernetes; 37% of users want to use Docker and 24% of users want to use Kubernetes.

Integrated Development Environment

Neovim is the most loved editor for the second year in a row, followed by Visual Studio Code. But Visual Studio Code is the tool everyone wants to learn the most, followed by Android Studio.

Technologies used and expected to be used

Programming, scripting and markup languages

Similar to last year, more than 10,000 Javascript developers expressed a desire to start or continue developing in Go or Rust.

database

There are 11,185 MySQL developers who want to work with PostgreSQL, and 9,520 MySQL developers who want to work with MongoDB.

cloud platform

Similar to 2021, there is a large number of AWS developers looking to develop in Google Cloud or Microsoft Azure.

Web Frameworks and Technologies

There are 12,954 developers using Node.js who want to use React.js.

high paying tech

Programming, scripting and markup languages

database

web framework

On average, median wages will increase by about 23% between 2021 and 2022. Flow, COBOL, Couchbase and IBM Cloud/Watson saw the biggest year-over-year salary increases.

Also, PHP developers are still underpaid compared to other languages ​​with the same experience.

Details can be found in the full report: https://ift.tt/gOJVEFz

After reading this report, many netizens expressed their views on PHP:

​

​

​

What do you think? The comment section is waiting for you.

The text and pictures in this article are from the OSC open source community