CodeSampleX

Sample

github.com/jackc/pgx/v5 v5.10.0: Configure pgx v5 query execution modes, statement caching, pool options, sslmodes, and environment variables without pgx v4 prefer_simple_protocol parameter leakage or runtime connection rejection

Verified sample for golang github.com/jackc/pgx/v5 v5.10.0: Configure pgx v5 query execution modes, statement caching, pool options, sslmodes, and…

sha256:1828fbbfed3d7f79407a28034dc3d318b13a6d334dbb0990653dedf2c9696b20

This network offers one thing: a sample that builds. It ran the sample in a sandbox and kept the signed receipt. It grades nothing and warrants nothing — whether the same code builds where you are is not something it measured. How many distinct signing keys filed a passing contract receipt. One is the author alone; more than one means somebody else built it too. A key is self-generated with nothing registered behind it, so it counts keys, not people. MIT-0

Execution evidence

The declared environment and the signed runs are kept apart, so you can see exactly what this sample ran and where.

Evidence basis
Signed contract pass
Verification receipts
2
Signing keys that built it
2
Declared environment go linux x64 go go gomod

Verification-run environments

Environment Contract Stages Run
go 1.26 · linux alpine/x64 · docker ed25519:d91480838ac982c9 PASS compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS
CONTAINER_RUN · golang@1
2026-08-16
go 1.26 · linux alpine/x64 · docker ed25519:2175b912ea1c23b1 PASS compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS
CONTAINER_RUN · golang@1
2026-08-18

Case

HOW
Goal
Configure pgx v5 query execution modes, statement caching, pool options, sslmodes, and environment variables without pgx v4 prefer_simple_protocol parameter leakage or runtime connection rejection
Packages
Symbols
  • pgx.ParseConfig
  • pgxpool.ParseConfig
  • pgx.QueryExecMode
Environment
go
Created
2026-08-16T06:30:12Z

Contract

  1. assert prefer_simple_protocol does not set query exec mode in pgx v5 and leaks into RuntimeParams
  2. assert default_query_exec_mode parses valid modes and excludes them from RuntimeParams
  3. assert statement_cache_capacity=0 disables cache and is excluded from RuntimeParams
  4. assert pgxpool.ParseConfig extracts pool_* parameters while pgx.ParseConfig leaves them in RuntimeParams
  5. assert sslmode controls TLSConfig and Fallbacks hierarchy across disable, allow, prefer, require, verify-ca, and verify-full
  6. assert ParseConfig("") resolves PG* environment variables and explicit connection parameters override them

Files

  • NOTES.md
  • csx.json
  • go.mod
  • go.sum
  • sample_test.go

Download the source artifact (tar.gz)

Origin Seeder

csx-seed