pgdbtemplate

Tired of your Go tests being slowed down by repetitive PostgreSQL database setup? I built pgdbtemplate to solve exactly that. It uses PostgreSQL's native template databases to create fully migrated test databases in milliseconds instead of seconds. The problem: Traditional test setup runs all your migrations for every single test. With a complex schema, this wastes minutes in every test run. The solution: Create one "golden" template database. Every test gets its own isolated copy instantly via CREATE DATABASE ... TEMPLATE. Benchmarks don't lie: - 1.5x faster for complex schemas (5+ tables) - 37% time saved creating 200 databases - 17% less memory usage - Performance gains increase with schema complexity It's: - Thread-safe and built for t.Parallel() - Driver-agnostic: works with both pgx and pq - Integrates with testcontainers-go - MIT L

Dear community, I have heard that appropriate self-promotion is allowed on this forum, so I want to welcome `pgdbtemplate`. It is the Go library for creating PostgreSQL test databases using template databases for lightning-fast test execution. Have you ever used PostgreSQL in your tests and been frustrated by how long it takes to spin up the database and run its migrations? `pgdbtemplate` offers... - Proven benchmarks showing 1.2x-1.6x faster performance than the traditional approach - Seamless integration with your projects by supporting both "github.com/lib/pq" and "github.com/jackc/pgx/v5" PostgreSQL drivers, as well as configurable connection pooling - Built-in migration handling - Full `testcontainers-go` support - Robust security implementation: safe against SQL injections, fully thread-safe operations - Production-ready