Alternatives to Sqitch logo

Alternatives to Sqitch

Flyway, Liquibase, Slick, Sequel Pro, and PostGIS are the most popular alternatives and competitors to Sqitch.
3
20
+ 1
0

What is Sqitch and what are its top alternatives?

It is a standalone change management system with no opinions about your database engine, application framework, or development environment. Native scripting. Changes are implemented as scripts native to your selected database engine.
Sqitch is a tool in the Database Tools category of a tech stack.

Sqitch alternatives & related posts

related Flyway posts

Miguel Suarez
Miguel Suarez
Lead Developer · | 9 upvotes · 281.1K views

Flyway vs Liquibase #Migration #Backwards-compatible

We were looking for a tool to help us integrating the migration scripts as part of our Deployment. At first sight both tools look very alike, are well integrated with Spring, have a fairly frequent development activity and short release cycles.

Liquibase puts a lot of emphasis on independence with the DB, allowing you to create the scripts on formats like JSON and YML, abstracting away from SQL, which it's also supported. Since we only work with one DB type across services we wouldn't take much advantage of this feature.

Flyway on the other hand has the advantage on being actively working on the integration with PostgreSQL 11, for it's upcoming version 6. Provides a more extensive set of properties that allow us to define what's allowed on what's not on each different environment.

Instead of looking for a tool that will allow us to rollback our DB changes automatically, we decided to implement backwards-compatible DB changes, for example adding a new column instead of renaming an existing one, postponing the deletion of the deprecated column until the release has been successfully installed.

See more
Liquibase logo

Liquibase

157
280
37
157
280
+ 1
37
Source control for your database
Liquibase logo
Liquibase
VS
Sqitch logo
Sqitch

related Liquibase posts

Miguel Suarez
Miguel Suarez
Lead Developer · | 9 upvotes · 281.1K views

Flyway vs Liquibase #Migration #Backwards-compatible

We were looking for a tool to help us integrating the migration scripts as part of our Deployment. At first sight both tools look very alike, are well integrated with Spring, have a fairly frequent development activity and short release cycles.

Liquibase puts a lot of emphasis on independence with the DB, allowing you to create the scripts on formats like JSON and YML, abstracting away from SQL, which it's also supported. Since we only work with one DB type across services we wouldn't take much advantage of this feature.

Flyway on the other hand has the advantage on being actively working on the integration with PostgreSQL 11, for it's upcoming version 6. Provides a more extensive set of properties that allow us to define what's allowed on what's not on each different environment.

Instead of looking for a tool that will allow us to rollback our DB changes automatically, we decided to implement backwards-compatible DB changes, for example adding a new column instead of renaming an existing one, postponing the deletion of the deprecated column until the release has been successfully installed.

See more
Slick logo

Slick

8.1K
220
0
8.1K
220
+ 1
0
Database query and access library for Scala
    Be the first to leave a pro
    Slick logo
    Slick
    VS
    Sqitch logo
    Sqitch
    Sequel Pro logo

    Sequel Pro

    258
    201
    65
    258
    201
    + 1
    65
    MySQL database management for Mac OS X
    Sequel Pro logo
    Sequel Pro
    VS
    Sqitch logo
    Sqitch
    PostGIS logo

    PostGIS

    230
    214
    29
    230
    214
    + 1
    29
    Open source spatial database
    PostGIS logo
    PostGIS
    VS
    Sqitch logo
    Sqitch
    Spring Data logo

    Spring Data

    220
    163
    0
    220
    163
    + 1
    0
    Provides a consistent approach to data access – relational, non-relational, map-reduce, and beyond
      Be the first to leave a pro
      Spring Data logo
      Spring Data
      VS
      Sqitch logo
      Sqitch
      Microsoft SQL Server Management Studio logo

      Microsoft SQL Server Management Studio

      193
      136
      0
      193
      136
      + 1
      0
      An integrated environment for managing any SQL infrastructure
        Be the first to leave a pro
        Microsoft SQL Server Management Studio logo
        Microsoft SQL Server Management Studio
        VS
        Sqitch logo
        Sqitch
        DataGrip logo

        DataGrip

        189
        161
        0
        189
        161
        + 1
        0
        A database IDE for professional SQL developers
          Be the first to leave a pro
          DataGrip logo
          DataGrip
          VS
          Sqitch logo
          Sqitch