Supabase

Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, Storage, and Vector embeddings.

Cred

• user: test, pass: XZ9Xcfc4EsfJMvQn

Features

• Unlimited API requests
• Social OAuth providers
• Up to 500MB database space
• Up to 1GB file storage
• Up to 2GB bandwidth
• Up to 50MB file uploads
• Up to 50,000 monthly active users
• Up to 500K Edge Function invocations
• Up to 200 concurrent Realtime connections
• Up to 2 million Realtime messages
• 1-day log retention
• Community support

Auth

• https://supabase.com/docs/guides/auth
• PostgreSQLRow_Level_Security
• Policies act as rule engine.
• Define a rule in the database table like this, auth.uid() = user_id

How It Works#

1. A user signs up. Supabase creates a new user in the auth.users table.
2. Supabase returns a new JWT, which contains the user’s UUID.
3. Every request to your database also sends the JWT.
4. Postgres inspects the JWT to determine the user making the request.
5. The user’s UID can be used in policies to restrict access to rows.

Authentication and Authorization with Sveltekit and Supabase

• https://supabase.com/docs/guides/auth/auth-helpers/sveltekit

Sveltekit example

• https://github.com/supabase/auth-helpers/tree/main/examples/sveltekit