Phinx

Phinx 是一个 PHP 数据库迁移和版本控制工具，用于跟踪和部署跨不同环境的数据库模式结构变更。它作为一个数据库版本控制系统，允许通过 PHP 代码定义和管理结构修改。

该工具提供了数据库模式版本控制和回滚机制，使用户能够撤销之前应用的迁移并将数据库恢复到特定的先前状态。此外，它还包含一个数据库填充器，用于使用初始基准记录或虚拟数据填充表。

该系统作为一个独立的命令行界面运行，管理迁移的顺序执行，并通过目标数据库内的元数据表跟踪当前的模式版本。

Features

Database Schema Version Control - Provides a version control system for database schemas using reproducible PHP migration files.
Database Migrations - Tracks and deploys structural changes to database schemas using versioned PHP code.
Database Versioning - Manages the evolution of database structures to synchronize schemas across different environments.
Migration Execution - Executes database schema updates in chronological order to ensure consistent evolution.
Schema Rollbacks - Enables users to undo previously applied migrations and restore the database to a stable previous state.
Schema Version Tracking - Tracks applied migrations via a dedicated metadata table within the target database.
Change Rollback Mechanisms - Supports reverting problematic schema updates to restore a stable database state without manual SQL.
PHP-Based Definitions - Allows structural changes to be defined as portable PHP code for version control.
Database Migration Tools - Serves as a PHP-based utility for versioning and applying incremental schema changes.
Database Schema Rollback Tools - Provides a dedicated mechanism to undo migrations and restore the schema to a specific previous state.
Data Seeding Utilities - Includes a seeder to populate database tables with initial baseline or dummy records.
Database Adapters - Provides standardized interfaces to decouple migration logic from specific database engines.
Database Seeding Tools - Automates the population of fresh databases with baseline records required for application functionality.
Standalone CLI Runtimes - Operates as a standalone CLI tool to execute migrations independently of a full framework.
Command Patterns - Implements reversible command patterns using up and down methods for schema application and rollback.
Database Seeders - Provides a seeder for populating database tables with initial records for development and testing.
Database Migrations - Manages database migrations.

Star 历史

cakephpphinx

Name: cakephp/phinx
Author: cakephp

View on GitHub

4,537 星标886 分支PHPMIT8 次浏览phinx.org

Phinx

该系统作为一个独立的命令行界面运行，管理迁移的顺序执行，并通过目标数据库内的元数据表跟踪当前的模式版本。

Features

Database Schema Version Control - Provides a version control system for database schemas using reproducible PHP migration files.
Database Migrations - Tracks and deploys structural changes to database schemas using versioned PHP code.
Database Versioning - Manages the evolution of database structures to synchronize schemas across different environments.
Migration Execution - Executes database schema updates in chronological order to ensure consistent evolution.
Schema Rollbacks - Enables users to undo previously applied migrations and restore the database to a stable previous state.
Schema Version Tracking - Tracks applied migrations via a dedicated metadata table within the target database.
Change Rollback Mechanisms - Supports reverting problematic schema updates to restore a stable database state without manual SQL.
PHP-Based Definitions - Allows structural changes to be defined as portable PHP code for version control.
Database Migration Tools - Serves as a PHP-based utility for versioning and applying incremental schema changes.
Database Schema Rollback Tools - Provides a dedicated mechanism to undo migrations and restore the schema to a specific previous state.
Data Seeding Utilities - Includes a seeder to populate database tables with initial baseline or dummy records.
Database Adapters - Provides standardized interfaces to decouple migration logic from specific database engines.
Database Seeding Tools - Automates the population of fresh databases with baseline records required for application functionality.
Standalone CLI Runtimes - Operates as a standalone CLI tool to execute migrations independently of a full framework.
Command Patterns - Implements reversible command patterns using up and down methods for schema application and rollback.
Database Seeders - Provides a seeder for populating database tables with initial records for development and testing.
Database Migrations - Manages database migrations.

Phinx 的开源替代方案

相似的开源项目，按与 Phinx 的功能重合度排序。

mattes/migrate
mattes/migrate
2,282在 GitHub 上查看
This project is a database schema migration engine that provides a command-line interface and a library for managing sequential structural changes. It functions as a version control utility for database schemas, enabling the application, reversion, and synchronization of incremental updates across development and production environments. The tool distinguishes itself through a driver-based abstraction layer that supports a wide range of relational and non-relational storage systems. It maintains schema consistency by using a dedicated metadata table to track versions and prevent concurrent up
Goaws-s3cassandracrate
在 GitHub 上查看2,282
pressly/goose
pressly/goose
10,197在 GitHub 上查看
Goose is a database schema versioning system and SQL migration tool designed for Go applications. It functions as a framework for tracking and applying incremental database changes through versioned SQL scripts, ensuring consistency across different environments. The project distinguishes itself by providing a build-time capability to exclude unused database drivers to optimize binary size and a filesystem abstraction that allows migration scripts to be bundled directly into a compiled executable. It also supports out-of-order execution logic to apply missing scripts that were created after a
Godatabasedatabase-migrationsgo
在 GitHub 上查看10,197
golang-migrate/migrate
golang-migrate/migrate
18,118在 GitHub 上查看
This project is a command-line utility designed to manage database schema versioning and automate incremental schema updates. It functions as a version control system for database structures, ensuring consistency across environments by tracking applied migrations in a dedicated metadata table and executing scripts in a sequential, reliable manner. The tool distinguishes itself through a driver-based abstraction layer that supports a wide range of database engines, including various SQL and distributed cloud databases. It provides robust concurrency control through advisory locking, which prev
Goaws-s3cassandradatabase
在 GitHub 上查看18,118
doctrine/migrations
doctrine/migrations
4,770在 GitHub 上查看
This project is a database version control system and schema evolution manager designed to track and apply incremental changes to database structures. It serves as a tool for versioning SQL database migrations using both programmatic PHP classes and SQL scripts. The system is designed specifically for integration with the Doctrine Object Relational Mapper for PHP, allowing database schemas to evolve incrementally without data loss through reversible migration steps. It covers capabilities for automated database migrations, environment synchronization, and schema versioning. These features fa
PHP
在 GitHub 上查看4,770

查看 Phinx 的所有 30 个替代方案

常见问题解答

cakephp/phinx 是做什么的？

cakephp/phinx 的主要功能有哪些？

cakephp/phinx 的主要功能包括：Database Schema Version Control, Database Migrations, Database Versioning, Migration Execution, Schema Rollbacks, Schema Version Tracking, Change Rollback Mechanisms, PHP-Based Definitions。

cakephp/phinx 有哪些开源替代品？

cakephp/phinx 的开源替代品包括： mattes/migrate — This project is a database schema migration engine that provides a command-line interface and a library for managing… pressly/goose — Goose is a database schema versioning system and SQL migration tool designed for Go applications. It functions as a… golang-migrate/migrate — This project is a command-line utility designed to manage database schema versioning and automate incremental schema… doctrine/migrations — This project is a database version control system and schema evolution manager designed to track and apply incremental… liquibase/liquibase — Liquibase is a database schema change management tool and version control system designed to track, manage, and apply… db-migrate/node-db-migrate — This project is a database migration framework designed to manage and execute versioned schema changes across multiple…