Database Migration

关于

Designed for developers building production-grade xOS apps, this skill provides a rigorous framework for evolving database schemas without risking user data. It emphasizes the core principle of immutable migrations and guides users through additive-only patterns, idempotency checks, and transactional updates. Whether you are dealing with 'cannot add NOT NULL column' errors or complex schema refactoring, it offers clear guidance on safe migration workflows, including specific implementation patterns for GRDB and SwiftData, ensuring that every update preserves the integrity of existing user information.

主要功能

• Rigorous testing checklists for both fresh installs and upgrade paths
• Additive-only migration patterns to prevent accidental data loss
• Proactive identification of high-risk anti-patterns like column deletion
• Idempotency checks to ensure safe execution across multiple runs
• 61 GitHub stars
• Framework-specific guidance for SQLite, GRDB, and SwiftData

使用场景

• Adding new columns or relationships to a live production database
• Executing complex database refactors across multiple versioned migrations
• Resolving 'NOT NULL' or foreign key constraint errors during schema updates