Need advice about which tool to choose?Ask the StackShare community!
Flyway vs pgweb: 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; pgweb: Web-based PostgreSQL database browser written in Go. This is a web-based browser for PostgreSQL database server. Its written in Go and works on Mac OSX, Linux and Windows machines. Main idea behind using Go for the backend is to utilize language's ability for cross-compile source code for multiple platforms. This project is an attempt to create a very simple and portable application to work with PostgreSQL databases.
Flyway and pgweb can be primarily classified as "Database" tools.
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, pgweb provides the following key features:
- Connect to local or remote server
- Browse tables and table rows
- Get table details: structure, size, indices, row count
Flyway and pgweb are both open source tools. pgweb with 5.94K GitHub stars and 419 forks on GitHub appears to be more popular than Flyway with 4.2K GitHub stars and 915 GitHub forks.
Pros of Flyway
- Superb tool, easy to configure and use13
- Very easy to config, great support on plain sql scripts9
- Is fantastic and easy to install even with complex DB6
- Simple and intuitive4
- Easy tool to implement incremental migration1
Pros of pgweb
Sign up to add or upvote prosMake informed product decisions
Cons of Flyway
- "Undo Migrations" requires pro version, very expensive3