TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Oracle SQL Developer

    Score8.1 out of 10
    N/AOracle 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.N/A

    PhpStorm

    Score9.6 out of 10
    N/AJetBrains supports PhpStorm, an integrated development environment (IDE).

    $9.90

    per month per user

    Pricing
    Oracle SQL DeveloperPhpStorm
    Editions & Modules
    No answers on this topic
    For Individuals
    $99
    per year per user
    For Organizations
    $249
    per year per user
    Offerings
    Pricing Offerings
    Oracle SQL DeveloperPhpStorm
    Free Trial
    NoYes
    Free/Freemium Version
    YesNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Oracle SQL DeveloperPhpStorm
    Considered Both Products
    Oracle
    No answer on this topic
    JetBrains
    No answer on this topic
    Key User Insights
    Would buy again
    96%
    Would buy again
    22 Answers
    100%
    Would buy again
    10 Answers
    Delivers good value for the price
    100%
    Delivers good value for the price
    22 Answers
    100%
    Delivers good value for the price
    10 Answers
    Happy with the feature set
    96%
    Happy with the feature set
    22 Answers
    100%
    Happy with the feature set
    10 Answers
    Lived up to sales and marketing promises
    93%
    Lived up to sales and marketing promises
    13 Answers
    90%
    Lived up to sales and marketing promises
    9 Answers
    Implementation went as expected
    100%
    Implementation went as expected
    20 Answers
    100%
    Implementation went as expected
    9 Answers
    Best Alternatives
    Oracle SQL DeveloperPhpStorm
    Small Businesses
    No answers on this topic
    Visual Studio
    Score8.8 out of 10
    Medium-sized Companies
    Redgate SQL Toolbelt Essentials
    Score9.6 out of 10
    PyCharm
    Score9.3 out of 10
    Enterprises
    Redgate SQL Toolbelt Essentials
    Score9.6 out of 10
    WebStorm
    Score9.6 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Oracle SQL DeveloperPhpStorm
    Likelihood to Recommend
    9.0
    (74 ratings)
    10.0
    (20 ratings)
    Likelihood to Renew
    9.0
    (5 ratings)
    -
    (0 ratings)
    Usability
    8.9
    (4 ratings)
    9.2
    (5 ratings)
    Support Rating
    7.0
    (2 ratings)
    9.4
    (3 ratings)
    Implementation Rating
    9.2
    (2 ratings)
    -
    (0 ratings)
    User Testimonials
    Oracle SQL DeveloperPhpStorm
    Likelihood to Recommend
    Oracle
    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
    Read full review
    JetBrains
    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
    Read full review
    Pros
    Oracle
    • 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
    Read full review
    JetBrains
    • 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
    Read full review
    Cons
    Oracle
    • 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
    Read full review
    JetBrains
    • 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
    Read full review
    Likelihood to Renew
    Oracle
    We had already thought of changing to TOAD, but we decided to stick with Oracle SQL Developer until the end.
    Incentivized
    Read full review
    JetBrains
    No answers on this topic
    Usability
    Oracle
    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
    Read full review
    JetBrains
    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.
    Read full review
    Support Rating
    Oracle
    Large user community support
    Incentivized
    Read full review
    JetBrains
    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
    Read full review
    Implementation Rating
    Oracle
    Just download and uncompress!
    Incentivized
    Read full review
    JetBrains
    No answers on this topic
    Alternatives Considered
    Oracle
    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
    Read full review
    JetBrains
    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.
    Read full review
    Return on Investment
    Oracle
    • 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
    Read full review
    JetBrains
    • 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
    Read full review
    ScreenShots