// KynetraDB reference API shape — illustrative, not a migration guarantee
import { createClient } from '@kynetra/client'

const kdb = createClient('https://api.myapp.com', PUBLISHABLE_KEY)

// Example query shape retained from the original research catalogue
const { data, error } = await kdb
  .from('posts')
  .select('id, title, author(name)')
  .eq('published', true)
  .order('created_at', { ascending: false })
  .range(0, 19)

await kdb.auth.signInWithPassword({ email, password })

kdb.channel('live')
  .on('postgres_changes', { event: 'INSERT', table: 'messages' }, payload => {
    console.log(payload.new)
  })
  .subscribe()

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

const supabase = createClient('https://xxxx.supabase.co', ANON_KEY)

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

await supabase.auth.signInWithPassword({ email, password })

supabase.channel('live')
  .on('postgres_changes', { event: 'INSERT', table: 'messages' }, payload => {
    console.log(payload.new)
  })
  .subscribe()