Data & Persistence in Go

Give the Tasks API a real database, one query at a time.

The Tasks API you built in Building Web Services in Go keeps everything in a map, which forgets everything the moment it restarts. This book replaces that store with a real SQL database using nothing but the standard library's database/sql: opening a connection, reading and writing rows, handling NULL, versioned migrations, transactions, a SQL-backed implementation of the store interface, tests that run against an actual database, and generating type-safe queries with sqlc.

Start reading →

Talking to a Database
The sql.DB Handle
- sql.DB Is Not a ConnectionIntermediate3 min read
Reading Rows
Writing Rows
- Inserting, and Getting the ID BackIntermediate2 min read
- Updating, Deleting, and Knowing Whether It HappenedIntermediate2 min read
Correctness Under Load
Migrations
- Ordered MigrationsIntermediate2 min read
- Versioned, Idempotent MigrationsIntermediate3 min read
Transactions
- BeginTx, Commit, and the Deferred RollbackIntermediate3 min read
- Context, Cancellation, and Pool TuningIntermediate3 min read
The Store, For Real
A SQL-Backed Store
- Assembling the StoreIntermediate3 min read
- Errors Across the SeamIntermediate3 min read
Testing with a Database
- A Fresh Database Per TestIntermediate3 min read
- Fixtures and Atomic SeedingIntermediate3 min read
Type-Safe Queries with sqlc
- Generated QueriesIntermediate3 min read
- Where to Go NextIntermediate3 min read

Contents

Talking to a Database

Correctness Under Load

The Store, For Real