AWS Cloud9 vs. Oracle SQL Developer

AWS Cloud9 is great for product engineering and coding where you must take time to pair program and code in a specific isolated environment. It is entirely cloud based so there's no worry about saving and data consistency. It is all hosted on the Amazon Web Services cloud. It is less appropriate for more general workflows that don't require a specific cloud instance.

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

• Great, fast interface - There is a large list of shortcuts that make development on this IDE an experience that can sometimes even compare to something native.
• Integrated debugging/troubleshooting - AWS Cloud9 has integrated debugging tools that are quite well-designed.
• Lambda integrations - Cloud9 allows you to instantly run and maintain Lambda functions. It's probably the best IDE for developing on AWS Lambda.

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

• According to the project that is being executed it can become slow.
• It does not have the basic text manipulators.
• Shared terminals sometimes take a while to display.

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

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

Incentivized

The interface for Cloud9 needs some improvement. It is simply not as powerful and intelligent as a local text editor would be and thus it lacks the capabilities of fast filling when coding. Otherwise, I think it has a fair interface that they have tried mimicking an IDE.

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

Customer support is managed by the Cloud support team. I won't be able to comment on details, but it's fast.

Large user community support

Incentivized

Just download and uncompress!

Incentivized

S3 is a great service for storing unstructured data. It is cheap and us an user we don't have to care about scaling. Amazon S3 is a managed service. We use it for avery simple projects in our organization.

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

• This software has been really useful for our company since thanks to the fact that you can work together with other colleagues in the same code, it is much easier to advance in the development of projects and thus be able to make your delivery in a much shorter time.
• Because it provides all the necessary tools to develop projects, there is a great saving of time and costs.
• It is easy to use so any user can use it and this makes it possible to streamline each project much faster and more if you do not necessarily have to be in the company to advance in them, and this is thanks to the fact that it can be used from anywhere with internet access.

• 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