How does exactly

test db

work? I am trying to

\include

sql files but it cannot find it.

Hi everyone I am having a really weird error. When I use the script to generate the types on my React Client, and after it a run again the app I get a type error on lines that aren't included on the the types file. We are 2 developers and I am the only one experience it even with a fresh project (Downloading from the repo, npm instal and then I run the script for generating types). Can someone help me with this ? Thank you so much 🙂

Woke up and my data from https://til.arvrtise.com no longer displays. Was my account locked or flagged for something?

https://stackoverflow.com/questions/46619510/how-can-i-download-image-on-firebase-storage here a link , I want to download the image from the img url directly to storage is it possible ?

Hi! We have just started using supabase for our project. I am curious about how to solve schema migrations when collaborating on the same project. We have e2e tests running on every pull request and on every merge to the main. I saw that it is recommended to use 2 separate projects, but how can we manage to try out our schema changes on pr-s without messing up each others work? I saw that branching will be available in the future, but can someone please recommend a solution in the meantime?

Looking for the simplest and fastest way to do this

Hello, I can't import openai with esm.sh. I have an error message telling me that I have a problem with axios. Do you have any idea how to patch the problem?

When using Supabase, postgres database logic is such an integral part of the solution. Is there a recommended way to create automated tests for PL/PGSQL? I was thinking testing RLS, policies, functions etc...

As the title says really, is it possible to remove items from storage from within a pl/pgsql function? When a user wants to close their account I have a database function I call as the process for closing an account is quite involved. As part of this I want to go into storage and delete all their files and avatars they've uploaded. They have a folder unique to their account so that bit is easy, it's just not going to be practical or desirable to delete all their media using supabase-js storage API. While I'm in my close account pl/pgsql function, it would be great if I could just find their folder and kill it. Any suggestions?

Is anyone using the singleton pattern for using all services from supabase in React or Nextjs as i want to implement this to reduce import costs in my project as this will reduce my bundle size and also the efficiency of my project

hello, I have a question that I seek help with. I deployed Supabase on digital ocean droplet and it is working fine, however, I did lose the jwt of it and I need to create anon API key and service key. I followed this guide for deploying but don't seem to know exactly what I should do if I lost the jwt, and I don't want to re-deploy another instance or lost data from my Supabase instance, is this possible? I'm at the point where I can open the console UI of the droplet: ![image]() Thank you in advance.

Hello guys, We were checking what version of Postgre is running for a future migration, when we did a simple SELECT VERSION();, we got that as a response: PostgreSQL 14.1aarch64-unknown-linux-gnu,compiled by gcc (Ubuntu 10.3.0-1ubuntu1~20.04) 10.3.0, 64-bit It feels like there are 2 ubuntu version running, could any one enlight me if that means the Postgre Database, on Supabase, is running on a machine with Ubuntu 10.3.0 ? Thank you, Chris

tried to create it too. but it keeps showing an error. i am trying to convert intervals to strings. would appreciate some help. thanks!

Hiya. Obligatory first time poster! I currently attempting to login users with a social oauth flow and am finding that the provider token is lost after a session refresh, which is mentioned in the Supabase docs. I am trying to persist the provider_token and provider_refresh_token within the user_metadata. I'm listening to auth events and trying to refresh my provider token when Supabase refreshes it's token. The provider refresh is working as expected and storing the new tokens in the user_metadata, but the session passed in local storage does not reflect the most up-to-date data stored in the database. Is there a way I can tell Supabase to update the local session data when the updateUser() method is called? Is there a better way to accomplish what I am trying to do? I am using SvelteKit and the associated auth-helpers v0.9.0

I am talking about production code not development code.

I have a text column define as array: ["string1", "string2"] I would like to know how to update the array with a new string using the supabase api to get this: ["string1", "string2", "string3"] Thanks for the help

Is there a way to white label / brand magic links? I don't see it in the docs and it doesn't seem like paid plans offer that either. It looks kind of unprofessional and raises some questions among corporate users when they get emails with supabase.app host instead of the one they signed from.

Hey I'm trying to find a way to select with distinct just like in SQL using supabase python client something like:

py
supabase.table("foos").select("bar").distinct()

any idea how?

My goal was to use docker for my local development stack and then host the services on Supabase Cloud for production. I wanted to use docker so that there was less "magic" in my stack and I could also have more control. Is there any way your can use the cli command

supabase link

with a self hosted project rather than the typical local installation? I think the only valuable thing this would enable you to do would be to easily migrate your database from development to production. Maybe I could do this manually? I would appreciate any insight on this. Thanks all!

Pls Help fast my website is going down

Unable to create a table "relation already exists" Hi guys. I'm trying to create a new table but get the error message that the table already exists, but it isn't visible in the UI. Have someone encountered something similar?

Hello all, relatively new to supabase and I'm currently building a project on Next13 with the new experimental app dir. I'm trying to validate a user when a request is sent to an endpoint within the page/api folder, however I'm having issues with most things I've tried. I've done .getUser and .getSession but am having no luck. I did confirm in the console that I have my auth cookie on the api request page. But the session and user functions always return null. Any thoughts on how I can possibly resolve this?

There any way to change the mutations name? I spend a hole hour to see the graphql insert table name need to be lower case

I am using Next 13 (appdir) and Supabase to create an application where users can upload data to their profile. For this, I created a form, which collects the data and passes it though a useState (for which I require client side rendering), but then I need to write this to Supabase, which to my knowledge requires an async function and therefore needs for the component to be on the server. Does anybody have any tips as to how to go about this and can point me in the right direction?

Have anyone worked with supabase in mono-repo? My client is react and edge functions is deno. Enabling deno plugin, makes VScode not complete import statements, command-click, and so on in react.

I am very used to cmd + clicking to see the code, types etc in vscode. How do we do it in deno?

I'm getting this error when trying to log in I've verified multiple times that my email is in the database so that's not the issue. What gives?

Log ID
...

Log Timestamp (UTC)
2023-03-13T20:41:02.000Z

Log Event Message
{"component":"api","error":"error finding user: ERROR: column users.deleted_at does not exist (SQLSTATE 42703)","level":"error","method":"POST","msg":"500: Database error finding user","path":"/otp","referer":...}

Log Metadata
[
  {
...
    "timestamp": "2023-03-13T20:41:02Z",
....
    "method": "POST",
....
    "msg": "500: Database error finding user",
...
    "path": "/otp",
    "component": "api",
...
    "error": "error finding user: ERROR: column users.deleted_at does not exist (SQLSTATE 42703)"
  }
]

I have a primary project with DB. I can connect, migrate, seed, and the query tables. I make second 'stage' project. I configure and then run prisma migrate in local dev terminal. It ack's that migration was successful AND points to correct DB URL. HOWEVER, when I go to look at the migrated tables, there are no tables. I am running on Vercel. I am pointing to same DB URL AND it is loading data that was seeded. STRANGE! My app sees the data using DB URL but I do not see any tables in the Supabase Dashboard.

I am trying to set up native sign in on Flutter. I have the apple side working fine, but for the google side I cannot figure out how to pass a nonce. I am following the recommended codepath as far as I can tell. Any help? @DanMossa

I have downloaded my TS schema, now how should I pass a specific row type to useState so TS doesn't complain?

ts
  const [todos, setTodos] = useState<???>([])
  useEffect(() => {
    supabase
      .from("todos")
      .select()
      .then((res) => {
        setTodos(res.data);
      });
  }, []);