Likelihood to Recommend 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 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 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 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. Joe He Lead Database Administrator
Read full review Cons 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 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 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 We had already thought of changing to TOAD, but we decided to stick with Oracle SQL Developer until the end.
Read full review Usability 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 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 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 Large user community support
Read full review Implementation Rating Just download and install
Read full review Just download and uncompress!
Read full review Alternatives Considered 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 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 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 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