Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

do it <:KEKW:626137917445636118>  they'd probably give you comcast service and expect you to pay for it even though you didn't ask for it and already have a line with someone else

I’ll gladly accept their service if they can line it up in Romania, Europe 😂

is it just with self-hosted supabase instances?

You can’t access `supabase.co` with their security thing enabled

If it's self-hosted most probably it's not in the block list of domains 😛

i have comcast and i can reach supabase.co, it just redirects to supabase.io

You probably don’t have the advanced security enabled

It uses their own dns server and simply reroutes

Hence the ssl error for the users having the issue

supabase.co redirects to io by default I think, I live in Europe and I get that too

I wonder how many reports they need to actually look into it. Cause I know at least 5 of my users reported it for review

Plus hundreds others probably after @Supabase tweeted

I wonder... does this even work actually? It’s supposed to let you visit for one hour

But you’ll never reach their service on https

Oh speaking of, I should probably send an email to move to .in for auth too until this gets fixed out 🤦‍♀️

Please refrain from such comments, we have users who use Strapi with Supabase too and we are an inclusive community.

Just added social auth (Google, Twitter, Github) to my app and it was a breeze!

Does supabase have any triggers on storage ?

You can create a database function to do something when an insert happens on the `storage.objects` 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

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

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

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

My first project had `auth_logs` table too which was never added in this project..

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;
```

Then every time an object gets uploaded I call this trigger
```sql
-- trigger the function every time a file is uploaded
create trigger on_file_created
    after insert on storage.objects
    for each row execute procedure public.handle_add_storage();
```

All of these can be created through the SQL editor

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 😅

I also deleted them and wasn't able to do anything then

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

which is why you might only see two options in that section

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

but as <@!107176742342402048> mentioned, please don't modify these tables, since if you do, functionality and upgrades will break.

Hey <@107176742342402048>, 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.

When a new file is uploaded it triggers something ?