RLS policy based on input

Is there a way to export Supabase project/table config so that other devs can import it? Kind of like a quick start / 1 click setup to get a similar project up and running?

hello hello friends! gotta say - Supabase is pure love! ❤️

ello yall

it's already 20k now lol

10 mins and 67 stars

Congrats on 20k stars!

Let me go and un-star and see what happens 😆

Maybe take a look at this: https://www.pgadmin.org/docs/pgadmin4/development/schema_diff.html#schema-diff-ddl-comparison-panel

hello

Just a reminder to please follow the #843998099033817088 for this server - mods will kick/ban accounts that post inappropriate messages

it's going to be a hackathon for me indeed i didn't knew 10th was the deadline aaAAAAAA

Hi guys, is there anyway to send user invite email from Supabase API? I could send it from web UI but I've checked the docs and couldn't find if it's possible to send an invite email with Supabase client in a React project

Hi guys! is there a criteria for contributing? I mean what kind of app should i have to build? does it requires having more functionality? or does even hello world counts for the hacktoberfest?

One question to the @User , when saving for example an index.html file in the bucket is there some option which when we take the link gives us the exact html instead of it being inside of the tag and another html ?

sry accidently wrote it here meant to write it in help

#ASK Why i got this error while uploading file :

message: "new row violates row-level security policy for table \"objects\""
​
statusCode: "42501"

service.ts :

ts
uploadImage(data: File): Observable<any> {
    return defer(() => this.supabase.storage.from('bookimage').upload(`public/test.png`, data, {
      cacheControl: '3600',
      upsert: false
    })).pipe(
      map(({ error, data }) => {
        if(error) {
          throw(error);
        }

        return data;
      })
    )
  }

can you download more files at the same time from the buckets @User ? As in if we have a subfolder with 2-3 files, something like:

js
const { data, error } = await supabase
  .storage
  .from('storage')
  .download(['test/item1', 'test/item2', 'test/item3'])

Or:

js
const { data, error } = await supabase
  .storage
  .from('storage')
  .download('test/item1')
  .download('test/item2')
  .download('test/item3')

Hope I kinda got the point across 🙂

https://supabase.io/blog/2021/09/28/supabase-hacktoberfest-hackathon-2021 All details are here 😎

If using anon key: Do you have any policies set up for the bucket to allow write? Even public buckets need policies for write access, although read access is public. Or are you using service key with supabase-js?

it was solved right now by adding INSERT policies on

Other policies under storage.objects

. Sorry i didn't see the Notes on the documentation which say i should adding policies

Awesome. We could do a better job of showing that policies are still required for public buckets for write and insert.

a very beginner question here guys: if i want to insert a row that has foreign keys of ids, do I have to run 2 queries that first, fetches the ids, then insert? or is there a better way?

@User please refrain from posting such content on the platform, this is against community code of conduct

In this RLS example (https://supabase.io/docs/guides/auth/row-level-security#restrict-updates), am I right to assume that a user could potentially update their own profile

user_id

to point to another user ? If yes, is that what the "WITH CHECK expression" would be for ?

postgresql
-- 1. Create table
create table profiles (
  id uuid references auth.users,
  avatar_url text
);

-- 2. Enable RLS
alter table profiles
  enable row level security;

-- 3. Create Policy
create policy "Users can update their own profiles."
  on profiles for update using (
    auth.uid() = id
  );

Yes, WITH CHECK looks at the incoming data.

Cool ! Thanks, that's good to know