From e26a214de3958e48e94cdac0e1ae0641e3221deb Mon Sep 17 00:00:00 2001
From: Stefan Majewsky <majewsky@gmx.net>
Date: Fri, 31 Jul 2026 23:08:39 +0200
Subject: pgruntime: allow overriding .testdb path

---
 pgruntime/testdb.go        | 31 ++++++++++++++++++++++++++++++-
 pgruntime/tool_template.sh |  7 ++++---
 2 files changed, 34 insertions(+), 4 deletions(-)

diff --git a/pgruntime/testdb.go b/pgruntime/testdb.go
index 1c7035e..261f88a 100644
--- a/pgruntime/testdb.go
+++ b/pgruntime/testdb.go
@@ -10,6 +10,7 @@ import (
 	"os"
 	"os/exec"
 	"path/filepath"
+	"runtime/debug"
 	"strings"
 	"testing"
 	"time"
@@ -46,6 +47,16 @@ var toolScriptTemplate []byte
 //	func TestMain(m *testing.M) {
 //		pgruntime.WithTestDB(m, m.Run)
 //	}
+//
+// If the environment variable PGRUNTIME_TESTDB_PATH is set, this path will be used instead of ".testdb" below the module root dir.
+// This can be used e.g. to place the testdb on a tmpfs to avoid slow disk IO.
+// Doing so can reduce test execution times in realistic scenarios by as much as two thirds.
+// For clarity, a symlink will be created at the usual ".testdb" location, pointing to the actual path.
+//
+// If the value of $PGRUNTIME_TESTDB_PATH contains the string "%MODULE%" (e.g. "/tmp/testdb/%MODULE%"),
+// this string will be replaced by the name of the main module.
+// Using this placeholder, you can set this variable in your shell rc file once,
+// but the test databases of different applications will still be neatly separated.
 func WithTestDB(m *testing.M, action func() int) int {
 	// NOTE: Lifting the "-p 1" restriction is tough because tests for multiple packages are
 	//       compiled into one test binary per package, and thus execute in separate processes.
@@ -91,6 +102,7 @@ func withTestDB(m *testing.M, action func() int) (_ int, returnedError error) {
 }
 
 func findTestdbPath() (string, error) {
+	// find `$REPO_ROOT/.testdb`
 	cwd, err := os.Getwd()
 	if err == nil {
 		cwd, err = filepath.Abs(cwd)
@@ -106,7 +118,24 @@ func findTestdbPath() (string, error) {
 	if !ok {
 		return "", fmt.Errorf("neither the working directory %q nor any of its parents contain a go.mod file", cwd)
 	}
-	return filepath.Join(rootPath, ".testdb"), nil
+	testdbPath := filepath.Join(rootPath, ".testdb")
+
+	// find override path, if any
+	overridePath := os.Getenv("PGRUNTIME_TESTDB_PATH")
+	if overridePath == "" {
+		return testdbPath, nil
+	}
+	if strings.Contains(overridePath, "%MODULE%") {
+		info, ok := debug.ReadBuildInfo()
+		if !ok {
+			panic("$PGRUNTIME_TESTDB_PATH contains %MODULE% placeholder, but binary was not built with module support")
+		}
+		overridePath = strings.ReplaceAll(overridePath, "%MODULE%", info.Main.Path)
+	}
+
+	// if there is an override path, report the override path (so that initDBIfNecessary can create it),
+	// but put a symlink at the standard path for convenient access
+	return overridePath, os.Symlink(overridePath, testdbPath)
 }
 
 func findModuleRootDir(dirPath string) (Option[string], error) {
diff --git a/pgruntime/tool_template.sh b/pgruntime/tool_template.sh
index d0ddea1..7e3827f 100644
--- a/pgruntime/tool_template.sh
+++ b/pgruntime/tool_template.sh
@@ -1,13 +1,14 @@
 #!/usr/bin/env bash
 set -euo pipefail
+cd "$(dirname "$0")"
 
 stop_postgres() {
 	EXIT_CODE=$?
-	pg_ctl stop --wait --silent -D .testdb/datadir
+	pg_ctl stop --wait --silent -D datadir
 	exit "${EXIT_CODE}"
 }
 trap stop_postgres EXIT INT TERM
 
-rm -f -- .testdb/run/postgresql.log
-pg_ctl start --wait --silent -D .testdb/datadir -l .testdb/run/postgresql.log
+rm -f -- run/postgresql.log
+pg_ctl start --wait --silent -D datadir -l run/postgresql.log
 $COMMAND -U postgres -h 127.0.0.1 -p 54320 "$@"
-- 
cgit v1.3.1