Let’s say you created a Go program that stores data in PostgreSQL — you installed PostgreSQL, wrote the Go code, and everything works; great!
But after writing a test for your code, you wonder: how do you best provide PostgreSQL to your automated tests?

Community Picks is a section on daily.dev where our community members share the most interesting and valuable content they've discovered online. From insightful articles to handy tools, every post is a gem curated by our dedicated coomunity. To contribute to Community Picks, you need to have at least 250 reputation points, ensuring that only active and trusted members can share their finds.

Community Picks

Using ephemeral PostgreSQL instances can simplify testing for Go programs by avoiding configuration and setup problems. This method ensures that tests start with an empty database, making them reliable and environment-independent. By utilizing packages like `postgrestest`, developers can streamline the setup process, optimize test runtime, and reduce system resource usage.

Testing with Go and PostgreSQL: ephemeral DBs

<p>If you’re using a single schema in PostgreSQL, which by default is the <code>public</code> schema, then you could just clone that and set the search path to that schema while the test is running <code>SET search_path TO &lt;my schema&gt;</code></p>
<p>With this method, you can even run tests in parallel because each test can set up a separate schema in the same database.</p>
