⚠️ Announcement:This project got too big and more complex than I anticipated. I am moving this project to a new repository. You can find the new repository here.
This project is a blog aggregator service in Go. It utilizes RESTful API that fetches data from remote locations and stores them in a production-ready database tools like PostgreSQL, SQLc, Goose, and pgAdmin.
It also utilizes a long-running service worker that reaches out over the internet to fetch data from remote locations.
-
Rename the
.env.examplefile to.envand fill in the required environment variables. Make sure to have properDATABASE_NAMEin the.envfile.cp .env.example .env
-
Run the following command to start postgresql server using docker-compose
docker-compose up -d
-
Run the following command to use
gooseto apply migrationsdocker-compose run --rm go-tools goose up
-
Run the following commands to generate
sqlccodedocker-compose run --rm go-tools sqlc generate
-
Run the following command to stop postgresql server using docker-compose
docker-compose down
Docker compose file also installs Go tools (sqlc and goose) inside a docker container. This setup encapsulates your development environment within Docker, keeping your host machine clean and ensuring consistency across different development setups.
To use sqlc and goose, you would run commands inside the go-tools container. For example, to generate SQLC code, you might use:
docker-compose run --rm go-tools sqlc generateOr to apply migrations with goose, you might use:
docker-compose run --rm go-tools goose upRemember to rebuild your Docker Compose services if you make changes to the Dockerfile or need to update the tools:
docker-compose build go-tools