Supabase
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
JoinS
Supabase
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
JoinCan't reach database server at `aws-1-ap-southeast
is there anyone can help me
i used next js prisma...
Supavisor is not working read/write data using {USER}.cluster.{CLUSTER_ALIAS} - ":tenant_not_found"
Maybe you can help me with the supavisor setup. The thing is that the direct connection "type=single" works, but I'm trying to configure "type=cluster" cluster_tenants to add replica/primary (read/write) and connect like this "postgres://supabase-user-alias.cluster.supabase-realtime:password@ip:6543/supabase"
But now I get the error "[error] ClientHandler: Subscribe error: {:error, :tenant_not_found}", here is the full log:
```
project=supabase-realtime user=supabase-user-alias mode=transaction type=cluster app_name=psql peer_ip=10.244.243.1 [info] Starting pool(s) for {{:cluster, "supabase-realtime"}, "supabase-user-alias", :transaction, "supabase", nil}
project=supabase-realtime user=supabase-user-alias mode=transaction type=cluster app_name=psql peer_ip=10.244.243.1 [error] Can't find tenant with external_id {{:cluster, "supabase-realtime"}, "supabase-user-alias", :transaction, "supabase", nil} {:error, :not_found}...
RLS policy to read only my "profile" VS read "all names" from "profile" that are on "comments" table
What I have: 2 tables, one called "profiles" with fields like "name", "surname", "avatar_url" and others of my interest, and another called "comments" where is the "text" of the comment and a field called "author_id" that it's the UUID of the user that add the comment.
The problem is with the Policy: right now I have a policy to only "read my own profile" (just like the tutorial or example on the website), so when I want to join "comments" table with my "profiles" table to show on a field the name of the author, I get "null" because I only allowed to fetch my own profile.
We want to keep a level of privacy with the profiles, so no user (for now) should have access to other profiles. And even if I just have the role with the less permission, at least I still want to see the comments of an entity and be able to see the names, ¿any idea how should be tackle this issue?, ¿what it's the best recommendation?...
