DATABASES / LESSON 09
Supabase Basics.
What a database is, what Supabase adds, and why real-time matters

Loading the lesson…
Loading activities…
DATABASES / LESSON 09
What a database is, what Supabase adds, and why real-time matters

Loading the lesson…
Loading activities…
Every app needs somewhere to keep its stuff. User profiles, posts, orders, messages... all of it has to live somewhere. That's the job of a database, and Supabase makes databases a whole lot less scary.
Think of a database as a super-organized collection of information. It's kinda like a spreadsheet, just WAY more powerful.
Here's what some user data might look like in a database.
| id | name | joined_date | |
|---|---|---|---|
| 1 | Sarah | sarah@email.com | 2024-01-15 |
| 2 | Mike | mike@email.com | 2024-01-20 |
| 3 | Emma | emma@email.com | 2024-02-01 |
Your app can do four things with it.
Those four moves are called CRUD, short for Create, Read, Update, Delete.
Supabase is a service that gives you a database plus a bunch of extra features. It's built on top of PostgreSQL, a popular and reliable database system.
Where it gets fun is all the stuff Supabase piles on top to make your life easier.
Spin up a database in seconds. There's no server setup. Click a few buttons and you've got a working database.
Supabase automatically creates an API for your data. You can read and write data from your app without writing complicated database code.
When data changes, Supabase can tell your app instantly. Perfect for chat apps, live feeds or collaborative tools.
Supabase comes with its own authentication system. You could use it instead of Clerk if you'd rather.
Store images and files right alongside your database data.
The real-time feature is what makes Supabase stand out. Let me show you why it's such a big deal.
Picture a chat app. Somebody sends a message, and here's what happens.
Now here's the same thing with Supabase real-time.
You never refresh, and your app never sits there checking over and over. It just works (I know, I know, everybody says that... but this time it's true).