All Questions
6 questions
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
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
1
answer
384
views
How to check if an array has one of the objects in the query an throw all the objects inside of it in Supabase
maybe the title of the question is not the best but i don't know how to explain it better in just one line.
So, to have context the best is to see the query that i'm doing in JavaScript for Supabase ...
- 45
0
votes
1
answer
349
views
Can I get a property instead of array of records using supabase select() in join table?
Take a look at the schema visualizer:
This is my request:
const { data } = await supabase.from('teams').select(`
*,
members:profiles (
*,
roles (
name
),
members(
...
- 154
0
votes
2
answers
415
views
How Can I Query User Via JSONB Data In Supabase?
This is a function that I wrote down to communicate with database and query admin users by a property that I call usertag which is unique for each user.
Idk why the function returns null, I mentioned ...
- 57
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