Databases

10 pages in this section.

Data Access in Go: database/sql as the Foundation

Learn how Go's database/sql package provides a driver-agnostic foundation for database access, connection pooling, and transactions.

Go Databases Explainer Data

Databases Basics

Learn Go database basics with 10 examples using database/sql. Explore sql.Open, ExecContext, QueryContext, rows.Scan, and connection handling.

Go Databases Basics Examples

database/sql Connection Pooling & Timeouts

Tune Go's database/sql connection pool with SetMaxOpenConns, SetMaxIdleConns, and SetConnMaxLifetime to prevent database starvation.

Go Databases Connection Pooling

Transactions, Prepared Statements & sql.Tx

Learn how to use sql.Tx in Go to group database operations into atomic transactions and reuse prepared statements for efficiency.

Go Databases Transactions Prepared

GORM vs sqlx vs Raw database/sql

Go Databases List Cheatsheet

Migrations with golang-migrate & goose

Learn to manage database schema changes with golang-migrate and goose. Apply SQL or Go migrations, handle rollbacks, and integrate into CI/CD pipelines.

Go Databases Migrations Golang

Redis Caching & NATS/Kafka Messaging

Go Databases Redis Caching

embed for SQL Migrations & Seed Data

Embed SQL migration files and seed scripts in Go binaries using embed.FS. Learn to deploy self-contained artifacts for databases.

Go Databases Embed Sql

Databases & Data Access Best Practices

Optimize database access with best practices for Go applications. Learn about connection pooling, context deadlines, query timeouts, and observability.

Go Databases Best Practices List

Databases Highlights Summary

A single-page roundup of every highlight bullet from the 9 pages in the Databases section, grouped by source page so you can scan all 52 takeaways without opening each article individually.

Highlights Summary Databases

Databases

Search Documentation

Databases