Backend Development with Supabase

Supabase is rapidly gaining popularity as an open-source Firebase alternative. It stands out with its PostgreSQL-based structure and powerful features.

Why Supabase?

PostgreSQL: A real relational database

Row Level Security: Strong security policies

Real-time: Instant data synchronization

Auth: Easy authentication

Storage: File storage

Edge Functions: Serverless functions

Basic Usage

import { createClient } from '@supabase/supabase-js'
const supabase = createClient(
  process.env.NEXT_PUBLIC_SUPABASE_URL!,
  process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY!
)
// Fetching data
const { data, error } = await supabase
  .from('posts')
  .select('*')
  .order('created_at', { ascending: false })// Inserting data
const { data, error } = await supabase
  .from('posts')
  .insert({ title: 'New Post', content: 'Content' })

Authentication

// Email signup
const { data, error } = await supabase.auth.signUp({
  email: 'user@example.com',
  password: 'password123'
})// Google login
const { data, error } = await supabase.auth.signInWithOAuth({
  provider: 'google'
})

Real-time Subscriptions

const channel = supabase
  .channel('posts')
  .on('postgres_changes',
    { event: '*', schema: 'public', table: 'posts' },
    (payload) => {
      console.log('Change:', payload)
    }
  )
  .subscribe()

Conclusion

Supabase is an excellent backend solution for modern web and mobile applications. Being open source and using PostgreSQL makes it different from Firebase.