471 questions
Advice
1
vote
0
replies
34
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
78
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
188
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
2
answers
300
views
How can I connect my backend server to Supabase?
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
2
answers
499
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
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
1
answer
114
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
0
answers
125
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
1
answer
121
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
1
answer
380
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
459
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
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
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
0
votes
1
answer
215
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
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
-1
votes
2
answers
31
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
4
votes
0
answers
511
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,576
0
votes
0
answers
599
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
1
vote
0
answers
128
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 ...
0
votes
0
answers
118
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 { ...
2
votes
1
answer
724
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 ...
0
votes
1
answer
997
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
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
619
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
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 ...
