Database Subsetting for PostgreSQL: A Practical Guide (2026)Learn how FK-aware PostgreSQL subsetting works, preserve referential integrity, anonymize PII during extraction, and choose the right tooling in 2026.14 min read·basecut.hashnode.devApr 16
How to Set Up a PostgreSQL Test Database in GitHub Actions (Without pg_dump)The pg_dump restore step is often the slowest part of your CI pipeline — and the most likely to contain PII. Here's a faster, safer pattern using pre-9 min read·basecut.hashnode.devApr 9
How to Set Up a Staging Database from Production PostgreSQL (2026 Guide)Stop dumping your entire production PostgreSQL database to staging. Learn how to create a fast, PII-free, referentially complete staging environment using subsetting and anonymization.10 min read·basecut.hashnode.devApr 7
How to Replace Seed Scripts with Production SnapshotsSeed scripts work until they don't. Here's how to replace them with FK-aware production snapshots that stay current, stay safe, and require zero maintenance8 min read·basecut.hashnode.devMar 26
How to Anonymize PII in PostgreSQL for DevelopmentReal emails, names, and addresses sit in most dev databases. Here's how to anonymize PII in PostgreSQL during snapshot creation — not after the fact.10 min read·basecut.hashnode.devMar 24