Story
Pgtestdb's template cloning approach to testing is fast
1 report
1 website
1 discussion
Latest report
Overview
pgtestdb is a Go/Postgres testing package that utilizes Postgres template databases for efficient testing. Cloning a template database is significantly faster than migrating a test database from scratch or using Docker-based techniques.
Summary from brandur.org.
Reports
One report so far. Additional coverage will appear here when it is linked to this story.
Community reactions
Each reaction summarizes sampled comments from the linked discussion.
Hacker News · brandur.org
Hacker News discussion ↗
Historical count: 5 · 5 saved in sample · Historical sample
Analysis ready
Read this discussion’s reaction
Based on 5 sampled comments from this thread. Analyzed 2026-08-02.
- Praise: Using template databases for testing is a game-changer — speeds up the process dramatically, especially when you have a large schema.
- Praise: The performance gains are noticeable, particularly with a 400-500 table schema; this method really enhances efficiency.
- Praise: pgtestdb's approach to providing a clean database quickly is impressive, especially when migrations run only once, saving time across multiple tests.
- Praise: Running PostgreSQL on a ramdisk can take the speedup even further, making the cloning process lightning fast and ideal for intensive testing.
- Concern: Some commenters are skeptical about the effort involved, suggesting that using fakes for tests might be easier and cheaper, especially for lower layers of testing.
- Concern: Concerns were raised about the potential fragility of fakes in complex database operations, which can lead to misleading test results.
- Concern: There’s a worry that the 'dirty db' testing approach could lead to ambiguous failures, making debugging more complicated.