Create a New Supabase Project and Basic PostgreSQL Schema

Supabase is a collection of open source tools that wrap around a PostgreSQL database - Hosting, Auth, Realtime, File Storage, Edge Functions etc. In this lesson, we go to database.new to create a free Supabase project.

Additionally, we create a tweets table and populate it with some seed data.

Code Snippets

Create a tweets table

create table if not exists tweets (
  id uuid default gen_random_uuid() primary key,
  created_at timestamp with time zone default timezone('utc'::text, now()) not null,
  title text not null
);

Insert tweets

insert into tweets(title)
values
  ('first tweet'),
  ('second tweet'),
  ('third tweet');

Resources

• Supabase docs
• Supabase SQL Editor