Jjakeinbasecut.hashnode.dev·Apr 16 · 14 min readDatabase Subsetting for PostgreSQL: A Practical Guide (2026)Every team that has tried to copy production data into a dev environment has hit the same wall: production is too big, full of PII, and growing. The fix is not a bigger laptop or a faster pg_dump. It 00
Jjakeinbasecut.hashnode.dev·Apr 9 · 9 min readHow to Set Up a PostgreSQL Test Database in GitHub Actions (Without pg_dump)This post was originally published on basecut.dev. The standard GitHub Actions job for PostgreSQL tests looks something like this: - name: Set up test database run: psql "$TEST_DB_URL" -f scripts/s00
Jjakeinbasecut.hashnode.dev·Apr 7 · 10 min readHow to Set Up a Staging Database from Production PostgreSQL (2026 Guide)Setting up a PostgreSQL staging database that actually reflects production is one of those tasks that sounds simple and turns into a day of cleanup. The obvious approach — pg_dump production to stagin00
Jjakeinbasecut.hashnode.dev·Mar 26 · 8 min readHow to Replace Seed Scripts with Production SnapshotsSeed scripts are technical debt that nobody tracks. They start as a convenience — a few INSERT statements so the app boots locally — and they end up as a 400-line file that touches 30 tables, breaks o00
Jjakeinbasecut.hashnode.dev·Mar 24 · 10 min readHow to Anonymize PII in PostgreSQL for DevelopmentAsk any developer whether their local database has real customer data in it, and most will say no. Ask them to check, and most will find that it does. Real emails in users. Real names in profiles. Rea00
