Databases Intermediate

What is Migration?

A version-controlled change to a database schema that can be applied and reversed systematically.

Database migrations track schema changes over time, similar to version control for code. Each migration defines an "up" (apply) and "down" (revert) operation, such as creating tables, adding columns, or modifying constraints.

Migrations ensure all environments (development, staging, production) have identical database schemas. They are run in sequence and tracked to prevent re-application. Tools include Flyway, Liquibase, Alembic, and framework-specific migration systems.

Learn More About This Topic

SQL for Absolute Beginners

Related reading

Redis Fundamentals

Related reading

MongoDB Fundamentals: Building Scalable NoSQL Applications with Document Databases

Related reading

Related Terms

Time-Series Database

A database optimized for storing and querying timestamped data points like metrics, sensor readings, and event logs.

An open-source, in-memory data store used as a database, cache, message broker, and queue with sub-millisecond response times.

A database that uses graph structures with nodes, edges, and properties to store and query highly connected data.

A database object that enables row-by-row processing of query results, useful for operations that cannot be done in bulk.

Connection Pool

A cache of database connections that can be reused, avoiding the overhead of creating new connections for each request.

The process of organizing database tables to reduce data redundancy and improve data integrity.

View All Databases Terms →