Go application setup with PostgreSQL, sqlx, goose migrations

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

[@thuanquoc1231]

Sometimes I just watch how people do stuff and see if I'm doing stuff correctly or effectively.
Thank you for making this video 😁👍

[@MakeProgrammingFunAgain]

I'm probably neither, but at least I'm having fun in the process!

[@andrii7879]

this tutorial is awesome! super helpful

[@MakeProgrammingFunAgain]

Glad I could help!

[@superchillh3o]

Awesome