DbVisualizer vs. PhpStorm

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.

PhpStorm is well suited for any PHP development. It integrates well with Symfony, Laravel, CodeIgniter, Cake & Twig. I have used it very successfully in the past and despite not being my go-to editor, I will still use it when working on PHP heavy frameworks.

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

• Version Control: Git, Subversion, and Others.
• Alerts about code being developed, alerts like errors, discontinuation of some function, suggestions for improvements.
• Application database access can run SQL commands directly from PhpStorm without having to have any other clients open.
• Shortcut keys that assist in the coding process.

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

• There is a bug sometimes, when you pull that the directory structure it forgets all the folders
• It's not free
• When I copy paste the default is to not keep the same spacing/tab pattern of the original, which I'm not a fan of

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.

PhpStorm is very easy to use, once you get the hang of it. It can take a while to get the hang of it because there's so many options, some of which are buried in the imposing settings panel. It could use some help with multi-cursor, especially multi-file editing but that's a minor gripe.

Never used

Incentivized

The JetBrains community is all about helping others succeed, even in the most obscure setups. I have never had a question go unanswered, or I have never been able to come up with empty results in searching for the answer. My questions or concerns are typically address from other users in the community, so timing is pretty quick for a response

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

Each one of the products I've listed are great in their own right, but non of them provide as complete a solution as PhpStorm in my opinion. Very few products offer all of the features that PhpStorm does and those that do don't have the greatest performance in my experience. Some have a great text editor but lack other critical features while others have a bounty of features, but the text editor is garbage. Before I tried PhpStorm, I stuck to using simple text editors because the features the IDEs offered didn't outweigh performance hit of running such a large, slow program. PhpStorm isn't lightweight by any means but I haven't noticed any of the common performance issues that I experienced with other IDEs.

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"

• Recent AI advancements have saved us time to build by integrating it direct with the IDE allowing build to deployment to happen at a more rapid pace than previously possible
• Integrated AI commit message generation saves time and effort from team members shorting time writing documentation allowing more time spent in development
• Integrated git development causes less friction across team with version control and merge conflict resolution shortening development work flows

Incentivized