Oracle SQL Developer vs. PhpStorm

[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

PhpStorm is well suited for any PHP development. It integrates well with Symfony, Laravel, CodeIgniter, Cake & Twig. I have used it very successfully in the past and despite not being my go-to editor, I will still use it when working on PHP heavy frameworks.

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

• Version Control: Git, Subversion, and Others.
• Alerts about code being developed, alerts like errors, discontinuation of some function, suggestions for improvements.
• Application database access can run SQL commands directly from PhpStorm without having to have any other clients open.
• Shortcut keys that assist in the coding process.

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

• There is a bug sometimes, when you pull that the directory structure it forgets all the folders
• It's not free
• When I copy paste the default is to not keep the same spacing/tab pattern of the original, which I'm not a fan of

Incentivized

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

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.

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

Just download and uncompress!

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

Each one of the products I've listed are great in their own right, but non of them provide as complete a solution as PhpStorm in my opinion. Very few products offer all of the features that PhpStorm does and those that do don't have the greatest performance in my experience. Some have a great text editor but lack other critical features while others have a bounty of features, but the text editor is garbage. Before I tried PhpStorm, I stuck to using simple text editors because the features the IDEs offered didn't outweigh performance hit of running such a large, slow program. PhpStorm isn't lightweight by any means but I haven't noticed any of the common performance issues that I experienced with other IDEs.

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

• Recent AI advancements have saved us time to build by integrating it direct with the IDE allowing build to deployment to happen at a more rapid pace than previously possible
• Integrated AI commit message generation saves time and effort from team members shorting time writing documentation allowing more time spent in development
• Integrated git development causes less friction across team with version control and merge conflict resolution shortening development work flows

Incentivized