Questions tagged [supabase]

Supabase is a collection of open source tools to build modern applications quickly and efficiently. It uses the PostgreSQL database to power its authentication, database, and storage features. Use this tag when you are having problems, and not to ask for new features.

Supabase is a combination of open source tools. It builds the features of Firebase using enterprise-grade, open source products. Supabase is not a 1-to-1 mapping of Firebase. Its aim is to give developers a Firebase-like developer experience using open source tools.

Supabase has an official JavaScript library as well as community built Dart, Rust, Kotlin, C# and Python libraries.

Supabase is composed of four components

  • Database
  • Authentication
  • Storage
  • Functions (coming soon)
1213 questions
4
votes
1 answer

Unable to push local migrations to Supabase through CLI

I tried to push the local migrations to the supabase database through its cli with the command supabase db push. The error it is showing me is: Error: ERROR: must be owner of table users (SQLSTATE 42501) I had set up the cli with supabase db remote…
Electric Dragon
  • 176
  • 5
  • 17
4
votes
2 answers

How to run Supabase on AWS?

I'm looking for any tutorial or how to guide on deploying Self Hosted Supabase with AWS. Trying to use the Postgres RDS but it doesn't have pgjwt plugin and we can't install it on manage service like RDS. Any link will be very helpful, thank you
dts
  • 153
  • 1
  • 7
4
votes
1 answer

Next JS + Supabase real time subscription subscribes with state "closed"

I am working on this helpdesk for a school project using Next JS and Supabase and got stuck on realtime chat between the operator and the client. I subscribe to the table in useEffect hook and return the unsubscribe function to clean up. But when i…
vskorepa
  • 53
  • 3
4
votes
1 answer

"Uncaught Error: More than one relationship was found" with Supabase client query

I'm building a multitenant app and running into an error after adding multiple relations that point to the same table: Uncaught Error: More than one relationship was found for teams and users When performing this query: const data = await…
tdc
  • 5,174
  • 12
  • 53
  • 102
4
votes
1 answer

Supabase set password after email invite

In a Supabase app, I want to invite users (instead of them signing themselves up). I can invite a user with their email, but they get sent a link which directly authenticates them (like a magic link). I rather have the user set their password the…
Sventies
  • 2,314
  • 1
  • 28
  • 44
3
votes
1 answer

How to make a boolean form input in supabase using nextjs server actions?

I am trying to make a form to submit data to supabase (with nextjs 13). I can submit a string input. I am trying to add a boolean field. I have commented out the 'published' fields in this form. If I try using this approach, and enter any of 'true'…
Mel
  • 2,481
  • 26
  • 113
  • 273
3
votes
1 answer

Create recursive view with WHERE clause

I am trying to make a view for my recursive query, and use the view with a where clause to set a starting point. CREATE TABLE dog ( id int, name varchar(50) ) CREATE TABLE dog_parent ( id int, dog_id int, parent_id int, ) This…
skorpio
  • 179
  • 1
  • 6
3
votes
1 answer

Can't update an image from the bucket

I've been trying to update a single file within a folder in the bucket that i created but when i go to update with a new image from the front does not update the image and gives the following error. statusCode: "404", error: "Not found" Then when i…
Richi
  • 438
  • 5
  • 18
3
votes
1 answer

Error when trying to call a supabase edge function

I am trying to call a supabase edge function in javascript but I am getting this error: access to fetch at 'https:/blablala.functions.supabase.co/hello-world' from origin 'http://localhost:5173' has been blocked by CORS policy: Response to…
3
votes
1 answer

Dynamic social sharing cards populated in

I've built a blog website and am trying to implement dynamic social share cards for each individual blog. While everything appears to be working properly when I inspect the head element in developer tools, when I do a live test or run the link…
jrfii
  • 41
  • 3
3
votes
1 answer

How to deploy all Supabase edge functions at once?

I have multiple Supabase edge functions I want to deploy simultaneously when I push to production. These are all the functions in my .supabase/functions folder, ie: .supabase functions my_function_1 index.ts …
3
votes
1 answer

Supabase Google auth integration with Capacitor (React) for iOS

I am trying to integrate Supabase Google Auth into my Hybrid app built with Capacitor. It is working fine for web, but I am not able to get it working for iOS. There isn't any documentation around this as well. I've tried to change the redirect URL…
3
votes
3 answers

Supabase Generate Types Failing

I am trying to run the command to update my typing via cli and it continues to give me the following error but when I debug this is all I get. Not much to work with. 2023/03/01 09:34:01 Recv First Byte Error: failed to retrieve generated types:…
Luke Longo
  • 119
  • 1
  • 7
3
votes
1 answer

Deno import_map.json for supabase

I try to work with supabase edge functions in a Deno environment in IntelliJ Ultimate. The corresponding plugin is already installed but inside my supabase folder the functions I wanna create do not support Deno IntelliSense which makes things quite…
Markus G.
  • 1,620
  • 2
  • 25
  • 49
3
votes
1 answer

Failed to create and edit tables in Supabase, "Failed to create pg.columns:..."

I have failed to create or edit tables in Supabase. It is showing an error message "Failed to create pg.columns: must be the owner of event trigger pgsodium_trg_mask_update". I think it has something to do with the launch of supabase vault, but I…
Charles Kasasira
  • 240
  • 1
  • 5
  • 15