🗄️
CC10045 min

Day 26

Setting Up Supabase

Time to add a database!

Today's Lesson

Supabase is a database that's easy to use - like a spreadsheet that code can talk to. Your contact form submissions need somewhere to live. Today, you'll set that up.

Today's Tasks

  1. 1Create a Supabase account and project
  2. 2Create a table for contact form submissions
  3. 3Get your API credentials
  4. 4Add them to Vercel environment variables

Prompt to Use

Help me set up Supabase for my portfolio:
1. Walk me through creating an account and project
2. Create a table called 'contacts' with columns for name, email, message, and created_at
3. Show me where to find my API credentials
4. Help me add them to Vercel as environment variables

Expected Outcome

Supabase project with contacts table, connected to Vercel.

New Terms

  • Supabase
  • Database
  • Table
  • API Credentials
  • Row Level Security

Pro Tip

Supabase has a visual table editor. You can see your data like a spreadsheet.

Coming Tomorrow

We'll save form submissions to the database.

P.S. Databases used to require serious server knowledge. Supabase made it accessible to everyone.