00:00 Introduction and Setup
01:03 Project Setup
02:05 Troubleshooting Database Role Issues
03:15 Setting Up Database and Connection
03:55 Connect to Database in Go
04:50 Reading Config from Environment Variables
06:39 Database Migrations
08:58 Conclusion and Future Plans
This video covers:
* setting up a new Go project,
* configuring PostgreSQL,
* writing a PostgreSQL connection URL,
* installing and configuring sqlx, pq, goose,
* executing simple SQL query with sqlx,
* schema migrations with goose.
Code for this video is available at: github.com/moroz/goma/tree/20...
Websites visited in the video:
github.com/jmoiron/sqlx
github.com/lib/pq
www.postgresql.org/docs/curre...
www.postgresql.org/docs/curre...
direnv.net
github.com/pressly/goose