const { data, error } = await supabase.auth.signUp(
  {
    email: 'example@email.com',
    password: 'example-password',
    options: {
      data: {
        first_name: 'John',
        age: 27,
      }
    }
  }
)

raw_user_meta_data

documents

select

update

editable

readonly

select

update

user_id

document_id

js
  const formdata = await new Promise((res, rej) => {
    const form = new Formidable({ multiples: true });
    form.parse(req, (err, fields, files) => {
      if (err) {
        rej({ err });
      }
      const daunt = files.image;
      console.log({ daunt });
      res({ err, fields, files });
    });
  });

  const formData = formdata as any;
  const { title, description } = formData.fields as formidable.;
  const postImage = formData.files.image as formidable.File;

  const imageCompressed = await sharp(postImage.filepath)
    .toFormat("png", { palette: true })
    .png({ quality: 8 })
    .toBuffer();

  const ress = await supabase.storage
    .from("post-images")
    .upload(Math.random().toString() + ".png", imageCompressed, { upsert: false });

text/plain;charset=UTF-8 - 157 bytes

png

signInWithOtp

verifyOtp

Error: Remote database Postgres version 15 is incompatible with db.major_version 14. If you are setting up a fresh Supabase CLI project, try changing db.major_version in supabase/config.toml to 15.
Try rerunning the command with --debug to troubleshoot the error.

Error: Failed reading config: Invalid db.major_version: 15.
Try rerunning the command with --debug to troubleshoot the error.

await supabase.rpc('hello_world')

security definer

const { data: { user }  } = await supabase.auth.getUser()

  const form = reactive({
    data: {
      first_name: '',
      last_name: '',
      country: '',
      city: '',
      address_line: '',
      postal_code: '',
      username: '',
      email: '',
      currency: '',
      language: '',
    },
  });
  
  if (user && user.id) {
    const getAccount = async () => {
      const { data: account, error } = await supabase
      .from('accounts')
      .select()
      .eq("user_id", user.id)
      return { account, error };
    };
    const { account, error } = await getAccount();
    console.log(account)

    form.data.first_name=account[0].first_name
    
    console.log(error)
  }

email@provider.com | email+1@provider.com | ...

js
const getElement = async () => {
        const { data: url } = supabase.storage.from('svg-assets').getPublicUrl(element.elementName);
        return url;
    };

    let image: { publicUrl: string };
    let loading = true;

    $: console.log(image, element.elementName)

    onMount(async () => {
        image = await getElement();
        

        setTimeout(() => {
            loading = false;
        }, 1000);
    });

'https://latdcbfvbassfihdwpwi.supabase.co/storage/v1/object/public/svg-assets/totoro_umbrella'} 'totoro_umbrella'
'https://latdcbfvbassfihdwpwi.supabase.co/storage/v1/object/public/svg-assets/totoro_umbrella'} 'moon_loader'