DataGrip vs PhpStorm

Need advice about which tool to choose?Ask the StackShare community!

DataGrip

355
373
+ 1
14
PhpStorm

10.2K
7.6K
+ 1
1.6K
Add tool

DataGrip vs PhpStorm: What are the differences?

What is DataGrip? A database IDE for professional SQL developers. A cross-platform IDE that is aimed at DBAs and developers working with SQL databases.

What is PhpStorm? Professional IDE for PHP and Web Developers. PhpStorm is a PHP IDE which keeps up with latest PHP & web languages trends, integrates a variety of modern tools, and brings even more extensibility with support for major PHP frameworks.

DataGrip and PhpStorm are primarily classified as "Database" and "Integrated Development Environment" tools respectively.

Some of the features offered by DataGrip are:

  • Intelligent query console
  • Efficient schema navigation
  • Explain plan

On the other hand, PhpStorm provides the following key features:

  • Smart PHP Code Editor
  • Code Quality Analysis
  • Debugging and Testing

According to the StackShare community, PhpStorm has a broader approval, being mentioned in 647 company stacks & 503 developers stacks; compared to DataGrip, which is listed in 19 company stacks and 15 developer stacks.

Advice on DataGrip and PhpStorm
Johnny Bell

When I switched to Visual Studio Code 12 months ago from PhpStorm I was in love, it was great. However after using VS Code for a year, I see myself switching back and forth between WebStorm and VS Code. The VS Code plugins are great however I notice Prettier, auto importing of components and linking to the definitions often break, and I have to restart VS Code multiple times a week and sometimes a day.

We use Ruby here so I do like that Visual Studio Code highlights that for me out of the box, with WebStorm I'd need to probably also install RubyMine and have 2 IDE's going at the same time.

Should I stick with Visual Studio Code, or switch to something else? #help

See more
Replies (15)
Erik Ostrom
Recommends
RubyMine

If you're working with both Ruby and JavaScript, buy RubyMine and shut down the other two. It's much better for Ruby than Visual Studio Code is. It can also do everything WebStorm does, if you install the plugins you need from JetBrains, and they all work together nicely.

See more
Marc Swikull
Recommends
RubyMine

If you install RubyMine, you shouldn't need WebStorm, as all the functionality of WebStorm appears to be included in RubyMine. (See here: https://softwareengineering.stackexchange.com/a/132950).

I've used PhpStorm for several years and have never needed to open (or even download) WebStorm for anything front-end or JavaScript related.

See more
Russel Werner
Lead Engineer at StackShare · | 6 upvotes · 122.9K views
Recommends
WebStorm
at

I work at the same company as you and I use WebStorm for 99% of my tasks. I also have RubyMine installed and use that when I have to tweak some backend code. I tried using RubyMine for JavaScript but was unhappy with how it felt and I believe that WebStorm is faster because it has less plugins and language extensions running. Summary: Buy and use WebStorm for primary development and keep VS Code around for when you have to touch Ruby.

See more
Danny Battison
Recommends
PhpStorm

JetBrains all the way - my entire team uses PhpStorm and none of us would even consider switching.

The availability of IDEs for other languages along with consistency in environment and keyboard shortcuts is also a godsend, which is the reason I'd also choose Rider over Visual Studio (but also VS for Mac is trash, but I digress...)

See more

I've never had much issue running multiple IDEs and generally pick them based on the languages they best support. For front end work where I mainly use TypeScript, I stick heavily with Visual Studio Code. However, for backend work which we do primarily in Python, PyCharm is my go-to editor. The one thing that I do however is I do remap keyboard shortcuts so I get consistent keyboard ability even when I switch IDEs.

See more
Recommends
PhpStorm

So here is the deal man, bottom line you want to write code. All of these tools are built in a mouse-driven world, they are designed not for engineers, but office monkeys. If you want a real workflow that gives you ultimate performance, customization and speed you need to use a modal editor, I suggest NeoVim. Start using it 20% of the time on single file edits, watch youtube videos about it and teach yourself vim gestures. It will infuriate you for 6 weeks, make you cry for another 2 months. But as you use it more, as long as your usage goes over 40% of the time, in 6 months you will understand why most of the world's too engineers use it. Settling on lesser editors out of laziness is exactly the attitude that results in shitty the engineering. Yeah it's hard. You're smart. You do hard things. Once it isn't hard anymore you will blow yourself away at how much more efficiently you edit files.

Also vim keybindings in a mouse driven editor does not cut it. Managing files, buffers and workflow is half of the value of vim/neovim. It is OK if you have to use an IDE (currently I only use an IDE for java development, so I have little choice)

So use VSCode while you teach yourself vim.

See more

Visual Studio Code is a text editor. And this is best option in my opinion. For Ruby, I cannot say how VS Code is good. If you wanna choose IDE, RubyMine should fit your needs. Because IDEs are more compatible with major needs. But text editors are just text editor. You can do same things with also text editors. I recommend to try both VS Code and RubyMine. And you will be able to find which fits better for your needs

See more

If I have to choose one I would go with VS Code; it’s become pretty mature and keeps getting better. If those plugins are creating problems for you then just uninstall them, find an alternative, or make a PR to fix. But at the end of the day these are IDE’s and they are meant to save you time. I would go with whatever helps you develop code faster. If restarting VS code slows you down then make a switch, that personally would annoying the crap out of me. Else maybe it’s a quick restart, not the end of the word, hopefully someone will fix at some point.

See more
Lungu Alexandru-Mihai
Recommends
Vim

