By using flutter sdk

Is it possible to remove the verify signup via email and let people login immediately after signup?

There's a toggle in the auth settings

It's not written by me. I created this table by SQL:

SQL
create table public.file_versions (
  id uuid default uuid_generate_v1() primary key,
  name text,
  created_at timestamp with time zone DEFAULT timezone('utc' :: text, now()) NOT NULL,
  updated_at timestamp with time zone DEFAULT  timezone('utc' :: text, now()) NOT NULL
);

Then I insert a row in table editor, it gave me this error.

Hi there, I have two questions when uploading files. Can't figure them out 😭 Could anyone give me a favor? Thanks. 1. I can't upload file to a specific bucket. I have 4 public buckets and neither of them has a policy, but I can upload files to the other 3 buckets. Uploading to

specs

bucket will get

new row violates row-level security policy for table "objects"

2. I got

application/json

as an image's content type after uploading a file from blob. Core code is below.

js
// imageData is Uint8Array
const blob = new Blob([imageData], {
    type: 'image/png'
  })

  const fileExt = fileName.split('.').pop()
  const uniqueName = `${uuid()}.${fileExt}`
  const { data, error } = await supabase.storage
    .from('heron')
      .upload(uniqueName, blob, {
        contentType: 'image/png'
      })

I've not used

uuid_generate_v1()

before but I do know that

uuid_generate_v4()

works

Probably best to ask this in #843999948717555735 or better ask on the discussion board where it's easier to keep track of https://github.com/supabase/supabase/discussions

and more how to open chrome ?

docs finish :/

Yeah, v4 worked, I switched to v4.

Thanks Silentworks, I'll move it into GitHub discussion.

Has anyone thought of a good way to create a profile on signup?

I leave some PR in superpal-ui-web https://github.com/supabase/supabase-ui-web/pulls 🤟

Can I import CSV data into an existing table? I see where you can import data when creating a new table

Sure. This is possible with Supabase, as it is built-in to the dashboard itself.

Maybe you can use https://supabase.io/docs/reference/javascript/auth-update

const { user, error } = await supabase.auth.update({ 

data: { hello: 'world' } 

})

I see. I have a separate table for the profile according to one of the provided templates

Even if a bucket is public, you still need to add RLS policies to upload and delete

Oh wow! ❤️ thank you

Where in the dashboard?

Does anyone know what might cause this error?

Oh, I guess I have the same issue. I remember I used to add some policies to the bucket but there's no policy showed in policy panel. Maybe it's a bug caused by recent updates?

If I manually insert a new row, I then get this error when the client tries to insert a new row again into the table. I have an id property that's the PK and serial {"hint":null,"details":"Key (id)=(1) already exists.","code":"23505","message":"duplicate key value violates unique constraint \"user_story_pkey\""}

Don't know your steps for this, but I just created function and trigger in SQL editor and it worked. Because I can't create function in the new functions and triggers panel (see https://discord.com/channels/839993398554656828/839993398554656831/870860572109983754 ).

sql
-- create function called update_updated_at
CREATE OR REPLACE FUNCTION public.update_updated_at()
RETURNS TRIGGER AS $$
BEGIN
  NEW.updated_at = TIMEZONE('utc' :: TEXT, NOW());
  RETURN NEW;
END;
$$ LANGUAGE plpgsql SECURITY DEFINER;

-- add trigger for projects table
CREATE TRIGGER trigger_projects_updated_at
BEFORE UPDATE ON public.projects
FOR EACH ROW
EXECUTE PROCEDURE public.update_updated_at();

-- add trigger for users table
CREATE TRIGGER trigger_users_updated_at
BEFORE UPDATE ON public.users
FOR EACH ROW
EXECUTE PROCEDURE public.update_updated_at();

Anyone can help with column level security?

If you mean preventing users from writing to a specific column on a specific row, consider moving that value to another table, and applying RLS policies to the new table

You can check out this great blog post made by the Supabase team: https://supabase.io/docs/learn/auth-deep-dive/auth-row-level-security

If you need help please post in #843999948717555735 or on the Supabase GitHub Discussion https://github.com/supabase/supabase/discussions, #839993398554656831 is not the place to be asking for help.

I tried to create a batch of 50 non relation small document and its really slow, abt 8-9 seconds. Does it happen to you guys?

nope