I created a compose.yml and a Dockerfile to connect Rust (Actix Web) with PostgreSQL (SQLx). Now, I am encountering some errors, and the compile error says the following:

DATABASE_URL=postgres://postgres:secret@postgres:5432/postgres
compile error message

DATABASE_URL=postgres://postgres:secret@localhost:5432/postgres
compile error message

The purpose of my project is to integrate a Rust backend with a Next.js frontend and PostgreSQL, with hopes of deploying the project on AWS or other cloud platforms.

Connecting Rust with PostgreSQL in a local environment is not my primary goal. I prefer to do this on AWS RDS, but debugging in a local environment is essential.

Any advice is welcome:)

Dockerfile

compose.yml

Cargo.tml

main.rs

controllers/game.rs