Well you can try for a while MacVim because it is already configured with tons of plugins. My favourite text editors are Sublime Text and TextMate which are lightweight and speedy. My feeling is that JetBrains IDEs are making you brainless.

See more
Kyle Schoonover
Senior Software Engineer at Nordstrom · | 2 upvotes · 88.6K views

I'm personally a Visual Studio Code fan. I've used it for both Go and Java. It really depends on the quality and support of the plugins. Typically VS Code doesn't crash as much as a bad plugin causes an unforeseen error. Make sure you stay up to date and look at alternative plugins.

See more

If you find something that works and are comfortable with it, stay with it. Changing IDE's and learning their idiosyncrasies takes valuable time away from programming while learning setups and keyboard short cuts. I personally use VS Code for cost and decent multiple language support. I've had issues occasionally with it locking up, but it is under heavy development and continually improving. I have also found it more intuitive for new programmers. ** Having profiles for different languages can reduce the amount of plugins running and issues they can cause.

See more
Recommends
PhpStorm

I usually have both running but do the bulk of my language work in the appropriate JetBrains flavor. One thing to watch out for in VS is that under the hood it is running the tools needed for whatever language you are working with. This is where tools like JetBrains shine. While I am sure you can tune the heck out of what you use in VS, the provides context and clarity...

See more
Recommends
at

Visiual Studio is the best

See more

I've used all of these IDEs and VSC is probably the best overall. WebStorm, PHPStorm, and other Jetbrains IDEs are great for projects that only use the language that the IDE was designed for. But, Visual Studio Code on the other hand has so many extensions and works with so many languages.

See more

Are you using the prettier-vscode VSCode extension or prettier via prettier-eslint? The prettier-vscode extension recommends you...

Use prettier-eslint instead of prettier. Other settings will only be fallbacks in case they could not be inferred from ESLint rules.

See more
Get Advice from developers at your company using Private StackShare. Sign up for Private StackShare.
Learn More
Pros of DataGrip
Pros of PhpStorm
  • 4
    Works on Linux, Windows and MacOS
  • 2
    Wide range of DBMS support
  • 1
    Code completion
  • 1
    Generate ERD
  • 1
    Quick-fixes using keyboard shortcuts
  • 1
    Code analysis
  • 1
    Database introspection on 21 different dbms
  • 1
    Export data using a variety of formats using open api
  • 1
    Import data
  • 1
    Diff viewer
  • 286
    Best ide for php
  • 233
    Easy to use
  • 219
    Functionality
  • 165
    Plugins
  • 161
    Code analysis
  • 87
    Integrated version control
  • 75
    Great php ide for mac
  • 73
    All-round php ide
  • 62
    Local history
  • 53
    Themes
  • 17
    Best PHP IDE
  • 11
    Database control
  • 10
    Easy to find anything and everything in your code
  • 9
    Best bebugging
  • 9
    Best inspection variable
  • 7
    Great frameworks integration
  • 7
    PHPUnit integration
  • 7
    Getting Better
  • 7
    UX
  • 7
    Command line integration
  • 6
    Composer integration
  • 6
    Performance
  • 6
    Coolest IDE
  • 5
    Real time code validation
  • 5
    Easy to use and github interaction
  • 5
    Neat does the job and easy
  • 5
    Best ide for advanced php and symfony
  • 4
    Best ide for php
  • 4
    TypeScript support
  • 4
    Code indexing
  • 4
    It has no match. it filled one of the biggest void
  • 4
    Fast and relevant auto-complete
  • 4
    Great refactoring support
  • 4
    Cross platform
  • 3
    Integration with Vagrant and Docker
  • 3
    Debugger for Javascript
  • 3
    Good
  • 3
    Very good
  • 2
    Debugging in the Just-In-Time Mode
  • 2
    Perfect locahost / host sync
  • 2
    Awesome debugging features

Sign up to add or upvote prosMake informed product decisions

Cons of DataGrip
Cons of PhpStorm
    Be the first to leave a con
    • 14
      Uses a lot of memory
    • 10
      Does not open large files
    • 9
      Slow
    • 8
      Uses Java machine
    • 3
      No way to change syntax highlight for files without ext
    • 2
      No save prompt or asterisk on file change

    Sign up to add or upvote consMake informed product decisions

    What is DataGrip?

    A cross-platform IDE that is aimed at DBAs and developers working with SQL databases.

    What is PhpStorm?

    PhpStorm is a PHP IDE which keeps up with latest PHP & web languages trends, integrates a variety of modern tools, and brings even more extensibility with support for major PHP frameworks.

    Need advice about which tool to choose?Ask the StackShare community!

    What companies use DataGrip?
    What companies use PhpStorm?
    See which teams inside your own company are using DataGrip or PhpStorm.
    Sign up for Private StackShareLearn More

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with DataGrip?
    What tools integrate with PhpStorm?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    What are some alternatives to DataGrip and PhpStorm?
    Navicat
    Powerful database management & design tool for Win, Mac & Linux. With intuitive GUI, user manages MySQL, MariaDB, SQL Server, SQLite, Oracle & PostgreSQL DB easily.
    MySQL WorkBench
    It enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort.
    DBeaver
    It is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc.
    PyCharm
    PyCharm’s smart code editor provides first-class support for Python, JavaScript, CoffeeScript, TypeScript, CSS, popular template languages and more. Take advantage of language-aware code completion, error detection, and on-the-fly code fixes!
    TablePlus
    TablePlus is a native app which helps you easily edit database data and structure. TablePlus includes many security features to protect your database, including native libssh and TLS to encrypt your connection.
    See all alternatives