sql

How to Access Relational Databases with Go?

Using PostgreSQL as an example.

Packages Used

• sql: Generic SQL interface provided by the Go standard library. Must be used in conjunction with a database driver.
• pq: Pure Go PostgreSQL driver for database/sql.

Prerequisite

• Install Docker.

Quick Start

• Start a Postgres docker instance with docker-compose.

cd sql
docker compose up -d

• Execute the program.

go run main.go

• Tear down the Postgres docker instance.

docker compose down