Python continues to lead the 2023 programming language list! SQL wins first place in work requirements

With the rapid development of technology, programming languages ​​have become an indispensable part of modern society:

Whether it is website development, mobile applications, artificial intelligence or embedded Systems, programming languages ​​all play a key role.

Most of the current popular AI artificial intelligence is implemented through the Python language.

As the basic language of the AI ​​technology framework, compared with other programming languages, Python can be dynamically compiled, which not only has high development efficiency, but can also build networks and process data.

Simple syntax and versatility in multiple scenarios have made Python the most popular programming language in recent years.

Similarly, SQL (Structured Query Language) is a programming language used to store and process information in a relational database.

SQL allows users to perform a variety of operations, including querying data, inserting, updating, deleting data, and defining and managing database structures.

Through SQL, users can easily interact with the database to achieve data storage, retrieval and maintenance. The SQL language has simple syntax and rich functionality, allowing developers to effectively manage large amounts of data.

Therefore, in this year’s 10th annual list of top programming languages ​​released by IEEE Spectrum, Python and SQL ranked first in trends and jobs respectively, while Python ranked first Spectrum’s top list.

Interpretation of the rankings

Rankings in Spectrum reflect typical IEEE members’ interest in programming languages and needs.

Job categories show the programming language skills currently required for related jobs, and trends represent contemporary programming languages ​​that are particularly popular or valued.

Python’s dominance among programming languages ​​has strengthened largely at the expense of smaller, more specialized languages.

Python has become a "jack of all trades" programming language and excels in some areas.

For example, in the field of artificial intelligence: powerful and extensive libraries make Python ubiquitous.

While Moore's Law is waning in high-end computing, low-end microcontrollers are still benefiting from performance improvements, which means that it is now available on a 70-cent CPU. Sufficient computing power.

And Python has become a competitive choice in embedded development.

In the long run, Python’s position is also strengthening:

Now, many children and teenagers are using Python to write their Be the first to play or control the first LED.

This can help them seamlessly move into more advanced fields and even find jobs using the same programming language.

#But just mastering Python cannot fully meet professional needs.

In the "job" ranking on the list, SQL tops the list. This is because in today's distributed architecture, a large amount of business-critical data is stored in SQL databases.

If you want to do anything with this information, you must know how to obtain it.

But the irony is that pure SQL programmers have a hard time finding work. Employers like to see SQL skills combined with other languages ​​like Java or C.

On the other hand, although Python has become the undoubted number one in the current trend in the rankings, programming is far from becoming a a single culture.

Java and various C-like languages ​​combined have surpassed Python in popularity, especially in high-performance or resource-sensitive tasks.

Because Python’s interpreter overhead is too expensive (despite many attempts to make Python more competitive in this regard), and there are software ecosystems that are not easily integrated for other reasons into Python.

For example, the R language is a language used for statistical analysis and visualization that came to prominence a few years ago with the rise of big data.

Although the R language is powerful, it is not easy to learn. Its syntax is arcane, and functions are often performed on entire vectors, lists, and other high-level data structures.

Although there are Python libraries that can provide similar analysis and graphics functions, the R language is still very popular because of its specificity, which also makes R scripts difficult to port.

Given that a large amount of statistical analysis and academic research is based on the R language, this is a significant problem.

This situation is similar to Fortran. In Fortran, the value of existing verification code for physics simulations and other scientific calculations has always exceeded the costs associated with using one of the oldest programming languages ​​in existence.

Even today, people can still find jobs as Fortran programmers. But the job may require a security clearance, as these jobs are primarily at U.S. federal defense or energy laboratories, such as Oak Ridge National Laboratory.

If you can't get a security clearance, but still like a programming language with a certain history, Cobol is another possible option.

This is for similar reasons as Fortran: because there are a large number of installed code bases that work well even when errors are costly.

Many large banks still need Cobol programmers, and in fact there are more fintech developer positions on the market looking for Cobol masters than positions in the currency space.

These old languages ​​may also appear in some unexpected places. For example, Ladder Logic was originally created for industrial control applications and is usually associated with old-fashioned technology.

However, one of the most compelling new aerospace companies, Blue Origin, has posted jobs that require Ladder Logic skills.

This may be related to the cluster of ground equipment needed to fuel, power and test the booster and spacecraft.

It can be seen that although Python is the current mainstream programming, Java and C languages ​​​​still have their own advantages, and some old languages ​​​​are irreplaceable.

Different programming languages ​​meet different needs, and maintaining diversity is crucial.

The above is the detailed content of Python continues to lead the 2023 programming language list! SQL wins first place in work requirements. For more information, please follow other related articles on the PHP Chinese website!