Setup SQLc in Golang, Postgres on a Docker Container
In this video, part 3 of our web application series, we dive into setting up SQLc and Postgres on a Docker container to enhance our user registration system. SQLc, a code generator for Go, ensures type-safe and efficient database interactions. We'll cover its installation, configuration, and usage for generating code from SQL queries, focusing on creating a directory for SQLC-generated code, configuring sqlc.yaml, and writing basic SQL queries. Additionally, we’ll set up a Docker container for Postgres, detailing the creation of a Dockerfile, building the Docker image, and organizing Docker commands with a bash script for seamless database management. Join us to streamline your Go and SQL development workflow!
0:00 intro
01:16 Setup SQLc
04:34 Docker
05:01 Writing a Dockerfile
06:33 Bash script for automation