471 questions
Advice
1
vote
0
replies
35
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
1
answer
455
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
12
votes
24
answers
38k
views
prisma Error: p1001: Can't reach database server at `db.xocheossqzkirwnhzxxm.supabase.co`:`5432`
I started learning about prisma and supabase and would like to implement both technologies in my Next.js app. After running npx prisma migrate dev --name init I was faced with the following error:
...
- 209
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
23
votes
3
answers
21k
views
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": "...
- 1,155
2
votes
1
answer
725
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
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
160
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
0
votes
1
answer
1k
views
how to access auth.users table for functions trigger
I need some help with supabase triggers. I am trying to follow along with this tutorial here, however I can't seem to figure out how to access the auth.users table, as it seems to be protected.
When I ...
- 762
1
vote
1
answer
518
views
supabase.Auth.CurrentSession returns null , c# client
I'm using dotnet add package supabase-csharp as a c# client.
I'm signed in var session = await supabase.Auth.SignIn(email, password); successfully, but when i tried to get the current user or session ...
- 33
0
votes
1
answer
520
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
31
votes
4
answers
46k
views
How to get "COUNT(*)" in Supabase
I want to retrieve row count in Supabase.
I am guessing it would be something like this:
const { data, error } = await supabase
.from('cities')
.select('name', 'COUNT(*)')
Is this possible with ...
- 19.2k
1
vote
1
answer
2k
views
How to import my supabase db types in edge functions (Deno)?
How can I (properly) use the locally downloaded types of my supabase db for use in an Edge Functions environment (Deno) to provide autocomplete suggestions in VS Code?
I tried doing it similarly to ...
6
votes
2
answers
7k
views
Using supabase.auth.getSession() is potentially insecure
I am using Supabase in my Next.js application.
I have initialised Supabase as shown below. This process is even mentioned in their official documentation.
utils/supabase/server.js
'use server'
import ...
- 780
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
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
3
votes
1
answer
1k
views
Manage edge functions in a multi-environment development setup using webhooks on supabase
I’m currently working on a project that uses Supabase with multiple environments (local, staging, and production). My development workflow involves:
Developing locally with Supabase CLI.
Deploying ...
- 814
-1
votes
1
answer
707
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
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
1
vote
0
answers
177
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 ...
- 699
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
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
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
2
answers
2k
views
Using Materialized Views for RLS in Supabase: Best Practices and UI Limitations [closed]
I'm working on a project where I need to calculate the final cost (gasto) for each expense by applying various taxes. I also need to implement Row-Level Security (RLS) to restrict data access based on ...
- 655