database-orm

Preventing N+1 query problems with an ORM requires optimizing relation management and query patterns. This skill provides guidance on leveraging Prisma and Drizzle ORM features to eagerly load relations and structure queries that avoid performance bottlenecks.

The expand-contract pattern is a zero-downtime migration strategy that separates schema changes into backward-compatible phases. This skill explains how to safely apply expand-contract techniques, manage rollbacks, and backfill data without interrupting application availability.

Managing database transactions and prepared statements in Drizzle involves using its specific query builder APIs for execution control. This skill covers how to handle transactions effectively and leverage prepared statements to optimize performance within the Drizzle ORM.

Choosing between Prisma and Drizzle for schema definition depends on your preferred abstraction level for relation management. This skill offers best practices for both ORMs, detailing their distinct patterns for schema design, relation handling, and query optimization.

Safely backfilling data during a Prisma refactoring requires combining zero-downtime migration strategies with robust testing. This skill addresses how to execute safe data backfilling, manage schema transitions, and prevent query performance bottlenecks.

Database migration testing and safe rollbacks are needed whenever you apply schema changes to production environments. This skill provides techniques for robust migration testing, zero-downtime deployments, and executing safe rollbacks to maintain data integrity.