DbVisualizer vs. IntelliJ IDEA

Whenever you have to access data sources from more than one database engine provider, you should consider using DbVisualizer for the task. Switching between multiples IDE consumes time and resources (memory), and you also need to learn menus, shortcuts, etc., for each IDE, while using DbVisualizer allows you to work consistently no matter which database engine you are connecting. You can use it to simply navigate through data structures, write SQL sentences or even create new tables and views, develop stored procedures, etc.

Incentivized

For a modern software project, where you want to store everything as code, from the backend to the frontend, to the DB patch scripts, to the documents, API specs, diagrams, infrastructure-as-code, etc. IntelliJ is basically your one-stop. In the same IDE, you can write code, write a spec, draw diagrams, make changes to patch scripts, infrastructure definition.

Incentivized

• Timed queries that add their result to the result grid for every execution are helpful. Creation of graphs also extremely helpful.
• Query history and auto-recover feature makes sure we don't lose our queries.
• Actions like exporting grids to Excel or other tools is a very easy task.

Incentivized

• Unit testing: Fully integrated into IntelliJ IDEA. Your unit tests will run smoothly and efficiently, with excellent debugging tools for when things get tricky.
• Spring integration: Our Spring project using Maven works flawlessly in IntelliJ IDEA. I know firsthand that Apache is also easily and readily supported too. The integration is seamless and very easy to set up using IntelliJ IDEA's set up wizard when importing new projects.
• Customization: IntelliJ IDEA comes out of the box with a bunch of handy shortcuts, as well as text prediction, syntax error detection, and other tools to help keep your code clean. But even better is that it allows for total customization of shortcuts you can easily create to suit your needs.

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

• IntelliJ IDEA wins as long as the language is Java. Outside that , e.g., in other languages, it is not so advanced.
• It is licensed, with a steep licensing cost. All features are not included in the free edition.
• It is not as light as Eclipse, so in a weak system, it can be a pain.

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

VS Code is maturing and has a Scala plugin now. The overall experience with VS Code - for web development at least - is very snappy/fast. IntelliJ feels a bit sluggish in comparison. If that Scala plugin for VS Code is deemed mature enough - we may not bother renewing and resort to the Community Edition if we need it.

Incentivized

Menus are simple and well organized. You can use the same shortcuts no matter which database engine you are connecting to. Configuration of data source connections is simple while keeping all required options.

Incentivized

The user interface for IntelliJ Idea is phenomenal. It's got the usual JetBrains interface but it works well to support all Java processes. All in all, it is a solid product and to be expected from JetBrains who creates this integrated development environment software. It allows me to test in the IDE and run other manual workflows automatically such as install packages.

Incentivized

Customer support is really good in the case of IntelliJ. If you are paying for this product then, the company makes sure that you will get all the services adequately. Regular update patches are provided to improve the IDE. An online bug report makes it easier for the developers to find the solution as fast as possible. The large online community also helps to find the various solutions to the issues.

Incentivized

This installs just like any other application - its pretty straight forward. Perhaps licensing could be more challenging - but if you use the cloud licensing they offer its as simple as having engineers login to the application and it just works.

Incentivized

DbVisualizer provides a good value when compared against other 3rd party products with similar features as well as products with similar functionality made by the database vendors. The user interface is good and user friendly / intuitive and easy to learn. It doesn't take too long for an experienced DBA / database developer to come up to speed.

Microsoft Visual Studio Code (VS) requires a lot of textual configuration, where IntelliJ IDEA provides a graphical interface with configuration options displayed. This matters a lot to me as I don't want to hunt around the internet to remember how to set different parameters that I don't use very often. This may be the biggest reason I don't use VS. Eclipse was great for when I was in college, but the power offered by IDEA is so much better that I haven't actually looked back since.

Incentivized

• The institution is of the governmental type, therefore we do not measure the commercial impact of using this tool
• The impact on the benefit of the population is always positive with tools that streamline our processes, and DbVisualizer is one of the best

Incentivized

• IntelliJ wasn't provided as complimentary, but the pricing was reasonable. We're healthcare organization of which our applications used to be mission critical and affect to patient safety, we were willing to pay the price.
• With the pricing, business support was good and well conducted during the project.
• Overall it was cost-effective as it saved our developers' time in general. (We don't have quantitative measure but we got feedback from them)

Incentivized