golang-database

To handle NULLable columns in Go, use specific types like sql.NullString or pointers in your structs during row scanning. This Skill provides best practices for safely mapping database rows to structs while avoiding nil pointer dereferences.

Manage database transactions in Go by using explicit Begin, Commit, and Rollback methods with configured isolation levels. This Skill provides best practices for writing safe, explicit, and observable transaction management code.

Choosing between sqlx and pgx for Go database access depends on your need for standard library compatibility versus PostgreSQL-specific optimizations. This Skill offers tool recommendations and best practices applicable to both packages for safe database interactions.

Configure connection pool management in Go by tuning database/sql settings like SetMaxOpenConns, SetMaxIdleConns, and SetConnMaxLifetime. This Skill provides comprehensive guidance on optimizing connection pools for efficient database access.

This Go database guide applies to PostgreSQL, MariaDB, MySQL, and SQLite. It provides comprehensive best practices for parameterized queries, struct scanning, and transaction management that are safe and efficient across these database systems.