Databases
Which databases have you used in the last 12 months?
The most intriguing aspect of this data is that the order is exactly the same as it was last year. There have been no changes.
The results for some questions, including this one, have been split into 2 groups based on the respondents’ involvement with SQL. Those who identified SQL as one of their 3 primary programming languages were sorted into the “SQL is primary” group, while everyone else who has used SQL in the last 12 months was placed in the “SQL is secondary” group. The answers have also been split according to the databases used by the respondents.
Which databases have you used in the last 12 months?
This question was only answered by respondents who use a database.
Do you plan to adopt or migrate to other databases in the next 12 months? If so, to which ones?
Database users seem to be extremely conservative when it comes to change: most of the developers surveyed do not plan to migrate this year.
Do you plan to adopt or migrate to other databases in the next 12 months? If so, to which ones?
This question was only answered by respondents who use a database.
Which tools do you regularly use for working with databases?
DataGrip’s share has increased slightly and climbed two positions, moving into the top 5.
Which tools do you regularly use for working with databases?
This question was only answered by respondents who use a database.
Keep in mind that most of the respondents use two or more databases at the same time. So, it’s not strange for MongoDB users to also use MySQL Workbench.
How long have you worked with databases?
How long have you worked with databases?
This question was only answered by respondents who use a database.
MongoDB is a popular choice among NoSQL databases for both junior and senior developers.
Do you debug stored procedures?
Do you debug stored procedures?
This question was only answered by respondents who use a database.
Do you have tests in your database?
Do you have tests in your database?
This question was only answered by respondents who use a database.
The largest number of tests is performed/run on Oracle and MSSQL databases.
Do you keep your database scripts in a version control system?
Do you keep your database scripts in a version control system?
This question was only answered by respondents who use a database.
MySQL is the database used least often with version control systems.
Do you write comments for the database objects?
More than half of the developers that work with databases use comments in them.
Do you write comments for the database objects?
This question was only answered by respondents who use a database.
Oracle users are the most active database commenters.
Approximately how many rows (or equivalent) does your largest table have?
Approximately how many rows (or equivalent) does your largest table have?
This question was only answered by respondents who use a database.
Keep in mind that most of the respondents use two or more databases at the same time. It’s not necessarily the case that users who use SQLite database have billions of rows in SQLite database
Thank you for your time!
We hope you found our report useful. Share this report with your friends and colleagues.
Participate in future surveys
If you have any questions or suggestions, please contact us at surveys@jetbrains.com.