storetest

const EnvDatabaseURL = "AKARI_TEST_DATABASE_URL"

EnvDatabaseURL is the environment variable that opts a run in to the integration tests. Its value is a normal Postgres URL; only the host and credentials are used to reach the server, since each test's database is created beside the one the URL names rather than being it.

const (

	// EnvMaxLiveStores overrides defaultMaxLiveStores, so a run against a Postgres
	// with a different connection ceiling can retune the gate without a recompile.
	EnvMaxLiveStores = "AKARI_TEST_MAX_STORES"
)

Connection budget. Every test provisions its own database and opens a pool against the one shared Postgres, so the suite's peak connection load is the number of test Stores live at once times the per-pool cap. Two constants bound that product:

• poolMaxConns (C) caps a single Store's pool.
• maxLiveStores (N) caps how many Stores are live at once, and it does so ACROSS every `go test` binary, not just within one package's process. The storeGate below is a counting semaphore backed by advisory file locks in a temp directory keyed to the Postgres instance, so every binary aimed at that server draws from the same N slots. A plain in-process semaphore cannot do this (each package `go test` compiles is its own binary with its own memory), which is why `go test ./...` no longer needs a `-p` pin to stay bounded.

The ceiling is N*C = 32*4 = 128 connections, under the 200 max_connections .eph configures, leaving room for the transient CREATE/DROP maintenance connections and the dev server's pool under `eph run`. It holds regardless of `-p` or GOMAXPROCS, since the gate spans processes. Set AKARI_TEST_MAX_STORES to tune N (a smaller Postgres wants a smaller N; more headroom allows a larger one).

As before, the ceiling is a worst case, not the steady state: pgx opens pool connections lazily (pool_min_conns defaults to 0), so a pool holds only what its test uses at once. Almost every test sits at one or two connections and only the concurrent-ingest test reaches C, so a full run peaks well under the ceiling.