Goose
6.4#8 in database migration toolsFree planFree planAPILinuxmacOSSelf-hosted
VisitGoose vs pgroll
What both publish
| Fact | Goose | pgroll |
|---|---|---|
| License | The GitHub repository states that Goose is licensed under the MIT License. | The repository is licensed under Apache License 2.0. |
| Platforms | The installation guide documents prebuilt or source installation for macOS, Linux, and Windows. | Prebuilt binaries are available for Linux, macOS, and Windows; installation is also documented through Homebrew and from source. |
| Purpose | Goose is a database migration tool for managing database schemas with incremental SQL changes and/or Go functions. | pgroll is an open-source command-line tool for safe, reversible PostgreSQL schema migrations that keep multiple schema versions available simultaneously. |
Goose plans
- GooseFree
pgroll plans
- Open sourceFree
- Open-sourceFree
Pick Goose if…
Goose may suit developers who want to manage database schema changes from a command-line tool or integrate migration handling through a library. Teams using the provider need to arrange safe concurrent migrations themselves unless they configure a session locker.
Pick pgroll if…
pgroll suits developers managing PostgreSQL schema changes who want old and new versions to coexist during application rollout. Teams using PostgreSQL 14 with row-level security should weigh its documented limitation.