데브허브 | DEVHUB | Intro to Supabase – Full Tutorial for Beginners
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...
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: / 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
![[강의미리보기]MySQL로 배우는 데이터베이스 개론과 실습(2)](https://i1.ytimg.com/vi/8gyKghHavjg/hqdefault.jpg)