When I run docker-compose up postgres service start successful. However my Golang API can not connect to my postgres service. I tried manually without docker and it works. Golang Connection string looks like this host=db port=5432 user=%s dbname=%s password=%s sslmode=disable.…
I have golang code like: import ( "github.com/bobertlo/go-mpg123/mpg123" ) func main() { ... } From terminal, to build this code. I must set below env variable: export C_INCLUDE_PATH=$C_INCLUDE_PATH:/opt/homebrew/Cellar/mpg123/1.32.3/include export LIBRARY_PATH=$LIBRARY_PATH:/opt/homebrew/Cellar/mpg123/1.32.3/lib Now I want build using vscode. I configure the launch.json,…
I am generating a key that will expire in Redis. As a programming language, I am using Go. The problem is that I need to know when something expires, because based on that, I know which key is expiring or…
Postgresql tries to connect to a Db with the same name as the user, even when I specify the DB name in the connection string. Cadena de conexión: host=localhost port=5432 user=carsUser password= dbname=the-new-cars sslmode=disable 2024/06/22 16:00 Error al hacer ping…
I'm trying to establish SSL/TLS connection to AWS RDS MySQL. The server is build in Docker and I can't force it to use certificate bundle provided by AWS... When I run the service in Docker container I receive first ERROR:…
I'm essentially doing an ETL on a large SQL table. I need to pull rows, perform a calculation, then write them back to the same server but a different table. What I'm seeing is workChannel fill up then everything stops.…
The final goal im trying to achive is to be able to have a write and read function to mimic a database and functions i can use to access it. So after reading the data it should be able to…
I am using CTE to check database rows, delete rows by filtering and finally to insert row into the database. Below is the go function to Insert a row: func (vm VoteModel) Insert(vote *Vote) error { ctx, cancel := context.WithTimeout(context.Background(),…
I have a little project in Go basically with a connection. Dockerfile FROM golang:1.22.3 AS build-stage WORKDIR /app COPY go.mod go.sum ./ RUN go mod download COPY . . RUN CGO_ENABLED=0 GOOS=linux go build -o /go-start ./cmd/server/main.go FROM scratch WORKDIR…
I have a code which does unit testing, where I prepare a database for the tests (I do not use sql-go-mock), so I want to insert returning id with a simple sql INSERT INTO, but for some reason pgx errors…