/ Home

Course 1: Supabase Basics with Python

1. Introduction to Supabase

   • What is Supabase?
   • Firebase vs Supabase vs Custom Backends
   • Architecture Overview: Postgres, Auth, Storage, Real-time

2. Setting Up Supabase

   • Creating a Supabase Project
   • Supabase Dashboard Overview
   • Installing Supabase Python SDK
   • Connecting Python to Supabase Project

3. Understanding the Supabase Database

   • PostgreSQL Foundations
   • Tables, Columns, Data Types, Constraints
   • SQL Editor in Supabase Console

4. CRUD Operations with Python

   • Insert Data
   • Select/Query Data
   • Update Data
   • Delete Data
   • Query Filters, Ordering, Range, Pagination

5. Supabase Auth (Authentication)

   • Sign Up, Email Login, Magic Link
   • OAuth Provider Login
   • Managing Sessions in Python

6. Row-Level Security (RLS)

   • What is RLS?
   • Enabling RLS on Tables
   • Basic Read/Write Policies

7. Supabase Storage with Python

   • Uploading Files
   • Downloading Files
   • Buckets Overview

8. Real-Time Data Basics

   • Realtime Architecture
   • Listening to Table Events from Python

9. Supabase CLI and Local Development Intro

   • Installing CLI
   • Running Supabase locally
   • Syncing schema to cloud

10. Exporting and Importing Data

    • CSV / JSON Exports
    • Import Tools

11. Mini Project

    • Build a basic CRUD app using Python + Supabase

---

Course 2: Advanced Supabase with Python

1. Advanced RLS and Security Policies

   • Multi-condition Rules
   • Role-based Access
   • Policy Debugging

2. Auth + Python Deep Integration

   • Token-based Mechanisms
   • Role-changing workflows
   • Secure APIs

3. Supabase Storage Advanced

   • Signed URLs
   • Access expiration logic
   • File privacy and moderation

4. Edge Functions with Python

   • Writing Serverless Functions
   • Triggering DB logic through functions
   • Integrating Auth into Functions

5. Python Framework Integration

   • FastAPI with Supabase
   • Flask with Supabase
   • Building admin panels

6. Triggers, SQL Functions & Extensions

   • Creating Triggers
   • Writing PostgreSQL Functions
   • Using pgvector, hstore, cron

7. Real-Time Deep Dive

   • Websocket Patterns
   • Real-time Analytics Boards
   • Real-time Notifications and Chat

8. Supabase for ML/GenAI Pipelines

   • Using pgvector for embeddings
   • Retrieval Augmented Generation storage
   • Python + Supabase RAG workflows

9. Supabase for Dashboards

   • Integrating with Plotly Dash
   • Live charts from database streams

10. Migrations & Version Control

    • Advanced CLI Usage
    • Branching database schemas
    • Promote staging to production

11. Deployment & Production

    • Tier strategy
    • Backup and disaster recovery
    • Performance & indexing tuning

12. Capstone Project

    • Deploy a full-stack Python + Supabase app using Authentication, RLS, Storage, Real-time, ML Vector Search