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

Supabase

<@559459864544542751> nothing in junk Mail I assume?

nope, nothing. I've tried several times too

Have you checked your project logs? I’m not sure but there might be some clues there

just checked gmail via the web app and i can see the emails in there, must be a problem with my Outlook, thanks!

jai, tried with those steps and still no luck https://xvnvyntlneifzyrjuijv.supabase.co/auth/v1/authorize?provider=google&state=ewogICJteV9jdXN0b21rZXkiOiAieGN4Y3p4YyIKfQ==&redirect_to=vscode://eliostruyf.vscode-auth0-authprovider

Did you try it like this with the params encoded? https://xvnvyntlneifzyrjuijv.supabase.co/auth/v1/authorize?provider=google&state=ewogICJteV9jdXN0b21rZXkiOiAieGN4Y3p4YyIKfQ%3D%3D&redirect_to=vscode%3A%2F%2Feliostruyf.vscode-auth0-authprovider

Either that or 
https://xvnvyntlneifzyrjuijv.supabase.co/auth/v1/authorize?provider=google&redirect_to=vscode%3A%2F%2Feliostruyf.vscode-auth0-authprovider%3Fstate%3DewogICJteV9jdXN0b21rZXkiOiAieGN4Y3p4YyIKfQ%3D%3D

also in the log , no information about params

From what I understand, it's not yet possible to store data from a webhook into Supabase. Is this correct?

Can you provide a bit of context on what you want to do?  Edge functions might be a way if you don't control the webhook. https://supabase.com/docs/guides/functions

There are two examples here of using edge functions to handle webhooks:
https://github.com/supabase/supabase/tree/master/examples/edge-functions

Thanks, I need to add data from a Paddle webhook to the database and return a license key.

I see functions can use `createClient` to interact with the database

Also really new to Deno, so I'll have to figure out how it can verify the Paddle webhook. They only have a Node example, but with a bit of luck Deno fully supports the modules used in it.

This video was really helpful
https://www.youtube.com/watch?v=1Tz0FBoqCTQ

Hi all I have a table defined with default values for `id` and `created_at` and am tring to enter data as so: `await supabase.from('pads').insert()` but this doesn't work. is there a way of creating a record without passing anything in?

have you heard of this: https://neon.tech/ do you think it might have an impact on supabase?

Thanks for the share! Looks like planetscale but postgres

Hey guys, is this library production ready?  https://www.npmjs.com/package/@supabase/supabase-auth-helpers

Because I'm a dummy, can someone tell me what nuances there are when using RPC regarding RLS?

Normal (security invoker) Postgres functions will use RLS policies as the user making the call.  So with rpc the role/jwt of the user making the call to the API.

If you declare the function as security definer (privileges of creator of function) then it will normally bypass all RLS on tables and you need to enforce security in the function itself.

Ah that makes a lot of sense. So by default it's the invoker of the rpc.  And is that the opposite of views? Where the default for views is creator?

Not even sure views has an option to "be the user"...

For views, you would bake your auth logic into the view itself using something like a `WHERE some_table.user_id = auth.uid()` . You can always add a `OR auth.role() = 'administrator'` check if you want to be able to see all the data from the view when logged in to the dashboard

Next version of Postgres (15?) supports view policies but in the mean time, the above seems the only feasible way to do RLS-like functionality on views

That makes a lot of sense. Thank you so much

Is there a performance difference between match and multiple equal signs? Or does it end up getting converted to the same thing?

match gets converted to multiple .eq.  So maybe very minor speed diff either way possibly based on loops versus function calls in postgres.js.
Also, no offense, but can you ask specific coding help questions in one of the help threads.  Thanks

Ah, yeah of course. I didn't think of it as general help since I'm not actually asking for help on anything specific.
But good point. Thanks!

AYO I got my first Supabase PR merge in 🐣

Hello there, might be a stupid question but on the self hosted article (<https://supabase.com/docs/guides/hosting/overview>) on the ``Managing your database`` section it recommends to decouple the database from the middleware, but isn't Kong + GoTrue the middleware basically ?

Yes this is correct, so you would connect to your Postgres database that is not a part of your docker instance.

I see, thanks for the fast reply, was confused

I'm wondering if there's a tool that generates triggers and functions for people who don't actually know SQL? (like when this happens, do this to this table column)

Not that I know of but you can ask here for help if you are ever doing something and not sure how to do it.

Will do! I was thinking it would be amazing to have something like https://supabase-schema.vercel.app/ but that actually adds functionality, not just maps it

To make things easier for makers. Highly tempted to try building it together with someone if nothing like that exists.

Decoupling the database from the middleware

Tool for generating triggers and functions

Hi all. supabase newbie here. google auth shows me this error ```Missing or invalid credentials.```  what am doing wrong?

Please ask help questions in the the help section in the future as it does threads automatically.
To use Google auth you have to follow this setup process:  https://supabase.com/docs/guides/auth/auth-google
Not sure why you would get an email if you are using a 3rd party auth.  If you want email auth you start with this:  https://supabase.com/docs/guides/auth/auth-email

Also i don't get the email when i tried to signup. it shows repeated_signups in the log though. please help me to going

Hi. Does anyone have problems with the Supabase dashboard? (with losing a session after log in?)

I just found out, that problem exists only when I had VPN active

Question: does https://github.com/supabase/supabase include the storage api? I have the feeling i need to install them separately.

Yes, if you get the docker image following this guide,  you will have access to the API:

 https://supabase.com/docs/guides/hosting/docker

If you go for the hosted, then no need to set anything up. API is enabled by default and ready to use.

Hm, thanks! I guess i've missed something in that guide. The storage icon doesn't appear in the left-hand menu.

You get the API, but not the studio code for storage.  There is a thread on github discussing that and that SB wants to add storage in at some point as it has database stuff in it.  https://github.com/supabase/supabase/issues/4440

Haha, thanks! I just stumbled upon the same post. Apparently i’m not the only one confused.

hey! I'm having some issue with using filters with JSONB with supabase, for example, let's say that I have column `content` with this value: ```{
  "body": "testing again",
  "context": [
    {
      "type": "group",
      "stream": "kjzl6cwe1jw148482np90z6odirjwf66c6h97t5z52p7a7bpcig8iju43323q7y"
    }
  ]
}```

And I want to filter the table to get only the rows that have the stream value in the `context` array being equal to: `kjzl6cwe1jw148482np90z6odirjwf66c6h97t5z52p7a7bpcig8iju43323q7y` what would be the supabase query to achieve this?

This column looks like a array with json inside of it, not sure if you can filter data by that column.

Looks very similar to this one. https://stackoverflow.com/questions/51267155/in-postgresql-how-can-i-select-rows-where-a-jsonb-array-contains-objects

Try it out in the SQL Editor and if it works you can wrap it in a `rpc`.

@here currently no new project creation available, whats up with that?