While goose supports PostgreSQL advisory locks, other databases lack this feature, leaving them vulnerable to concurrent migration race conditions.
Proposing a table-based locking mechanism.
This would ensure safe migrations for non-PostgreSQL databases in distributed deployments where multiple instances might attempt migrations simultaneously.
While goose supports PostgreSQL advisory locks, other databases lack this feature, leaving them vulnerable to concurrent migration race conditions.
Proposing a table-based locking mechanism.
This would ensure safe migrations for non-PostgreSQL databases in distributed deployments where multiple instances might attempt migrations simultaneously.