---
title: "jake (@jakelazarus) | Hashnode"
description: "jake (@jakelazarus) writes on Hashnode. Read their latest articles and follow their work."
url: "https://hashnode.com/@jakelazarus"
---

@jakelazarus

# jake

@jakelazarus · Chicago, United States · Joined March 2026

### [Database Subsetting for PostgreSQL: A Practical Guide (2026)](https://basecut.hashnode.dev/postgresql-database-subsetting?utm_source=hashnode&utm_medium=feed)

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.dev](https://basecut.hashnode.dev/postgresql-database-subsetting?utm_source=hashnode&utm_medium=feed)

[Apr 16](https://hashnode.com/posts/postgresql-database-subsetting/69e0f26ffbb543874782f1ae)

### [How to Set Up a PostgreSQL Test Database in GitHub Actions (Without pg\_dump)](https://basecut.hashnode.dev/postgresql-test-database-github-actions?utm_source=hashnode&utm_medium=feed)

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.dev](https://basecut.hashnode.dev/postgresql-test-database-github-actions?utm_source=hashnode&utm_medium=feed)

[Apr 9](https://hashnode.com/posts/postgresql-test-database-github-actions/69d7b7fe9d77ddf966f89b50)

### [How to Set Up a Staging Database from Production PostgreSQL (2026 Guide)](https://basecut.hashnode.dev/how-to-set-up-a-staging-database-from-production-postgresql-2026-guide?utm_source=hashnode&utm_medium=feed)

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.dev](https://basecut.hashnode.dev/how-to-set-up-a-staging-database-from-production-postgresql-2026-guide?utm_source=hashnode&utm_medium=feed)

[Apr 7](https://hashnode.com/posts/how-to-set-up-a-staging-database-from-production-postgresql-2026-guide/69d51558f53115ad5c13ffe4)

### [How to Replace Seed Scripts with Production Snapshots](https://basecut.hashnode.dev/replace-seed-scripts-with-production-snapshots?utm_source=hashnode&utm_medium=feed)

Seed 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 maintenance

8 min read · [basecut.hashnode.dev](https://basecut.hashnode.dev/replace-seed-scripts-with-production-snapshots?utm_source=hashnode&utm_medium=feed)

[Mar 26](https://hashnode.com/posts/replace-seed-scripts-with-production-snapshots/69c54449f64fcbd070cd655c)

### [How to Anonymize PII in PostgreSQL for Development](https://basecut.hashnode.dev/how-to-anonymize-pii-in-postgresql-for-development?utm_source=hashnode&utm_medium=feed)

Real 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.dev](https://basecut.hashnode.dev/how-to-anonymize-pii-in-postgresql-for-development?utm_source=hashnode&utm_medium=feed)

[Mar 24](https://hashnode.com/posts/how-to-anonymize-pii-in-postgresql-for-development/69c2a3d9f68c03405847cdeb)
