472 questions
-1
votes
0
answers
30
views
Supabase upsert in React Native profile table not updating onboarding_completed
I'm building a mobile app with React Native (Expo) and using Supabase for authentication and user profiles.
This is my profiles table
create table public.profiles (
id uuid primary key references ...
- 19
Advice
1
vote
1
replies
50
views
How do I make an authenticated request from my Next.js API on Supabase with RLS enabled?
In my case, I only want authenticated users to perform a SELECT query on my database, so I set up my RLS Policy for this scenario. This is where I am hitting an issue. With RLS enabled, I need to let ...
0
votes
0
answers
113
views
How to set up subdomain-based multi-tenancy with Next.js, Supabase (DB/Auth), and next-intl?
I’m trying to build a multi-tenant platform similar to how Sentry works, where the root domain (e.g. https://sentry.io/en) serves the marketing site, and each tenant has its own localised subdomain (e....
- 308
0
votes
0
answers
80
views
failed to send batch: ERROR: Out of memory (SQLSTATE XX000)
When calling supabase db reset I get this error: failed to send batch: ERROR: Out of memory (SQLSTATE XX000).
It breaks because of one migration where I create a db function that uses the postgres net ...
- 4,942
0
votes
0
answers
50
views
supabase postgis tile server and javascript decoding base64 encoded data
I was trying to serve vector tiles on the fly using an rpc function in superbase but somehow when the responce arrives in the front end using a custom protocol. the vector tiles are not displayed.
...
0
votes
0
answers
195
views
ECONNREFUSED error after migrating backend from Render to cPanel with Supabase DB
I'm running into a frustrating issue after migrating my backend from Render (free tier) to cPanel (for beta testing and reviews). The backend is built with Express, uses Drizzle ORM, and connects to a ...
0
votes
1
answer
90
views
Can't select data from supabase
I run supabase locally using supabase CLI. I can auth user and get him id or email. I created sample table with columns id(int8) and created_at(timestamptz). I manually insert 4 records for test and ...
0
votes
1
answer
327
views
How can I connect my backend server to Supabase? [closed]
I'm currently working on a project that involves a native client app, a backend server (Node.js), and Supabase for both the database and authentication.
Here's the architecture I'm considering:
The ...
- 1
0
votes
0
answers
21
views
What could be causing NextAuth with Google provider to fail in production (Vercel) despite correct callback URLs and environment variables?
enter image description here
GOOGLE_CLIENT_ID=********.apps.googleusercontent.com
GOOGLE_CLIENT_SECRET=********
AUTH_SECRET=JSR+v4MCFEAMAOMtEcXYeh5nJCnVrKJaY0czK1byVhI=
DATABASE_URL=postgresql://user:...
0
votes
2
answers
511
views
Unable to connect Supabase Database to Spring Boot Application due to Timeout Error
I'm working with spring boot and postgresql project. I able to connect my spring boot application to local postgresql without any problem.
Then I tried to connect my spring boot project with supabase ...
- 451
0
votes
0
answers
170
views
Supabase Issue: HTTP schema does not exist
I am trying to send confirmation email whenever user logged in for the first time, record its email to the table user_approvals table under public schema. so when i change the value of is_approved (...
- 1
1
vote
0
answers
41
views
React and Supabase data modeling clarification
So below is a beginning structure to part of my data that im trying to setup for a notes app. This notes app will have the ability to have folder and sub folder, and sub folders with in that folder. ...
0
votes
0
answers
73
views
How to have different environments for an Expo app with Supabase?
I have a React Native app built with Expo and Supabase. It works great in development. Now, I want to create a staging and production environment on Supabase (like on Firebase). I couldn't find how to ...
- 383
0
votes
1
answer
122
views
Supabase RLS policy issue
I am trying to get or create some data in Supabase. I am using Python(>= 3.9) Fast API and vercel for deployment. The issue is:
{
"error": "Failed to get history: {'code': '42501'...
- 11
0
votes
1
answer
465
views
Supabase Realtime subscription not working with custom JWT and RLS in Next.js + NextAuth setup
I'm building a website using Next.js, NextAuth, and Supabase. I'm not using Supabase's built-in auth — instead, I manage a custom users table and generate custom JWTs using NextAuth during sign-in.
In ...
- 3
0
votes
0
answers
127
views
How to increase the timeout for Supabase Migrations running in CLI?
I have a migration file that creates a materialized view. However, this takes a while and supabase db push is running into a timeout (using their cloud service, managed by CLI)
I tried also export ...
- 12.5k
0
votes
0
answers
30
views
Open question in the Supabase pricing system?
For a new Flutter project, I want to use Supabase as the backend. Unfortunately, two questions have arisen. I'm using the SDK provided by Supabase for Flutter.
Now, when I execute an insert, select, ...
0
votes
1
answer
128
views
Supabase Kotlin join query
I have a small Kotlin app which uses a Supabase database as backend. I have the problem that I have 2 relations in the tables I want to retrieve and I can't find a solution for my query.
I have a ...
- 428
0
votes
0
answers
179
views
Supabase Db Query is super slow with simple test query using service role
A Simple db query in a table with just 2 rows takes atleast 12 seconds, sometimes timeout!
What is the mistake in my code? My code works so credentials are correct. I don't use Supabase auth, so I use ...
- 1,494
0
votes
1
answer
382
views
Integration issue "Unable to read Kotlin metadata"
My Supabase build fails unless I remove Supabase related dependencies and code:
Unable to read Kotlin metadata due to unsupported metadata kind: null.
Gradle file:
plugins {
alias(libs.plugins....
- 1
0
votes
1
answer
526
views
Build fails when integrating supabase in Android app using Kotlin?
I was trying to integrade supabase with my android kotlin app but the build fails with this exception:
org.gradle.api.tasks.TaskExecutionException: Execution failed for task ':app:kaptDebugKotlin'.
...
- 1
0
votes
1
answer
468
views
Supabase error: cannot drop function storage.get_level(text) because other objects depend on it
While trying to create a local dev environment,
supabase db reset
is failing with
Resetting local database...
Recreating database...
Initialising schema...
Seeding globals from roles.sql...
Applying ...
- 113k
0
votes
1
answer
98
views
Supabase error: permission denied to create extension "moddatetime"
While trying to create a local supabase dev environment,
supabase start
is failing with
Seeding globals from roles.sql...
Applying migration 20250315203000_remote_schema.sql...
Stopping containers...
...
- 113k
0
votes
0
answers
52
views
prisma.findmany() on production mode return outdated data, but in dev mode all ok
When trying to get data from the prisma.order.findmany() table, in development mode we get the correct data, in production mode we get the data only at the initialization stage of the project.
...
- 11
0
votes
1
answer
42
views
Unexpected output Supabase SQL Editor
Unexpected all null rows output with missing columns when running query (designed and tested on pgadmin) on Supabase SQL Editor. I already checked an both tables have RLS disabled and no constraints ...
- 3
1
vote
0
answers
48
views
Supabase query return string instead of list
I want to get the parameters interest.name, interest.description, interest.category.name as String with the value that is currently returning a list. They are translations and I select the value ...
- 409
1
vote
0
answers
169
views
Supabase cannot connect to PostgreSQL database
I am facing this issue.
schema.prisma
generator client {
provider = "prisma-client-js"
}
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
...
- 281
0
votes
1
answer
224
views
Supabase authentication giving error while saving use data in profile table
I am building a next js app with authentication and user data. I am trying supabase for the first time and used some online help to create some tables and triggers to save user information in profile ...
- 1,203
0
votes
0
answers
91
views
Querying supabase - ParserError<"Empty string">
I am trying to figure out how to query supabase. I have an events table with a host_id attribute. it is a foreign key to the user.id in the users table.
I am trying (and failing miserably) at figuring ...
- 2,765
0
votes
0
answers
60
views
Kotlin Supabase Update Query Always Returns Empty List Despite Working SQL Query
I am trying to update a row in my Supabase database using Kotlin. However, the update operation always returns an empty list, and the update does not reflect in the database. I have verified that the ...
- 153
0
votes
0
answers
182
views
Supabase Kotlin query returning an empty list while the same SQL query works perfectly in the editor?
I am trying to fetch the latest scan data for a specific user_id from my Supabase table using the Kotlin library. However, the query is returning an empty list, even though the same SQL query works ...
- 153
-1
votes
2
answers
34
views
Update separate table columns from nested jsonb attributes
I'm trying to run a Postgres SQL call to migrate data from a jsonb field to separate fields for each attribute, and for some reason the process is not working for the nested fields.
{
"basis&...
- 1,714
1
vote
0
answers
179
views
Supabase - new row violates row-level security policy
I have created a simple app with vue.js frontend and an express.js backend. It has a login that works properly and in the databse I can see one user and his ID. I have enabled row level security for ...
- 719
4
votes
0
answers
512
views
supabase link bug: Local config differs from linked project
There seems to be an issue with linking local projects to remote projects.
For a clean slate: I've attempted creating a new vanilla local repo, installing supabase, creating a new remote project, and ...
- 3,586
0
votes
1
answer
157
views
Supabase Error: more than one row returned by a subquery used as an expression
I have two tables bands_profiles and bands.
I'm trying to get all bands that a user is part of.
The JS query I've written is
const usersBands = await supabase
.from("bands_profiles")
...
- 1,409
0
votes
0
answers
608
views
timeout issue on supabase rpc calling a function to refresh materialized view
im working on a supabase x python projet and need to run a REFRESH MATERIALIZED VIEW CONCURRENTLY call via my python code. I believe the only way to do this is via supabase rpc on a function.
this is ...
- 11
0
votes
0
answers
38
views
How to Get userId for Creating a Post in NextJS 15 with Prisma and Supabase?
NextJS 15, Supabase(DB), and Prisma are being used, and I am working on creating an endpoint API using Route Handlers. The issue I encountered is regarding the .createPost part where the data is:
...
1
vote
0
answers
132
views
Webhook event for new user created on Supabase
I am currently working on fintech mobile application with Supabase and my backend. Is it possible that to have an event triggered when a new user is created. i want to use supabase Edge functions to ...
1
vote
0
answers
89
views
How can I change the default /rpc/ endpoint in Supabase PostgreSQL to a custom endpoint?
I am currently using Supabase with a PostgreSQL database for my application, and I would like to customize the default /rpc/ endpoint for remote procedure calls (RPC). My goal is to create a custom ...
- 430
0
votes
0
answers
119
views
Supabase Query Builder Only Returning One Row Instead of Two
I'm using Supabase's query builder to fetch data with a foreign key relationship, but the query is only returning one row, even though I expect it to return two.
Here's the code I'm using:
const { ...
0
votes
0
answers
52
views
Can I protect a Supabase DB table by a custom "invite code"?
So I am currently building a SaaS that features an invitation system. The general workflow is:
User A signs up
User A creates an organization as owner
User A creates an invitation
User B receives an ...
2
votes
1
answer
728
views
Supabase RLS not working with custom JWT token
I am creating a custom JWT token using the supabase edge function with the JWT secret provided in the supabase dashboard.
I have all the required claims in the token as per the docs [here, Custom ...
1
vote
0
answers
916
views
Too many idle database connections in supabase
I am using some edge-functions where I do some direct postgre database operations in supabase.
So whenever this edge function is called, I do something like this:
const pool = new postgres.Pool(...
- 4,942
0
votes
1
answer
1k
views
In supabase-js how to display corresponding SQL query in console.log?
I want this
const { data, error } = await supabase
.from('users')
.select(`*`)
.eq('id', 5)
.single();
to print out this
SELECT * FROM users WHERE id=5
in console.
or ...
- 147
-1
votes
1
answer
718
views
GitHub Actions: Supabase Postgres container fails to initialize with 'password authentication failed for user supabase_admin
I'm trying to set up a GitHub Actions workflow which would start supabase database as a step , I eventually want to run my tests that i have written in Django , But when trying to start the Supabase ...
- 151
2
votes
0
answers
324
views
uploading media files in supabase storage bucket with clerk authentication
I'm trying to upload images to Supabase storage from a React Native Expo app. The images are first compressed using expo-image-manipulator, but the upload fails with:
ERROR Error uploading images: No ...
- 21
0
votes
1
answer
59
views
How to set-up an insert from select call?
I am looking to insert data into a Supabase table using a select as the source. Something like:
INSERT INTO foo (x, y)
SELECT x,y from widget where date > '12-12-2023';
However, I can find out a ...
- 1,714
0
votes
1
answer
628
views
Local Edge Function gives error Supabase relation "public.<table_name>" does not exist
I'm trying to develop a local supabase edge function. I have followed the documentation and correctly installed and locally deployed the function.
I have a simple edge function that, when it receive a ...
- 1,699
3
votes
3
answers
6k
views
How to configure Supabase as a database for a Spring Boot application?
I’m working on a Spring Boot application and I’d like to use Supabase database as my database.
I’ve successfully set up Supabase and created a project, but I’m having trouble configuring it in my ...
- 93
0
votes
1
answer
3k
views
supabase_vector_container is not ready: unhealthy
I want to set up supabase locally host on windows, i have downloaded and installed docker. I first tried
--- # Get the code
git clone --depth 1 https://github.com/supabase/supabase
# Go to the docker ...
