Try our new research platform with insights from 80,000+ expert users

JetBrains IDEs vs Oracle SQL Developer comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

JetBrains IDEs
Ranking in IDE
3rd
Average Rating
9.0
Number of Reviews
3
Ranking in other categories
No ranking in other categories
Oracle SQL Developer
Ranking in IDE
5th
Average Rating
8.6
Number of Reviews
30
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the IDE category, the mindshare of JetBrains IDEs is 3.4%, down from 6.7% compared to the previous year. The mindshare of Oracle SQL Developer is 4.2%, down from 6.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
IDE
 

Featured Reviews

Paco Velasco Reina - PeerSpot reviewer
Allows the development Microsoft products on Linux with good plugins and integrations
One of the most important things to improve is the consumption of resources, mainly memory. You also need a very powerful computer compared to Visual Studio Code or Visual Studio Enterprise. An important improvement would be the case of having more than one instance open. It is common to have more than one instance because of developing linked microservices or frontend/backend at the same time. Memory usage in this case should be optimized. The debugging of objects and their manipulation is also not optimal. Sometimes it is difficult to observe variables or very complex objects. There are also memory overflows that sometimes cause debugging to stop.
Theodoros Loizou - PeerSpot reviewer
Useful features, simple implementation, and scalable
For first-time users of Oracle SQL Developer, it's going to be a bit difficult, but they can find their way around over time. I rate Oracle SQL Developer a nine out of ten. I didn't face any other issues other than it being a bit slow when you have a lot of work to do.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Having the complete development environment in Linux in the same way as in Windows is already the best."
"Good support for refactoring."
"I have a lot of flexibility with it."
"Ability to analyze performance, using Explain Plan statement."
"You can install it on every platform. It just works. The other thing is that it's free. And Oracle is committed to the development of the tool, so it has been improving."
"It allows us to implement a form of test driven development (TDD) for database-resident code."
"The most valuable features of Oracle SQL Developer that I use. However, I do not use all of them"
"I like it because it's very similar in output to SQL *Plus, and it has many convenience features that make it easier to read the data and use the basic reporting features it provides."
"You do not have to install it, just dump it on the OS, then use it."
"It's easy to deploy, I can copy it onto the system and run it without having to install it and this makes it a very good solution for quick use."
 

Cons

"One of the most important things to improve is the consumption of resources, mainly memory."
"Sometimes, plugins (from third parties) are not updated."
"If they had something on the Web then you wouldn't need to install it, just query, like Enterprise Manager."
"The initial setup is always a problem, it cannot find the Java SDK."
"The stability depends on what version you're using. There are more successful versions and are less successful versions. For example, 17.3 is less successful. There were many bugs. Now, we are trying to pull all the developers to upgrade to 17.4."
"The competing products have more features."
"There is room for improvement in the Real Time SQL Monitoring."
"I would like it to support background processes better."
"Scalability has room for improvement. Often if you have to do a heavy load of queries or are getting large result sets you have to be careful not to overload the Java virtual machine that's running."
"I think it would be great to have an overview over the sessions it opens so that we could easily see and control which connections to the database we want to keep open, which ones are hanging; and it would be great to make them independent from each other."
 

Pricing and Cost Advice

Information not available
"It is basically free."
"It has the advantage that it's free. The next best competitor would cost several thousand dollars."
"It's a no-cost license and it offers outstanding functionality on that basis."
"It's a free tool."
report
Use our free recommendation engine to learn which IDE solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
20%
Financial Services Firm
16%
Comms Service Provider
11%
Real Estate/Law Firm
8%
Financial Services Firm
21%
Government
15%
Computer Software Company
10%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What is your experience regarding pricing and costs for JetBrains IDEs?
The licenses are quite expensive, especially considering that there is a free version of Visual Studio. However, the licenses come down in price as they are rolled out annually, which is a welcome ...
What needs improvement with JetBrains IDEs?
One of the most important things to improve is the consumption of resources, mainly memory. You also need a very powerful computer compared to Visual Studio Code or Visual Studio Enterprise. An imp...
What is your primary use case for JetBrains IDEs?
Our main use case is to program APIs in Microsoft Net Core >= 2.2. The development of APIs under JetBrains Rider allows us to use the Microsoft framework under Linux natively as if we were doing...
Ask a question
Earn 20 points
 

Learn More

 

Overview

 

Sample Customers

Citi, Siemens, Salesforce, Twitter, HP, New York Times, Pintrest, Airbnb, Expedia, Samsung, Volkswagen, Wikipedia, NASA
Prinova
Find out what your peers are saying about JetBrains IDEs vs. Oracle SQL Developer and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.