I am considering switching my project to use Supabase but I need to be able to connect from PostgreSQL to remote database to query for data. For example, MySQL. Do Supabase PostgreSQL databases support the extension(s) for doing so?

Is there a way to get session info after a signup using

supabase.auth.api.createUser()

Is there a way to read a random line with the supabase API?

did any one know why i cant acsses objects inside array ?

Can't seem to edit or delete rows via UI anymore, was able to yesterday

Hoping someone can confirm what I'm experiencing is working as intended: 1) User clicks on reset password which uses the email recovery function

let { data, error } = await supabase.auth.api.resetPasswordForEmail(email)

2) After the link in the email is clicked I should be redirecting the user to an update password form (yet to be implemented) 3) At this point though, without updating the password, I can still sign in with the old password. Will the old password still function since the old one hasn't been changed despite the user clicking the reset password link from the email?

any one know how to add array foreinkeys in supabase

o/ question is there any way to run code when a row in a table is created?

Hey. If I have a jsonb field in my table, is it possible to do an

update

on it that will only update existing fields or add new ones? I want it to act as a PATCH rather than a PUT

How can I add more custom External Authentication Providers? im intrested in Steam, Nintendo, Epic, Play Station Network and Xbox

Hey folks, does the supabase-js have a way to call edge functions built-in?

How to add Supabase database into Google Data Studio's data source?

Hi, how can i prevent so only I can login? With email magic link? I tried with my other email and it got an email aswell. I will go into authentication where I have my user already, and if that matches or something with the email then send magic link otherwise you will not be able to login, or signup. defenitly not signup.

When I click on forgot password, the recovery token is populated in the auth.users table for the respective row. And then when you click the email link, that token ID is the refresh token found in the URL of the redirect and is also removed from the auth.users row. My logic is that I verify the access token against my JWT secret and then that the type=recovery and also check whether the user types the same password twice. But what use is the refresh token? I've been trying to research what it's for and how I use it but I'm not finding many answers. Any leads on where I can learn more?

Hi everyone, is there a way to execute

supabase db reset

BUT on the Remote DB?

is it possible/suggested/safer to change SERVICE_KEY and ANON_KEY in the supabase/cli? if so, how can one generate new ones? they seem to be hardcoded in the go source code

Is there a guide somewhere on taking a Supabase Platform project and "exporting" all the stuff there to your local filesystem so you can either run it locally or push to another Project? I'm looking at running my first project and want devs to have a shared environment but also be able to push it to a separate Production environment later. Or have the option to pull it down and run their Functions locally while working on changes

is there a guide to migrate Authentication out of firebase and into supabase / stytch ?

Hi all! I'm working on the tech stack at arketa.co (YC S20 batch mates 😄 ) -- I'd love to give supabase a shot and finally think I found something worthy! We're building some analytics tools for our customers, and compound queries in firestore are becoming impossible (mutliple "IN" filters in a single query) where having a sql queryable db would work well. I'd like to keep firestore for application data, but replicate some collections in supabse for querying abilities. What's the best way to do this? I'm thinking of having a simple document trigger on firestore that then updates a row in supabase. what do you all think?

I'm running Supabase CLI 0.26.0, with Docker images:

supabase/studio:latest
supabase/postgres-meta:v0.33.2
supabase/pgadmin-schema-diff:cli-0.0.4
supabase/storage-api:v0.15.0
postgrest/postgrest:v9.0.0.20220211
supabase/realtime:v0.22.4
inbucket/inbucket:stable
supabase/gotrue:v2.6.18
kong:2.1
supabase/postgres:14.1.0.21

I have a table

discovery.nfts

and a table in

public.likes

that has a foreign key to

discovery.nfts

. I am running a DDL migration that alters the schema, and now I'm getting warnings for PostgREST that the relation between

public.likes

and

discovery.nfts

cannot be found. I tried both

docker kill -s SIGUSR1 <postgrest container id>

NOTIFY pgrst, 'reload schema';

I confirmed that PostgREST said the schema was reloaded, but I still get the error

Hey! Does something like a

unique_together

constraint exist in Supabase? I'm working with a

habit-entries

table that has a habit, date, and user row. It stores which habits a user did on which date. To avoid duplicate entries I'd like to add a

unique_together

constraint for like in Django: https://docs.djangoproject.com/en/4.0/ref/models/options/#unique-together (in this case it would be

unique_together = ['user_id', 'habit_id', 'date']

) Is this possible and if so can someone redirect me to the resource/tutorial? I couldn't find anything😅

anyone know what the expected format is here? using something like '2022-06-16T16:25:39.000Z' does not seem to work

Is there a plpgsql equivalent to js toPrecision()? https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Number/toPrecision

Hi everyone, I am just getting started with Supabase and having some difficulties setting up my local environment. I initially followed the instructions on the documentation, got local changes migrating to remote, but when I tried to add changes to the online version through the dashboard, I can't find a way to bring those onto my local machine. During playing around with the various commands, I got an error message that told me the migrations on remote was out of sync and to delete the rows on that schema and try again. I did that and no luck. I then tried to remove all files from the local system and start again, but I now get this error when even following the local development instructions: $ supabase remote set 'xyz' $ supabase db remote commit $ supabase db reset Error: Error resetting database: ERROR: cannot drop function graphql.build_delete(jsonb,jsonb,jsonb,text,text) because extension pg_graphql requires it HINT: You can drop extension pg_graphql instead. Any ideas on what I can do to fix this? Thanks

Hello everyone! I have setup cron jobs and calls to an external API following the approach on this page: https://supabase.com/blog/2021/03/05/postgres-as-a-cron-server. With that being said I am concerned about the security of my API token. Especially if I decide to go multi-tenant and store an API key for each user so they can connect to an API and access data specific to them. What is the recommended approach for ensuring that the API key is encrypted and can then still be used to do the API calls when the cron job executes?

Unable to receive results from real-time subscription

Hi, is there a way to access the query parameters from the client on row level security? For example: I want to deny queries, that select every record in the table, but I want to allow queries, that select a specific record with an id.

Hey, is there a way to create sync authentication between two different react apps with Supabase? Like when I (log in /log out) of one app, it (log in / log out) of the other app.

Hi! I am using a

count

and noticed that it is

"exact"

in the docs. I was wondering if there were other options, like

"estimate"

that could make my request faster. Example:

js
.select('*', { count: 'exact', head: true })

Is there a way to disable magic link sign ups / sign ins?