hello, I'm doing an admin app where there is no 'sign up' functionality, obviously. And I want to use e-mail/password for auth. So I want to be able to "send invitation" from supabase to a new user to this admin app, and it seems to be working. But when this user gets the e-mail and presses the link, he will be logged in. But he still doesn't have a password, so I want him to come to "create a password" / profile page directly but I'm not sure how to do this. Also, when is there a row in supabase profile table called password? It's not there per default. Please give me some general idea how a workflow for making this happen could look like, thanks!

When I use

signUp

from the browser, Supabase sends a verification email. When using

createUser

, Supabase doesn't seem to send a verification email, but it is still not possible to log in, as the email hasn't been verified. Is there some way I can have the verification email sent?

Hello everyone! I have some actions that run some triggers/functions, for example: 1. Delete a row from a table 2. It fires a trigger pointing to a function 3. That function inserts a row in another table I was wondering if for some reason the (1) delete is completed succesfully, but the (3) inserts fails, Will I end with inconsistent data?, or it will roll back the delete action like if it was a transaction? Thanks in advance guys!

I'm using Twitter API that let user schedule the tweets. To do that I have to store user's twtr auth token in db and every user has their own auth token that is retrieved from twitter. In general devs consider any extra safety net to store those tokens securely ? More context: These user auth tokens are used at the time when the tweet is going to be sent out from their account. Any help is appreciated. Thanks!

Hi guys, Trying out Supabase for a test app, got it setup via docker as per official guide, but ran in to a very big problem. Every time I bring the containers down with docker-compose down and then bring them back up whatever tables or data I had is gone. I'm not a docker expert so a little help would be much appreciated. I see that in the yml file the db volumes points to some init script... so not sure how to assigned /var/lib/postgres/data to a folder than does not get wiped out each time. Thanks!

Hi! I'm currently evaluating Supabase for a project at my university. Unfortunately this isn't just an internal app, it's something that students may want to use as well, so its very likely that this app is supposed to be hosted on the public internet. Unfortunately, as of a recent court decision, (Schrems-II, from EuGH (European Supreme Court), it is no longer allowed to transfer personal data to US cloud platforms under privacy shield. This still allows for private B2C apps to be offered in the EU though However, due to a very recent german court decision, this is no longer possible for public entities, such as gov agencies, which my uni belongs to under law. To be clear: I don't think this will be a university app for quite too long, its a student project and for managebilities sake we have explored Supabase Offerings as an avenue to get started quickly, but from what it looks like, it is expected of us to try your self hosted solution and host via our unis data center. So I was wondering, apart from obviously securing Supabase Studio behind a proxy, is there anything about the standard docker app configuration you provide with docker that we'd need to harden? I understand that you're hesitant on giving too much guidance on self hosted, but it'd be very cool if we could use a PaaS service like this for our project.

If I use the auth-helpers for server side authentication, will I also have to set up client-side as a separate ordeal, or do the auth-helpers cover both?

This is not an isomorphic client right? This should only be run server-side, to prevent the client from obtaining any file they want?

Docs for magic link says "Under Email Auth turn Enable Email Signup to ON", but this doesn't exist in the settings. I am also using supabase UI for the auth UI and I don't see the "Sign in with magic link" link rendered when importing the supabase ui auth. What am I missing?

Is it possible to add users to db (self-hosted) without email authentication process? Self hosted supabase doesn't connect to email thus cannot send out email for verification which brings to catch 22

is it just me or supabase doesn't provide all the same features in the self host? also even storage doesn't seems to be supported in self host.

I see there are banned until column in scheme auth users I wonder how to do that in dashboard

When running

supabase functions serve hello-world

I'm getting the error

Module not found "file:///home/deno/functions/hello-world/index.ts"

. Any ideas how can I fix this to develop locally? I'm on a Mac, using VSCode.

How would I go about getting the download url for a storage item, for example if I wanted to use it in a

src

attribute?

Hi All! I'm developing a chat functionality in my Flutter app and wanted to know your opinions on how to query list of conversations of the current user. I have a table with messages that have rows: sender, receiver etc. I can query messages for a conversation easily but how can I list conversations that current user have? Do you haven any ideas on this?

Is there only a limit to how many files I can store or also how often the files are requested. I'm thinking of using it for a couple of large Images that I don't want to serve serve statically on my website - is there a limit to how many Users this would be possible for with the free tier?

