migrationpilot.hashnode.devSquawk vs MigrationPilot: PostgreSQL Migration Linters ComparedSquawk and MigrationPilot are both open-source PostgreSQL migration linters. Both analyze SQL files for dangerous operations and both integrate with CI. But they differ significantly in approach, rule depth, and what information they give you. This c...1d ago·7 min read
migrationpilot.hashnode.devAtlas Paywalled Their Migration Linter — Here Are Your Free AlternativesIn October 2025, Atlas moved atlas migrate lint out of their free Starter plan. If you relied on Atlas for catching dangerous PostgreSQL migrations in CI, you now need a paid plan or a new tool. This guide covers what changed, what's still available ...1d ago·8 min read
migrationpilot.hashnode.devFlyway vs Liquibase for PostgreSQL: An Honest ComparisonFlyway and Liquibase are the two most widely used database migration tools in the Java ecosystem. Both support PostgreSQL. Both are mature. And both have significant differences in philosophy, syntax, and capabilities. This guide compares them honest...1d ago·6 min read
migrationpilot.hashnode.devHow to Add Database Migration Checks to Your CI/CD PipelineCode review catches logic bugs, linting catches style issues, and type checking catches type errors. But what catches dangerous database migrations? Most teams ship migration SQL without any automated safety checks. Here is how to fix that. Why CI Ch...1d ago·6 min read
migrationpilot.hashnode.devWhich ALTER TABLE Operations Lock Your PostgreSQL Table?ALTER TABLE is not a single operation. PostgreSQL has dozens of ALTER TABLE sub-commands, and they acquire different lock levels. Some are instant and harmless. Others lock your entire table and block all traffic. This is the complete reference. ACCE...1d ago·5 min read