Backend Brilliance: An Expansive Supabase Course for Streamlined Backend-as-a-Service
Chapters (7)
Chapter 1
36 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
24 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
71 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
24 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
24 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
36 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
36 XP
Beyond the Surface: Achieving Mastery of Supabase
Chapter Progress
No progress yet
LESSONS (3)
Automate with Ease: Database and Edge CRON Jobs
Coming Soon
12 XPDelve into the world of background processes, exploring traditional CRON setups and Supabase's innovative implementation. Set up a CRON job with Edge Functions to streamline data aggregation, stats table population, and artwork ranking.
Monitoring Mastery: Supabase Logging and Observability
Coming Soon
12 XPBecome an expert in logging and filtering logs within Supabase. Monitor edge function calls, and pinpoint errors to ensure smooth and efficient application development.
Control in Your Hands: Self-Hosting and Local Development
Coming Soon
12 XPAssess the pros and cons of self-hosting infrastructure and evaluate hosting options. Create a demo project with a forked Supabase repo, tap into local development benefits, and experience seamless development in your control.