All Questions
Tagged with postgresql supabase-js
31 questions
0
votes
0
answers
30
views
How to use Supabase DB Functions in Javascript Client API using Select Query?
My Goal is to get the coordinates in human readable form without using a seperate request as follows.
supabase.rpc('fn')
I have a table named live_route and it is linked to an other table named ...
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
184
views
Supabase JS Client query returning null for Joined Data when using "or" filter
I am using the Supabase JS Client to fetch data from my work_orders table and join it with the customers and synced_users tables. The query works perfectly without any filters, but when I add an or() ...
- 106
0
votes
0
answers
26
views
Supabase (PostgreSQL) brain teaser
I have a 3 tables:
services - info about services (id, title)
city - info about city (id, city_name)
service_city - map multiple cities to services (service_id, city_id)
and I need functionality to ...
- 385
3
votes
0
answers
441
views
Supabase JS, Joins without explicitly defining foreign and primary keys on Schema Level
I want to Run the following query using SupabaseJS
select
inspection_part.serial_no,
inspection_part.part_name,
inspection_part.requested_date_time,
inspection_part.completed_date_time,
...
- 527
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
1
answer
266
views
Supabase RPC returns fewer records than if I query the database itself
I have a postgres (v15) function that takes a users id, and returns a list of other users that are similar to them. What similar means probably doesn't matter for the question here, but just in case, ...
- 21
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
563
views
Insert JSON object into JSON array column
I am working on a small project to learn Supabase and NextJS. I am trying to add a JSON object to my sites array which is defined as a JSON array. I want to add the config (and more in the future) to ...
2
votes
2
answers
6k
views
How to Use AND Operator with OR Condition in Supabase Query?
I'm working on a query in Supabase where I need to select specific columns from a table based on multiple conditions. Specifically, I need to select columns a, b, and c from a table where column e is ...
- 21
0
votes
2
answers
516
views
Use Postgres functions on Supabase Client js
I have table 'MyTable' containing the column 'observations' of type jsonb. The Json structure is as following:
{
...
obsList: [
{
species: 'Goldfinch',
number: 2
},
{
...
- 54
0
votes
1
answer
906
views
How to join table many to one via supabase in reactjs?
I have a table where when I test it with the following query select *, category_product from product inner join category on product.category_id = category.id inner join type on product.type_product = ...
- 1