WebStorm vs. Oracle SQL Developer vs. PhpStorm

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

PhpStorm is well suited for any project that utilizes PHP. I have used it on Windows, Ubuntu, and Mac OS and it works great on all those platforms. Having a solution that keeps the developer from having to constantly switch tools to do their job is invaluable. Whether you're a junior developer, front end engineer or a senior developer, PhpStorm is a great product that will help you get your work done.

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

• Database browsing, Remote host browsing, and all the deep seated customizations for both the UI and Technical feasability are the result of an amazing integrity and compatibility with most components and technologies.
• The built-in shell is insanely helpful for traversing code in order to debug scripts with ease, and the plug-in system makes this software quite extensible.
• Not to mention the variety of options and settings (divided into global settings and per-project settings) are both intuitive & easy to use, especially the fact that I can export and import them across my workstations while maintaining my spacing & indentation, highlighting, inspection patterns and syntax styling.

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

• Some of the newest github copilot features lag behind what's being done in vs code and would be nice if more of the newer features were brought over though this has greatly improved recently
• Interface can be a little overwhelming for newcomers
• Some features like rainbow brackets should be native rather than addon

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

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

PhpStorm is very easy to use, once you get the hang of it. It can take a while to get the hang of it because there's so many options, some of which are buried in the imposing settings panel. It could use some help with multi-cursor, especially multi-file editing but that's a minor gripe.

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

The JetBrains community is all about helping others succeed, even in the most obscure setups. I have never had a question go unanswered, or I have never been able to come up with empty results in searching for the answer. My questions or concerns are typically address from other users in the community, so timing is pretty quick for a response

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

Easier to use, more features, more reliable. Much more purpose built with specific integrations aimed directly at php code instead of the broad generic interfaces the other software have that are aiming to support many different languages.

• 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

• PhpStorm decreased the time to market of new features - we are following the Agile SCRUM methodology with 2 weeks sprints. Using PhpStorm helped with releasing UI features even faster than 2 weeks.
• Considering the price of the license and the cost of the server where we run it, the ROI is still high due to less time spent by developers with writing code, debugging, refactoring etc. Especially when you have highly paid developers.
• Increased people's happiness - by using a modern tool with lots of features which has made their work easier.

Incentivized