Flyway
Flyway

96
3
15
Knex.js
Knex.js

63
0
20
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.

What is Flyway?

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?

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.

Want advice about which of these to choose?Ask the StackShare community!

Why do developers choose Flyway?
Why do developers choose Knex.js?
What are the cons of using Flyway?
What are the cons of using Knex.js?
    Be the first to leave a con
    What companies use Flyway?
    What companies use Knex.js?
    What are some alternatives to Flyway and Knex.js?
    Liquibase
    Developers store database changes in text-based files on their local development machines and apply them to their local databases. Changelog files can be be arbitrarily nested for better management.
    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.
    Open PostgreSQL Monitoring
    Open PostgreSQL Monitoring is a free software designed to help you manage your PostgreSQL servers.
    DataGrip
    A cross-platform IDE that is aimed at DBAs and developers working with SQL databases.
    See all alternatives
    What tools integrate with Flyway?
    What tools integrate with Knex.js?
      No integrations found
      Decisions about Flyway and Knex.js
      No stack decisions found
      Interest over time
      Reviews of Flyway and Knex.js
      Review ofFlywayFlyway

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

      How developers use Flyway and Knex.js
      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?
      Pricing unavailable
      Pricing unavailable
      News about Flyway
      More news
      News about Knex.js
      More news