DBArtisan vs. PhpStorm

DBArtisan is excellent for large institutions with multiple mission-critical databases. It works especially well for cross-platforms RDBMS support. I am mostly familiar with Oracle, but less familiar with SQL Server and Sybase. So I certainly appreciate having a similar interface that allows me to manage those less familiar RDBMS, as this will mean a smaller learning curve. DBArtisan is mostly for DBAs, it is not suitable for developers, I believe the vendor has a separate tool for that

Incentivized

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

• The free trial offer was great for me to test the software before purchasing it.
• It monitors queries well and shows resource allocation, as well as detailed stats for each running query.

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

• DBArtisan lacks a utility that does schema or object comparisons, which is a feature in Toad. I find this useful in some situations where I need to find out all differences between Prod and QA for a given schema, for example. DBArtisan doesn't seem to have the capacity to do this.
• I wish there was a way for the tool to warn me before performing a long-running task. For example if I want to re-organize a large table or rebuild an index for a table with millions of rows, it should warn me before executing it, so that I may choose to do it in a different way. Sometimes if I let these long operations run for too long, it freezes the program and crashes DBArtisan. I would rather run it on the DB server, and run it in background so that it doesn't time out, if DBArtisan gave me a warning before execution.
• Idera has taken over Embarcadero. I never heard of or dealt with Idera for support. I don't know if they have same the quality support as 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

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.

I have never tried their support so the number above is meaningless

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

DBArtisan does not have an in-depth performance analyzer for databases.

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

• While it is expensive, it saves us a great deal of time in getting a lot of DB work done.
• The front end is reasonably powerful and significantly more polished than any of the free alternatives

Incentivized

• 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