Supabase documentation - Seneca-CDOT/telescope GitHub Wiki
What is Supabase
Supabase is an application development software that provides different backend services:
- Authorization
- File storage
- Database (PostgreSQL)
- Realtime
Access:
Currently, we're self-hosting Supabase (one of Supabase advantages) in our docker containers, the code can be found at docker/supabase
. We're using:
- Database
- Authorization
Database
The Database is PostgreSQL and we're using its row level security feature. For example, in 04-telescope-schema.sql, we only allow a user to edit his own record.
Entity Relationship Diagram (ERD)
As of Release 2.7, these are the tables we have: