DbVisualizer vs. WebStorm

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

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

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

• 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

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

• 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

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.

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

• 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