Codeanywhere vs. DbVisualizer

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

Seamlessly querying PostgreSQL/PostGIS, Oracle, SQL Server, and SQLite from one interface without switching tools. The intelligent autocomplete and schema browsing make it ideal for writing queries and understanding unfamiliar databases. Complex performance tuning, deep monitoring, and automated backup/recovery require specialized DBA tools. Performance degrades with tens or hundreds of thousands of rows; command-line tools or ETL solutions are better suited to bulk data processing.

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

• Out-of-the-box support for many different databases.
• Intuitive UI for interacting with data.
• Flexibility of SQL Commander for writing scripts.
• Great support for working with JSON data in recent updates.
• Database connections over SSH.
• Table relationship visualization is very helpful.
• The tree view is well organized in how it splits out schemas.

• 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

• Small, but noticeable: it would be nice to be able to highlight just one column of a data output for copy/paste by clicking on the column header (a feature some of us are accustomed to from SQL Server Management Studio)
• Is there an ability to bulk import an excel file to a table in a connected SQL Server in DbVis? If so, I haven't figured that out yet. I still largely use Microsoft SSMS to import data to our team's personal SQL Server, but can easily query that server via DbVis)
• (I really don't have any major complaints - our company has tried to steer users toward DBeaver for YEARS, which I cannot stand. DbVis knocks the beaver out of the water)

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

It does what we need it for, which is manipulate data, check connections, visualize database structures, check on user rights, or even just version checks on the used databases. The 'type to get to table name' feature is often irrational in behaviour, which leads to frustration. The start-up time could be much better, and the UI changes between versions are sometimes a hassle for us when buttons are suddenly moved or their appearance changes. We use a wide variety of DBVis versions on customer installations (which use the once-bought version), and differences in the look and feel between versions sometimes slow us down.

Never used

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

[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

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

Incentivized

• Positive: Real time saver when working across multiple databases. At least 30-40 mins a day are saved
• Positive: Helpful for the 'quick DBA' tasks without switching to the native tools: approx 1-2 hours saved weekly
• Positive: Easy switch between environments / schemas / etc without hassle: saved at least an hour daily