Eclipse vs. IntelliJ IDEA vs. Toad Database Developer Tools

I think that if someone asked me for an IDE for Java programming, I would definitely recommend Eclipse as is one of the most complete solutions for this language out there. If the main programming language of that person is not Java, I don't think Eclipse would suit his needs[.]

Incentivized

This is a superb tool if your project involves a lot of backend development, especially in Java/Spring Boot and Kotlin. The support for the front end is great as well, but some developers may prefer to use the GitHub copilot add-on. I especially love using the GitHub copilot add-on. It may be less appropriate if your project requires heavy use of HotSwaps for backend debugging, as sometimes the support for that can be limited.

Incentivized

Toad for Oracle is very well suited for all Oracle implementations, be it single instance or RAC. It is best suited for use of Oracle DBA, Developer and Database Engineers. I don't recommend Toad for Oracle for Project Managers or Solution Architects. This can be a pricier choice for these people. They can do fine with free options like SQL Developer.

Incentivized

• Eclipse organizes imports well and does a good job presenting different programming languages.
• Eclipse auto formats source code allowing customization and increased readability.
• Eclipse reports errors automatically to users rather than logging it to the console.
• Eclipse has coding shortcuts and auto-correction features allowing faster software development.

Incentivized

• Unit testing: Fully integrated into IntelliJ IDEA. Your unit tests will run smoothly and efficiently, with excellent debugging tools for when things get tricky.
• Spring integration: Our Spring project using Maven works flawlessly in IntelliJ IDEA. I know firsthand that Apache is also easily and readily supported too. The integration is seamless and very easy to set up using IntelliJ IDEA's set up wizard when importing new projects.
• Customization: IntelliJ IDEA comes out of the box with a bunch of handy shortcuts, as well as text prediction, syntax error detection, and other tools to help keep your code clean. But even better is that it allows for total customization of shortcuts you can easily create to suit your needs.

Incentivized

• Toad is a de-facto standard tool for data developers and analysts. Generally speaking it provides almost every function needed to manage data in EDW with great performance and stability.
• The nature of clinical data is big-sized: one table may have billions of rows. Toad provides critical functions to manage SQLs, e.g. Top SQL that can monitor and manage SQLs using CPU power and network bandwidth, so that EDW administrator can optimize ETL operations in the best efficiency.
• Many of our data analysts are not computer science backgrounded (having clinical / nursing background). Toad provides great auditing tools such as Tuning Lab or SQL Scanner, so that data analysts can train themselves with guidance of the tool.

Incentivized

• While the DB integration is broad (many connectors) it isn't particularly deep. So if you need to do serious DB work on (for example) SQL Server, it is sometimes necessary to go directly to the SQL Server Studio. But for general access and manipulation, it is ok.
• The syntax formatting is sometimes painful to set up and doesn't always support things well. For example, it doesn't effectively support SCSS.
• Using it for remote debugging in a VM works pretty well, but it is difficult to set up and there is no documentation I could find to really explain how to do it. When remote debugging, the editor does not necessarily integrate the remote context. So, for example, things like Pylint don't always find the libraries in the VM and display spurious errors.
• The debugging console is not the default, and my choice is never remembered, so every time I restart my program, it's a dialog and several clicks to get it back. The debugging console has the same contextual problems with remote debugging that the editor does.

Incentivized

• Finding if a feature exists or not in IntelliJ IDEA can be challenging.
• For example, if we know how to format a particular file, the command is Ctrl+Alt+Shift+L, but if we don't, then finding it is difficult.
• Setting up a project interpreter and directory structure might not be intuitive at first.
• Git integration can be improved. For example, it isn't easy to rebase using UI in IntelliJ IDEA.

Incentivized

• The power and control it gives is at the same time kind of a negative thing. There's too many options available, even when you don't need them. For simple database operations it's sometimes easier to just use SQL Developer since navigation is way more intuitive and easy.
• Related with the above: there is a steep learning curve. However, since this is the main tool for any Oracle developer, this is not that much of a problem.
• If I remember well, Toad used to be free, some 20 years ago. Or at least had a free version. It would be nice to have a free version. The dedicated Oracle developers and DBA's won't use the free version, but all the rest of us developers might use it instead of SQL Developer. It would make communications between everybody somewhat easier.

