*loading an old version on my phone thats unchanged and worked a few hours ago

all seams to be working for me @User might be worth posting in #843999948717555735

Just got an error for upserting data. Think its just an issue on their end right now

hello, is creating two projects for production and staging db still the reccomended approach?

POV: you heard real-time security mentioned in spaces

After hearing what the updates actually were 🔥

I'm having problem with Realtime and RLS on my Supabase project. Only authenticated policy doesn't work and I can't listen any of of my realtime tables. Is there anyone who is facing with same problems?

that was fast

Hi, I'm struggling with the delete subscription, I have no idea why it isn't working. Been tryna debug for an hour now.

js
  React.useEffect(() => {
    if (!room) {
      return
    }
    const onDeleteRoomSubscription = supabase
      .from<Room>(`rooms:id=eq.${room.id}`)
      .on('DELETE', () => {
        toast.success(`Room ${room.title} was deleted!`)
        push('/rooms')
      })
      .subscribe()

    return () => {
      supabase.removeSubscription(onDeleteRoomSubscription)
    }
  }, [push, room])


  const deleteRoom = async () =>
    await supabase.from<Room>('rooms').delete().eq('id', roomId).single()

I can delete a room, but the realtime stuff ain't happening, the code within the subscription, been console logging all over the place 😒

Do other events work? (update, insert etc.)

im using it in navigation, UPDATE on users table

so ye

.on('*', () => { if (payload.eventType === "INSERT") { toast.success(

Room ${room.title} was deleted!

) push('/rooms')} })

maybe you can try like that

sorry "DELETE"

yeah imma check if it happens on all events

yeah, good idea 🙏 🙏

In my project all events are broken actually 🙂

a

god damn

yo boss

@User this works

React.useEffect(() => {
    const onDeleteRoomSubscription = supabase
      .from<Room>('rooms')
      .on('*', () => {
        console.log('Room deleted')
        toast.success(`Room ${room?.title} was deleted!`)
        push('/rooms')
      })
      .subscribe()

    return () => {
      supabase.removeSubscription(onDeleteRoomSubscription)
    }
  }, [push, room])

switching it to delete doesn't work

god damn man 😩 , struggling so much with supabase 😅

everyone on twitter be loving it, but i had such ups and downs with it lul

Did you enabled RLS on those tables?

lemme check boss

nah

idk what that is

It's a new feature. You can protect realtime tables with RLS. Only authenticated user can see the realtime updates etc.