Flyway聽vs聽Knex.js聽vs聽Massive

Get Advice Icon

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

Flyway
Flyway

134
144
+ 1
26
Knex.js
Knex.js

88
110
+ 1
20
Massive
Massive

0
3
+ 1
0

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.

What is Knex.js?

Knex.js is a "batteries included" SQL query builder for Postgres, MySQL, MariaDB, SQLite3, and Oracle designed to be flexible, portable, and fun to use. It features both traditional node style callbacks as well as a promise interface for cleaner async flow control, a stream interface, full featured query and schema builders, transaction support (with savepoints), connection pooling and standardized responses between different query clients and dialects.

What is Massive?

Massive's goal is to help you get data from your database. This is not an ORM, it's a bit more than a query tool - our goal is to do just enough, then get out of your way. Massive embraces SQL completely, and helps you out when you don't feel like writing another mundane select * from statement.
Get Advice Icon

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

Why do developers choose Flyway?
Why do developers choose Knex.js?
Why do developers choose Massive?
    Be the first to leave a pro

    Sign up to add, upvote and see more prosMake informed product decisions

      Be the first to leave a con
        Be the first to leave a con
        What companies use Flyway?
        What companies use Knex.js?
        What companies use Massive?
          No companies found

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

          What tools integrate with Flyway?
          What tools integrate with Knex.js?
          What tools integrate with Massive?

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

          What are some alternatives to Flyway, Knex.js, and Massive?
          Liquibase
          Liquibase is a leading open-source tool for database schema change management. Liquibase helps teams track, version, and deploy database schema and logic changes so they can automate their database code process with their app code process.
          Slick
          It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred.
          Sequel Pro
          Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases.
          PostGIS
          PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL.
          Spring Data
          It makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. This is an umbrella project which contains many subprojects that are specific to a given database.
          See all alternatives
          Decisions about Flyway, Knex.js, and Massive
          Miguel Suarez
          Miguel Suarez
          Lead Developer | 8 upvotes 167.2K views
          atJobsrepublicJobsrepublic
          Flyway
          Flyway
          Liquibase
          Liquibase
          PostgreSQL
          PostgreSQL
          #Migration
          #Backwards-compatible

          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
          Interest over time
          Reviews of Flyway, Knex.js, and Massive
          Review ofFlywayFlyway

          it works with complex SQL script and it is very high customizable.

          How developers use Flyway, Knex.js, and Massive
          Avatar of Flux Work
          Flux Work uses Knex.jsKnex.js

          Not an ORM but a query builder. So developers are encouraged or sometimes forced to think about SQL and database layer, which is a good thing.

          Avatar of Zube
          Zube uses Knex.jsKnex.js

          Converts JS to SQL. Pretty awesome!

          How much does Flyway cost?
          How much does Knex.js cost?
          How much does Massive cost?
          Pricing unavailable
          Pricing unavailable
          News about Flyway
          More news
          News about Knex.js
          More news
          News about Massive
          More news