BaaS Service User Guide

JavaScript / TypeScript

• Installation

  npm install @supabase/supabase-js

• Initialization and data operations

  import { createClient } from '@supabase/supabase-js'
  
  const supabase = createClient(
    '<YOUR_SUPABASE_URL>',
    '<YOUR_SUPABASE_ANON_KEY>'
  )
  
  // Sign up
  const { data: { user } } = await supabase.auth.signUp({
    email: 'user@example.com',
    password: 'password123'
  })
  
  // Sign in
  const { data: { session } } = await supabase.auth.signInWithPassword({
    email: 'user@example.com',
    password: 'password123'
  })
  
  // Insert data
  const { data } = await supabase.from('todos').insert({
    title: 'Learn Supabase',
    done: false
  }).select()
  
  // Query data
  const { data: todos } = await supabase.from('todos')
    .select('*')
    .eq('done', false)
    .order('created_at', { ascending: false })
  
  // Update data
  const { data: updated } = await supabase.from('todos')
    .update({ done: true })
    .eq('id', 1)
    .select()
  
  // Delete data
  await supabase.from('todos').delete().eq('id', 1)
  
  // Real-time subscription
  supabase.channel('todos-changes')
    .on('postgres_changes', {
      event: '*',
      schema: 'public',
      table: 'todos'
    }, (payload) => {
      console.log('Data changed:', payload)
    })
    .subscribe()
  
  // File upload
  await supabase.storage.from('avatars').upload('user1/avatar.png', file)

Python

• Installation

  pip install supabase

• Initialization and data operations

  import os
  from supabase import create_client, Client
  
  url: str = os.environ.get("YOUR_SUPABASE_URL")
  key: str = os.environ.get("YOUR_SUPABASE_ANON_KEY")
  supabase: Client = create_client(url, key)
  
  # Sign up
  res = supabase.auth.sign_up({"email": "user@example.com", "password": "password123"})
  
  # Sign in
  res = supabase.auth.sign_in_with_password({"email": "user@example.com", "password": "password123"})
  
  # Insert
  supabase.table("todos").insert({"title": "Learn Supabase", "done": False}).execute()
  
  # Query
  response = supabase.table("todos").select("*").eq("done", False).order("created_at", desc=True).execute()
  
  # Update
  supabase.table("todos").update({"done": True}).eq("id", 1).execute()
  
  # Delete
  supabase.table("todos").delete().eq("id", 1).execute()
  
  # File upload
  supabase.storage.from_("avatars").upload("user1/avatar.png", file_data)

Flutter / Dart

• Installation

  flutter pub add supabase_flutter

• Initialization and data operations

  import 'package:supabase_flutter/supabase_flutter.dart';
  
  Future<void> main() async {
    await Supabase.initialize(
      url: '<YOUR_SUPABASE_URL>',
      anonKey: '<YOUR_SUPABASE_ANON_KEY>',
    );
    runApp(MyApp());
  }
  
  final supabase = Supabase.instance.client;
  
  // Sign up
  await supabase.auth.signUp(email: 'user@example.com', password: 'password123');
  
  // Sign in
  await supabase.auth.signInWithPassword(email: 'user@example.com', password: 'password123');
  
  // Insert
  await supabase.from('todos').insert({'title': 'New task', 'done': false});
  
  // Query
  final data = await supabase.from('todos').select().eq('done', false).order('created_at');
  
  // Update
  await supabase.from('todos').update({'done': true}).eq('id', 1);
  
  // Delete
  await supabase.from('todos').delete().eq('id', 1);
  
  // File upload
  await supabase.storage.from('avatars').upload('user1/avatar.png', file);

Swift

Initialization and data operations

import Supabase

let client = SupabaseClient(
  supabaseURL: URL(string: "<YOUR_SUPABASE_URL>")!,
  supabaseKey: "<YOUR_SUPABASE_ANON_KEY>"
)

// Sign up
try await client.auth.signUp(email: "user@example.com", password: "password123")

// Sign in
try await client.auth.signIn(email: "user@example.com", password: "password123")

// Insert
try await client.from("todos").insert(["title": "New task", "done": false]).execute()

// Query
let todos: [Todo] = try await client.from("todos").select().eq("done", value: false).execute().value

// Update
try await client.from("todos").update(["done": true]).eq("id", value: 1).execute()

// Delete
try await client.from("todos").delete().eq("id", value: 1).execute()

Kotlin

Initialization and data operations

val supabase = createSupabaseClient(
    supabaseUrl = "<YOUR_SUPABASE_URL>",
    supabaseKey = "<YOUR_SUPABASE_ANON_KEY>"
) {
    install(Auth)
    install(Postgrest)
    install(Storage)
}

// Sign up
supabase.auth.signUpWith(Email) { email = "user@example.com"; password = "password123" }

// Sign in
supabase.auth.signInWith(Email) { email = "user@example.com"; password = "password123" }

// Insert
supabase.from("todos").insert(Todo(title = "New task", done = false))

// Query
val todos = supabase.from("todos").select { filter { eq("done", false) } }.decodeList<Todo>()

// Update
supabase.from("todos").update({ set("done", true) }) { filter { eq("id", 1) } }

// Delete
supabase.from("todos").delete { filter { eq("id", 1) } }

C#

Initialization and data operations

var url = Environment.GetEnvironmentVariable("YOUR_SUPABASE_URL") ?? throw new InvalidOperationException("Environment variable YOUR_SUPABASE_URL is not set.");
var key = Environment.GetEnvironmentVariable("YOUR_SUPABASE_ANON_KEY") ?? throw new InvalidOperationException("Environment variable YOUR_SUPABASE_ANON_KEY is not set.");
var supabase = new Supabase.Client(url, key);
await supabase.InitializeAsync();

// Sign up
await supabase.Auth.SignUp("user@example.com", "password123");

// Sign in
await supabase.Auth.SignIn("user@example.com", "password123");

// Insert
await supabase.From<Todo>().Insert(new Todo { Title = "New task", Done = false });

// Query
var todos = await supabase.From<Todo>().Filter("done", Operator.Equals, "false").Get();

// Update
await supabase.From<Todo>().Filter("id", Operator.Equals, "1").Update(new Todo { Done = true });

// Delete
await supabase.From<Todo>().Filter("id", Operator.Equals, "1").Delete();