Post Content
Learn how to use Supabase by building a real-world React.js Sales Dashboard app with authentication, real-time data operations, and secure user management.
✏️ Study this course interactively on Scrimba:
https://scrimba.com/intro-to-supabase-c0abltfqed?utm_source=youtube&utm_medium=video&utm_campaign=fcc-intro-supabase
Code is available on the Scrimba course page for each lesson.
The app features user authentication with role-based access along with a visualization of aggregated sales deals for each rep, updating in real-time as new deals are added. You’ll also build scalable user profiles which are automatically created upon signup using database triggers, and secure all data with permission-based filtering. By the end, you’ll have a production-ready business application with proper user management, data visualization, and security.
Scrimba on YouTube: https://www.youtube.com/c/Scrimba
⭐️ Chapters ⭐️
– 0:00:00 Course introduction
– 0:05:42 Introduction to Persistence
– 0:09:48 Supabase project setup
– 0:20:50 Query the database using supabase-js
– 0:27:55 Query with aggregate function
– 0:31:50 Storing the data in state
– 0:34:57 Format data for chart
– 0:40:26 Realtime subscription
– 0:47:17 New deal form
– 0:56:54 Insert new data
– 1:00:21 Section 1 Recap
– 1:01:00 Introduction to Auth
– 1:02:10 Router setup
– 1:10:35 Context API
– 1:18:38 Auth Session state – part 1
– 1:29:26 Auth Session state – part 2
– 1:31:40 JSON Web Tokens (anon)
– 1:39:24 JWTs (authenticated)
– 1:45:53 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
– 2:11:43 Navigate & Link
– 2:18:21 Sign out
– 2:27:53 Navigate after sign out
– 2:32:20 Row Level Security
– 2:37:11 RLS: Authenticated users only
– 2:43:19 Home redirect
– 2:52:13 Protected Route
– 2:58:53 Sign up
– 3:08:34 Database refactor – part 1
– 3:16:18 Database refactor – part 2
– 3:25:19 User profiles table
– 3:31:35 Sign up expansion
– 3:35:05 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
– 4:42:46 Account type in Header
– 4:48:45 Section 2 Recap
🎉 Thanks to our Champion and Sponsor supporters:
👾 Drake Milly
👾 Ulises Moralez
👾 Goddard Tan
👾 David MG
👾 Matthew Springman
👾 Claudio
👾 Oscar R.
👾 jedi-or-sith
👾 Nattira Maneerat
👾 Justin Hual
—
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news Read More freeCodeCamp.org
#programming #freecodecamp #learn #learncode #learncoding
