Developer Ecosystem

Databases

Share:

The questions in this section were only shown to respondents who indicated that they use databases.

Share:

Which databases have you used in the last 12 months?

SQLite has dropped from third to fifth place, and we’re stumped as to why. Lightweight and easy to use, SQLite is employed in standalone desktop applications, embedded development, local storage for mobile applications, and just about anywhere else. Are local databases quickly becoming redundant in an era when even your coffee maker has a backend in the cloud? Or maybe developers are switching to other embedded databases? If you have a better explanation, we'd love to hear it!

Which databases have you used in the last 12 months?

The results for some questions, including this one, have been split into three groups based on the respondents’ involvement with SQL:
  • “SQL – main” includes those who ranked SQL first among their primary programming languages.
  • “SQL – primary” includes those who identified SQL as one of their three primary programming languages (possibly as their main one).
  • “SQL – secondary” includes everyone else who has used SQL in the past 12 months.
SQLite and MongoDB appear to be favored by occasional SQL users, as their simple setup and usage make them ideal for small-scale applications, learning, and prototyping. On the other hand, MS SQL Server and Oracle Database, the two veteran databases, are notably more popular among SQL professionals than non-professionals.

Relative popularity of databases by region

Relative popularity is defined as the popularity of a database in a particular region in comparison to its popularity worldwide. For example, the share of MySQL in Germany is 39%, whereas its worldwide share is 51%. Dividing the difference (–12%) by 51%, we get –24%. This is how we define the relative popularity of MySQL in Germany.

Relative popularity of databases by primary programming language

Relative popularity is defined as the popularity of a database among users of a certain programming language in comparison to its popularity in general. For example, the share of MongoDB among Python users is 29.2%, whereas its general share is 26.6%. Dividing the difference (+2.6%) by 26.6%, we get +10%. We refer to this as the relative popularity of MongoDB among Python developers.

Which databases have you used in the last 12 months?

In this reciprocity table, each value denotes how many users of the Column database also use the Row database. For example, 38% of MySQL users also use PostgreSQL, whereas 51% of PostgreSQL users also use MySQL.

Which tools do you regularly use for working with databases?

Which tools do you regularly use for working with databases?

Different users engage with databases in different ways. While database professionals prefer using DataGrip or SQL Server Management Studio, those who use SQL only occasionally tend not to install dedicated applications for this purpose but instead rely on the Database plugin in a JetBrains IDE or simply the command line.

Which tools do you regularly use for working with databases?

Considering that most respondents use two or more databases at the same time, it’s no wonder that, for example, Redis users also use pgAdmin.
JetBrains products appear to be particularly popular among Redis users, something we’ve observed in our reports since 2020. Notably, built-in Redis support was introduced in DataGrip 2022.3; previously, it was possible to use Redis via a specialized plugin.

Relative popularity of database tools by region

Relative popularity is defined as the popularity of a tool in a region compared to its popularity worldwide. For example, the share of Command Line in Argentina is 7.8%, whereas its worldwide share is 19.4%. Dividing the difference (–11.6%) by 19.4%, we get –60%. We refer to this as the relative popularity of Command Line in Argentina.
A handful of tools exhibit significant regional specificity. For instance, Navicat is highly popular in China, where an impressive 42% of developers use it. This comes as no surprise, as the tool was developed in Hong Kong and has been well-tailored to Chinese users from the outset, actively establishing a strong presence primarily in that market.

Experience with databases

Experience with databases

Experience with databases

Do you use a version control system (VCS) to track changes in the database schema?

Do you use a version control system (VCS) to track changes in the database schema?

How do you store database schema changes in the VCS?

How do you store database schema changes in the VCS?

How do you store database schema changes in the VCS?

What tools do you use to store database schema changes in the VCS?

What tools do you use to store database schema changes in the VCS?

What tools do you use to store database schema changes in the VCS?

How many connections do you have in your database explorer?

How many connections do you have in your database explorer?

How many connections do you have in your database explorer?

How many connections do you have in your database explorer?

Approximately how many rows (or equivalent) does your largest table have?

Approximately how many rows (or equivalent) does your largest table have?

Approximately how many rows (or equivalent) does your largest table have?

DataGrip

Many databases, one tool

Previous

Big Data

Next

Data Science

Databases:

2023

2022
2021
2020
2019
2018
2017

Thank you for your time!

We hope you found our report useful. Share this report with your friends and colleagues.

Join JetBrains Tech Insights Lab

Take part in surveys and UX studies to make JetBrains products easier to use yet even more powerful. For participating in our research, you’ll also get the chance to earn rewards.

Sign Up

Learn more

Raw data Soon

We are preparing the raw data. You can leave your email to get notified when it is available for download.

By submitting this form I agree to the JetBrains Privacy Policy

If you have any questions or suggestions, please contact us at surveys@jetbrains.com.