Guide safe SQLite database migrations in Rails 8 applications.
npx skills add https://github.com/doncan-orozco/papyro --skill sqlite-doncan-orozco
Please help me install this Agent Skill. Skill: sqlite Source: https://github.com/doncan-orozco/papyro/tree/main/.ai/skills/sqlite Command: npx skills add https://github.com/doncan-orozco/papyro --skill sqlite-doncan-orozco
This Skill provides essential patterns and best practices for managing SQLite database migrations in Rails 8 applications, ensuring data integrity and preventing downtime during schema changes.
strong_migrations and database_consistency for auditing and enforcing database health.status column to your articles table, this Skill guides you through the multi-deploy strategy to safely add the column, backfill data, and eventually remove it without interrupting service.Use the sqlite skill to add a new column named 'published_at' to the 'articles' table with a datetime type.
High-intent search queries and answers about installing and using this skill.
To safely add a column in SQLite without downtime, use a multi-deploy strategy to add the column, backfill data, and then enforce constraints. This Rails migration pattern prevents application errors by separating schema changes from data updates.
The best way to audit SQLite database integrity is by using the database_consistency gem. It checks your Rails application models against your SQLite schema to detect missing indexes, constraints, and potential data integrity issues.
Yes, strong_migrations works with SQLite in Rails 8 to enforce database health. It automatically blocks risky migration operations, guiding you to use safer patterns for column modifications, constraint management, and index creation.
Handle SQLite data backfilling by deploying the schema change first, then updating records in batches. This Rails migration strategy ensures data integrity by avoiding locking the database during long-running data updates.
Use multi-deploy strategies for SQLite schema changes when adding constraints or modifying columns in production. This approach minimizes risk by separating schema additions, data backfilling, and constraint enforcement across distinct deployments.
curiositechManage Drizzle ORM schema definitions and SQLite database migrations efficiently.
mbadozPlan zero-downtime database migrations across PostgreSQL, MySQL, and ORMs.
maxritterEnforces ORM standards for models across Django, SQLAlchemy, Prisma, and ActiveRecord.
agnaldo4jManage PostgreSQL schema lifecycles with versioned Flyway migrations and HikariCP pooling.