Dockerfile Integration of Cerbos with PostgREST
Budget: $30 – $250 USD
We need a simple Dockerfile setup that integrates Cerbos for API authorization with PostgREST. The project involves setting up a PostgreSQL database with four simple tables: students, teachers, lessons, and schools, and configuring Cerbos for basic role-based access control.
Tasks:
Create a Dockerfile that integrates Cerbos and PostgREST.
Setup a PostgreSQL database with the four mentioned tables and populate them with some basic sample data.
Configure Cerbos policies for four roles:
Student: Can view their own info and lessons.
Teacher: Can view their lessons and students.
School Admin: Can manage teachers, students, and lessons.
Super Admin: Can manage everything.
Provide simple instructions to run the Docker container and test the setup.
Deliverables:
Dockerfile
SQL script for the database with sample data
Basic Cerbos policy configuration
This is a simple proof of concept, mainly to test the API authorization. It should be quick and straightforward for anyone experienced with Docker and PostgREST.
Tasks:
Create a Dockerfile that integrates Cerbos and PostgREST.
Setup a PostgreSQL database with the four mentioned tables and populate them with some basic sample data.
Configure Cerbos policies for four roles:
Student: Can view their own info and lessons.
Teacher: Can view their lessons and students.
School Admin: Can manage teachers, students, and lessons.
Super Admin: Can manage everything.
Provide simple instructions to run the Docker container and test the setup.
Deliverables:
Dockerfile
SQL script for the database with sample data
Basic Cerbos policy configuration
This is a simple proof of concept, mainly to test the API authorization. It should be quick and straightforward for anyone experienced with Docker and PostgREST.