go-database

Go database connection setup requires proper pool tuning and configuration for Postgres, MySQL, or SQLite. This Skill provides templates for connection management, repository patterns, and safe data access to ensure reliable production Go database operations.

Database transactions in Go need robust handling to maintain data integrity. This Skill implements transaction patterns with retry logic and error handling, ensuring reliable data access and transaction management across production Go applications.

The repository pattern in Go database access separates data layer logic from business logic. This Skill provides repository pattern implementations with safe data access, validation tooling, and consistent query execution using sqlx or ORM frameworks.

Yes, Go database operations support both sqlx and ORM usage. This Skill accepts an optional ORM choice during initialization and applies best practices across SQL queries, ORM integration, and connection management for scalable database access.

Database migrations in Go production applications require scalable templates to ensure data integrity. This Skill provides migration templates alongside transaction handling and validation tooling, enforcing best practices for reliable schema evolution in production Go services.

Go database operations fail under concurrent loads due to fragile transaction handling and inconsistent access patterns. This Skill addresses these issues with retry logic, proper connection pool tuning, and robust error handling patterns for production resilience.