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

Supabase

Relational databases (like Postgres which Supabas uses) require your to have all columns upfront, you don't create them on the fly.

can i use api link ? directly 
imean like with fetch stuff
i saw it in some video and i can't find it atm

How can I create function hooks using CLI/SQL? Or can I only do it via the web console?

I have like 20 hooks and don't want to manually create them all

I'm guessing you want to create your functions and triggers through SQL, this is possible as this is all the Supabase UI is doing under the hood. Functions and Triggers are native to Postgres.

You can create a function like:
```sql
-- inserts a row into public.users
create function public.handle_new_user()
returns trigger as $$
begin
    insert into public.users (id)
    values (new.id);
    return new;
end;
$$ language plpgsql security definer;
```
and a trigger for the function like:
```sql
-- trigger the function every time a user is created
create trigger on_auth_user_created
    after insert on auth.users
    for each row execute procedure public.handle_new_user();
```

I had an issue with my project but I made a new one and creating the triggers via SQL works

Il try to create table from scratch after check with pgAdmin

Are there any performance implications if I use a uuid as PK? For example, I have orders, bookings and payments where I'd like to use a uuid as a pk

I think uuid is preferred to anything else as postgres can do optimizations behind the scenes

Hi I am author of this issue, thanks for your help.

Provider's social login Google. I have this login enabled -> https://xrcvldvpazufasqpqolt.supabase.co/auth/v1/authorize?provider=google

The problem is that access is requested to go to  xrcvldvpazufasqpqolt.supabase.co  and this url is horrible, it seems that it is allowing access to some virus. XD

Is there a way to mask it with the real name of my website?

Answered here https://github.com/supabase/supabase/discussions/2925

Creating functions and triggers through SQL

Plz supabase tuotorial for flutter in depth explain

you can create a new table from the client side?

Hi everyone, getting an error for creating a record with a post call from postman.

I can manually add the record, so it isn't a field type issue. Been over the syntax several times, but can share that too if it would help...

I'm using integromat to iterate through a Plaid API. There are 9 responses, 3 went through, 6 failed. Testing in postman returned this message

I'm confused, is this a Supabase issue or a Plaid API issue?

Supabase. I'm creating the record in Supabase.

You showed the returned body but not the body sent, its kinda hard to guess what's wrong without the full picture

I verified all the field types match, all columns allow for null values... not sure what the issue is. Tested it with another JSON response from Plaid and got the same issue from supabase.

just wanted to ask like i have a table of all the posts with columns such as created by , topic , title and no of bookmarks

so assuming i will have various like tens of thousands of ideas under each topic and everyuser wants like top 20-30 post and some posts from people they folloe

so do i query each time from the original db or do i just make another db like top 100 ideas under each topic and every 15 mins just update that db based on the current position of our posts?

I'm going to assume this is what your question is about, you would only need 1 database, but can have multiple tables to handle this or just do it from the one table. This is a design decision that you will have to make, if the query will be a complex on you can also look into creating a View instead of a new table and query that.

The query will be mostly to retieve posts with topic ="some specific topic" ordered by Views

And some of the times user specific like someone i am following has released a new post then i would love to do that

Same as before it will be a design decision that you will need to make, Postgres (Supabase in turn) has the options I stated above to handle whichever decision you choose.

And I wanted to ask how mature the supabase sdk for dart is?

the topics will be read more often than write

Should the table be queried or should I use a aggregate table

Can you try doing an insert using the Supabase client library instead and see what the results are?