WebStorm vs. Oracle SQL Developer

WebStorm is a great product for programming and development. It has all the capabilities needed for education, as well as for professional deployment. I use it in the classroom with my students, who benefit from the comprehensive drop down menus and the integrated spell check. It also has a clean user interface that allows for customization.

Incentivized

[Oracle SQL Developer is] best suited if your company works with different databases and needs a common SQL editor to manage and query data for its user. Oracle SQL Developer works very well with Oracle but also some other relational databases. If you do lot of querying and import/export in database, then this is tool for you. It's ideal for DBAs as well for data modeling, management, session monitoring, logging, versioning, etc. It’s not ideal for no relational/noSQL or big data. It is not tool for visualization. It’s best suited for querying using SQL. Companies that are looking for free tools that are robust and most useful should definitely look at it.

Incentivized

• This is the only editor in my opinion which gives you the full development experience if you want to code in JavaScript.
• WebStorm supports many different linters including "standards". This has been such a blessing for our team. All our PRs look perfect now.
• WebStorm is very good in design. I love coding in it.
• It has terminal built right into it. I know many other editors also provide this, but I really like how seamlessly the terminal works out of the box.
• Most of the plugins you will ever need is already installed right off the box. I haven't installed anything new so far.
• The rename/reformat functions are very intelligent. I feel very confident renaming something new.
• There is a "validation" inspector which reports anything as small as spellings. This helps us keep our codebase very-very clean.

Incentivized

• Export SQL results to a spreadsheet. After a query is run, you are able to export the results to a spreadsheet
• Easily preview data columns on an Oracle table or view and the metadata on those columns.
• SQL Editor is color-coded so that you can tell easily what are keywords.
• You can set up SQL code templates to be able to use shortcut keys to format your SQL query easily in a readable format that you prefer.

Incentivized

• Didn't find any apparent issue overall, except sometimes the WebStorm is running too many default validation check in the backend and response is slow, typically when we keep WebStorm running for some time, and if we restart the WebStorm it will take long time to be "warm up", perhaps, some JetBean team can consider some performance improvement

Incentivized

• Setup can be challenging if your schemas aren't well formed or managed. Also, the ability to model/develop extensions for an existing database solution will depend on how robust the DBA provisioned roles and designed the respective schemas.
• Detailed analysis of models can be clunky for complex relational models.

Incentivized

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

Incentivized

It allows most users to perform daily activities in a simple way, with no cost since the tool is free.

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

Oracle SQL Developer is very easy to use and there are a wide range of courses available which can help you get started just within a day. Data can be exported in multiple formats based on user requirements. Organizational data can be stored and management effectively using Oracle SQL Developer. All the data, tables, sequences, indexes can be easily created and updated in Oracle SQL Developer.

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

VS Code is free and more popular. Popularity helps in that you can do pair programming more easily because you all use the same [tool]. It's also easier when trying to guide someone (especially a junior developer). However, Webstorm comes with more out-of-the-box and is generally faster and more effective. Webstorm has been around for many more years as well.

Incentivized

Oracle SQL Developer is available on multiple platforms, Windows Mac Linux and it's free. SQL Developer is best suited for a big cross functional globally based team. SQL Developer is less resource intensive, compared to other IDEs. SQL Developer has the capability to manage and develop Oracle Database in both on premise and Cloud deployments. SQL Developer can also connect and interact with non oracle database like MS SQL server and MySQL etc.

Incentivized

• Our UX guys love the Emmet support provided by WebStorm and enjoy cranking out prototypes quicker than they could before.
• I love the standardization provided by the tslint support. When all the devs code to the same standard, it makes our code more maintainable.
• The test support makes it easier to write and execute tests, lowering the barrier to entry of creating test suite around our code. Testing makes maintenance of any codebase far more effective and efficient.

Incentivized

• No impact on the organization's budget as Oracle SQL Developer is free.
• With the increased productivity of our database administrators, they are able to better assist the software developers in prototyping future products.
• Through Oracle SQL Developer, our administrators were able to normalize many of our databases, reducing the amount of redundancy, and hence increasing the performance of our main application.

Incentivized