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

Flyway

Stacks290

Followers563

+ 1

Votes33

pgcli

Stacks5

Followers18

+ 1

Votes0

Add tool

Flyway vs pgcli: What are the differences?

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; pgcli: Postgres CLI with autocompletion and syntax highlighting. This is a postgres client that does auto-completion and syntax highlighting.

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

Some of the features offered by Flyway are:

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

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

Auto-completion as you type for SQL keywords as well as tables and columns in the database.
Syntax highlighting using Pygments.
Smart-completion (enabled by default) will suggest context-sensitive completion.

Flyway and pgcli are both open source tools. It seems that pgcli with 8.01K GitHub stars and 365 forks on GitHub has more adoption than Flyway with 4.2K GitHub stars and 915 GitHub forks.

Manage your open source components, licenses, and vulnerabilities

Learn More

Pros of Flyway

Pros of pgcli

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

Be the first to leave a pro

Sign up to add or upvote prosMake informed product decisions

Cons of Flyway

Cons of pgcli

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

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 pgcli?

This is a postgres client that does auto-completion and syntax highlighting.

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

What companies use Flyway?

What companies use pgcli?

No companies found

Manage your open source components, licenses, and vulnerabilities

Learn More

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

What tools integrate with Flyway?

What tools integrate with pgcli?

PostgreSQL

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

What are some alternatives to Flyway and pgcli?

Liquibase

Liquibase is th 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.

MySQL

The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.

PostgreSQL

PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.

See all alternatives

Flyway vs pgcli

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

Pros of Flyway

Pros of pgcli

Sign up to add or upvote prosMake informed product decisions

Cons of Flyway

Cons of pgcli

Sign up to add or upvote consMake informed product decisions

What is Flyway?

What is pgcli?

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

What companies use Flyway?

What companies use pgcli?

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

What tools integrate with Flyway?

What tools integrate with pgcli?

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

Related Comparisons

Trending Comparisons

Top Comparisons