Will edge functions support Node modules once Deno supports that feature?

Hey! I want to self host Supabase, but am unsure where to find instructions on how to do so. Can anyone help?

I have followed the instructions laid out here: https://supabase.com/docs/guides/hosting/docker but during

docker-compose up

I am getting many errors - all related to migration issues and DB connection issues. The

supabase-db

container spun up in Docker outputs following:

ls: reading directory '/docker-entrypoint-initdb.d/': Operation not permitted
ls: reading directory '/docker-entrypoint-initdb.d/': Operation not permitted
ls: reading directory '/docker-entrypoint-initdb.d/': Operation not permitted
ls: reading directory '/docker-entrypoint-initdb.d/': Operation not permitted
ls: reading directory '/docker-entrypoint-initdb.d/': Operation not permitted
ls: reading directory '/docker-entrypoint-initdb.d/': Operation not permitted
ls: reading directory '/docker-entrypoint-initdb.d/': Operation not permitted
ls: reading directory '/docker-entrypoint-initdb.d/': Operation not permitted
ls: reading directory '/docker-entrypoint-initdb.d/': Operation not permitted
ls: reading directory '/docker-entrypoint-initdb.d/': Operation not permitted
ls: reading directory '/docker-entrypoint-initdb.d/': Operation not permitted

and I imagine this is the root cause of all the issues. Has anybody experienced similar issue and know how to resolve?

I already have a directus app with an external postgres db. https://supabase.com/docs/guides/integrations/directus This guide says you can connect supabase with directus.

I'm using Portainer on my server. In Generate API Keys section (https://supabase.com/docs/guides/hosting/docker#generate-api-keys) it's said that you need to replace anon and service keys in

volumes/api/kong.yml

, however I can't really do that. In Portainer, you can create a stack using

docker-compose.yml

, but you can't load files directly for a stack (ie.

volumes/api/kong.yml

). Any suggestions?

Tring to use supabase self hosting, Im running postgre docker on a droplet and connecting this droplet from another droplet. when i setup db connection im getting this error. should i add schemas,dbs manyually? https://github.com/supabase/supabase/discussions/8890

I'm particularly interested in how folks handle keeping their API keys secret?

so I want to check if user has enough balance like ~ declare after_balance numeric; begin select balance into after_balance from profiles where id = new.owner; if (after_balance + new.price) < 0 then raise exception 'You dnt have enough balance'; end if; update balance from profiles SET after_balance WHERE id = new.owner; return new; end; ~ but cant do that because near 'end' ??

Hi, i maintain a selfhosted version of supabase with docker-compose. I use all the latest versions. When i try to enable pg_graphql, i get this error:

function graphql_public.graphql(text,text,jsonb,jsonb) is not a member of extension "pg_graphql"

How do i solve this?

Hey there, have been wondered if using {returning: "minimal"} on update() query on client side is secure enough, I have a table which shouldn't be read by users (selects are handled by a database view) but still when updated returns the original row, and I wanted to make sure that no user can mess with my client side code and see privileged data.

Is it possible to access the Schema Auth with prisma? I'd like to relate a table created in public with the auth users for extra data (profile data).

Hello! I'm playing with Supabase docker deployment. I create my local deployment using the CLI, with the

supabase start

command. I would like to know: - How can I setup secrets? It seems that creating a .env has no effect - Are edge functions working with a local deployment? - Can I use the CLI tools with a docker deployment? I cannot generate an access token from my local Supabase studio, it gives me a 404 error. In general, what doesn't work with docker deployments except the settings page in the studio? Thanks

using this to set the server cookie. don't see anything in the docs

TypeError: Cannot read properties of undefined (reading 'setAuthCookie')
  3 | export default function handler(req, res) {
  4 |   console.log(supabase.auth.api);
> 5 |   supabase.auth.api.setAuthCookie(req, res);
    |  ^
  6 | }

#867322586915799041 hello, im new to supabase. im currently using the free tier to try out a project. i noticed there are a bunch of roles for eg. anon, authenticated, authenticator, pg_monitor, supabase_admin, supabase_auth_admin. i have 2 questions. 1. what are the purpose of these roles / how do i go about using these roles? 2. is there a 60 connection limit to each of these roles in the free tier program? (where can i get more information regarding these roles?) Thank you in advance for helping 🙆‍♂️