Stack Overflow
Stack Overflow

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
7
votes
1 answer

Can't migrate schema using Prisma with Supabase

When I use the Postgres database on Supabase I run the following command, npx prisma migrate dev --name init, but I get the following error (first command in screenshot): Error: db error: FATAL: bouncer config error 0:…
steve238
  • 831
  • 1
  • 10
  • 19
7
votes
1 answer

Is there RESTful API available for auth features of Supabase

We are trying out Supabase and found it awesome, especially about how easy it is to implement user authentication. So far we have been using the official JavaScript client library and everything we tried works (thumbs up to the devs!). Yet for some…
haochenx
  • 143
  • 1
  • 4
7
votes
3 answers

delete associated records in Supabase

When using Supabase, is there a clean / simple way in which I can delete all associated records together with an item? Say I have Posts and a Post can have many Comments. When I delete the Post I want to delete the Comments as well. Something like…
Sventies
  • 2,314
  • 1
  • 28
  • 44
7
votes
2 answers

NextJS getServerSideProps pagination

I am using NextJS and Supabase for database. I am not sure how to use pagination here. Because the solution I am looking is passing query to the API. I cant do that because I am directly fetching it from database. What is the solution for me…
kelly
  • 115
  • 1
  • 5
6
votes
2 answers

Multiple GoTrueClient instances detected in the same browser context

I'm creating a project with nextjs and supabase. For an unknown reason, I'm getting the following warning in the console: Multiple GoTrueClient instances detected in the same browser context. It is not an error, but this should be avoided as it…
maaajo
  • 839
  • 6
  • 10
6
votes
1 answer

Supabase select and join a 1-1 relation with Typescript support

I have the following select query: return supabase .from("Content") .select(`*, Users (userId, firstname)`) .eq("Users.userId", "Content.userId") .eq("contentId", contentId) .limit(1) .single(); the response object has this…
Vallo
  • 1,827
  • 2
  • 21
  • 42
6
votes
1 answer

INSERT into the table and return id of the record Supabase JS

Based on the docs, inserting a new record const { error } = await supabase .from('countries') .insert({ name: 'Denmark' }) returns { "status": 201, "statusText": "Created" } For columns that are Is Identity, it automatically assigns a…
Jingles
  • 875
  • 1
  • 10
  • 31
6
votes
4 answers

Where can i find the graphiql explorer in Supabase?

Do you know where and how can i use a graphiql explorer to to see my schema and do some graphql request with Supabase ?
Tim
  • 162
  • 2
  • 10
6
votes
1 answer

supabase query for one-to-one foreign key, return single value (not array)

How can I query a one-to-one relationship with foreign key in supabase? My tables: games (id, created_at, played_at) results (game_id, key) Data: games ("id": 1, "created_at": "2022-03-02T11:01:11+00:00", "played_at":…
vikingsteve
  • 38,481
  • 23
  • 112
  • 156
6
votes
2 answers

Supabase: how to query users by eMail?

I'm using Supabase in a Node JS middleware. I am developing an invite function thats receives an eMail address of an existing supabase user via a REST Endpoint. Now it should query the users table in order to get the users ID. But this does not seem…
Niko Fischer
  • 213
  • 3
  • 7
5
votes
1 answer

Supabase signup() fails - signup not allowed

I am trying to signup a new user with email/password. I am on a free tier, and believe I have made the necessary settings. The Flutter code is: Supabase.instance.client.auth.signUp( email: 'abcde@gmail.com', password: 'password', ); I get…
Sunil Gupta
  • 666
  • 6
  • 20
5
votes
1 answer

`supabase start` on Windows failing

I am running Windows 11 and have installed the supabase cli via Scoop per the documentation. I am adding it to an existing repository so I have already ran the below commands with no issue: supabase login supabase init When I go to run supabase…
Azarath
  • 81
  • 6
5
votes
2 answers

How to download table created in supabase

I've created a table in supabase and filled it up with some data, Is there any way to download this table without interacting with supabase client? I want to save this as CSV file for future use but there's no apparent feature to extract the entire…
risky last
  • 385
  • 4
  • 12
5
votes
1 answer

Supabase signInWIthPassword is giving me a 502 error

All auth functions work except signInWithPassword using React, TypeScript, and Supabase. My context: It allows me to signIn, create a profile and move on. I am able to getUser() during the session when logged in. I can signOut as well too. But when…
David Serrano
  • 51
  • 2
5
votes
0 answers

Deno / Postgres "invalid peer certificate contents: invalid peer certificate" error

I'm using deno db to connect to a supabase postgres server. Here's the error from deno deploy. TLS connection failed with message: invalid peer certificate contents: invalid peer certificate: UnsupportedCertVersion Defaulting to non-encrypted…
ThomasReggi
  • 55,053
  • 85
  • 237
  • 424
1
2
3
…
80 81