-
Database: one
Postgresql
database is running on a RDS instance on AWS. -
Drive: we have one S3 bucket to store the sql file.
-
Application: we created a reverse proxy with
Nginx
and an API withFastApi
, they are both running on a virtual machine one an EC2 instance on AWS.
In order to store our sql initialization file, we created an Amazon S3 bucket. Then we just had to drag&drop the file on the S3 interface.
To create the database, we've decided to run a Postgres database on Amazon RDS. The first step was to connect to an EC2 instance via SSH protocol in order to have an Ubuntu terminal to run docker.
Once we were connected to the VM, we ran a Postgres image in docker to have a way to use psql
. Then we copy our SQL init file inside our VM, to copy it inside our docker container.
Once we got our file, we were able to connect with psql
to our database server instance and initilialize it.
You can access the API by following this link.
You will land on the documentation page.
- Get all members - link
- Get member by name - e.g. "Smith" link
- Get all facilities - link
- Get all bookings - link
Feel free to star this repository or fork it if you find it usefull.
Cheers!