What does sqlalchemy/alembic do?

Alembic 是一个用于 SQLAlchemy 的数据库模式版本控制系统和迁移工具。它通过版本化脚本管理数据库结构的增量更新，支持升级和降级，从而保持数据库与代码同步。

What are the main features of sqlalchemy/alembic?

The main features of sqlalchemy/alembic are: Database Schema Migrations, Database Schema Version Control, Transactional DDL Execution, Schema State Diffing, Schema Version Tracking, Migration Script Generators, SQLAlchemy Schema Migrations, Database Schema Diffing Tools.

What are some open-source alternatives to sqlalchemy/alembic?

Open-source alternatives to sqlalchemy/alembic include: doctrine/doctrinemigrationsbundle — DoctrineMigrationsBundle is a database schema migration tool and a Symfony framework integration for managing and… doctrine/migrations — This project is a database version control system and schema evolution manager designed to track and apply incremental… ariga/atlas — Atlas is a SQL database schema management tool and database infrastructure as code framework. It provides a… xataio/pgroll — pgroll is a PostgreSQL migration framework designed for zero-downtime schema changes. It applies non-blocking DDL… cakephp/phinx — Phinx is a PHP database migration and versioning tool used to track and deploy structural changes to database schemas… doctrine/persistence — This project is an object persistence library and data mapper abstraction layer. It provides a set of shared…

Alembic - 管理 SQLAlchemy 数据库迁移

Database Schema Migrations - Provides a comprehensive system for the automated versioning and updating of database structures to maintain consistency across environments.
Database Schema Version Control - Provides a complete system for tracking and managing incremental updates to database schemas.
Transactional DDL Execution - Wraps schema changes in database transactions to ensure atomic updates and prevent partial corruption.
Schema State Diffing - Provides algorithmic calculation of changes needed to transform a live database schema to match a model definition.
Schema Version Tracking - Maintains a dedicated database table to record the current version ID and track applied migrations.
Migration Script Generators - Automatically produces candidate migration directives by comparing data models to live database states.
SQLAlchemy Schema Migrations - Specifically designed to handle schema migrations for databases defined by SQLAlchemy ORM models.
Database Schema Diffing Tools - Includes a utility to identify discrepancies between a live database schema and model metadata.
Migration State Tracking - Uses a dedicated database table to track which schema versions have been applied.
Non-Linear Migration Versioning - Implements a graph-based version tracking system that supports branching and merging of database schema updates.
Transactional Migration Managers - Executes schema migrations within atomic transactions to maintain data integrity during updates.
Database Transactions - Ensures database consistency by executing schema updates within atomic transactions.
SQL String Compilations - Translates high-level Python migration directives into raw SQL strings for auditing and manual execution.
Migration Directive Rendering - Converts high-level Python migration directives into raw SQL strings for auditing.
Migration Script Templates - Generates Python scripts from templates to define explicit database upgrade and downgrade paths.
Directed Acyclic Graph Models - Implements migration tracking as a graph to support complex branching and merging of schema versions.
Database Clients - Database migration tool for SQLAlchemy.

Alembic 的开源替代方案

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

doctrine/doctrinemigrationsbundle
doctrine/DoctrineMigrationsBundle
4,311在 GitHub 上查看
DoctrineMigrationsBundle is a database schema migration tool and a Symfony framework integration for managing and versioning database changes using the Doctrine Migrations library. It functions as a bridge connecting the Symfony service container to Doctrine database migration workflows. The project provides a system for tracking and applying incremental changes to a database schema, ensuring consistent states across development, staging, and production environments. It automates schema updates to maintain data structures without manual SQL execution. The tool integrates with the framework t
PHP
在 GitHub 上查看4,311
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
ariga/atlas
ariga/atlas
8,096在 GitHub 上查看
Atlas is a SQL database schema management tool and database infrastructure as code framework. It provides a declarative database migration engine that computes the difference between a desired schema state and the current database state to automatically generate the necessary SQL for transitions. The project distinguishes itself through a comprehensive suite of analysis and visualization tools, including a database schema linter that detects destructive changes and data loss risks. It also features a SQL schema visualization tool capable of generating entity-relationship diagrams from extract
Go
在 GitHub 上查看8,096
cakephp/phinx
cakephp/phinx
4,537在 GitHub 上查看
Phinx is a PHP database migration and versioning tool used to track and deploy structural changes to database schemas across different environments. It functions as a version control system for databases, allowing structural modifications to be defined and managed through PHP code. The tool provides mechanisms for database schema versioning and rollback, enabling users to undo previously applied migrations and restore a database to a specific previous state. Additionally, it includes a database seeder for populating tables with initial baseline records or dummy data. The system operates as a
PHP
在 GitHub 上查看4,537