Question 1

How does PGmigrate compare to Alembic for PostgreSQL migrations?

Accepted Answer

PGmigrate is simpler and more focused on PostgreSQL's native features, with built-in support for transactional rollbacks and callbacks, while Alembic is tightly integrated with SQLAlchemy and supports multiple databases but may require more configuration for advanced PostgreSQL DDL.

Question 2

How to set up PGmigrate in a Django project?

Accepted Answer

Install via pip with 'pip install yandex-pgmigrate', then configure it separately from Django's built-in migrations using a config file. It's best used as a standalone tool alongside Django for more control over PostgreSQL-specific schema changes.

Question 3

Can PGmigrate handle data migrations or only schema changes?

Accepted Answer

Primarily designed for schema changes, but since it supports arbitrary SQL in migration files, you can include data manipulation statements. However, its transactional features are optimized for DDL, so data migrations might require careful handling to avoid performance issues.

Question 4

What are callbacks in PGmigrate and how do they work?

Accepted Answer

Callbacks are DDL operations that run at specific steps in the migration process, like before or after applying migrations. For example, you can drop a view before a migration and recreate it afterward to ensure consistency, as described in the README's features.

Question 5

Is PGmigrate good for large-scale production databases?

Accepted Answer

Yes, it's designed for production reliability with features like online migrations for rollback safety and version gaps checks. However, direct DDL execution means you should test thoroughly to avoid locking or performance impacts on large databases.

Question 6

Does PGmigrate support version control integration?

Accepted Answer

While not directly integrated, migration files are stored as SQL or Python scripts in a directory, so they can be easily managed with Git or other version control systems, aligning well with standard development workflows.

pgmigrate

What is pgmigrate?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions