All Questions
14 questions
0
votes
1
answer
81
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
1
vote
0
answers
501
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,844
0
votes
1
answer
464
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,587
1
vote
0
answers
164
views
Massive data import from remote CSV file using COPY command within a Edge Function
Im trying to achieve a massive data insertion (about 50.000) from a CSV file uploaded into Supabase Storage from the frontend, and process data inside a Serveless Supabase Edge Function, trying to ...
0
votes
0
answers
262
views
I'm having trouble connecting my nodejs api with supabase
When trying to connect my nodejs api to supabase I receive the following error ERROR: getaddrinfo ENOTFOUND https://mmizsesimllgybfcjasy.supabase.co what could it be? Abaixo envio o codigo que faz a ...
1
vote
0
answers
123
views
Supabase sort / filter by relation count
I have the following query:
let query = supabase
.from("property_owners")
.select(
`id, full_name, property(id), address(id, street, house_number, city, zipcode, ...
- 631
0
votes
1
answer
159
views
RLS issues in Supabase arise when attempting to filter products based on the `company_id` stored in `auth.user_metadata`
I want to show a list of products to the right employees. Based on the structure below:
Tina works at Company A (10), so I want them to see Apple
Sam works at Company B (11), so they will see Banana.
...
- 985
0
votes
1
answer
1k
views
How to subscribe to a supabase realtime channel multiple times?
Situation
How can I design a feature that a user can visit a page, subscribe to real-time changes and unsubscribe if the user navigates away from the page using Supabase realtime (PostgreSQL)?
By ...
0
votes
0
answers
732
views
Supabase self-referencing many-to-many relationship failing
I want to implement a many-to-many relationship between rows of the same table. Imagine I have a books table and I want each book to have a list of related books to be queried and displayed on my site....
- 61
0
votes
3
answers
1k
views
How to listen to supabase realtime changes when a column parent is null?
I am trying to listen to supabase realtime changes when parentTodos is null. How can I do that?
const { createClient } = require('@supabase/supabase-js')
const supabase = createClient(process.env....
- 171
0
votes
1
answer
914
views
Supabase function doesn't do any calculations
I have a function:
begin
if pg_trigger_depth() <> 1 then
return new;
end if;
new.rating = ROUND((new.total_score / new.total_reviews), 1);
return new;
end;
This function ...
- 35
1
vote
1
answer
3k
views
Supabase won't take UPDATE query
I'm currently using supabase to make quick MVP for college work. I create feedback feature, so I have to update some columns in row. There is my JS query:
const { error: updateError } = await supabase....
- 35
3
votes
2
answers
3k
views
How to modify a Supabase table from the dashboard UI or the Supabase SQL editor?
Whenever I try to modify an existing table in the Supabase dashboard, I get this error "Failed to pg.columns: must be owner of table <table_name>". This seems to be like a permission ...
- 55
2
votes
1
answer
7k
views
Could not find the function in the schema cache ( RPC supabase )
Hi I have created a postgres function using the supabase ui with 4 parameters.
see this screenshot
function definition is
begin
insert into public.rooms (created_by_id, room_manager_id, room_name, ...
- 21