Show HN: Diesel-guard – Lint Diesel migrations for unsafe PostgreSQL patterns
3 days ago
- #Diesel
- #PostgreSQL
- #Database Migrations
- Diesel Guard detects unsafe PostgreSQL migrations that can cause downtime or lock tables.
- Provides safe alternatives for operations like adding columns with defaults, dropping columns, and adding indexes non-concurrently.
- Works with any Diesel project without requiring configuration.
- Supports safety-assured blocks for manually verified operations.
- Commands include `diesel-guard check` to analyze migrations and `diesel-guard init` to create a configuration file.
- Common unsafe operations include adding columns with defaults, dropping columns, and changing column types.
- Multi-step approaches are recommended for safe migrations, such as adding columns without defaults first and backfilling data separately.
- Safety-assured comment blocks can bypass checks for verified operations.
- Contributions are welcome, with guidelines provided in CONTRIBUTING.md and AGENTS.md.