Backend Brilliance: An Expansive Supabase Course for Streamlined Backend-as-a-Service
Chapters (7)
Chapter 1
XP
Supabase Foundations
Chapter Progress
No progress yet
LESSONS (3)
Backend Evolution: The story of the backend solutions leading to Supabase
12 XP
Foundational
Brief history of backend solutions
Introduction to Supabase
Overview of upcoming lessons
Project Blueprint: Introducing PixelPulse
12 XP
Foundational
Overview of project components
Core React + Vite + Supabase stack setup
Zero to Hero: Setting up Supabase in under 10 minutes
12 XP
Foundational
Supabase dashboard overview
.env and API keys setup
Row level security setup
Chapter 2
XP
Knock Knock!: Supabase Authentication
Chapter Progress
No progress yet
LESSONS (2)
Navigating the Authentication Maze: A walk through the intricacies of authentication systems
12 XP
Foundational
Commonly used authentication strategies
Understanding email / password and SSO authentication
Introduction to Supabase authentication
Advanced
Understanding OTP and MFA authentication
Authentication assurance levels (AAL1, AAL2, AAL3)
Guide to Auth Magic: Master Email and OAuth with Supabase
12 XP
Foundational
Common authentication user journeys
Email / password auth implementation
SSO auth implementation
Advanced
Client-Side user authentication tracking
Personalized emails through Custom SMTP
User data management
Chapter 3
XP
Data Expeditions: A Masterclass on Supabase Databases
Chapter Progress
No progress yet
LESSONS (6)
Planning the Walls: Data Architecture in PostgreSQL
12 XP
Foundational
Building blocks of relational databases
Data manipulation using SQL
Advanced
Non-redundant databases using normalization (1NF, 2NF, 3NF)
Performant data queries using database indexing
API Odyssey: REST, GraphQL, and the Art of API Navigation
11 XP
Foundational
Database connection options (direct, pooling, APIs)
GraphQL Basics
Integrate Typescript using Supabase’s type generation
Advanced
Unstructured data storage
RPC Wonders: Improving with Postgres Functions
12 XP
Foundational
Introduction to Postgres functions
PLPGSQL programming syntactic structure
Advanced
Controlling access within Postgres functions
Polymorphic functions using function overloading
Integrating logic using transaction control
You Shall Not Pass!: Row Level Security
12 XP
Foundational
Fundamentals of RLS
Postgres access control roles
Advanced
Finegrained access through custom RLS policies
Advanced RLS policies real world use cases
Implement Instagram Story security rules using RLS
Secure Twitter Edit feature using RLS
A Complete Guide to Full-Text Search in Postgres
12 XP
Foundational
Fundamentals of full-text search in Postgres
Writing text-search queries using SQL and Supabase
Advanced
Deep dive into internal working on Full-Text Search in Postgres
Triggers & Webhooks: Action-packed Database Management
12 XP
Foundational
Overview of triggers and webhooks
Building triggers using Supabase's GUI
Adding basic webhooks through Supabase
Best practices for optimal triggers and webhooks
Advanced
Complex triggers and webhooks using plpgsql
Clean deletions using cascading deletion triggers
Safeguarded data through modification prevention triggers
Robust data practices through integrity constraints
Chapter 4
XP
Storage Chronicles: Exploring the Supabase Storage API
Chapter Progress
No progress yet
LESSONS (2)
Storage Explored: Tour of the Supabase Storage API
12 XP
Foundational
Overview of Supabase Storage API
Programmatic uploads using Supabase Client
Advanced
Reliable file transfers through resumable uploads
Storage Reinforced: Access Control, Caching and Image Transformation
12 XP
Foundational
Supabase Storage dashboard
Overview of Caching and CDN
Advanced
Optimized images through Supabase image transformations
Deep dive into Smart CDN cache invalidation
Chapter 5
XP
Supabase Realtime: Put Supabase in the Fast Lane
Chapter Progress
No progress yet
LESSONS (2)
Realtime Revolutions: Implementing Postgres Change Listeners
12 XP
Foundational
History of web communications
Inner workings of Web Sockets
Postgres change listeners
Supabase realtime subscriptions
Advanced
Filters for granular realtime monitoring
Chaining Postgres listeners
Engaging Experiences: Realtime Presence and Broadcast
12 XP
Foundational
Why client-to-client communication
Real world use cases of client-to-client channels
Challenges with traditional implementations
Advanced
Realtime presence tracking using Supabase Presence
P2P messaging channels using Supabase Broadcast
Tailoring broadcast behavior
Chapter 6
XP
Edge of Tomorrow: Unleashing Supabase’s Edge Functions
Chapter Progress
No progress yet
LESSONS (3)
Living on the Edge: A Introduction into Serverless Computing
12 XP
Foundational
History of computing, from Mainframe to Edge Functions
Real world use cases of edge functions
Getting Started with Edge Functions: Writing and Deploying our First Edge Function
12 XP
Foundational
Installing and setting up Supabase CLI
Writing and Deploying a basic Edge Function
Invoking edge function using cURL and supabase-js
Advanced
Debugging Edge Functions using Logs Explorer
Pushing the Boundaries: A Deep Dive into Advanced Edge Functions Concept
12 XP
Foundational
Using Supabase-js in Edge Function
Edge Function as Database Webhooks
Advanced
Using Edge Function with User's Auth Context to follow RLS policies
CI/CD on Edge Function with GitHub Actions
CORS support in Edge Functions
Building a full-fledged GraphQL API on Edge Functions
Chapter 7
XP
Control in Your Hands: Mastering Self-Hosting, Local Development, and Branching
Chapter Progress
No progress yet
LESSONS (2)
Local Development: Setting up and Managing Environments
12 XP
Foundational
Importance of local development
Setting up local development
Advanced
Database Migrations
Database Seeding
Managing Different Project Environments
Supabase Branching: Simplifying Development Across Multiple Environments
12 XP
Foundational
Understanding Supabase Branching
The need for Branching
Setting Up Branching in Supabase