Your database,
now alive.

import { createClient } from '@wowsql/js'

const wowsql = createClient(WOWSQL_URL, WOWSQL_KEY)

// Subscribe to INSERT events on messages table
const channel = wowsql
  .channel('chat')
  .on(
    'postgres_changes',
    { event: 'INSERT', schema: 'public', table: 'messages' },
    (payload) => {
      console.log('New message:', payload.new)
      // { id: 42, text: 'Hello!', user_id: '...' }
    }
  )
  .subscribe()

// Broadcast to all connected clients
channel.send({
  type: 'broadcast',
  event: 'typing',
  payload: { user: 'Alice' }
})

// Track who's online — built in
const room = wowsql
  .channel('online-users')
  .on('presence', { event: 'sync' }, () => {
    const state = room.presenceState()
    console.log('Online now:', Object.keys(state).length)
  })
  .subscribe(async (status) => {
    if (status === 'SUBSCRIBED') {
      await room.track({
        user_id: currentUser.id,
        online_at: new Date().toISOString()
      })
    }
  })