Atom vs. Oracle SQL Developer

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Atom
Score 8.3 out of 10
N/A
Atom is a free and open source text editor offering a range of packages and themes.N/A
SQL Developer
Score 7.7 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.N/A
Pricing
AtomOracle SQL Developer
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
AtomSQL Developer
Free Trial
NoNo
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
AtomOracle SQL Developer
Top Pros
Top Cons
Best Alternatives
AtomOracle SQL Developer
Small Businesses
BBEdit
BBEdit
Score 8.2 out of 10
PyCharm
PyCharm
Score 9.2 out of 10
Medium-sized Companies
Vim
Vim
Score 9.7 out of 10
PyCharm
PyCharm
Score 9.2 out of 10
Enterprises
Vim
Vim
Score 9.7 out of 10
PyCharm
PyCharm
Score 9.2 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
AtomOracle SQL Developer
Likelihood to Recommend
7.3
(31 ratings)
7.5
(72 ratings)
Likelihood to Renew
10.0
(1 ratings)
10.0
(4 ratings)
Usability
9.0
(2 ratings)
8.2
(2 ratings)
Support Rating
8.6
(13 ratings)
7.0
(2 ratings)
Implementation Rating
10.0
(1 ratings)
9.2
(2 ratings)
User Testimonials
AtomOracle SQL Developer
Likelihood to Recommend
Open Source
Atom is great for simple HTML coding. It's fast, has intuitive shortcuts and several options. I particularly love the "convert spaces to tabs" function that I haven't seen in other editors.
I'm not sure how it would fair in more serious web development today, if there are plugins for live updates of the page you are working on...
But the problem is that it has been discontinued so you know there are no new features or fixes coming through.
Read full review
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.
Read full review
Pros
Open Source
  • Atom is highly customizable and allows for various themes and extensions that can make your code easier to read.
  • Atom has many code hinting features that allow users to write faster and integrate with services likeLINT that can clean up your code once your done to meet your internal teams style choices.
  • It's very fast and manages projects well - Accessing other files within a related folder(s) is very easy and intuitive.
  • It's free!
Read full review
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.
Read full review
Cons
Open Source
  • There should be a better user tips manual page to learn keyboard shortcuts
  • It would also be beneficial if mathematical and data analytic tools were added
  • it has quite high start-up timing when you open large projects to work on it
  • Sometimes, atom closed suddenly and do not open again
  • It still lacks better options with the previews even though there are already some by users adding plugins
  • It doesn't have self-correct features for lint errors, unlike IntelliJ
Read full review
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.
Read full review
Likelihood to Renew
Open Source
Well Atom is open source so the re-new is a no brainer. The only way I would stop using Atom is if the developers somehow made it not function well. Or, if the project got forked to a commercial version or something. Or, there could be the case that development stops or that it was not updated on this or that platform
Read full review
Oracle
We had already thought of changing to TOAD, but we decided to stick with Oracle SQL Developer until the end.
Read full review
Usability
Open Source
I give Atom a 9 because it is one of the most modern text editors built with JavaScript intentionally to allow the editor to be changed and modified with custom functionality that a team may need. I think I would otherwise give atom an 8 due to support, but it gets a 9/10 because of the extensibility/plugin capability.
Read full review
Oracle
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.
Read full review
Support Rating
Open Source
Atom has an active forum and a Slack group where you can ask technical questions. Occasionally, the authors will pop in to answer a few questions here and there, but most of the time, its other helpful users who will assist you. Though they aren't the most knowledgeable, they are at least timely.
As for plugin support, that differs with each plugin, but as I mentioned before, many plugins are no longer maintained.
Read full review
Oracle
Large user community support
Read full review
Implementation Rating
Open Source
Just download and install
Read full review
Oracle
Just download and uncompress!
Read full review
Alternatives Considered
Open Source
Our company likes to keep things open, and we don't want to prevent developers from customizing their environment the way they want. Atom seemed to be a lot more open than our existing tools and has good community support on pretty much any programming language. This can create some confusion since adding too many extensions or customizing can make the tool slower than it is supposed to be.
Read full review
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.
Read full review
Return on Investment
Open Source
  • The tool we use when we need quick fixes. Allows fast, reliable scripting to fix urgent problems in our applications.
  • When applications grow from 5-10 files to 100's, they need to be migrated to a heavier-duty IDE. This can be cumbersome and quite annoying, but is necessary to maintain code integrity on such a large scale (since it cannot be done with the limited default toolset of Atom).
Read full review
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.
Read full review
ScreenShots