All you have to do is run the shell script, and it should download postgres stuff, sqlx itself, and run the required sqlx commands. Then, it drops you into another shell (I could make this more visual if required), so you don't have to open a new terminal window, and so that the docker container is automatically destroyed again once you exit out of that shell.
I can get the backend to compile this way. However, I haven't tried out actually doing any reads or writes with the database, so tbh not sure if that works (though I don't see why it shouldn't).
One weird thing: once you exit the shell, and the postgres docker container is destroyed, compiling the rust backend still works for some reason, even though the database should be "dead"/unreachable.
All you have to do is run the shell script, and it should download postgres stuff, sqlx itself, and run the required sqlx commands. Then, it drops you into another shell (I could make this more visual if required), so you don't have to open a new terminal window, and so that the docker container is automatically destroyed again once you exit out of that shell. I can get the backend to compile this way. However, I haven't tried out actually doing any reads or writes with the database, so tbh not sure if that works (though I don't see why it shouldn't). One weird thing: once you exit the shell, and the postgres docker container is destroyed, compiling the rust backend still works for some reason, even though the database should be "dead"/unreachable.