WebStorm is an integrated development environment (IDE) by JetBrains. Designed for JavaScript and TypeScript development, WebStorm also aims to make it easy to tackle the most challenging tasks. Whether resolving Git merge conflicts or renaming a symbol across multiple files, it takes just a few clicks.
$0
per year
Oracle SQL Developer
Score 8.7 out of 10
N/A
Oracle SQL Developer is an integrated development environment (IDE) which provides editors for working with SQL, PL/SQL, Stored Java Procedures, and XML in Oracle databases.
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.
[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.
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
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.
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
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.
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.
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.
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.
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.
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.
