Module restapi::requests::models

Expand description

Modules for the postgres database models

Running a secure postgres database locally using docker

If you want to run the example server, it requires configuring the postgres database.

The included guide is part of the github repo:

https://jay-johnson/restapi

Below is the guide included for rust docs:

If you have not generated the certs locally, then you can run this one-line command:

cd ../../certs && ./generate-tls-assets.sh -c ./configs/dev-network.yml -f && cd ../docker/db

Please note: the Postgres Dockerfile will copy the tls assets from the ../../certs/tls into a image named: localbuild/postgres14

./build-postgres.sh

Before starting the stack, please note this command will start 2 docker images:

localbuild/postgres14 - built from open source postgres:14.1-alpine image)
dpage/pgadmin4 - useful db management web app, but please do not allow access to this docker container access to the public internet - it is not intended to be secure enough for internet traffic

./start.sh

docker ps

Postgres is listening to secure connections on tcp port 5432.

openssl s_client -connect 0.0.0.0:5432 -starttls postgres

psql --set=sslmode=require -h 0.0.0.0 -p 5432 -U postgres -d mydb

By default, you can login to pgadmin4 at:

Note: unless you add the Certificate Authority to your host, your browser will get an ssl warning:

https://0.0.0.0:5433/login?next=%2F

Default login credentials which you can change in the compose.yml under the environment variables list:

The default password is postgres, and you can change it in the compose.yml under the environment variables list:

./init-db.sh

psql --set=sslmode=require -h 0.0.0.0 -p 5432 -U postgres -d mydb -c "\dt"

Module for a user

Model for tracking user-uploaded s3 keys

Module for a user’s one-time-use password

Module for verifying a user by email