Course lesson
Supabase handles hosting a database, authentication, authorization, file storage, realtime, edge functions, database functions, triggers and webhooks - lots of ways to build apps and automate backend stuff.
Supabase handles hosting a database, authentication, authorization, file storage, realtime, edge functions, database functions, triggers and webhooks - lots of ways to build apps and automate backend stuff.
In this lesson, we head over to database.new to create a new Supabase project. Additionally, we use the dashboard to easily create a new table for our messages. We talk through some different data types and constraints that can be applied to columns. Lastly, we populate our new table with some example messages.
SQL code snippets can be run against your Supabase database by heading over to your project's SQL Editor, pasting them into a new query, and clicking
RUN.
Create a messages table
Insert messages
Course lesson
Supabase handles hosting a database, authentication, authorization, file storage, realtime, edge functions, database functions, triggers and webhooks - lots of ways to build apps and automate backend stuff.
create table if not exists messages (
id uuid default uuid_generate_v4() primary key,
created_at timestamp with time zone default timezone('utc'::text, now()) not null,
content text not null
);insert into messages(content)
values
('first message'),
('second message');