Atom vs. Oracle SQL Developer

Atom is great for developers looking for a completely hackable experience. There is a ton of plugins available to you, and you can really build an editor that matches your own personal taste. The performance is also pretty neat and does not impact your CPU as much as the competition.

Incentivized

[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

• 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!

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

• Due to some default settings, when I opened the file in Atom and commit it on Git it shows almost every line is changed so my PR is looking too big/ugly.
• I think omitting the empty spaces should not be the default setting.
• Performance needs some attention.

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

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

Incentivized

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

Incentivized

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.

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

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.

Incentivized

Large user community support

Incentivized

Just download and install

Incentivized

Just download and uncompress!

Incentivized

Atom is incredibly lighter than Dreamweaver, of course it doesn't have the tools DW provides in terms of preview and clicking an element to be taken to the code... but for small web pages this is not necessary.

Atom is more similar to Notepad++ and the very popular vs code... but I prefer it to vs code because of the themes (although i found recently some new additions that are similar to my favourite) and just the feeling when navigating/typing is not the same, it's very hard to describe... but it just doesn't feel "right"

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

• ROI can be said as neutral because eventually, we have to switch to another text editor because of many limitations of Atom for large code.
• In starting stage of the project, everything was fine and things were happening as expected
• Overall it has been a great experience using Atom in my organization but many challenges were faced so that's something Atom should work on.

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