golang-database-patterns

The repository pattern in Go is implemented using interface-based data access layers to abstract database operations. This Skill provides code examples for building testable data access layers using standard library database/sql, sqlx, and pgx drivers.

Database transaction handling in Go requires safe rollback and commit management. This Skill details robust transaction patterns with retry logic, demonstrating how to manage concurrent operations safely using pgx and sqlx connections.

Database migrations in Golang using golang-migrate involve versioning your schema with sequential SQL files. This Skill covers schema versioning practices and provides scripts to apply migrations within a Go application workflow.

Choosing pgx vs sqlx for PostgreSQL integration depends on your driver needs; pgx offers protocol-level PostgreSQL features while sqlx wraps the standard database/sql interface. This Skill explores both libraries for different integration requirements.

Handling NULL values in Go SQL queries requires specific scanner types or pointer fields to avoid runtime panics. This Skill addresses NULL handling techniques and common anti-patterns like N+1 queries and SQL injection risks.