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.
1,791
questions
5
votes
1
answer
4k
views
Is there a way to perform full text search on multiple columns on Supabase with Javascript?
I've tried using many symbols to separate columns; ||, |, &&, & with and without spaces.
For instance
.textSearch("username, title, description", "...");
.textSearch(&...
- 55
5
votes
2
answers
4k
views
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 ...
5
votes
1
answer
4k
views
How To Update Entire Row In Supabase Table? (Getting 400 Error)
I am trying to make an input form where the user can change several values in one row simultaneously which get submitted to the database using the update() method. The values are being read from the ...
- 197
5
votes
1
answer
7k
views
Issues with Dagger Hilt and KSP in Android Kotlin Project: Cannot Resolve Symbol ‘Inject’
I’m working on an Android project with Kotlin and using Dagger Hilt for dependency injection. Recently, I’ve attempted to migrate from kapt to KSP (Kotlin Symbol Processing) for code generation, as ...
- 101
5
votes
1
answer
4k
views
How to check email already exists in Supabase table for signup in flutter?
Here I tried to move from firebase to Supabase in my flutter project.
I stuck on first stage.
onPress register button,
final response = await Supabase.instance.client.auth.signUp(email,pass);
This is ...
- 393
5
votes
2
answers
891
views
Only allow read if user has exact document id postgresql row level security/supabase
Is there a way for a user to only be able to read a document only if they have the exact document ID?
I want to avoid creating users, so the only security is a random guid saved in browser memory - ...
- 1,131
5
votes
1
answer
3k
views
`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 ...
- 91
5
votes
1
answer
2k
views
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 ...
- 310
5
votes
2
answers
3k
views
How to change the redirecting url for Google OAuth with supabase?
I am trying to set up a website with supabase using Google OAuth for authentication.
It's fairly easy and convenient to set up and works really well, by following this tutorial and consulting the docs....
- 1,238
5
votes
2
answers
2k
views
How to pass in parameters from client side to server side code in Sveltekit?
I've been trying to run a query to a Supabase database that needs a dog breed passed through and will return metrics about it, the breed is defined on the client side. I was able to get the server ...
- 63
5
votes
1
answer
2k
views
Access supabase database from edge function as admin
I'm coming from Firebase Function... Where I can use the Admin Library to access database from the Function bypassing all security rules? On supabase I didn't yet find a way to do that, the ...
- 160
5
votes
1
answer
191
views
Run slow background process when certain conditions in Postgres data are met?
I'm using Postgres (via Supabase) and Node (via NextJS on Vercel).
I have a table report which has columns for an enum region, and generated_text which is content generated by AI.
create type region ...
- 23.2k
5
votes
2
answers
3k
views
How to pull data from my production supabase database into my local supabase database
I have been trying to fix this problem, I could not search any documentation for this specific problem. I have everyhing setup, the project is linked, the docker is running, I just can not figure out ...
- 121
5
votes
2
answers
524
views
Error in handling error messages for login: http://localhost:3000/auth/login net::ERR_ABORTED 405 (Method Not> Allowed)
I have this /app/auth/login/route.ts
import { createRouteHandlerClient } from '@supabase/auth-helpers-nextjs'
import { cookies } from 'next/headers'
import { NextResponse } from 'next/server'
export ...
- 1,729
5
votes
1
answer
1k
views
How to upload file from python Flask web app to Supabase Storage
I want to be able to upload a file from Flask to Supabase Storage, but it only has documentation for the javascript api link to docs.
Also, I can't find any examples or any open source project that ...
5
votes
1
answer
2k
views
Supabase third party oAuth providers are returning null?
I'm trying to implement Facebook, Google and Twitter authentication. So far, I've set up the apps within the respective developer platforms, added those keys/secrets to my Supabase console, and ...
- 3,636
4
votes
1
answer
2k
views
Cannot destructure property 'supabaseUrl' of 'getConfig(...)' as it is undefined
I followed @supabase/auth-helpers-sveltekit guide on how to integrate supabase-auth helpers with sveltekit.
Yet, when running the dev server, I get an internal error
Cannot destructure property '...
- 800
4
votes
2
answers
5k
views
Nexts.js 13 + Supabase > What's the proper way to create a user context
I'm building an app with Next.js 13 and Supabase for the backend, and I've been stuck on figuring out the best/proper way to go about creating a context/provider for the current logged in user.
The ...
- 338
4
votes
1
answer
6k
views
Supabase: How to automatically update a timestamp field after updating a row?
What DB I am using?
Supabase hosted version
What do I need?
After I update a row with .update({ name: 'Middle Earth' }) method I need to
automatically update also a timestamp in my table.
How can ...
- 2,042
4
votes
2
answers
1k
views
Sveltekit,Supabase and Vercel (problem with Supabase when deploying to Vercel)
I'm trying to set up Sveltekit, Supabase and Vercel.
It works correctly on a local environment (SvelteKit and Supabase), but when I deploy it to Vercel there is a problem with Supabase - "Error: ...
- 517
4
votes
1
answer
412
views
Supabase Auth UI: show the sign up UI not the sign in UI?
I am using Supabase Auth UI as the login / sign up auth provider for my website.
Currently the Auth UI always shows the login button. I can get onto the sign up UI by clicking "Don't have an ...
- 55
4
votes
1
answer
6k
views
supabase.auth.getUser() returns error on vue-router route guard
I am attempting to build a Vue application that uses Supabase authentication. Inside one of the route guards in the router file, I implemented supabase.auth.getUser() in order to retrieve the user ...
- 1,699
4
votes
1
answer
5k
views
Update multiple rows in a single query in a Supabase Database (postgres)
I looking to update multiple rows via a single query in Supabase. I'm struggling to find an example of how to do it online.
For this example here is how the data exists the database's 'food' table:
...
- 323
4
votes
1
answer
3k
views
Transactions in supabase
I have two tables that reference each other. For the sake of example, say they're Posts and Comments:
Posts
-----
id bigint
title text
body text
Comments
--------
id ...
- 2,600
4
votes
1
answer
5k
views
How to insert timestamp without timezone using Supabase-JS client?
I want to insert current timestamp without timezone to Supabase.
I know I can set default value of the timestamp column to NOW() but
there can be some delay in the timing and I need it precise.
I ...
- 2,042
4
votes
1
answer
2k
views
supabaseUrl is required sveltekit
I'm having this problem for quite a while and want to solve this:
According to supbase documentation you create a .env file
VITE_SUPABASE_URL="YOUR_SUPABASE_URL"
VITE_SUPABASE_ANON_KEY="...
- 164
4
votes
1
answer
2k
views
"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 ...
- 5,274
4
votes
2
answers
1k
views
Auth in chrome extension with supabase
I am currently working on a Chrome extension that relies on a web application for user login. The web application leverages Supabase and the Google provider for user authentication. I have ...
- 95
4
votes
2
answers
897
views
Supabase realtime connection failing when custom JWT is used
I'm using supabase self-hosted and auth0 for my authentication instead of the default authentication provided by supabase. So I'm signing my auth0's payload with supabase secret and sending it in ...
- 321
4
votes
4
answers
2k
views
Supabase Edge function says no body was passed
I'm invoking a supabase edge function with the following
async function getData(plan_data){
console.log(plan_data)
console.log(JSON.stringify({plan_data}))
const { data, ...
- 63
4
votes
1
answer
1k
views
How to use bigint safely with Supabase JS
Postgres' bigint type holds 64 bit integers. But the Supabase JS library returns those values as JS numbers, which cannot safely store 64 bit integers AFAIK. What would be the correct way to handle 64 ...
- 1,133
4
votes
1
answer
2k
views
Supabase dynamic RPC function
I am looking to create an RPC for grabbing distinct values of a column but I am going to be doing this across multiple tables and I don't want to have to write this function over and over for each ...
- 1,124
4
votes
1
answer
1k
views
Supabase database size issue [closed]
I am quite new to Supabase.
Please clarify this:
I have a table in the database and its only 32KB in size.(2 columns and 2 rows of data only)
So why it is showing a Database Space Usage (under ...
4
votes
2
answers
8k
views
new row violates row-level security policy for table "tasks"
I am new to supabase and am trying to integrate my Todo App made with BlueBase, a Framework based on react and react native. And, I am facing such a problem.
CreateTaskScreen.tsx
import React from '...
- 63
4
votes
1
answer
3k
views
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 ...
4
votes
2
answers
1k
views
Supabase Auth UI: Google OAuth is redirecting, but email is not
Edit:I found the source of this issue. The redirectTo param of the Auth component works for OAuth providers, but does not work for email or magiclink. Does anyone know how to redirect users to a ...
- 83
4
votes
1
answer
2k
views
Restrict Supabase Sign up to a specific domain
Supabase url and anon tokens are very easy to retrieve from any site using them. This is normally not an issue for interior tables because you can set up RLS to restrict user from viewing/modifying/...
- 1,124
4
votes
3
answers
2k
views
Supabase reset password error: "Auth Session Missing"
The following function fails with error "Auth Session Missing"
const { error } = await supabase.auth.updateUser({
password: password,
});
After getting the reset password link on my mail ...
- 333
4
votes
1
answer
3k
views
How to add additional user metadata upon login with Google using Supabase Auth?
I would like to get the first name and last name from the logged in user's Google profile. Upon checking, Google is using givenName and familyName. Is it possible to only do this with Supabase alone ...
- 366
4
votes
1
answer
716
views
Supabase triggers : ERROR: function charindex(unknown, text) does not exist (SQLSTATE 42883) (SQL)
I have two tables auth (this is the default one given by supabase) and profiles
when a new row is added in auth table I want a new row with the data added in auth table to be added in profiles tables ...
- 45
4
votes
1
answer
2k
views
Connecting to postgres on supabase via pgBouncer from prisma
Problem
running out of database connections in prod leading to errors like this;
Error:
Invalid `prisma.queryRaw()` invocation:
Timed out fetching a new connection from the connection pool. More ...
- 1,571
4
votes
1
answer
3k
views
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 ...
- 306
4
votes
1
answer
1k
views
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 ...
- 53
4
votes
3
answers
6k
views
How can I insert un-exist record and skip exist record in Supabase?
How can I use insert but skip the records I already have in my Supabase?
I have a very huge records that I've done scraping from it (over 3000 records, exactly is 3393 records)
I thought that INSERT ...
- 596
4
votes
1
answer
225
views
Slow when stream video from supabase storage
I always get lag or buffer when playing video (size 28 Mb) from supabase storage in my mobile application. Every each lag can takes about 1 or 2 seconds, its not good for UX. I'm in free tier, if pro ...
- 298
4
votes
1
answer
528
views
Supabase Auth: onAuthStateChange not triggered
I'm trying to implement Google Auth in my app but I can't get it work.
ElevatedButton(
child: Text("Sign in"),
onPressed: (){
supabase.auth....
- 894
4
votes
1
answer
702
views
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 ...
4
votes
2
answers
4k
views
Supabase not allowing upload of files into storage bucket
I have a simple script for uploading a .txt file into a Supabase bucket named 'training-data'. The bucket was made public, and I made sure to include the necessary storage/object policies in order to ...
- 73
4
votes
2
answers
2k
views
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 ...
- 163
4
votes
2
answers
3k
views
Supabase "TypeError: fetch failed"
I am making a to-do list application with Supabase and NextJS-13 and while fetching the lists from Supabase, the server gave me this error
Error Image
My List table on Supabase has three columns:
id
...
- 51