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

Flyway

240
481
+ 1
30
Knex.js

157
351
+ 1
47
Add tool

Flyway vs Knex.js: What are the differences?

What is 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.

What is Knex.js? SQL query builder for Postgres, MySQL, MariaDB, SQLite3, and Oracle. 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.

Flyway and Knex.js can be categorized as "Database" tools.

"Superb tool, easy to configure and use" is the top reason why over 6 developers like Flyway, while over 3 developers mention "Write once and then connect to almost any sql engine" as the leading cause for choosing Knex.js.

Flyway and Knex.js are both open source tools. It seems that Knex.js with 9.79K GitHub stars and 1.22K forks on GitHub has more adoption than Flyway with 4.16K GitHub stars and 904 GitHub forks.

According to the StackShare community, Flyway has a broader approval, being mentioned in 14 company stacks & 19 developers stacks; compared to Knex.js, which is listed in 10 company stacks and 9 developer stacks.

Get Advice from developers at your company using Private StackShare. Sign up for Private StackShare.
Learn More
Pros of Flyway
Pros of Knex.js
  • 12
    Superb tool, easy to configure and use
  • 9
    Very easy to config, great support on plain sql scripts
  • 5
    Is fantastic and easy to install even with complex DB
  • 4
    Simple and intuitive
  • 10
    Write once and then connect to almost any sql engine
  • 9
    Faster
  • 8
    Nice api, Migrations/Seeds
  • 7
    Flexibility in what engine you choose
  • 7
    Free
  • 5
    Multi support and easy to use
  • 1
    Simple query API

Sign up to add or upvote prosMake informed product decisions

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

    Sign up to add or upvote consMake informed product decisions

    - No public GitHub repository available -

    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.

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

    Jobs that mention Flyway and Knex.js as a desired skillset
    Pinterest
    San Francisco, CA, US; Palo Alto, CA, US
    Pinterest
    San Francisco, CA, US; Palo Alto, CA, US
    Pinterest
    San Francisco, CA, US; Palo Alto, CA, US
    CBRE
    Narva, Ida-Virumaa, Estonia
    What companies use Flyway?
    What companies use Knex.js?
    See which teams inside your own company are using Flyway or Knex.js.
    Sign up for Private StackShareLearn More

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

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

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

    What are some alternatives to Flyway and Knex.js?
    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.
    Hibernate
    Hibernate is a suite of open source projects around domain models. The flagship project is Hibernate ORM, the Object Relational Mapper.
    Switch
    Ring your mobile phone, computer, and desk phone at the same time. Answer calls and switch seamlessly between devices. Use your personal device with a business phone number so you're always reachable.
    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.
    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