Access Legal Proclaim vs. Codeanywhere vs. Oracle SQL Developer

In my view, there is no comparable product on the market...especially at this price point. Anyone asking, I would tell them it's a world-class product. Easy to use interface, straightforward production. Compared to Powerpoint, which I know many churches still use, Proclaim is a no-brainer. It has saved me a huge amount of time in my weekly preparations.

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

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

• Allowance for many types of media
• Generally a very stable platform
• Easy to use interface

• 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

• 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

• Editor could be more robust
• A better way to organize the media library would be helpful
• Lack of support for MOV files

• 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

• 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

Proclaim is designed specifically for Worship design and has many features catered specifically to our market segment. Powerpoint WILL get the job done, but because it is more geared to corporate, general production, it really isn't comparable for our use case.

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

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

• The biggest factor is time savings

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

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