DbVisualizer vs. WebStorm

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.

WebStorm is a great product for programming and development. It has all the capabilities needed for education, as well as for professional deployment. I use it in the classroom with my students, who benefit from the comprehensive drop down menus and the integrated spell check. It also has a clean user interface that allows for customization.

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

• This is the only editor in my opinion which gives you the full development experience if you want to code in JavaScript.
• WebStorm supports many different linters including "standards". This has been such a blessing for our team. All our PRs look perfect now.
• WebStorm is very good in design. I love coding in it.
• It has terminal built right into it. I know many other editors also provide this, but I really like how seamlessly the terminal works out of the box.
• Most of the plugins you will ever need is already installed right off the box. I haven't installed anything new so far.
• The rename/reformat functions are very intelligent. I feel very confident renaming something new.
• There is a "validation" inspector which reports anything as small as spellings. This helps us keep our codebase very-very clean.

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

• Didn't find any apparent issue overall, except sometimes the WebStorm is running too many default validation check in the backend and response is slow, typically when we keep WebStorm running for some time, and if we restart the WebStorm it will take long time to be "warm up", perhaps, some JetBean team can consider some performance improvement

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

It's an irreplaceable part of my toolkit and isn't that expensive per year.

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.

Great in debugging, testing, developing and maintaining softwares in a number of languages. Great support for many languages and their syntaxes. Great support of many third party extensions and plugins like GIT and html plugins. The RAM usage of WebStorm however could be really improved, it literally takes almost all of the RAM of my machine with 16GB RAM

Incentivized

Never used

Incentivized

I gave this rating because I have never needed their customer support, which is the highest level of support I suppose. When a product works just fine out of the box and everything you may need is well documented, it's a paradise for the customer. But I've seen some questions asked on their portal, and I've seen thorough answers given to the questions and the willingness to support the customer with follow-ups and everything else.

Incentivized

Highly recommend the JetBrains Toolbox, it remembers your recent projects and launches from the task bar.

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

VS Code is free and more popular. Popularity helps in that you can do pair programming more easily because you all use the same [tool]. It's also easier when trying to guide someone (especially a junior developer). However, Webstorm comes with more out-of-the-box and is generally faster and more effective. Webstorm has been around for many more years as well.

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"

• Our UX guys love the Emmet support provided by WebStorm and enjoy cranking out prototypes quicker than they could before.
• I love the standardization provided by the tslint support. When all the devs code to the same standard, it makes our code more maintainable.
• The test support makes it easier to write and execute tests, lowering the barrier to entry of creating test suite around our code. Testing makes maintenance of any codebase far more effective and efficient.

Incentivized