https://supabase.com/ logo
Join Discord
Powered by
# off-topic
  • r
    add a RLS policy that only let's users whose user_id is in the posts row see those posts
  • r
    or you can filter it out on the frontend
  • u
    @User thanks for the reply! what would the
    Copy code
    select()
    look like? i have a policy set up rn for only updates but i can set one for viewing too
  • u
    how do i get the user id to query the posts with? should i get it from auth.user() ?
  • a
    love it
  • j
    @User yes, you would pull the authed users id with the supabase client - then you would do a simple select and add an .eq('user_id', user.id)
  • j
    and that's going to get you what you want
  • u
    thank you sir
  • j
    you're welcome
  • r
    Hey all
  • r
    with supabase db, using the APi can we work with relationships also?
  • j
    You mean the client api?
  • j
    Yes, you can work with relationships.
  • j
    Here's an example from the docs using javascript:
    Copy code
    const { data, error } = await supabase
  .from('countries')
  .select(`
    name,
    cities (
      name
    )
  `)
  • m
    I noticed I have storage requests

    https://i.imgur.com/8qeJFmi.png▾

    Yet I have no buckets and don't use storage
  • d
    Hey is supabase API down? can't access from my app or even from the website. Any idea when will it come ack
  • d
    please someone do reply , i have an app running in production which uses supabase as backend
  • c
    ping?
  • c
    @User everything seems to be working on my side
  • d
    i'm getting 'Error Connecting to API' from supabase site and my app request returns 'Fetch error ,
    Copy code
    type: 'system',
  errno: 'ECONNREFUSED',
  code: 'ECONNREFUSED'
  • c
    well have you tried to ping the service?
  • c
    do it local, and remote
  • c
    and see where you at from there
  • d
    yeah, will try
  • n
    @User my supabase was down a few days ago and I fixed it by restarting the service (under settings in the control panel)
  • d
    thanks will try
  • d
    no luck
  • n
    😦
  • n
    @User you can also email beta@supabase.io
  • n
    I'm not part of the supabase team, so don't know if they're more responsive by email or here
1...798081...392Latest