WebStorm vs. Oracle SQL Developer

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

Almost all development activities (the tool is called "SQL Developer", not "DBA Toolset") can be done easily and quick with [Oracle] SQL Developer. From data model creation (tables, views) to development (creation of procedures, functions, packages) and then testing (SQL Developer includes an easy to use debugger), all tasks can be performed in a single tool.

It may not be as complete as other solutions for DBA tasks like instance monitoring, but it is usually OK for development and testing environments if you want to do some basic troubleshooting.

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

• Object Browser in SQL Developer allows you to explore the contents of your database using the connection tree.
• The SQL Worksheet is an editor that allows for execution of SQL statements, scripts, and PL/SQL anonymous blocks. SELECT statements can be executed to return results in a spreadsheet-like 'grid' or can be executed as a script such to emulate SQL*Plus behavior and output
• DBA Console allows users with administrative privileges to access DBA features such as database init file configuration, RMAN backup, storage, etc.

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

• Inability to run multiple queries on the same database. You can only run one query on a given database.
• Analytical models created from complex tables isn't accurate, and needs work.
• Inability to view multiple tables of a database side-by-side. When trying to find correlations between tables, it would help to be able to see them at once on the same page.

Incentivized

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

Incentivized

We had already thought of changing to TOAD, but we decided to stick with Oracle SQL Developer until the end.

Incentivized

It's easy to teach new users the extreme basics to get them working, then let them figure out little tips, tricks, shortcuts, refactorings, and other features on their own.

Incentivized

At times, Oracle SQL Developer may experience freezing issues. However, despite this occasional inconvenience, the tool offers valuable features such as the ability to integrate plugins like utPLSQL, which greatly assists in debugging and testing our packages. Additionally, the usage of breakpoints and the flexibility to format text according to individual configurations enhance the debugging process.

Incentivized

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

Large user community support

Incentivized

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

Incentivized

Just download and uncompress!

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

I have started to use Toad for Oracle recently because it is easier to sort and filter results, due to their memory sort feature that puts the results from your query in memory so that you don't have to rerun your query. I have used SQL Developer to easily update records in tables that I need to fix. I haven't found an easy way to do this in Toad other than writing SQL insert statements.

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

• It gives 100% return on investment as it is free of cost.
• No need to have multiple tools for each database
• Considering the employee training, so one can save money on training, as it is not very hard to use so still savings.

Incentivized