Supabase Features

Supabase is an open-source BaaS platform that provides:

  • PostgreSQL database: A powerful SQL database similar to MySQL.
  • Auto-generated APIs: REST (and GraphQL) endpoints are created automatically from our database schema.
  • Authentication system: Complete user registration, login, and session management.
  • Row Level Security: Database-level permissions that control user-specific data access.
  • Real-time subscriptions: Live updates whenever data changes in our database.
  • File storage: Built-in file upload and management capabilities.
  • Edge functions: Serverless functions for custom back-end logic when needed.

Supabase uses PostgreSQL, which is another SQL database, just like MySQL. All the SQL knowledge we’ve gained transfers directly to PostgreSQL.

Setting up Supabase

Creating Your Project

  1. Sign up: Go to supabase.com and create a free account.
  2. Create a Personal Organisation on a free plan.
  3. Create a project:
    • Select the organisation.
    • Project name: “posts-app”.
    • Database password: This must be a strong password.
    • Region: Choose the closest to your location.
    • Click the Create new project button.
  4. Wait for setup: Project creation takes 1-2 minutes.

Project Dashboard

Once created, you’ll see the Supabase dashboard. The main features can be accessed via the menu on the left.

Tags: