Published On Mar 2, 2024
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: https://github.com/moroz/goma/tree/20...
Websites visited in the video:
https://github.com/jmoiron/sqlx
https://github.com/lib/pq
https://www.postgresql.org/docs/curre...
https://www.postgresql.org/docs/curre...
https://direnv.net
https://github.com/pressly/goose