A mental model for Prisma Migrate | Prisma Docs
This guide provides a conceptual overview of database migrations using Prisma Migrate when working with relational databases. It covers: what database migrations are, their value, and what Prisma Migrate is and how you can evolve your database schema with Prisma Migrate in different environments. If you are working with MongoDB, use prisma db push to evolve your schema. Database migrations are a controlled set of changes that modify and evolve the structure of your database schema. Migrations help you transition your database schema from one state to another. For example, within a migration you can create or remove tables and columns, split fields in a table, or add types and constraints to your database. This section describes general schema migration patterns for evolving database schemas. The two main schema migration patterns are: The migration files (SQL) should ideally be stored together with your application code. They should also be tracked in version control and shared with th
Understanding Migrations Copy Markdown Open A mental model guide for working with Prisma Migrate in your project What are database migrations? Database migrations are a controlled set of changes that modify and evolve the structure of your database schema. Migrations help you transition your database schema from one state to another. For example, within a migration you can create or remove tables and columns, split fields in a table, or add types and constraints to your database. Patterns for evolving database schemas For migrations, there are two main types of migrations that can be made: Mod
related reading
- What is Prisma ORM? (Overview) | Prisma Documentationprisma.io
- Project Cambria: Translate your data with lensesinkandswitch.com
- Evolutionary Database Designmartinfowler.com
- Database Migrationsvadimkravcenko.com
- How Does a Database Work?cstack.github.io
- The Beginner's Guide to Databasestechnically.substack.com
- Ingest data from self-hosted PostgreSQL | Materialize Documentationmaterialize.com
- Conceptual vs Logical vs Physical Data Models: Key Differencesthoughtspot.com
- About dbt run command | dbt Developer Hubdocs.getdbt.com
- The startup's Postgres survival guidehatchet.run
- Incremental Database Computationsfeldera.com
- Exploring versions of the Postgres logical replication protocolblog.peerdb.io