golang-database

Prevent SQL injection in Go database access by using parameterized queries. This Skill provides best practices to ensure your code remains safe and secure against injection attacks.

Map database rows to Go structs efficiently using struct scanning techniques. This Skill demonstrates how to explicitly scan rows without relying on heavy ORMs for PostgreSQL, MariaDB, MySQL, or SQLite.

Handle transactions and connection pooling in Golang by applying explicit transaction management and optimized connection configurations. This Skill guides you through safe multi-statement operations and database connection management.

You do not need an ORM for Go database access with PostgreSQL or MySQL. This Skill helps you write safe, explicit, and observable database code using libraries like sqlx or pgx instead of ORMs.

Manage database schema migrations in a Go project using external tools like golang-migrate or Flyway. This Skill provides best practices for integrating migration tools alongside your database access code.

Your Go database query loses context cancellation signals if context propagation is not maintained. This Skill shows how to pass context correctly to maintain deadlines and cancellation signals during database operations.