Database Transaction - CI/CD Glossary Definition
A database transaction is a unit of work that either completes entirely or not at all, giving all-or-nothing consistency.
A database transaction is a unit of work that either completes entirely or has no effect, giving all-or-nothing consistency across multiple operations.
Many migration tools wrap each migration in a transaction so a failing statement leaves the schema untouched rather than half-applied.
Related guides
ACID - CI/CD Glossary DefinitionACID: ACID is a set of guarantees for reliable transactions: Atomicity, Consistency, Isolation, and Durabilit…
Deadlock (Database) - CI/CD Glossary DefinitionDeadlock (Database): A deadlock occurs when two or more transactions each hold a lock the other needs, so non…
Idempotent Migration - CI/CD Glossary DefinitionIdempotent Migration: An idempotent migration produces the same result whether it runs once or many times, ty…