Incentivized

I love this product, what makes it one of the best tool out in the market is its ability to function with a wide range of languages. The online community support is superb, so you are never stuck on an issue. The customization is endless, you can keep adding plugins or jars for more functionalities as per your requirements. It's Free !!!

Incentivized

VS Code is maturing and has a Scala plugin now. The overall experience with VS Code - for web development at least - is very snappy/fast. IntelliJ feels a bit sluggish in comparison. If that Scala plugin for VS Code is deemed mature enough - we may not bother renewing and resort to the Community Edition if we need it.

Incentivized

It is the preferred tool for our organization.

Incentivized

It has everything that the developer needs to do the job. Few things that I have used in my day-to-day development 1. Console output. 2. Software flash functionality supporting multiple JTAG vendors like J-LINK. 3. Debugging capabilities like having a breakpoint, looking at the assembly, looking at the memory etc. this also applies to Embedded boards. 4. Plug-in like CMake, Doxygen and PlantUML are available.

Incentivized

There is always room for improvement, but I haven't met any IDE that I liked more so far. Even if it did not fit a use case right out of the box, there is always a way to configure how it works to do just that.

Incentivized

I give is an 8 because nothing is a 10 and there is always room for improvement. I believe the user who is not as technologically inclined would be better suited with an easier way to identify the options for setting the layout up for Toad's GUI. To some it is very cumbersome and confusing.

Incentivized

I gave this rating because Eclipse is an open-source free IDE therefore no support system is available as far as I know. I have to go through other sources to solve my problem which is very tough and annoying. So if you are using Eclipse then you are on your own, as a student, it is not a big issue for me but for developers it is a need.

Customer support is really good in the case of IntelliJ. If you are paying for this product then, the company makes sure that you will get all the services adequately. Regular update patches are provided to improve the IDE. An online bug report makes it easier for the developers to find the solution as fast as possible. The large online community also helps to find the various solutions to the issues.

Incentivized

I give the overall support for Toad for Oracle a 10/10. This is because whenever there has been an issue with this software, our team has got an immediate response. The same can not be said for similar software. The most recent example of this is when we needed to renew our licenses. Some employees were unable to log in to code with the given license key. Support was able to resolve the issue quickly.

Incentivized

This installs just like any other application - its pretty straight forward. Perhaps licensing could be more challenging - but if you use the cloud licensing they offer its as simple as having engineers login to the application and it just works.

Incentivized

The installation, adaptability, and ease of usage for Eclipse are pretty high and simple compared to some of the other products. Also, the fact that it is almost a plug and play once the connections are established and once a new user gets the hang of the system comes pretty handy.

Incentivized

Eclipse is just so old, like a dinosaur, compared to IntelliJ. There are still formats that Eclipse supports better, especially old and/or propriety ones. Still, most of the modern software development needs can be done on IntelliJ, & in a much better way, some of them are not even supported on Eclipse.

Incentivized

Toad is much better than Tableau query writer. Tableau is not intuitive and requires knowledge of proprietary database language to fully implement. Tableau does not perform as quickly and accurately as Toad. Toad is very easy and slim to install. Additional hardware is often required to run Tableau smoothly. Support for Tableau is even more expensive than Toad support.

Incentivized

• This development environment offers the possibility of improving the productivity time of work teams by supporting the integration of large architectures.
• It drives constant change and evolution in work teams thanks to its constant versioning.
• It works well enough to develop continuous server client integrations, based on solid or any other programming principle.

Incentivized

• Easier to find bugs and debugs, thus reducing man hours and generating immediate dollar impact.
• Coding time is lessened, which in turn again reduces man hours and generates immediate dollar impact.
• Refactoring code is more innovative and easy here, resulting in more maintainable code.

Incentivized

• Quick and easy query development helps reduce man-hours in a project which converts to real dollars.
• Query analysis and tuning result in low database overhead and low latency, thus translating into real dollars because a system can thus handle more requests from customers.
• Ease of use makes it easy to deploy greenhorns in projects with minimal training, thus helping save money. Otherwise menial and simple jobs would have required experienced DBAs.

Incentivized