All Questions
3 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
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