Overview
Syllabus
- Course introduction
- Introduction to Persistence
- Supabase project setup
- Query the database using supabase-js
- Query with aggregate function
- Storing the data in state
- Format data for chart
- Realtime subscription
- New deal form
- Insert new data
- Section 1 Recap
- Introduction to Auth
- Router setup
- Context API
- 1:18:38 Auth Session state - part 1
- 1:29:26 Auth Session state - part 2
- JSON Web Tokens anon
- JWTs authenticated
- Add user to Auth.Users
- 1:47:58 Sign in component - part 1
- 1:53:39 Sign in component - part 2
- 2:00:57 Sign in auth function - part 1
- 2:08:54 Sign in auth function - part 2
- Navigate & Link
- Sign out
- Navigate after sign out
- Row Level Security
- RLS: Authenticated users only
- Home redirect
- Protected Route
- Sign up
- 3:08:34 Database refactor - part 1
- 3:16:18 Database refactor - part 2
- User profiles table
- Sign up expansion
- Trigger
- 3:46:41 Refactor deals table - part 1
- 3:51:12 Refactor deals table - part 2
- 3:59:18 Refactor deals table - part 3
- 4:02:31 Fetch all profiles - part 1
- 4:08:19 Fetch all profiles - part 2
- 4:13:41 Update new deal form - part 1
- 4:24:49 Update new deal form - part 2
- 4:31:25 Update fetchMetrics - part 1
- 4:36:33 Update fetchMetrics - part 2
- Account type in Header
- Section 2 Recap
Taught by
freeCodeCamp.org