AWS Cloud9 vs. DbVisualizer

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

Well suited for medium size to large Oracle system that includes a large and complex database schema with many database objects including functions and triggers. Also well suited for a medium size to large Microsoft SQL Server system with many complex database objects. Its SQL editor and query builder are well suited in developing complex SQL queries.

• 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

• Provides simple access to all tables, indexes, views, triggers, stored procedures, etc., to just about every database on the market
• Allows me to develop and run queries in a simple, easy to read and understand manner
• Allows me to create entire new schemas as well as alter existing schemas
• Gives me access to databases without the need to install specific drivers for any particular database

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

• does not handle lost connections well (specially after stopping a running query) (mysql). eg. after hitting stop, and then hitting run again, it can sometimes look like its running the query, but it isn't actually!
• filtering on databases window is clunky (why the need for filtering certain object types at a time? just filter everything, google style)
• altering table, adding columns (NOT to the end of the table's columns, but earlier) is not supported (mysql) even though the db supports it (alter table add column BEFORE..)

Incentivized

We never had problems with it. It is able to connect to all data sources (Oracle, Informix, DB2, SQL Server) that we currently use.

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

I use this tool for several hours each day, spanning many years in various projects. It's wide support for various database types while keeping consistency within the UI for each is important when working with various databases day in and day out.

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

Never used

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

[DbVisualizer] is pretty easy to use compared to IntelliJ because of it's simplicity. The performance is very good, it feels as good as a native application compared to the other two softwares I used for the same purpose. It's very cheaper compared to the other two tools and that's a big selling point.

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.

• The only point I could potentially give is hours saved by having so many warehouses hooked up in one place vs. having to manage connection string changes/password updates across multiple applications... maybe 10% decrease in time spent managing connections? Mind you, I've had everything hooked up on DbVis for close to 6 years so it's hard to remember the "before times"