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.3 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.
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.
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.
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.
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.
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.
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.
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.
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.
