DbVisualizer vs. Xcode

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

We are huge advocates of native iOS development and there is just real alternative when it comes to developing in Swift or Objective-C for the iPhone and iPad

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.

• Debugging
• Profiling
• Great IDE

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)

• Documentation
• Number of settings can be overwhelming
• Embedded help for settings and configuration
• Templates
• Collaboration
• Managing of credentials (although this has recently gotten better)

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

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.

Xcode occasionally exhibits some behaviors that are hard to explain, but are generally cleared by restarting the program. In an application this large and complex, I suppose this is somewhat expected. The sheer vastness of the frameworks collection has to be a huge management issue all by itself. However, those breaks in the flow can have impact on developer productivity.

Incentivized

Since we don't use the cloud based features of Xcode, it is basically available 24/7 for us. We don't need the extended compilation features that are offered in the cloud as our projects to this point have not been that large or complex. We have never seen a wholesale breakdown of Xcode availability at any point in our use of the product.

Incentivized

Every developer wants faster compiles, but that can be achieved by either going to the cloud or by provisioning the local station to a higher powered configuration. My only minor complaint is the amount of local mass storage that Xcode as a system consumes. This makes it interesting to set up a development environment on a midrange laptop, however it is easily managed with external storage at a reasonable price.

Incentivized

Never used

Incentivized

DBeaver is used by some of our customers. We find it clunky and unintuitive. One customer used TOAD for his Oracle installation (15+ years ago). We did not like it at all. When researching for a universal database tool some 20 years ago, we found dbvis and never looked back. We have not found a need to look for other soulutions so we never checked others.

Xcode is the clear choice in general circumstances in Apple echosphere application development (for instance, not for Java or web programming necessarily) primarily due to the fact that it is Apple's in-house tool. It received a lot of attention and is used by a huge audience of developers. It has the advantage of being free, heavily supported by Apple, tightly tied to OS and hardware changes, and benefits from significant Apple Intelligence enhancements in the latest version.

Incentivized

Xcode only loses points due to the occasional situation where it manages to somehow tie itself into a knot and starts to exhibit odd symptoms. This is almost always solved by simply saving progress and restarting the environment. Fortunately, that doesn't happen too frequently and is easily repaired while taking a short break to walk around and stretch.

Incentivized

• The pricing for DbVisualizer is fair.
• The tool also succeeds in non-functional areas I find important, such as being able to install and/or run without requiring administrator privileges on Windows.
• Has capability to generate diagrams and models from existing databases which is very helpful in reverse engineering.

Incentivized

• Xcode is free, and is supported at low cost by individual or organizational membership
• There are a lot of free resources available, which is particularly important to students and independent developers
• Since producing apps is not a core business function of the university, it is difficult to provide direct bottom-line tangible benefits, but frequently programming students come in with a basic understanding of Xcode already in place, which saves class time
• Producing standard structured code from a standard IDE makes it easier for sharing code with peer institutions
• Students expect to have university branded "helper" apps available, and Xcode makes it fairly easy to transport code from one contractor to another
• No negative impacts are immediately evident other than familiarization time with the IDE can be high if you try to know what everything does

Incentivized