where in the cards table I have a board_id column that references the ID column of the boards table

What is

auth.users.is_super_admin

for?

Exported types and Realtime subscription

Hey, for subscriptions. What's a common pattern for dealing with relations? For example, an intiall query returns a set of objects with populated sub-entities. What's a good way to subscribe to an object and but also refetch the relations. Could that be done as part of the subscription callback? 🤔

If I have a complicated query for loading data including relations. And I have a subscription that I listen to for changes on that. Does it make sense to leverage the payload that comes from the subscription callback? Doing so would require me to patch the local data. Seems more convenient to just rerun the original complicated query. Right?

Partly because I started working on subscriptions before they supported RLS, but also because you pretty much need to reload/update your data everytime a supscription breaks connection for what ever reason, I just use subscription to let me know something changed and to go fetch new stuff with a common call for startup/update/restart. Sometimes I use a record id/count to figure out how much to load versus what is already there.

anyone know how to clone a supabase instance?

Hi, i need to create a admin only custom login, but i can’t figure out how to do it. Dm me if you have any solutions please. Thanks!

Hello! Is there an option to enable the storage UI on the self-hosted version of supabase?

Is it possible to retrieve the access token of a user from the database? I want to send an HTTP request from a PostgreSQL function but I need a mean to authenticate it.

hello! can I create generated columns in supabase? https://www.postgresql.org/docs/12/ddl-generated-columns.html

Since a couple of days I get logged out after a few hours and the page looks like this - anyone else with that issue? It's very annoying.

same

@User Did you try to create the table manually and request the API ? Since a generated column is handled as a normal column during query I think you can use them without more configuration

thank you

does anyone know how to fix cors errors with google oauth signin in supabase? i get redirected to the login but once i select account, it's sending error

hey, did you find a fix? I am facing the same issue

I tried changing stuff from google cloud console as well as supabase api settings, but still facing this issue. did you fix it?

hmm waiting for a few hours worked for me

How do I create multiple projects on a self-hosted instance of Supabase?

My site intermittently is getting this error. I'm at a loss how to debug why this happens (it's inconsistent). What can I look at to debug why this is happening? Just randomly can't connect to the database.

Multiple self-hosed instances

Hi, when using

supabase.auth.session()

with the provider

discord

, is the access_token returned the discord one or like a supabase one?

How could I implement google OAuth like Firebase does. Cause when I implement google login, it redirect me to web page.

I don't want that. How to do the other way like opening a dialogue with our accounts.

I started to self-host Supabase, and I changed the Postgres password. After I've done that (I put the new password in the .env file) Supabase isn't connecting to Postgres at all. What else do I have to change to get it to work?

restart and read the log

it's just a bunch of "connection failed" errors for each container