golang-database

Using parameterized queries in Go prevents SQL injection by separating SQL code from data. The golang-database skill provides expert guidance on writing safe, explicit database code with parameterized queries to ensure secure data handling.

Managing transactions and connection pooling in Go's database/sql package requires setting explicit isolation levels and configuring pool limits. The golang-database skill provides best practices and code examples to optimize database connection management for safe and observable operations.

Context propagation ensures Go database queries respect deadlines and cancellation signals. The golang-database skill provides best practices for passing context through your database access layer to maintain safe and observable query execution.

The golang-database skill offers comprehensive guidance on using pgx and sqlx. It provides best practices and code examples for Go developers working with various SQL databases and related tools to write safe, explicit database code.

For database migrations in Go backend applications, the golang-database skill recommends external tools for schema changes. It provides best practices for backend engineers working with PostgreSQL, MariaDB, MySQL, or SQLite to manage schema evolution.

Specific transaction isolation levels in Go should be used when managing multi-statement operations that require strict data consistency. The golang-database skill provides expert guidance on transactions and locking to ensure proper isolation for your database operations.