Eclipse vs. WebStorm 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

Groups that use a [variety] of development environments (.net, python, web), Jebrain's products and Webstorm, in particular, are a great choice for productivity. If your developers are accustom to another IDE it might be better for all to sync on the same one. I wouldn't take the cost aspect as a consideration. A productive developer is far more important.

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

• Includes a built in spell checker to eliminate time wasted searching for small mistakes.
• Provides a drop down menu of options complete with keyboard shortcuts that allow for streamlined programming.
• Identifies when variables are named differently, allowing for cohesive work without the scrolling.

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

• The popup file search sometimes frustrates me. It caps the number of results, and sometimes it isn't clear that it simply stopped looking. I also used to have trouble finding string occurrences that I knew were in my project, but I think they've made improvements in this area recently.
• Being a AAA IDE, WebStorm can be a memory hog. If I don't kill it every few days, it can get really slow. I would love to see performance improvements.
• Speaking of performance, WebStorm can take a long time to launch. I'd like to see improvements in launch times.

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

It's an irreplaceable part of my toolkit and isn't that expensive per year.

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

Great in debugging, testing, developing and maintaining softwares in a number of languages. Great support for many languages and their syntaxes. Great support of many third party extensions and plugins like GIT and html plugins. The RAM usage of WebStorm however could be really improved, it literally takes almost all of the RAM of my machine with 16GB RAM

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.

I gave this rating because I have never needed their customer support, which is the highest level of support I suppose. When a product works just fine out of the box and everything you may need is well documented, it's a paradise for the customer. But I've seen some questions asked on their portal, and I've seen thorough answers given to the questions and the willingness to support the customer with follow-ups and everything else.

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

Highly recommend the JetBrains Toolbox, it remembers your recent projects and launches from the task bar.

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

I think WebStorm is way ahead of open-source editors. Please don't get me wrong, I love open-source. But the other free editors have a lot of configuration which blocks my whole coding experience. Take "Atom" for example. I used it for about 3 months, but in that time I had to update the plugins hundreds of time, and for every little thing (e.g. linter) I had to download a community plugin, and with each plugin atom would get a little slow. Take "Eclipse" for another example, which is very suited for Java, but not so suited for JavaScript. Sublime was good, but WebStorm comes with many exciting features that I did not find in sublime/notepad.

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

• Saves lot of time when we are finding the text or files.
• Easy to work with for support projects.
• Nice code completion feature.
• It's all in one solution for both front end, back end and database solution to work with.
• Initial learning curve is required to use the workbench.
• Documentation can be improved better probably adding videos, would be helpful for visual person.

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