Does supabase have any triggers on storage ?

Thanks @User

Where can I find that table?

Scroll down on that page you posted the screenshot of

um sorry bit off-topic why i don't have function hooks? options 🤔

I'm not sure, maybe log out and log back into the dashboard and see if it shows

Yes but I don't have the table you mentioned

nope, didn't work

Ok so you would setup the trigger based on those tables then

Does that mean I upload image to storage and also add a row in db to triggers something ?

Whenever you upload to storage a row is automatically created in the db

I wonder I can't see that table....

Its in a schema not exposed to the public

now there's no option to type that table name

One second, I have a trigger setup on one of my project for this, let me dig it out

Thanks

So you will be using the

images

table to keep a reference of your files in

storage

right?

yes after I upload them in

images

bucket

So I created a function with raw SQL using the SQL editor in the dashboard

sql
-- inserts a row into public.images
create function public.handle_add_storage()
returns trigger as $$
begin
    insert into public.images (id, name)
    values (new.id, new.name);
    return new;
end;
$$ language plpgsql security definer;

Hmmm, new to SQL so I'll have to try them

So the second one is the one that triggers when something happens in the

storage.objects

table, this table is updated each time a new storage upload happens

Thanks, I'll try creating one with the UI first before SQL editor

I don't think you will have access to the

storage.objects

table from the UI as it's not in the

public

schema

tbh my first project had default tables namely storage, auth_logs and something else. I wonder by this project didn't had one

It has them, they are just not exposed in the dashboard

Okay.... still curios why they were in first 😅

Please don't delete such tables, this is probably why they have been hidden to prevent users from easily doing this

Okay 🤔 they updated is within a day lol xD

Btw, hooks are only rolled out to new projects as of now. Over the next few weeks, we will roll it out to existing projects

I just created that project yesterday

oh just catching up on the messages in this thread..i see that you are able to access the section, but you aren't able to see the storage.objects table..yup we only show public schema tables here ..for security reasons we don't show auth and storage..i haven't spent much time thinking about how to expose storage triggers, but this is definitely something we will launch

Can you confirm if

auth_logs

can be seen? I was able to see that in my first project and there was

storage

table too. In new project there were not any default tables.

these tables shouldn't be visible in the dashboard..there are still present, you can use a postgres client to connect to the db directly to view those tables. Some postgres clients are mentioned here - https://supabase.io/docs/guides/self-hosting#before-you-begin

Yes, thanks!

Hey @silentworks, I follow your advices here but I came across an issue: I have a "bayesgames" table. I want to trigger add a row for each .json file I upload, but I can't seem to get the values to work. here is my function:

sql
create function public.handle_add_storage()
returns trigger as $$
begin
    insert into public.bayesgames (id, name, type, size, last_modified, data, inserted_at)
    values (new.id, new.name, new.type, new.size, new.last_modified, new.data, new.inserted_at);
    return new;
end;
$$ language plpgsql security definer;

and here is my trigger:

sql
create trigger on_file_created
    after insert on storage.objects
    for each row execute procedure public.handle_add_storage();

I think the error is stating the issue here, it says there is no size property on the object you are storing. You will need to first figure out what properties are available.

It is a json file, what are the properties available for this type of files and is it possible for me to get the data inside of it ? Thanks for your help !

I'm not sure as I have never uploaded a json file before.

Alright I will check then, hopefully I can get the data of the json into a column thanks 🙏

You won't be able to get the content of the file as that is just a blog that is uploaded to storage. You can only get access to properties that are available on the file itself.

Basically I want to map through json data on my React App after Uploading a json file on my site, is there a way for me to access that data from the front of my app if this is not possible ?

Can you ask the question in #1006358244786196510 while providing as much information about what you are trying to accomplish there as others might be able to help too. This thread is old and only people who are in it will be seeing your question.

will do thanks