Is there a way to export a SQL schema for a Supabase Database from the UI ?

no, cli is probably your fastest option

Hello everyone can someone here help me get started with open source contribution I would like to be an active contributor to the Supabase repo,I am a final year undergrad student with some development experience as an intern and freelance in the past and would like to expand my knowledge while serving at the same time

Hi, I have an account on supabase.com but I have loggedin or signed up with GitHub How to do if I want to setup a password to start a paid account ?

If you are running into issue of logs in the dashboard not loading we are aware of the issue and are currently investigating it. https://status.supabase.com/incidents/qwwr2ftwsy03

https://github.com/GaryAustin1/RLS-Perfomance/blob/main/README.md Readme has details on tests and ways to improve your RLS performance and link to backup data. Pretty much if you have, or will have, tables with over 10K rows worth a look.

new to open source contribution, made a pull request is there any specific branch naming convention to raise one as I couldn't find anything related to it in the contribution guide

Someone yell at me and tell me why this would be bad practice. I'm using Prisma to generate these schemas, and using supabase auth. This

user

model is the public schema, the

users

model is the auth schema.

model user {
  // This user id is from the auth schema, not the public schema.
  user       users  @relation(fields: [id], references: [id])
  id         String @id @db.Uuid
  email      String
  first_name String
  last_name  String

  // ## Defined Relationships
  // ...removed

  @@schema("public")
}

is using the js sdk, does upsert require the id (primary key)? What if it is new data and it still does not have a primary key?

Can you give more details of how does it work? I am confused where should I put the "using" and "with check" parts

Yes you can just paste that into the with check part.

I mean. Where should I put it in the createPolicy function? or is it "combined", as long as I return a boolean

aha i see, let me guess...

first, you need to write your condition in "createPolicy".

after doing that, you can click convert button, then it converted as sql condition

and you need go to the supabase policy dashboard, create policy, and paste sql condition as "with check" part

When you first enter, it should look like this: enter the name of the table you want to modify in the red-lined area.

I see. so it is just generating the "conditions" no the whole policy itself

Am I doing this right? It doesn't seem to save

I just pasted the generated code

Um... it doesn't auto-complete the entire Policy SQL statement, this is something I'm thinking about now,,,, Do you always manage the entire RLS Policy in a full query statement? the way I was thinking was to do it via GUI in the Policy field of the Supabase Dashboard.

Can you copy that syntax and send it to me so I can check for syntax errors?

CREATE POLICY "test" ON "public"."profiles"
AS PERMISSIVE FOR SELECT
TO public
USING (boolean as $$ function createPolicy(cb) { cb({ row: globalThis, function: globalThis, auth: globalThis.auth, plv8: globalThis.plv8 }); } return createPolicy(function(context) { return true; }); $$ language plv8;)

I do but doing this via gui should be fine for now. I just assumed it will generate the policy. My whole workflow is we commit the policy via code and "upload" it via cli

It is too late now, but please use the thread feature....

lol ok

sorry @garyaustin 😅

i didn't catch that