you can execute that in the Dashboard SQL editor

Great, thank you so much again

Yo again

struggling with supabase subscriptions :3

js
  React.useEffect(() => {
    const userOnUpdateSubscription = supabase
      .from(`users:userId=eq.${currentAuthUser?.id}`)
      .on('UPDATE', (payload) => {
        console.log('Change received!', payload)
      })
      .subscribe()

    return () => {
      supabase.removeSubscription(userOnUpdateSubscription)
    }
  }, [currentAuthUser?.id])

Am I doing something wrong here 🤔

When I'm updating the user I'm not seeing the console log

Imma try see if it works for all users and all types of operations

if not then it is something else that's wrong lol

js
  React.useEffect(() => {
    const userOnUpdateSubscription = supabase
      .from('users')
      .on('*', (payload) => {
        console.log('Change received!', payload)
      })
      .subscribe()

    return () => {
      supabase.removeSubscription(userOnUpdateSubscription)
    }
  }, [currentAuthUser?.id])

This doesn't work too, cmon boss 😩

Supabase Subscriptions

Happy thanksgiving everyone!! 🦃 🎉

Happy Thanksgiving, Supabase!

Pre-Launch Week Announcement https://discord.gg/UkHZ7fxU

Pre-launch week live stream

Hey! 👋🏻

Did the call just drop?

Se ya @User!

Hey, Could we have an open-src-for-dummies, with a focus on supabase ofcourse, session or something? Pretty please

🎉 🎉 🧡

What would you want to be in it, maybe I could help 😛

Any update? Happy to create a GH issue for this, but I would expect it to be documented somewhere, especially since self-hosting users would also need to change auth settings like this?

Hey! Sorry if this was asked before, but is there any help needed/wanted for developing supabase-community packages for go? I read there is some development going on apart from postgrest-go

Could you please add an issue in the CLI repo?

Can someone confirm a bug (?) I found? With the JavaScript client, there is a method called

storage.from("").getPublicURL("")

This will however not return the public URL you get from the UI, which ends with the file name, but one that ends on the file id: client:

https://[].supabase.co/storage/v1/object/public/[your bucket name]/[file id]

(also notice how one reads supabase.in and the other one supabase.co) ui:

https://[].supabase.in/storage/v1/object/public/[your bucket name]/[file name]

now the issue is that the url the client returns actually 400s:

{"statusCode":"400","error":"Access Denied","message":"Access Denied"}

I would like to run commands like alter table in an external client like dbweaver. The postgres user doesn't have these privileges, so what would be the best approach? 1. Is it possible to use the supabase_admin user in the external client, if so, how does one get the password? 2. Elevate the postgres users privileges. 3. Create a new user with supabase_admin privileges ?

Not sure if this helps. For createSignedUrl, it is ".../object/sign/...". For getPublicUrl, it is ".../object/public/...". Copy URL in UI seems to create a signed url. Signed urls end with a jwt token "?token=XXX".

@HarryET the process I guess. I've never contributed to open source. I dd clone supabase repo but when i run it, it seems to only show the site without other functionality.. not sure if its a me thing but would love to try get more involved

Select the rows and "Export to csv". Or u can install postgresql-13 and connect directly to the db at port 5432.