Codeanywhere vs. ilos vs. Oracle SQL Developer

If you're looking for a VS Code-like online environment with containers to spin up a dev environment or execute code and scripts it is a good fit. The environments are very customizable, and, all said and done, the price is fair. If you're looking for a remote code editor that allows you to connect via SFTP/SSH and edit the remote files, it isn't quite as seamless as it used to be. I still haven't found any all-cloud alternative, but it could be better.

Incentivized

ilos is great for a larger group looking for an easy to learn capture system and platform all combined together. Because it lets you record, edit, and share there is no reason to learn one or two software for capture and editing, and another for sharing. ilos is not targeted at intermediate or advanced users, so the ability to manipulate your content - specifically when editing, is very limiting to more experienced users.

Incentivized

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.

Incentivized

• Run development containers with backend and frontend access.
• Allow for multiple users to collaborate and share containers and connections.
• Manage multiple connections to different servers.

Incentivized

• Desktop capture is simple even for first-time users
• Editing capabilities and focused on only the most common features, avoiding overwhelm or confusion
• Sharing inside Canvas is simple and intuitive

Incentivized

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

Incentivized

• Since some updates a couple of years ago, using Codeanywhere as a remote code editor rather than a container-based development environment has been more cumbersome and difficult.
• The modular nature of connections and containers seems like a good idea, but they don't always work properly.
• It's difficult sometimes to share a connection or container together with a collaborator.

Incentivized

• Features are often rolled out before they are fully baked
• Communication of changes can be limited and frustrating
• Not all changes feel like improvements, much less necessary

Incentivized

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

Incentivized

We had already thought of changing to TOAD, but we decided to stick with Oracle SQL Developer until the end.

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

Large user community support

Incentivized

Just download and uncompress!

Incentivized

I've used CodeTasty, which is much more of a straight remote code editor, but their dev team is entirely unresponsive, and I became uncomfortable storing credentials with them, so I pulled everything from them and went back to Codeanywhere. VS code is similar but not fully online. While I know that they've released a fully online version, I haven't had the time or wherewith-all to make it work in the capacity I need. Codeanywhere is still the best solution I've found.

Incentivized

It was a tough call to choose ilos over Kaltura, but the more limited features made ilos seem more approachable for novice users. Price was also far lower because of the limited focus of ilos. Kaltura did offer more tools for marketing/public purposes - such as streaming, capture integration, and video portals - but none of those are necessary for us.

Incentivized

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.

Incentivized

• Helped me make mission critical edits remotely and on-the-fly.
• Spent a bit of time figuring out the change in user interfaces.

Incentivized

• Makes sharing content with students easier for faculty - so they actually make and share videos more than before
• Students don't have issues viewing, even on limited bandwidth
• Because you can make a video wherever and whenever you want, creation has increased

Incentivized

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

Incentivized