This is a template that I developed for REST API backend with Go programming language and postgres database. This has support for custom postgres images that you can create and preload data in to that image, plus already written kubernetes files.

You can directly fork this and update according to your needs.

I am constantly learning and will be improving the code base even more.

Technologies and libraries

1. Go
2. Postgres
3. Gofiber
4. ORM
5. Docker

Building and running the application

You can directly run the kubernetes files or the docker containers by the commands below, you can also build the custom image stated below.

A. Create Custom postgres docker image

Modify the database/init.sql according to your needs to create your databases, tables, relations, and load data. During the building phase the Docker image will be builded by running the script inside the container to create the custom postgres image.

Command to build the postgres docker image

docker image build -f db.Dockerfile -t metalman66/postgresdb:latest .

Push the postgres docker image to docker hub

docker push metalman66/postgresdb

If you want to run the docker image locally, run the following command

docker container run -d --rm -p 5432:5432 -e POSTGRES_PASSWORD=postgres -e POSTGRES_USER=postgres --name postgresdb metalman66/postgresdb:latest

B. Docker Compose

You can run the application throught docker by using the docker-compose file. Command to run docker-compose.

docker-compose up --build

C. Kubernetes

You can run the application through deployment on a kubernetes cluster. Yaml files are present for the gobackend and the postgres db.

Run the following command to start the Kubernetes deployment and services.

kubectl apply -f postgresdb.yaml
kubectl apply -f gobackend.yaml

Future Tasks

1. Add tests
2. Add support for gRPC
3. Add support for GraphQL database
4. Add support for Auto build and push to dockerhub through Github actions

Useful links

1. https://cadu.dev/creating-a-docker-image-with-database-preloaded/
2. https://stackoverflow.com/questions/53735948/cannot-get-connection-between-containers