DbVisualizer vs. IntelliJ IDEA

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.

IntelliJ IDEA is very well suited for developers working on Java, Javascript, and related technologies. It is the best IDE I've found so far for software development in Java. IntelliJ IDEA is specifically well suited for web software development using Java as it provides default configurations for web frameworks like Spring and Spring Boot. For other use cases, I feel it is more than good enough.

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

• Compared to Eclipse, basically it is a easier to learn which results in faster learning curve. Good for small or mid-sized projects. Generally speaking developers can be productive in a short training and use.
• Very rich plug-in capability, such as out of the box support for version control systems.
• User friendly interface. Responsive and interactive than other IDE tools.

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

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.

There is always room for improvement, but I haven't met any IDE that I liked more so far. Even if it did not fit a use case right out of the box, there is always a way to configure how it works to do just that.

Incentivized

Never used

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] 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

In summary, IntelliJ is more polished and feature-rich out of the box, especially for Java development. Eclipse is extensible but can be rougher around the edges. IntelliJ costs money for advanced features, while Eclipse is free. IntelliJ offers many developers a better experience, but Eclipse remains a viable open-source alternative.

Incentivized

• 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"

• Boosts productivity: IntelliJ IDEA is efficient to operate, and with its shortcuts and customization, the possibilities to improve your productivity are endless.
• Clean code: IntelliJ IDEA will catch or syntax errors, or even suggest a way something could be written better, or call our your duplicated code or unused imports.
• An easy learning curve for new guys: It's much easier to use than some of the competition, so it helps the new guys hit the ground running by being easy to operate and understand.

Incentivized