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

DataGrip

469
532
+ 1
16
Flyway

252
495
+ 1
33
Add tool

DataGrip vs Flyway: What are the differences?

DataGrip: A database IDE for professional SQL developers. A cross-platform IDE that is aimed at DBAs and developers working with SQL databases; Flyway: Database Migrations Made Easy. Easy to setup, simple to master. Flyway lets you regain control of your database migrations with pleasure and plain sql. Solves only one problem and solves it well. Flyway migrates your database, so you don't have to worry about it anymore.

DataGrip and Flyway belong to "Database Tools" category of the tech stack.

Some of the features offered by DataGrip are:

  • Intelligent query console
  • Efficient schema navigation
  • Explain plan

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

  • Supported databases: Oracle, SQL Server, SQL Azure, DB2, DB2 z/OS, MySQL, MariaDB, Google Cloud SQL, PostgreSQL, Redshift, Vertica, H2, Hsql, Derby, SQLite
  • Supported build tools: Maven, Gradle, Ant and SBT
  • Works on: Windows, Mac OSX, Linux, Java and Android

Flyway is an open source tool with 4.2K GitHub stars and 915 GitHub forks. Here's a link to Flyway's open source repository on GitHub.

JustWatch, Red Panda Platform, and Picnic Technologies are some of the popular companies that use Flyway, whereas DataGrip is used by Como, Betabrand, and SupplyAI. Flyway has a broader approval, being mentioned in 15 company stacks & 19 developers stacks; compared to DataGrip, which is listed in 19 company stacks and 15 developer stacks.

Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of DataGrip
Pros of Flyway
  • 4
    Works on Linux, Windows and MacOS
  • 2
    Code analysis
  • 2
    Diff viewer
  • 2
    Wide range of DBMS support
  • 1
    Generate ERD
  • 1
    Quick-fixes using keyboard shortcuts
  • 1
    Database introspection on 21 different dbms
  • 1
    Export data using a variety of formats using open api
  • 1
    Import data
  • 1
    Code completion
  • 13
    Superb tool, easy to configure and use
  • 9
    Very easy to config, great support on plain sql scripts
  • 6
    Is fantastic and easy to install even with complex DB
  • 4
    Simple and intuitive
  • 1
    Easy tool to implement incremental migration

Sign up to add or upvote prosMake informed product decisions

Cons of DataGrip
Cons of Flyway
    Be the first to leave a con
    • 3
      "Undo Migrations" requires pro version, very expensive

    Sign up to add or upvote consMake informed product decisions

    - No public GitHub repository available -

    What is DataGrip?

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

    What is Flyway?

    It lets you regain control of your database migrations with pleasure and plain sql. Solves only one problem and solves it well. It migrates your database, so you don't have to worry about it anymore.

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

    Jobs that mention DataGrip and Flyway as a desired skillset
    CBRE
    Netherlands Noord-Holland Amsterdam
    CBRE
    United Kingdom of Great Britain and Northern Ireland England London
    CBRE
    Netherlands Noord-Holland Amsterdam
    CBRE
    Netherlands Noord-Holland Amsterdam
    CBRE
    United States of America Virginia Sandston
    CBRE
    United States of America Virginia Sandston
    CBRE
    Netherlands Noord-Holland Amsterdam
    CBRE
    United Kingdom of Great Britain and Northern Ireland England Croydon
    What companies use DataGrip?
    What companies use Flyway?
    See which teams inside your own company are using DataGrip or Flyway.
    Sign up for StackShare EnterpriseLearn More

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

    What tools integrate with DataGrip?
    What tools integrate with Flyway?

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

    What are some alternatives to DataGrip and Flyway?
    Navicat
    Powerful database management & design tool for Win, Mac & Linux. With intuitive GUI, user manages MySQL, MariaDB, SQL Server, SQLite, Oracle & PostgreSQL DB easily.
    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.
    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!
    See all alternatives