A simple tool to evolve PostgreSQL schema easily with transactional migrations and callbacks.
PGmigrate is a database migration tool specifically for PostgreSQL, enabling developers to manage and apply schema changes in a controlled and reliable manner. It solves the problem of evolving database schemas safely by supporting transactional migrations, callbacks, and online migration capabilities.
Database administrators and backend developers working with PostgreSQL who need a robust, simple tool for managing schema migrations in development and production environments.
Developers choose PGmigrate for its focus on PostgreSQL's DDL power, support for transactional and non-transactional migrations, and features like callbacks and online migrations that ensure database consistency and rollback safety.
Simple tool to evolve PostgreSQL schema easily.
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Supports online migrations in a single transaction, enabling rollback on errors to maintain database consistency, as highlighted in the README's key features.
Allows both transactional and non-transactional migrations, leveraging PostgreSQL's full DDL power for complex schema changes without limitations.
Includes version gaps check to detect missing versions, ensuring a reliable migration history and preventing deployment issues.
Supports subdirectories within the migrations folder, making it easy to organize and manage large sets of migration files.
Provides callbacks for executing DDL operations at specific migration steps, such as before or after migrations, adding flexibility to handle dependencies.
Only supports PostgreSQL, making it unsuitable for projects that use multiple database systems or plan to migrate away from PostgreSQL.
Requires a running PostgreSQL instance with superuser access for testing, which can be complex for local development or automated CI/CD pipelines compared to tools with embedded databases.
As a niche tool from Yandex, it has a smaller ecosystem and fewer third-party integrations or plugins compared to more popular options like Flyway or Alembic.