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.
N/A
PhpStorm
Score 9.5 out of 10
N/A
JetBrains supports PhpStorm, an integrated development environment (IDE).
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.
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.
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.
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.
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.
At times, Oracle SQL Developer may experience freezing issues. However, despite this occasional inconvenience, the tool offers valuable features such as the ability to integrate plugins like utPLSQL, which greatly assists in debugging and testing our packages. Additionally, the usage of breakpoints and the flexibility to format text according to individual configurations enhance the debugging process.
The UI is very easy to understand. From common to less common, with the search feature, you can find anything you are looking for within the software. For me, that makes it tremendously easy to use.
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
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.
Two things were decisive for choosing PhpStorm, and the first was the Education version since we were a university we were able to license for free, and the other was that we just had to use a single tool to develop our activities (coding, versioning), and operations in the DB). Another point was that the application is cross-platform.
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.
