The Simpler Supabase Alternative

import { createClient } from '@picobase_app/client'

// Zero config — reads from env
const pb = createClient()

import { createClient } from '@supabase/supabase-js'

const supabase = createClient(
  'https://xyz.supabase.co',
  'your-anon-key'
)

// Collection auto-creates on first write
const post = await pb
  .collection('posts')
  .create({ title: 'Hello', published: true })

// Requires table + migration first
const { data, error } = await supabase
  .from('posts')
  .insert({ title: 'Hello', published: true })

if (error) throw error

const posts = await pb
  .collection('posts')
  .getList(1, 20, {
    filter: 'published = true',
    sort: '-created',
  })

const { data, error } = await supabase
  .from('posts')
  .select('*')
  .eq('published', true)
  .order('created_at', { ascending: false })
  .range(0, 19)

// Sign up
await pb.auth.signUp({
  email: 'user@example.com',
  password: 'secure123',
})

// Sign in
await pb.auth.signIn({
  email: 'user@example.com',
  password: 'secure123',
})

// Sign up
const { data, error } = await supabase
  .auth.signUp({
    email: 'user@example.com',
    password: 'secure123',
  })

// Sign in
const { data, error } = await supabase
  .auth.signInWithPassword({
    email: 'user@example.com',
    password: 'secure123',
  })

const unsub = await pb
  .collection('messages')
  .subscribe((e) => {
    console.log(e.action, e.record)
  })

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