alt.hn

7/30/2026 at 3:49:03 PM

Pgtestdb's template cloning approach to testing is fast

https://brandur.org/fragments/pgtestdb

by peterldowns

7/30/2026 at 4:12:07 PM

> I’m going to add a recommendation in our docs for pgtestdb, particularly for users aiming to test end-to-end (i.e. job inserted by client → fully completed by worker).

That's exactly what I did to learn River — implementing simple apps and testing their execution with pgtestdb: https://github.com/lukasschwab/river-playground

The starter skeleton was LLM-generated and not quite perfect, but discovering the coding agent's mistakes was satisfying in its own right.

by lukasschwab

7/30/2026 at 4:50:38 PM

Just want to say thank you to Brandur for doing such a cool experiment. Last year I actually explored the River test suite to understand how they made it work so quickly — he's understating it when he says their implementation is "gold standard."

I'm both surprised and excited to hear that pgtestdb, out of the box, can give anyone a ~nearly as fast experience.

Going to have to throw some tokens at pooling... very interesting idea.

Thank you, Brandur!

by peterldowns